Leave Management for approved SP how to do the Logic

Debasis Mohapatra

Hi,

I am doing Leave Management project in Asp.net c#.

Through Free template i have created Master page ,Employee Details,Role,Department,Leave Type in Admin.

Now when the user will login with valid user id and password then the user can select the leave type dropdown,department dropdown,description,Approver dropdown and from date and todate. After click the submit the data is saved in the database. and through Joining the user can see the details in the gridview in panel view.

Now the mail has to go to approver to approved the leave and the status will show as in pending status in gridview. So what will be my SP to write if it's 0 then status will pending when 1 then approved when 2 then it will reject i the status.

Could you please guide me how to write the SP for this logic.

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Debasis Mohapatra7y ago
ok
Amit Mohanty7y ago
Hey you can use case statement in your SP.
For example.
Select CASE
WHEN 0 THEN 'Pending'
WHEN 1 THEN 'Approved'
WHEN 2 THEN 'Rejected'
END AS lStatus
From
Priyanka Jain7y ago
You can simply pass approved or rejected as text or flag from your code and based on it define case when in your stored procedure to get the desired result,
You can write code below in your stored procedure as,
CASE
    WHEN 'Pending' THEN 0
    WHEN 'Approved' THEN 1
    WHEN 'Rejected' THEN 2
    ELSE 0
END;
For more details, you can refer below link,

http://www.dotnetfunda.com/forums/show/10934/need-help-in-updating-gridview

http://ezzylearning.com/tutorial/using-checkbox-in-asp-net-gridview-control