[url removed, login to view] webservice rebuilt using content body instead of parameter

Cancelled

Description

THIS PROJECT IS URGENT, ONLY BID IF YOU CAN FINISH IN 2 HOURS.

I need a web service, similar to the one posted below to accepts JSON data and saves it to a MS SQL table. It must accept multiple rows and multiple columns.

IMPORTANT, it must accept the data through the body of the POST instead of a parameter. The current sample code (BELOW) works fine, but I need to submit the data through the strData parameter. I need to submit through the body. It should be something like: <HttpPost> Public Function UploadTest(<FromBody()> ByVal strInput() As clsTest) as string

I cannot give you access to my server. I will give you a sql data structure and sample code. You will deliver a full .net solution that I can test with, then I will migrate to my environment.

table structure:

CREATE TABLE [dbo].[tblTest](

[intCol1] [int] NULL,

[strCol2] [nvarchar](50) NULL,

[dteCol3] [date] NULL

) ON [PRIMARY]

Sample XML to upload:

[{"intCol1":13,"strCol2":"13 Test","dteCol3":"12/13/1997"}]

Sample Code:

<WebMethod()> _

Public Sub UploadTestData(strData As String)

Try

If [url removed, login to view](strData) Then

[url removed, login to view]("No Data Passed")

Return

End If

Dim lst As List(Of clsTest) = [url removed, login to view](Of List(Of clsTest))(strData)

Dim conn As New [url removed, login to view]([url removed, login to view]("ConnString2").ConnectionString)

If [url removed, login to view] <> [url removed, login to view] Then

[url removed, login to view]()

End If

Dim nCount = 0

If lst IsNot Nothing And [url removed, login to view] > 0 Then

For j = 0 To [url removed, login to view] - 1

Dim strSQL = "insert into tblTest([intCol1],[strCol2],[dteCol3]) values (" & _

lst(j).[url removed, login to view] & ",'" & lst(j).[url removed, login to view] & "','" & lst(j).[url removed, login to view] & "');"

Dim cmd As New SqlCommand(strSQL, conn)

Dim res = [url removed, login to view]()

If res = 1 Then

nCount = nCount + 1

End If

Next

[url removed, login to view]()

[url removed, login to view]([url removed, login to view]() + " Record Successfully Added.")

End If

Catch ex As Exception

[url removed, login to view]([url removed, login to view]())

End Try

End Sub

Skills: .NET, Microsoft SQL Server, VB.NET, Visual Basic, Web Services

See more: asp net webservice calling vb, net webservice servicedesk wrapper, net webservice post php, develop currecy converter project using net, import text file database using net, converting csv access using net, code project shoping cart using net, skills needed net webservice, save arabic sql server 2005 using net, php net webservice, axis2 client net webservice, developing electronic signature software using net, playing mp3s using net compact framework, read xml file using net insert sql server, crystal report parameter screen using net

Project ID: #12665520

6 freelancers are bidding on average $54 for this job

$25 USD in 1 day
(13 Reviews)
4.2
sheikDev

Hello, Im interested to work on this. If you are interested, i will work on next 2 hours and complete the work. Thanks, Sheik

$111 USD in 1 day
(11 Reviews)
3.6
TR49

I’d like to be considered for your "vb.net webservice rebuilt using content body instead of parameter" project. I'm software engineer with more than 3 years experience in Development & Designing. I'm exper More

$35 USD in 0 days
(4 Reviews)
2.2
seefattechnologi

Dear Sir, I think my profile and experience may be a good to match.For further information i will ask you some question at interview time. I am writing to express my interest in the .NET Programmers post for your More

$100 USD in 1 day
(1 Review)
1.4
mdineshkumar9490

Mobile:+919600964310

$30 USD in 1 day
(0 Reviews)
0.0
technovantsols

Dear Client, Thanks for providing us opportunity to place bid over the project and communicate with you.We mainly deal in web development, SEO, Android App, software testing and graphic design. Our vision is to b More

$23 USD in 6 days
(0 Reviews)
0.0