public ActionResult InsertWorkScheduleForEmployee(int empID)
{
try
{
var EmployeeID = empID;
List <EmployeeVsWorkSchedule> lstEmployeeSchedule = db.EmployeeVsWorkSchedules.Where(x => x.EmployeeID == empID).ToList();
EmployeeVsWorkSchedule sceheduleForDay1 = lstEmployeeSchedule.Where(x => x.DayID == 1).FirstOrDefault();
EmployeeVsWorkSchedule sceheduleForDay2 = lstEmployeeSchedule.Where(x => x.DayID == 2).FirstOrDefault();
EmployeeVsWorkSchedule sceheduleForDay3 = lstEmployeeSchedule.Where(x => x.DayID == 3).FirstOrDefault();
EmployeeVsWorkSchedule sceheduleForDay4 = lstEmployeeSchedule.Where(x => x.DayID == 4).FirstOrDefault();
EmployeeVsWorkSchedule sceheduleForDay5 = lstEmployeeSchedule.Where(x => x.DayID == 5).FirstOrDefault();
EmployeeVsWorkSchedule sceheduleForDay6 = lstEmployeeSchedule.Where(x => x.DayID == 6).FirstOrDefault();
EmployeeVsWorkSchedule sceheduleForDay7 = lstEmployeeSchedule.Where(x => x.DayID == 7).FirstOrDefault();
List <Day> dayList = db.Days.ToList();
return(Json(new { lstEmployeeSchedule = lstEmployeeSchedule, dayList = dayList, EmployeeID = EmployeeID, success = true }));
}
catch (Exception ex)
{
return(Json(new { success = false }));
}
}
public ActionResult SaveEmployeeWorkSchedule(List <EmployeeVsWorkSchedule> lstEmployeeVsSchedules)
{
if (lstEmployeeVsSchedules[0].EmployeeVsWorkScheduleID > 0)
{
try
{
foreach (var item in lstEmployeeVsSchedules)
{
EmployeeVsWorkSchedule employeeVsSchedule = db.EmployeeVsWorkSchedules.Find(item.EmployeeVsWorkScheduleID);
employeeVsSchedule.StartHour = item.StartHour;
employeeVsSchedule.StartMinute = item.StartMinute;
employeeVsSchedule.RunHour = item.RunHour;
employeeVsSchedule.RunMinute = item.RunMinute;
employeeVsSchedule.BreakStartHour = item.BreakStartHour;
employeeVsSchedule.BreakStartMinute = item.BreakStartMinute;
employeeVsSchedule.BreakEndHour = item.BreakEndHour;
employeeVsSchedule.BreakEndMinute = item.BreakEndMinute;
employeeVsSchedule.UpdateBy = AppUtils.GetLoginUserID();
employeeVsSchedule.UpdateDate = AppUtils.GetDateTimeNow();
db.Entry(employeeVsSchedule).State = EntityState.Modified;
db.SaveChanges();
}
return(Json(new { success = true, message = "Updated Successfully" }, JsonRequestBehavior.AllowGet));
}
catch (Exception ex)
{
return(Json(new { success = false }, JsonRequestBehavior.AllowGet));
}
}
else
{
try
{
foreach (var item in lstEmployeeVsSchedules)
{
EmployeeVsWorkSchedule employeeVsSchedule = new EmployeeVsWorkSchedule();
employeeVsSchedule.DayID = item.DayID;
employeeVsSchedule.StartHour = item.StartHour;
employeeVsSchedule.StartMinute = item.StartMinute;
employeeVsSchedule.RunHour = item.RunHour;
employeeVsSchedule.RunMinute = item.RunMinute;
employeeVsSchedule.BreakStartHour = item.BreakStartHour;
employeeVsSchedule.BreakStartMinute = item.BreakStartMinute;
employeeVsSchedule.BreakEndHour = item.BreakEndHour;
employeeVsSchedule.BreakEndMinute = item.BreakEndMinute;
employeeVsSchedule.EmployeeID = item.EmployeeID;
employeeVsSchedule.CreateDate = AppUtils.GetDateTimeNow();
employeeVsSchedule.CreatedBy = AppUtils.GetLoginUserID();
db.EmployeeVsWorkSchedules.Add(employeeVsSchedule);
db.SaveChanges();
}
return(Json(new { success = true, message = "Saved Successfully" }, JsonRequestBehavior.AllowGet));
}
catch (Exception ex)
{
return(Json(new { success = false }, JsonRequestBehavior.AllowGet));
}
}
}
