Sign In & Sign Out for Attendance project in C# windows application

Posted by Agopi.Net under C# on 8/23/2012 | Points: 10 | Views : 3788 | Status : [Member] | Replies : 1
Hi Friends,

I am struggled with singin & singout concept in attendance project. I can able to signin with current date. But i cannot do the signout, that i don't know how to write the signout coding. Since if employee work in night shift means, they will signin at 09:00 PM and signout at 06:00 AM. Here date will be different. So, how can we manage here.

Could anyone help me to short out this.

Regards,
Gopi A.




Responses

Posted by: Nadh123 on: 8/23/2012 [Member] Starter | Points: 25

Up
0
Down
GO
CREATE TABLE ATTENDENCE(
EMP_ID VARCHAR(16),
START_DATETIME DATETIME,
STARTTIME VARCHAR(16),
END_DATETIME DATETIME,
ENDTIME VARCHAR(16))

GO
--LOGIN TIME
INSERT INTO ATTENDENCE( EMP_ID,START_DATETIME,STARTTIME) VALUES('EMP001','10-AUG-2012','9:00 PM')
GO
--LOG OUT TIME
UPDATE ATTENDENCE SET END_DATETIME='11-AUG-2012',ENDTIME='5:00 AM' WHERE EMP_ID='EMP001'

--SALARY COUNT DAYS
SELECT COUNT(*) FROM ATTENDENCE WHERE EMP_ID='EMP001'
This is Usefull for u

Mahendra
91-9908699686

Agopi.Net, if this helps please login to Mark As Answer. | Alert Moderator

Login to post response