public ActionResult DeleteConfirmed(int id, int locId) { DbChangeLog log = new DbChangeLog(); LocHours deletedLocHours = context.DeleteLocHour(id); log.UserName = User.Identity.Name; log.Controller = ControllerContext.RouteData.Values["controller"].ToString(); log.Action = ControllerContext.RouteData.Values["action"].ToString(); log.ItemId = id; log.BeforeChange = Domain.Extensions.DbLogExtensions.LocHoursToString(deletedLocHours); if (deletedLocHours != null) { log.Success = true; TempData["message"] = string.Format("{0} : {1} was deleted", deletedLocHours.Days, deletedLocHours.Hours); } else { log.Success = false; log.Error = "Unable to delete location"; TempData["alert"] = "Sorry, there was an error, that location has not been deleted"; } context.SaveLog(log); return(RedirectToAction("Edit", "Locations", new { id = locId })); }
public ActionResult Edit(LocHours locHours) { /***** Logging initial settings *****/ DbChangeLog log = new DbChangeLog(); log.UserName = User.Identity.Name; log.Controller = "LocHours"; log.Action = (locHours.Id != 0) ? "Edit" : "Create"; if (log.Action == "Edit") { LocHours oldHours = context.LocHours.FirstOrDefault(m => m.Id == locHours.Id); log.BeforeChange = Domain.Extensions.DbLogExtensions.LocHoursToString(oldHours); } log.AfterChange = Domain.Extensions.DbLogExtensions.LocHoursToString(locHours); /***** end Logging initial settings *****/ if (ModelState.IsValid) { try { context.SaveLocHours(locHours); log.ItemId = locHours.Id; log.Success = true; TempData["message"] = string.Format("{0} : {1} has been saved", locHours.Days, locHours.Hours); } catch (Exception e) { log.Error = e.ToString(); log.Success = false; TempData["alert"] = string.Format("There has been an error. {0} : {1} has not been saved", locHours.Days, locHours.Hours); } } else { log.Error = "Errors: "; NLogLogger logger = new NLogLogger(); logger.Info("There has been a validation error, this record has not been saved"); foreach (ModelState modelState in ViewData.ModelState.Values) { foreach (ModelError error in modelState.Errors) { log.Error += error + "<br />"; } } TempData["alert"] = "There has been a validation error, this record has not been saved"; } log.AfterChange = Domain.Extensions.DbLogExtensions.LocHoursToString(locHours); context.SaveLog(log); return(RedirectToAction("Edit", new { id = locHours.Id })); }
public static string LocHoursToString(LocHours hours) { string locString = "<table class='table table-striped'>"; locString += "<tr><th>ID:</th><td>" + hours.Id.ToString() + "</td></tr>"; locString += "<tr><th>Days:</th><td>" + hours.Days + "</td></tr>"; locString += "<tr><th>Hours:</th><td>" + hours.Hours + "</td></tr>"; locString += "<tr><th>Priority:</th><td>" + hours.Priority.ToString() + "</td></tr>"; locString += "<tr><th>Parent Category ID:</th><td>" + hours.LocHourCatsId.ToString() + "</td></tr>"; locString += "</table>"; return(locString); }
public LocHours DeleteLocHour(int id) { LocHours dbEntry = context.LocHours.Find(id); if (dbEntry != null) { context.LocHours.Remove(dbEntry); context.SaveChanges(); SaveLocHoursXMLFile(); } return(dbEntry); }
// GET: LocHours/Edit/5 public ActionResult Edit(int?id) { LocHours hours = context.LocHours .FirstOrDefault(h => h.Id == id); LocHourCats cats = context.LocHourCats.FirstOrDefault(h => h.Id == hours.LocHourCatsId); LocationHoursViewModel model = new LocationHoursViewModel { Location = context.Locations .FirstOrDefault(h => h.Id == cats.LocationId), Cats = cats, LocHours = hours }; return(View(model)); }
public void SaveLocHours(LocHours hours) { if (hours.Id == 0) { context.LocHours.Add(hours); } else { LocHours dbEntry = context.LocHours.Find(hours.Id); if (dbEntry != null) { dbEntry.Days = hours.Days; dbEntry.Hours = hours.Hours; dbEntry.Priority = hours.Priority; } } context.SaveChanges(); SaveLocHoursXMLFile(); }