Leave-Management-System-.Net-ProjectLeave Management .Net project is for computer science final year students who are interested in developing online application which can be used in a college to reduce work load. This projects main idea is to develop an online application which will maintain faculty attendance, leaves and notices information. Leave Management application will reduce paper work and maintains record in more efficient way.           

  EXISTING SYSTEM:

 In existing system every college follows manual procedure in which faculty should enter in time and out time in a record book. At the end of each month Head of department will calculate leaves of every faculty member which is a time taking process and there is chances of losing records.

PROPOSED SYSTEM:

                                    In proposed system chances of losing data is not possible because data is maintained in the form of database. Every day attendance, leaves and notices information is updated in to database using a user friendly GUI. This will reduce work for Head of departments. This application is an online application which makes more flexible to access information.

[cc lang="asp"]using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;
public partial class LMS_LeaveUpdation : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
if (Page.IsPostBack == false)
{
string levid = Session["Levid"].ToString().Trim();
SqlCommand cmd = new SqlCommand(“sp_LeMS_forwardleave”);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(“@Levid”, SqlDbType.NVarChar, 20).Value = Session["Levid"].ToString();
//cmd.Parameters.Add(“@password”, SqlDbType.NVarChar, 20).Value = txtPassword.Text.Trim();
DAL dal = new DAL();
SqlDataReader dr = dal.DatareaderMethod(cmd, DAL.executemethods.ExecuteReader);
if (dr.Read())
{
Label1.Text = dr[0].ToString();
string s = dr[3].ToString();
string a = s.Split(‘ ‘)[0];
Label2.Text = a;
//Label3.Text =
Label6.Text = dr[4].ToString();
string d = dr[8].ToString();
string m = d.Split(‘ ‘)[0];
Label4.Text = m;
TextBox1.Text = dr[5].ToString();
TextBox2.Text = dr[9].ToString();
Label5.Text = dr[1].ToString();
TextBox3.Text = dr[7].ToString();

}

}
}
protected void Button2_Click(object sender, EventArgs e)
{
SqlCommand cmd = new SqlCommand(“sp_LeMS_Leaveaccept”);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(“@staffid”, SqlDbType.NVarChar, 50).Value = Label1.Text;
cmd.Parameters.Add(“@leavetype”, SqlDbType.NVarChar, 10).Value = Label5.Text;
cmd.Parameters.Add(“@numberofdays”, SqlDbType.Int).Value = Convert.ToInt32(Label6.Text.ToString());
cmd.Parameters.Add(“@Leave_remarks”, SqlDbType.NVarChar, 150).Value = TextBox3.Text;
cmd.Parameters.Add(“@Leave_Id”, SqlDbType.NVarChar, 20).Value = Session["Levid"].ToString().Trim();
DAL dal = new DAL();
object obj = dal.connectedMethod(cmd, DAL.executemethods.ExecuteNonQuery);
Response.Write(“<script language=javascript>alert(‘Leave accepted successfully’)</script>”);
}
protected void Button1_Click(object sender, EventArgs e)
{

SqlCommand cmd = new SqlCommand(“sp_LeMS_LeaveReject”);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(“@Leave_remarks”, SqlDbType.NVarChar, 150).Value = TextBox3.Text;
cmd.Parameters.Add(“@Leave_Id”, SqlDbType.NVarChar, 20).Value = Session["Levid"].ToString().Trim();
DAL dal = new DAL();
object obj = dal.connectedMethod(cmd, DAL.executemethods.ExecuteNonQuery);
Response.Write(“<script language=javascript>alert(‘Leave Reject successfully’)</script>”);
Response.Redirect(“LMS_LeaveStatus.aspx”);
}
}[/cc]

This application is developed in four modules.

Staff Module.

    In this module faculty will register their daily attendance information like incoming time and outgoing time and other information like leave approvals and new notifications. Members should log in to their account and update information. If there are any notifications related to previous day it is displayed in the form of pop up. Members should respond to that notification by sending replay to higher authorities.

Also see: Leave Management System Project in Vb.Net

HOD Module

In this module Head of the department will have permissions to look after data of every faculty member of their department. HOD can view data in the form of reports and get it in the form of print out. Reports can be displayed based on day, month. HOD can approve leave through this application and he can view leaves information of every individual. In this module HOD can easily manage classes schedule for that day.

Principal Module:

Among the entire modules principle module is given more permission. He can view information of every departments faculty information and take action based on the reports. Principle can view information like faculty member’s leaves, attendance and notifications including Head of departments. He can print reports on daily or monthly basis. In this module Leave approval and resignation are included.

download Project Report  of  CSE Leave Management .Net project.