//Apply leave public int ApplyLeave(LeaveStatu leavestatus) { //obj.LeaveStatus(leavestatus); obj.LeaveStatus.Add(leavestatus); obj.SaveChanges(); return(leavestatus.ID); }
public int SaveLeaveDetails(int id, LeaveStatu leavestatus) { //obj.Leaveapplied.Add(leavestatus); //obj.SaveChanges(); var command = obj.Database.Connection.CreateCommand(); command.CommandText = "[Leaveapplied]"; command.CommandType = CommandType.StoredProcedure; command.Parameters.Add(new SqlParameter("@id", id)); command.Parameters.Add(new SqlParameter("@Emp_id", leavestatus.Emp_id)); command.Parameters.Add(new SqlParameter("@fkLeaveType", leavestatus.fkLeaveType)); command.Parameters.Add(new SqlParameter("@Department", leavestatus.Department)); command.Parameters.Add(new SqlParameter("@FromDate", leavestatus.FromDate)); command.Parameters.Add(new SqlParameter("@ToDate", leavestatus.ToDate)); command.Parameters.Add(new SqlParameter("@LeaveReason", leavestatus.LeaveReason)); command.Parameters.Add(new SqlParameter("@FirstLineManager_id", leavestatus.FirstLineManager_id)); command.Parameters.Add(new SqlParameter("@FirstLineManagerStatus", leavestatus.FirstLineManagerStatus)); command.Parameters.Add(new SqlParameter("@FirstLineMangerComment", leavestatus.FirstLineMangerComment)); command.Parameters.Add(new SqlParameter("@SecondLineManager_id", leavestatus.SecondLineManager_id)); command.Parameters.Add(new SqlParameter("@SecondLineManagerStatus", leavestatus.SecondLineManagerStatus)); command.Parameters.Add(new SqlParameter("@SecondLineManagerComment", leavestatus.SecondLineManagerComment)); command.Parameters.Add(new SqlParameter("@Hr_id", leavestatus.Hr_id)); command.Parameters.Add(new SqlParameter("@Hr_Comment", leavestatus.Hr_Comment)); command.Parameters.Add(new SqlParameter("@Hr_Status", leavestatus.Hr_Status)); command.Parameters.Add(new SqlParameter("@EmpLeaveStatus", leavestatus.EmpLeaveStatus)); command.Parameters.Add(new SqlParameter("@LeaveAppliedDate", leavestatus.LeaveAppliedDate)); command.Parameters.Add(new SqlParameter("@CreatedOn", leavestatus.CreatedOn)); command.Parameters.Add(new SqlParameter("@CreatedBy", leavestatus.CreatedBy)); command.Parameters.Add(new SqlParameter("@UpdatedOn", DateTime.Now)); command.Parameters.Add(new SqlParameter("@UpdatedBy", null)); command.Parameters.Add(new SqlParameter("@Admin_id", null)); command.Parameters.Add(new SqlParameter("@Admin_Comment", leavestatus.Admin_Comment)); command.Parameters.Add(new SqlParameter("@FLDecisiondate", leavestatus.FLDecisiondate)); command.Parameters.Add(new SqlParameter("@SLDecisiondate", leavestatus.SLDecisiondate)); command.Parameters.Add(new SqlParameter("@HRRDecisiondate", leavestatus.HRRDecisiondate)); command.Parameters.Add(new SqlParameter("@IsHalfDay", leavestatus.IsHalfDay)); command.Parameters.Add(new SqlParameter("@IsProbationLeave", leavestatus.IsProbationLeave)); command.Parameters.Add(new SqlParameter("@IsLWP", leavestatus.IsLWP)); command.Parameters.Add(new SqlParameter("@ELC", leavestatus.ELC)); command.Parameters.Add(new SqlParameter("@IsELCFlag", leavestatus.IsELCFlag)); obj.Database.Connection.Open(); var reader = command.ExecuteReader(); while (reader.Read()) { } return(leavestatus.ID); }
// Update Employee Status public void UpdateEmpLeaveStatus(int id, int status, string comment, string senderid, string Employeeid) { LeaveStatu empleaveobj = obj.LeaveStatus.Where(c => c.ID == id).SingleOrDefault(); switch (senderid) { case "FirstLineManager": if (empleaveobj.FirstLineManager_id == "soumyajit_chakraborty" || empleaveobj.FirstLineManager_id == "divya_chakraborty") { if (Convert.ToInt32(empleaveobj.SecondLineManagerStatus) == 1) { empleaveobj.SecondLineManagerStatus = 0; } if (Convert.ToInt32(empleaveobj.Hr_Status) == 1) { empleaveobj.Hr_Status = 0; } empleaveobj.EmpLeaveStatus = status; } empleaveobj.FirstLineManagerStatus = status; empleaveobj.FirstLineMangerComment = comment; empleaveobj.UpdatedOn = DateTime.Now; empleaveobj.UpdatedBy = Employeeid; break; case "SecoundLineManager": if (empleaveobj.SecondLineManager_id == "soumyajit_chakraborty" || empleaveobj.SecondLineManager_id == "divya_chakraborty") { if (Convert.ToInt32(empleaveobj.FirstLineManagerStatus) == 1) { empleaveobj.FirstLineManagerStatus = 0; } if (Convert.ToInt32(empleaveobj.Hr_Status) == 1) { empleaveobj.Hr_Status = 0; } empleaveobj.EmpLeaveStatus = status; } else { if (Convert.ToInt32(empleaveobj.FirstLineManagerStatus) == 1) { empleaveobj.FirstLineManagerStatus = 0; } if (Convert.ToInt32(empleaveobj.FirstLineManagerStatus) == 3 && status == 3) { empleaveobj.Hr_Status = status; empleaveobj.EmpLeaveStatus = status; } } empleaveobj.SecondLineManagerStatus = status; empleaveobj.SecondLineManagerComment = comment; empleaveobj.UpdatedOn = DateTime.Now; empleaveobj.UpdatedBy = Employeeid; break; case "HrManager": if (Convert.ToInt32(empleaveobj.SecondLineManagerStatus) == 1) { empleaveobj.SecondLineManagerStatus = 0; } empleaveobj.Hr_Status = status; empleaveobj.Hr_Comment = comment; empleaveobj.EmpLeaveStatus = status; empleaveobj.UpdatedOn = DateTime.Now; empleaveobj.UpdatedBy = Employeeid; break; case "Admin": if (Convert.ToInt32(empleaveobj.Hr_Status) == 1) { empleaveobj.Hr_Status = 0; } if (Convert.ToInt32(empleaveobj.SecondLineManagerStatus) == 1) { empleaveobj.SecondLineManagerStatus = 0; } if (Convert.ToInt32(empleaveobj.FirstLineManagerStatus) == 1) { empleaveobj.FirstLineManagerStatus = 0; } empleaveobj.Admin_id = Employeeid; empleaveobj.Admin_Comment = comment; empleaveobj.EmpLeaveStatus = status; empleaveobj.UpdatedOn = DateTime.Now; empleaveobj.UpdatedBy = Employeeid; break; } obj.SaveChanges(); }
// Update Employee Status //public void UpdateEmpLeaveStatus(int id, int status, string comment, string senderid, string Employeeid) //{ // LeaveStatu empleaveobj = obj.LeaveStatus.Where(c => c.ID == id).SingleOrDefault(); // switch (senderid) // { // case "FirstLineManager": // if (empleaveobj.FirstLineManager_id == "soumyajit_chakraborty" || empleaveobj.FirstLineManager_id == "divya_chakraborty") // { // if (Convert.ToInt32(empleaveobj.SecondLineManagerStatus) == 1) // empleaveobj.SecondLineManagerStatus = 0; // if (Convert.ToInt32(empleaveobj.Hr_Status) == 1) // empleaveobj.Hr_Status = 0; // empleaveobj.EmpLeaveStatus = status; // } // empleaveobj.FirstLineManagerStatus = status; // empleaveobj.FirstLineMangerComment = comment; // empleaveobj.UpdatedOn = DateTime.Now; // empleaveobj.UpdatedBy = Employeeid; // break; // case "SecoundLineManager": // if (empleaveobj.SecondLineManager_id == "soumyajit_chakraborty" || empleaveobj.SecondLineManager_id == "divya_chakraborty") // { // if (Convert.ToInt32(empleaveobj.FirstLineManagerStatus) == 1) // empleaveobj.FirstLineManagerStatus = 0; // if (Convert.ToInt32(empleaveobj.Hr_Status) == 1) // empleaveobj.Hr_Status = 0; // empleaveobj.EmpLeaveStatus = status; // } // else // { // if (Convert.ToInt32(empleaveobj.FirstLineManagerStatus) == 1) // empleaveobj.FirstLineManagerStatus = 0; // if (Convert.ToInt32(empleaveobj.FirstLineManagerStatus) == 3 && status == 3) // { // empleaveobj.Hr_Status = status; // empleaveobj.EmpLeaveStatus = status; // } // } // empleaveobj.SecondLineManagerStatus = status; // empleaveobj.SecondLineManagerComment = comment; // empleaveobj.UpdatedOn = DateTime.Now; // empleaveobj.UpdatedBy = Employeeid; // break; // case "HrManager": // if (Convert.ToInt32(empleaveobj.SecondLineManagerStatus) == 1) // empleaveobj.SecondLineManagerStatus = 0; // empleaveobj.Hr_Status = status; // empleaveobj.Hr_Comment = comment; // empleaveobj.EmpLeaveStatus = status; // empleaveobj.UpdatedOn = DateTime.Now; // empleaveobj.UpdatedBy = Employeeid; // break; // case "Admin": // if (Convert.ToInt32(empleaveobj.Hr_Status) == 1) // empleaveobj.Hr_Status = 0; // if (Convert.ToInt32(empleaveobj.SecondLineManagerStatus) == 1) // empleaveobj.SecondLineManagerStatus = 0; // if (Convert.ToInt32(empleaveobj.FirstLineManagerStatus) == 1) // empleaveobj.FirstLineManagerStatus = 0; // empleaveobj.Admin_id = Employeeid; // empleaveobj.Admin_Comment = comment; // empleaveobj.EmpLeaveStatus = status; // empleaveobj.UpdatedOn = DateTime.Now; // empleaveobj.UpdatedBy = Employeeid; // break; // } // obj.SaveChanges(); //} public void UpdateEmpLeaveStatus(int id, int status, string comment, string senderid, string Employeeid) { LeaveStatu empleaveobj = obj.LeaveStatus.Where(c => c.ID == id).SingleOrDefault(); switch (senderid) { case "FirstLineManager": if (empleaveobj.FirstLineManager_id == "soumyajit_chakraborty" || empleaveobj.FirstLineManager_id == "divya_chakraborty") { if (Convert.ToInt32(empleaveobj.SecondLineManagerStatus) == 1) { empleaveobj.SecondLineManagerStatus = 0; } if (Convert.ToInt32(empleaveobj.Hr_Status) == 1) { empleaveobj.Hr_Status = 0; } empleaveobj.EmpLeaveStatus = status; } empleaveobj.FirstLineManagerStatus = status; empleaveobj.FirstLineMangerComment = comment; empleaveobj.UpdatedOn = DateTime.Now; empleaveobj.UpdatedBy = Employeeid; break; case "SecoundLineManager": if (empleaveobj.SecondLineManager_id == "soumyajit_chakraborty" || empleaveobj.SecondLineManager_id == "divya_chakraborty") { if (Convert.ToInt32(empleaveobj.FirstLineManagerStatus) == 1) { empleaveobj.FirstLineManagerStatus = 0; } if (Convert.ToInt32(empleaveobj.Hr_Status) == 1) { empleaveobj.Hr_Status = 0; } empleaveobj.EmpLeaveStatus = status; } else { if (Convert.ToInt32(empleaveobj.FirstLineManagerStatus) == 1) { empleaveobj.FirstLineManagerStatus = 0; } if (Convert.ToInt32(empleaveobj.FirstLineManagerStatus) == 3 && status == 3) { empleaveobj.Hr_Status = status; empleaveobj.EmpLeaveStatus = status; } } empleaveobj.SecondLineManagerStatus = status; empleaveobj.SecondLineManagerComment = comment; empleaveobj.UpdatedOn = DateTime.Now; empleaveobj.UpdatedBy = Employeeid; break; case "HrManager": if (Convert.ToInt32(empleaveobj.SecondLineManagerStatus) == 1) { empleaveobj.SecondLineManagerStatus = 0; } empleaveobj.Hr_Status = status; empleaveobj.Hr_Comment = comment; empleaveobj.EmpLeaveStatus = status; empleaveobj.UpdatedOn = DateTime.Now; empleaveobj.UpdatedBy = Employeeid; break; case "Admin": if (Convert.ToInt32(empleaveobj.Hr_Status) == 1) { empleaveobj.Hr_Status = 0; } if (Convert.ToInt32(empleaveobj.SecondLineManagerStatus) == 1) { empleaveobj.SecondLineManagerStatus = 0; } if (Convert.ToInt32(empleaveobj.FirstLineManagerStatus) == 1) { empleaveobj.FirstLineManagerStatus = 0; } empleaveobj.Admin_id = Employeeid; empleaveobj.Admin_Comment = comment; empleaveobj.EmpLeaveStatus = status; empleaveobj.UpdatedOn = DateTime.Now; empleaveobj.UpdatedBy = Employeeid; break; } obj.SaveChanges(); //update leavedetail table var empdeatilleaveobj = obj.DetailedLeaveStatus.Where(c => c.LeavestatusID == id).ToList(); if (empdeatilleaveobj.Count > 0) { foreach (var item in empdeatilleaveobj) { switch (senderid) { case "FirstLineManager": if (empleaveobj.FirstLineManager_id == "soumyajit_chakraborty" || empleaveobj.FirstLineManager_id == "divya_chakraborty") { if (Convert.ToInt32(empleaveobj.SecondLineManagerStatus) == 1) { item.SecondLineManagerStatus = 0; } if (Convert.ToInt32(empleaveobj.Hr_Status) == 1) { item.Hr_Status = 0; } item.EmpLeaveStatus = status; } item.FirstLineManagerStatus = status; item.FirstLineMangerComment = comment; item.UpdatedOn = DateTime.Now; item.UpdatedBy = Employeeid; break; case "SecoundLineManager": if (empleaveobj.SecondLineManager_id == "soumyajit_chakraborty" || empleaveobj.SecondLineManager_id == "divya_chakraborty") { if (Convert.ToInt32(empleaveobj.FirstLineManagerStatus) == 1) { item.FirstLineManagerStatus = 0; } if (Convert.ToInt32(empleaveobj.Hr_Status) == 1) { item.Hr_Status = 0; } item.EmpLeaveStatus = status; } else { if (Convert.ToInt32(empleaveobj.FirstLineManagerStatus) == 1) { item.FirstLineManagerStatus = 0; } if (Convert.ToInt32(empleaveobj.FirstLineManagerStatus) == 3 && status == 3) { item.Hr_Status = status; item.EmpLeaveStatus = status; } } item.SecondLineManagerStatus = status; item.SecondLineManagerComment = comment; item.UpdatedOn = DateTime.Now; item.UpdatedBy = Employeeid; break; case "HrManager": if (Convert.ToInt32(empleaveobj.SecondLineManagerStatus) == 1) { item.SecondLineManagerStatus = 0; } item.Hr_Status = status; item.Hr_Comment = comment; item.EmpLeaveStatus = status; item.UpdatedOn = DateTime.Now; item.UpdatedBy = Employeeid; break; case "Admin": if (Convert.ToInt32(empleaveobj.Hr_Status) == 1) { item.Hr_Status = 0; } if (Convert.ToInt32(empleaveobj.SecondLineManagerStatus) == 1) { item.SecondLineManagerStatus = 0; } if (Convert.ToInt32(empleaveobj.FirstLineManagerStatus) == 1) { item.FirstLineManagerStatus = 0; } item.Admin_id = Employeeid; item.Admin_Comment = comment; item.EmpLeaveStatus = status; item.UpdatedOn = DateTime.Now; item.UpdatedBy = Employeeid; break; } obj.SaveChanges(); } } }