Leave management system

Question

Hi all,
I am doing Leave management system project in SQL SERVER 2008 AND in Visual studio 2008 in c#. Can any one tell me about this project how to do it? what is the starting? what should come in database? and how to connect and all? The description of project is here :- " login to the system through the first page of the application change the password after logging into the system see his/her eligibility details (like how many days of leave he/she is eligible for etc) query the leave balance See his/her leave history since the time he/she joined the company. apply for leave, specifying the from and to dates, reason for taking leave, address for communication while on leave. see his/her current leave applications and the leave applications that are submitted to him/her for approval or cancellation approve/reject the leave applications that are submitted to him/her withdraw his/her leave application (which has not been approved yet)" If any one having source code for the same u can mail me at my id [e-mail]


Thanx all....

Answer 1

You can have Leave Type(Casual,Sick leave..etc)
in leave type can have total eligibility,caryyfwd count,encahment count..etc
for employee u can initialize leave at the begining of the yr based upon leave type eligibility.
when employee applies leave u can check with his eligibility and validate whether he has crosed limit..etc

Answer 2

Hi, I want to create it too...have you finished it?
My idea are follow...
1. check the PC login name automatically to save the login time. (means all the staff need to use their own computer to apply)
2. send a request to their dept head to get the approval (maybe send a mail to their dept head, to request them to login to system to approve or disapprove)
3. if approve, update the database. else the staff will receive a mail to show them the application is rejected.

Answer 3

Hi,
Let me answer your question 1 by 1

Q 1)  check the PC login name automatically to save the login time. (means all the staff need to use their own computer to apply)

         You can Go for ADS authentication.Get the user-id from ADS and publish site in IIS with anonymous login unchecked.
Q 2) Save supervisor's employid in table and send mail

Q 3) Same way check employees ID and send mail

mail me if u have doubts