Need to update the set of records using Windows Service

Question

0.00/5 (No votes)

See more:

Hi All,
I have a requirement that, Need to update the records in sql table based on sampling (i.e,assume, no of records=10 ,if sampling is 50% then 5 records need to update,if sampling is 70% then 7 records need to update using window service . ) using Entity Frame work

Kindly advise me how to implement in window service using C#

Am new to windows service & Entity frame work .Kindly guide me .How to take it forward.

Thanks in Advance,

Posted 16-Apr-15 2:03am

Member 8058334

Updated 17-Apr-15 0:28am

v4

Add a Solution

Comments

Garth J Lancaster 16-Apr-15 8:21am

what are the requirements that say you have to do this in a service ? nothings stopping you from doing so, except, you then have to write a program to control the service to change your sample parameters or such --- what's wrong with

a) a stored procedure (you can invoke this from a small exe started by (for example) the windows scheduler)

b) a batch program - again, started by a windows task scheduler

if you have no other choice but to write a service for some reason, I recommend you google for 'TopShelf' - that has all the plumbing/guts you need for a service.. if you need to do your update periodically, you can use TopShelf + Quartz.Net for scheduling, and, if you get the correct set of tools, you can set the environment up using Nancy/REST to keep and eye on the service/control it

Member 8058334 17-Apr-15 6:43am

Lancaster, Thanks for the comments.
Based on the sampling grid, the charts having the status “Completed” will be automatically assigned to the mapped QA(Quality Analyst) user as per the Agent-QA mapping.
o Example: - if 50% is the sampling for a Agent and he has 10 charts then any 5 charts need to automatically allotted to QA person.
All charts should follow the coder-QA Mapping, QC Carry forward (TAT Exceed accounts) need to be allocated to the QA (automatically using Window service) based on the assigned date/discharge date following the coder-QA Mapping. Any absenteeism should be managed by auto alert to Quality Team leader and team leader will reallot those accounts manually to another QA user)

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

ZurdoDev · Answer 1 · 2015-04-16T02:15:00

I'd suggest starting with the articles on this site, for example Creating a simple Windows Service[^].

The nice thing about .Net is no matter what kind of project you write, the C# will often be the same. So, create a Windows Service as a new project in Visual Studio and then write the code to access the db however you need to and then read through the article for how to debug and test it.

Praveen Kumar Upadhyay · Answer 2 · 2015-04-16T02:30:00

Code will remain same even in Windows Service. It is ultimately a console application only which deploys as a Windows service. So do your code and then put it in windows service.
Below are some links which will help you to how to create and deploy windows service.
Creating a Basic Windows Service in C#[^]
http://www.csharp-examples.net/install-net-service/[^]

Need to update the set of records using Windows Service

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0