Build an ASP.net webservice
$10-30 USD
Pagado a la entrega
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]
Nº del proyecto: #13306697
Sobre el proyecto
29 freelancers están ofertando un promedio de $82 por este trabajo
Hi sir I am having 5+ year of experience in ASP..NET development if you can give me chance to work with you
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 Más
.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 Más
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.
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 Más
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..
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.
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 Más
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
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
I am asp.net developer use various things web forms , MVC 4,5,6, Webapi2, with Microsoft Visual studio 2015,2017, angularjs, angular 2,
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 Más
