Kapalı

vb.net / sql server code refactoring

I am looking for a VB.net and SQL server expert to refactor and fix an issue I have with my code.

Currently, the piece of code has got inline SQL written for inserting record in SQL. the problem I am facing is when two people race to insert the record, it inserts same record twice and for one purchase two invoice gets generated.

I need to fix this issue and to detect a deadlock while this happens.

so you need to refactor this code to rewrite the piece of code to check the record exists or someone else has raced to insert the same record, if its inserted, you have [login to view URL] an exception or if not insert it.

also u need to write a logic to check for deadlock.

Solution u provide could be written as stored procedure as well.

let me know if u have any questions before bidding.

thanks

Beceriler: Microsoft SQL Server, Yazılım Mimarisi, VB.NET

Daha fazlasını gör: free code leave management system net sql server, addin outlook vb net sql server, assignment project design inplement windows desktop application vb net sql server meeting room database, refactor sql server, apexsql refactor, convert sql query to c# code online, apex sql refactor ssms 2017, apexsql refactor exe, visual studio 2017 format sql, sql to c# converter online, visual studio sql formatter, download project school management system source code made visual net sql server, mobile vb net sql server sample, save image table vb net sql server, saving xml files vb net sql server, vb net sql server, vb net sql server projects, vb net sql server sample database project, vb net sql server sample projects, vb net sql server samples

İşveren Hakkında:
( 17 değerlendirme ) LEICESTER, United Kingdom

Proje NO: #17253874

Bu iş için 11 freelancer ortalamada ₹2546 teklif veriyor

abhi98041

I am a Vb and sql server expert and i can do your job. you can check my reviews to see the quality of work i provide.

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% INR
(32 Değerlendirme)
4.3
in %bids___i_period_sub_35% gün içinde5555%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(13 Değerlendirme)
3.8
Hetalm24

Hi, I can surely fix the issue. Can we take this further? I'm a Microsoft expert with 10+ Years of Development experience in Microsoft technologies and have executed the various project and skill area are Web Ap Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% INR
(1 Yorum)
2.5
prjinfon

Hello Manager Can you let me know, approx how many places , we need to fix that issue? can we discuss, so we get more idea about estimation. my self Rakesh, i have over 5 years of exp in building website, deskto Daha Fazla

in %bids___i_period_sub_35% gün içinde2777%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(1 Yorum)
2.6
IngJoseCa

I have experience in sql and vb.net that you can help your goal

in %bids___i_period_sub_35% gün içinde1750%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(0 Değerlendirme)
0.0
in %bids___i_period_sub_35% gün içinde1300%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(0 Değerlendirme)
0.0
Swathi2423

I can optimize the query as per the requirement and I can provide you a solution with friendly interface if needed.

in %bids___i_period_sub_35% gün içinde1500%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(0 Değerlendirme)
0.0
sreekantha86

I can understand the issue. One doubt is, purchase invoice number is duplicating or not?. Need to set a unique key on purchase invoice table. We can change inline query to a stored procedure. Relevant Skills and Exper Daha Fazla

in %bids___i_period_sub_35% gün içinde1300%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(0 Değerlendirme)
0.0
freelancerdev201

Hello, I would like to express my interest in and enthusiasm for vb.net / sql server code refactoring assignment. i am expert at vb.net and sql server also deadlock insert process I have Microsoft.NET Cer Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% INR
(0 Değerlendirme)
0.0
in %bids___i_period_sub_35% gün içinde1250%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(0 Değerlendirme)
0.0
akchodvadiya

Hi there,Ashish here we are calling from rudra infotech. and we are specialist in software and web development. we have couple of team to working in vb.net if you have to see our desktop project just ping me. thank yo Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% INR
(0 Değerlendirme)
0.0