//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();
}
}
}
