C# Windows Form Application

Question

0.00/5 (No votes)

See more:

SQL-Server-2008

I have a table in my database namely EmpAttendance.

This table has some columns likely empid,c_Date,intime,outtime,status.

How can is send these details as an attachment via email for every half an hour(i have created a windows application in c#).

also how can i calculate difference between outtime AND INTIME.

Posted 5-Mar-13 0:41am

Harsha24

Add a Solution

Comments

choudhary.sumit 5-Mar-13 6:52am

i can understand you like this:
1. You want a email program written in c#.
2. You also want a timer code.
3. You are failed to make me understood what is outtime and intime here.
elaborate.

Harsha24 5-Mar-13 7:01am

Here I am developing an windows application which stores the intime and outtime of an employee using Employee Id. status is used to know whether employeee is IN or OUT.
I have done all this stuff.
Now i need to send an email which carries the details where status is equal to IN. and this process should be done for evrey 30 min.

Also i need to calculate the differene between Outtime and intime that is total working hours.

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)

**Orcun Iyigun** · Answer 1 · 2013-03-05T00:50:00

Your best option for this is to use a windows scheduler or using a windows service.
Example links for Win Scheduler:
Link 1[^]
Link 2[^]
How to create a Win Service:
Creating a Basic Windows Service in C#[^]
http://tech.pro/tutorial/895/creating-a-simple-windows-service-in-csharp[^]

Sending email with attachments:
MSDN MailMessage.Attachment property[^]
Example code[^]

Good luck,
OI

OriginalGriff · Answer 2 · 2013-03-05T00:54:00

Set up a timer, probably one minute intervals is fine, then have a counter which gives you the half hour. In the timer Tick event handler deal with the counter, and when it expires read the data from the DB.

Format the data into HTML and send it as an HTML email: Sending an Email in C# with or without attachments: generic routine.[^] should help.

Time differences are also easy:

C#

DateTime inTime = (DateTime) reader["intime"];
DateTime outTime = (DateTime) reader["outtime"];
TimeSpan diff = inTime - outTime;

C# Windows Form Application

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0