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

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

Write New Post |

Search Forums | Answered

Resolved Posts |

Un Answered Posts |

Forums Home

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.

Reply | Reply with Attachment

Alert Moderator

Responses

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

0	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

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

Latest Posts