my task is a c project that runs through browser. I need it converted to vb.net and into module/function that can run without UI, all feedback written to log. I am going to run this from a windows service. It's tricky to test though because it works with a 3rd party api [login to view URL] and each time you add a subscriber, you can't add them again.
The code is attached and a dump of a table it will use is at the link below.
Here is a bak file of the mssql database you will need. [login to view URL]
Here is an updated SQL statement:
SELECT MIN([login to view URL]) AS lngSurveyID,
MIN([login to view URL]) AS strShowName, MIN([login to view URL]) AS strFName, MIN([login to view URL]) AS strLName, [login to view URL], MIN([login to view URL]) AS strSpecialistFName
FROM tblShow
INNER JOIN tblQuestionAnswer ON [login to view URL] = [login to view URL]
INNER JOIN tblShowSpecialist ON [login to view URL] = [login to view URL] AND
[login to view URL] = [login to view URL]
LEFT JOIN tblSpecialist ON [login to view URL] = [login to view URL]
WHERE ISNULL([login to view URL], 0) = 0 AND
ISNULL([login to view URL], 0) = 0 AND
DATEADD(d, 2, [login to view URL]) >= [login to view URL] AND
DATEADD(d, -1, [login to view URL]) <= [login to view URL] AND
[login to view URL] > '9/1/2014' AND
[login to view URL] = 990
GROUP BY [login to view URL]
HAVING ISNULL([login to view URL], '') <> ''
Hello,
I am very much interested to do this work as i am experienced a lot in both vb.net & c#.net as well as SQL. Looking forward to have a positive response from you.
Thanks
I have total of 7 years of experience in .Net and well versed with both windows and web applications.
Also built many applications during my carrier.
Additional knowledge: C#, SQL, Silverlight, SSRS, SSIS, API, WCF,XML,XTML.
Please let me know if you are interested and i can start work immediately.
Nice to meet you!
I have read your description and been interested in your project.
I'm ready to discuss and start to work on it now.
====================================
Please discuss before awarding the project.