Build an ASP.net webservice

終了済み 投稿 7年前 着払い
終了済み 着払い

build a webservice in asp.net

1. build a webservice under existing sub-domain which accepts only JSON POST with onlky email parameter

2. when the webservice gets a POST it checks if the email is valid

a. if it does NOT valid or missing - prints error and stop

b. if it valid - continue

3. check if the email exist in ONE of the 2 tables;

a. select * from Email_Recipients where Email like @email and Agreement = 0

- if it returns true, add the email address (with user's other details) to a new table:

insert into Renew_Agreement_From_UnSubScrib(Email,RemoteUserID,Sniper_Creation)

select [login to view URL]

,[login to view URL]

,getdate()

from Email_Recipients as a

where Email like @email

and Agreement = 0

update the row:

update a

set [login to view URL] = 1

from Email_Recipients as a

where [login to view URL] like @email

b. select * from UnSubScribers where Email like @email

- if it returns true, add the email address (with user's other details) to a new table:

insert into Renew_Agreement_From_UnSubScrib(Email,RemoteUserID,UnSubScrib_Source,ActionDate,Sniper_Creation)

select [login to view URL]

,[login to view URL]

,[login to view URL]

,[login to view URL]

,getdate()

from UnSubScribers as a

where [login to view URL] like @email

delete the row:

delete a

from UnSubScribers as a

where [login to view URL] like @email

4. after inserting the new row to Renew_Agreement_From_UnSubScrib, AND updating/delete FROM UnSubScribers, send an email to the POST email address, using that API: [login to view URL]

.NET ASP.NET C#プログラミング マイクロソフトSQLサーバー SQL

プロジェクトID: #13306697

プロジェクトについて

29個の提案 リモートプロジェクト アクティブ 7年前

29人のフリーランサーが、平均$82 で、この仕事に入札しています。

sheikDev

Hello, I'm interested to work on this. If interested, please let me know. Thanks, Sheik

$55 USD 3日以内
(94件のレビュー)
6.0
sarangawaze6

Hi sir I am having 5+ year of experience in ASP..NET development if you can give me chance to work with you

$35 USD 30日以内
(13件のレビュー)
4.2
theblue8488

Hi, nice to meet you, I am a senior software engineering with more over 10 years experience in ASP.NET MVC, C#, Web service JavaScript, JQuery, CSS, Bootstrap, SQL Server, MySQL and i have more over 2 years experience もっと

$30 USD 5日以内
(10件のレビュー)
3.3
ratheeshkumar1

.Net Developer With 7 years of development experience in Microsoft technologies! Technically I have extensive experience of following technologies – 1. .NET & Entity Framework 2. , C# and VB.NET. 3. Use of もっと

$25 USD 1日以内
(2件のレビュー)
2.7
ercanoz

I have more than 10 years experience in c#.net. I have developed both web and windows projects during this time. My first goal at this bidding to have good reviews from you.

$60 USD 3日以内
(2件のレビュー)
2.9
soniasappal

We have a team of developers who is working together since 8 yrs....we involve in data entry also. Our team is capable , hard working and efficient. WE work with sincerity till the satisfaction of our client...for furt もっと

$74 USD 2日以内
(レビュー1件)
1.0
sumanrajpura

A proposal has not yet been provided

$50 USD 3日以内
(レビュー1件)
0.9
Esoul786

i can work on your web-service for 30 usd with in two days please let me know if you are interested.. i will wait for your response thanks in advance..

$35 USD 2日以内
(0件のレビュー)
0.0
vinu17

I have 12 years experience in .Net programming and I can complete this project very quick. I have worked on SQL, ASP.NET, webservices,AJAX, and have varied experience.

$25 USD 1日以内
(0件のレビュー)
0.0
iTechoza108

Hello, I have 3+ years of experience in web development and build lots of web services in asp.net. I am new on freelancer and find the your work is very suitable for me.. I will make you happy with my work and give yo もっと

$20 USD 2日以内
(0件のレビュー)
0.0
nevalpatil

Dear Sir, You just experience giving me work, I will assure that you will never go anywhere and your finding for your developers will end here.... kindly message me to discuss more... Regards, Neval Patil

$30 USD 1日以内
(0件のレビュー)
0.0
hasmukhsavaliya4

Hello, I have 3 years of working experience into .net and sql server 2008 and 2012. Please provide me details to start the work. Thanks

$55 USD 1日以内
(0件のレビュー)
0.0
msskhater

I am asp.net developer use various things web forms , MVC 4,5,6, Webapi2, with Microsoft Visual studio 2015,2017, angularjs, angular 2,

$66 USD 2日以内
(0件のレビュー)
0.0
prashobprakash

A proposal has not yet been provided

$15 USD 5日以内
(0件のレビュー)
0.0
jonasreward

Hi, My Name is Younes. I am a professional .NET (C#, VB .NET) developer with over Five years of experience with a Software Engineer degree. I am specially experienced in all kind of web services and windows servi もっと

$25 USD 10日以内
(0件のレビュー)
0.0
jaykansagara2187

A proposal has not yet been provided

$55 USD 5日以内
(0件のレビュー)
0.0