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