I gang

Windows Service

I need a simple Windows Service which will continuously cycle through a MS SQL table. This table is called 'Alerts' with each row containing a Unique ID, connection string, sql, a condition and a value. There is a second table called 'CallAlerts' which is to be updated as a result of processing rows from the Alerts table.

The service will continuously read the Alerts rows until the last row and then start with row one again. It will cycle through this table endlessly.

1) For each each row in Alerts there is reference data to some different database, you must connect to the database using the connection string and then run the query.

2) Using the query results, compare the returned row count using the condition (>, <, = ) and the value defined in the Alerts table. The result will be either true or false.

3) The next step is to open CallAlerts table which contains previous results. Search for the a row in the CallAlerts table with a matching Unique ID of the Alerts row and the field ClosedDT is null. (there should only be one or none with these two conditions)

4) If the condition's result from #2 is true and matching row is not found, then add a row in CallAlerts with the unique ID and datetime, if row was found then do nothing..

5) If the condition's result from #2 is false and an active row was found then update the row field ClosedDT with the current datetime. if row was not found then do nothing.

When an eof() is reached in the Alters table, then start over again beginning with row 1.

I expect the software to run flawlessly with developer created test data. The end product should include an installation for 32 and 64 bit machine.

This project should require only one day of work. Once accepted, I will send documentation which includes the database.

Færdigheder: .NET, C# Programmering, SQL

Se mere: string processing in c, string matching in c, matching string, compare ms project, beginning c# net, windows service, string matching, eof, start windows service, active net work, open service, update field sql field field, software service software product, net connect database, add software windows update, compare table data, project documentation sql, data add service, sql project documentation, string processing, string compare, sql query field, end service, project query processing, run sql query windows

Om arbejdsgiveren:
( 5 bedømmelser ) Rochester, United States

Projekt-ID: #4072230

Tildelt til:

armteamvw

Hi Sir, I read your bid request and i can do it in 1 [url removed, login to view] if you are interested in work with me just contact me with details and i can start immediately.

$200 USD på 1 dag
(26 bedømmelser)
6.0

14 freelancere byder i gennemsnit $147 for dette job

RockStone435

This looks to be interesting project. It depends which framework of .net you want to us. Secondly, you know that you have to use install util to install a service, are you talking about the installer to install the Mere

$175 USD in 10 dage
(116 bedømmelser)
7.2
forrestwang

hi sir, I can do your work without any doubt.

$200 USD in 2 dage
(35 bedømmelser)
6.6
Narfo

Hello, please check my message.

$100 USD på 1 dag
(6 bedømmelser)
6.0
MMaghawry

It is easy project as I'm professional in doing windows services using .net , so please let me do it.

$160 USD på 1 dag
(53 bedømmelser)
5.7
intechwebworks

Hello There I would like to help you in this task Thankyou

$250 USD på 1 dag
(14 bedømmelser)
4.9
kultech

I can done. Please contact with me. I will demo winservices. Thank you

$180 USD på 1 dag
(16 bedømmelser)
4.6
feninsoftech

Hi, This can be achieved by creating a windows service application with a Timer control to run endlessly. I have 7 Years experience in C# and SQL Server.

$120 USD in 5 dage
(3 bedømmelser)
3.7
silvansmith1972

Requirement seems clear to me, I have 8 years of experience in .net. Already developed window services for many of my web application in c#. I shall develop window service, deliver you setup for 32 bit and 64 bi Mere

$100 USD in 2 dage
(5 bedømmelser)
2.9
SkyDevelopers

I am able to complete the project as you have requested. I can complete your work using VB.NET..

$180 USD in 2 dage
(3 bedømmelser)
2.7
sumon355

Hello, I am very much interested to do this project.

$90 USD på 1 dag
(10 bedømmelser)
2.2
shamscse

Dear Hiring Manager, I'm interested for do your job which you recently posted. I have been a professional C# developer for three years, and I am very familiar with C, C++, Java, PHP,asp.net, mySql, MS SQL Server 200 Mere

$100 USD in 2 dage
(0 bedømmelser)
0.0
EngineerUmair

I can code [url removed, login to view] detail in pm

$100 USD in 3 dage
(0 bedømmelser)
0.0
adroitmindsllp

Hello there We are a group of highly experienced .NET developers, please see the private message for more details

$100 USD på 1 dag
(0 bedømmelser)
0.0