Sedang Disiapkan

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.

Kemahiran: .NET, Pengaturcaraan C#, SQL

Lihat lebih lanjut: matching string, string matching, eof, start windows service, active net work, open service, net connect database, add software windows update, compare table data, data add service, string processing, string compare, sql query field, end service, project query processing, run sql query windows, update table net, simple table project net, query sql windows, windows bit, field service, windows sql query, run windows service, sql data connection string, windows net sql

Tentang Majikan:
( 5 ulasan ) Rochester, United States

ID Projek: #4072230

Dianugerahkan kepada:

armteamvw

Hi Sir, I read your bid request and i can do it in 1 day.SO if you are interested in work with me just contact me with details and i can start immediately.

$200 USD dalam sehari
(26 Ulasan)
6.0

14 pekerja bebas membida secara purata $147 untuk pekerjaan ini

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 Lagi

$175 USD dalam 10 hari
(116 Ulasan)
7.2
forrestwang

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

$200 USD dalam 2 hari
(35 Ulasan)
6.6
Narfo

Hello, please check my message.

$100 USD dalam sehari
(6 Ulasan)
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 dalam sehari
(53 Ulasan)
5.7
intechwebworks

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

$250 USD dalam sehari
(14 Ulasan)
4.9
kultech

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

$180 USD dalam sehari
(16 Ulasan)
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 dalam 5 hari
(3 Ulasan)
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 Lagi

$100 USD dalam 2 hari
(5 Ulasan)
2.9
SkyDevelopers

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

$180 USD dalam 2 hari
(3 Ulasan)
2.7
sumon355

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

$90 USD dalam sehari
(10 Ulasan)
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 Lagi

$100 USD dalam 2 hari
(0 Ulasan)
0.0
EngineerUmair

I can code it.more detail in pm

$100 USD dalam 3 hari
(0 Ulasan)
0.0
adroitmindsllp

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

$100 USD dalam sehari
(0 Ulasan)
0.0