public ActionResult AddBreaks(M_ScheduleBreaks data) { try { string startTime = data.BreakOut.ToString(); string endTime = data.BreakIn.ToString(); DateTime start = DateTime.Parse(startTime); DateTime end = DateTime.Parse(endTime); if (start > end) { end = end.AddDays(1); } TimeSpan duration = end.Subtract(start); if (duration.TotalMinutes > 0) { data.BreakTime = duration.TotalMinutes.ToString(); data.CreateID = user.UserName; data.CreateDate = DateTime.Now; data.UpdateID = user.UserName; data.UpdateDate = DateTime.Now; M_ScheduleBreaks checker = (from c in db.M_ScheduleBreaks where c.BreakTime == data.BreakTime && c.BreakIn == data.BreakIn && c.BreakOut == data.BreakOut && c.ScheduleID == data.ScheduleID select c).FirstOrDefault(); if (checker == null) { db.M_ScheduleBreaks.Add(data); db.SaveChanges(); return(Json(new { msg = "Success", ID = data.ScheduleID }, JsonRequestBehavior.AllowGet)); } else { return(Json(new { msg = "Failed", ID = data.ScheduleID }, JsonRequestBehavior.AllowGet)); } } else { return(Json(new { msg = "zero", ID = data.ScheduleID }, JsonRequestBehavior.AllowGet)); } } catch (Exception err) { Error_Logs error = new Error_Logs(); error.PageModule = "Master - Schedule"; error.ErrorLog = err.Message; error.DateLog = DateTime.Now; error.Username = user.UserName; db.Error_Logs.Add(error); db.SaveChanges(); return(Json(new { msg = err.Message }, JsonRequestBehavior.AllowGet)); } }
public ActionResult DeleteScheduleBreak(int ID) { M_ScheduleBreaks schedule = new M_ScheduleBreaks(); schedule = (from u in db.M_ScheduleBreaks.ToList() where u.ID == ID select u).FirstOrDefault(); db.M_ScheduleBreaks.Remove(schedule); db.SaveChanges(); return(Json(new { msg = "Success" }, JsonRequestBehavior.AllowGet)); }
public ActionResult EditBreaks(M_ScheduleBreaks data) { try { M_ScheduleBreaks schedule = new M_ScheduleBreaks(); schedule = (from u in db.M_ScheduleBreaks.ToList() where u.ID == data.ID select u).FirstOrDefault(); schedule.BreakIn = data.BreakIn; schedule.BreakOut = data.BreakOut; TimeSpan BreakIn = DateTime.Parse(data.BreakIn).TimeOfDay; TimeSpan BreakOut = DateTime.Parse(data.BreakOut).TimeOfDay; TimeSpan ts = BreakIn - BreakOut; schedule.BreakTime = ts.TotalMinutes.ToString(); schedule.UpdateID = user.UserName; schedule.UpdateDate = DateTime.Now; M_ScheduleBreaks checker = (from c in db.M_ScheduleBreaks where c.BreakIn == data.BreakIn && c.BreakOut == data.BreakOut && c.ScheduleID == data.ScheduleID select c).FirstOrDefault(); if (checker == null) { db.Entry(schedule).State = EntityState.Modified; db.SaveChanges(); } else { return(Json(new { msg = "Failed" }, JsonRequestBehavior.AllowGet)); } } catch (Exception err) { Error_Logs error = new Error_Logs(); error.PageModule = "Master - Schedule"; error.ErrorLog = err.Message; error.DateLog = DateTime.Now; error.Username = user.UserName; db.Error_Logs.Add(error); db.SaveChanges(); } return(Json(new { msg = "Success" }, JsonRequestBehavior.AllowGet)); }