online leave management

Posted by Ruchimat under ASP.NET on 3/12/2012 | Points: 10 | Views : 1358 | Status : [Member] | Replies : 1
I am stuck I need to calculate leave applied , taken and left , in C# .
How do I do that . I can apply Leave and see on grid view ,. how do I do approval and calculation and updation of database . Please Help


Posted by: Sksamantaray on: 3/12/2012 [Member] Silver | Points: 25

You can have a LeaveMaster table where type of leave and max no of leave of that type can be taken should be stored.
Then you can have EmpLeave table. While applying a leave you check how many leave is left for a category for which employee wants leave.
After the successful transaction ,update the database recall the procedure to show updated data in gridview like Leave available, Leave Consumed and Leave left for each category.


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

Login to post response