public ActionResult RemoveSchedule(Guid id)
{
using (MTCDBEntities db = new MTCDBEntities())
{
var response = new TransactionResult();
try
{
BeatSchedule bs = db.BeatSchedules.Find(id);
if (bs != null)
{
db.BeatBeatSchedules.RemoveRange(db.BeatBeatSchedules.Where(p => p.BeatScheduleID == bs.BeatScheduleID));
db.BeatSchedules.Remove(bs);
db.SaveChanges();
}
response.HasError = false;
response.Message = String.Empty;
}
catch (Exception ex)
{
response.HasError = true;
response.Message = ex.InnerException.Message;
}
return(Json(response, JsonRequestBehavior.AllowGet));
}
}
public ActionResult CreateWeeklySchedule()
{
BeatSchedule model = new BeatSchedule();
//model.StartDate = DateTime.Today;
//model.EndDate = new DateTime(2050, 1, 1);
return(View(model));
}
public ActionResult DeleteConfirmed(Guid id)
{
BeatSchedule BeatSchedule = db.BeatSchedules.Single(r => r.BeatScheduleID == id);
db.BeatSchedules.DeleteOnSubmit(BeatSchedule);
db.SubmitChanges();
return(RedirectToAction("Index"));
}
public ActionResult DeleteConfirmed(Guid id)
{
using (MTCDBEntities db = new MTCDBEntities())
{
BeatSchedule BeatSchedule = db.BeatSchedules.Find(id);
db.BeatSchedules.Remove(BeatSchedule);
db.SaveChanges();
return(RedirectToAction("WeeklySchedule"));
}
}
public ActionResult Delete(Guid id)
{
BeatSchedule BeatSchedule = db.BeatSchedules.Single(r => r.BeatScheduleID == id);
if (BeatSchedule == null)
{
return(HttpNotFound());
}
return(View(BeatSchedule));
}
public ActionResult DeleteWeeklySchedule(Guid id)
{
using (MTCDBEntities db = new MTCDBEntities())
{
BeatSchedule BeatSchedule = db.BeatSchedules.Single(r => r.BeatScheduleID == id);
if (BeatSchedule == null)
{
return(HttpNotFound());
}
return(View(BeatSchedule));
}
}
public ActionResult EditWeeklySchedule(BeatSchedule BeatSchedule)
{
using (MTCDBEntities db = new MTCDBEntities())
{
if (ModelState.IsValid)
{
db.Entry(BeatSchedule).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("WeeklySchedule"));
}
return(View(BeatSchedule));
}
}
public ActionResult Create(BeatSchedule BeatSchedule)
{
if (ModelState.IsValid)
{
if (!db.BeatSchedules.Any(p => p.ScheduleName == BeatSchedule.ScheduleName))
{
BeatSchedule.BeatScheduleID = Guid.NewGuid();
db.BeatSchedules.InsertOnSubmit(BeatSchedule);
db.SubmitChanges();
}
return(RedirectToAction("Index"));
}
return(View(BeatSchedule));
}
public ActionResult SaveSchedule(BeatScheduleViewModel model)
{
using (MTCDBEntities db = new MTCDBEntities())
{
BeatSchedule bs = db.BeatSchedules.FirstOrDefault(p => p.BeatScheduleID == model.BeatScheduleId);
var isNew = false;
if (bs == null)
{
bs = new BeatSchedule();
bs.BeatScheduleID = Guid.NewGuid();
isNew = true;
}
bs.ScheduleName = model.ScheduleName;
bs.Sunday = model.Sunday;
bs.Monday = model.Monday;
bs.Tuesday = model.Tuesday;
bs.Wednesday = model.Wednesday;
bs.Thursday = model.Thursday;
bs.Friday = model.Friday;
bs.Saturday = model.Saturday;
bs.StartTime = TimeSpan.Parse(model.StartTime);
bs.EndTime = TimeSpan.Parse(model.EndTime);
if (isNew)
{
db.BeatSchedules.Add(bs);
BeatBeatSchedule bbs = new BeatBeatSchedule();
bbs.BeatBeatScheduleID = Guid.NewGuid();
bbs.BeatScheduleID = bs.BeatScheduleID;
bbs.BeatID = model.BeatId;
bbs.NumberOfTrucks = model.NumberOfTrucks;
db.BeatBeatSchedules.Add(bbs);
}
else
{
BeatBeatSchedule bbs = db.BeatBeatSchedules.Where(b => b.BeatScheduleID == model.BeatScheduleId).Where(b => b.BeatID == model.BeatId).FirstOrDefault();
bbs.NumberOfTrucks = model.NumberOfTrucks;
}
db.SaveChanges();
return(Json(true, JsonRequestBehavior.AllowGet));
}
}
public ActionResult CreateWeeklySchedule(BeatSchedule BeatSchedule)
{
if (ModelState.IsValid)
{
using (MTCDBEntities db = new MTCDBEntities())
{
if (!db.BeatSchedules.Any(p => p.ScheduleName == BeatSchedule.ScheduleName))
{
BeatSchedule.BeatScheduleID = Guid.NewGuid();
db.BeatSchedules.Add(BeatSchedule);
db.SaveChanges();
}
}
return(RedirectToAction("WeeklySchedule"));
}
return(View(BeatSchedule));
}
public ActionResult Edit(BeatSchedule BeatSchedule)
{
try
{
if (ModelState.IsValid)
{
db.BeatSchedules.Attach(BeatSchedule);
db.Refresh(RefreshMode.KeepCurrentValues, BeatSchedule);
db.SubmitChanges();
return(RedirectToAction("Index"));
}
}
catch (Exception ex)
{
Debug.WriteLine(ex.Message);
}
return(View(BeatSchedule));
}
