// GET: AdminRegistrations public ActionResult Index() { if (!LoginController.IsAdmin()) return View("~/Views/Login/Index.cshtml"); using (var db = new glsoverviewdbEntities()) { var registrations = db.registrations.Include(r => r.car).Include(r => r.employee).OrderByDescending(r => r.Date); return View(registrations.ToList()); } }
// NB: This code is run on EVERY page view, until a car is parked on that day! // Should only run once pr. day, but we couldn't fix this in time. public static void ResetCars() { using (var _db = new glsoverviewdbEntities()) { var lastAddedReg = _db.registrations.Max(r => r.Date); if (lastAddedReg.Date >= DateTime.Today) return; foreach (var car in _db.cars) car.Status = (int)StatusTypes.Arrived; _db.SaveChanges(); } }
public ActionResult Delete(int? id) { if (!LoginController.IsAdmin()) return View("~/Views/Login/Index.cshtml"); if (id == null) return HttpNotFound(); using (glsoverviewdbEntities db = new glsoverviewdbEntities()) { employee emp = db.employees.Find(id); return View(emp); } }
public ActionResult RegistrationChecked(int? id) { if (!LoginController.IsAdmin()) return View("~/Views/Login/Index.cshtml"); if (id == null) return HttpNotFound(); using (var db = new glsoverviewdbEntities()) { var reg = db.registrations.Find(id); reg.CommentHandled = true; db.SaveChanges(); } return RedirectToAction("Index"); }
public ActionResult Index(AdminModel am) { if (!LoginController.IsAdmin()) return View("~/Views/Login/Index.cshtml"); using (var db = new glsoverviewdbEntities()) { var registrationList = db.registrations .Include(r => r.car) .Include(e => e.employee) .Where(r => !(r.Comment == null || r.Comment.Trim() == string.Empty) && r.CommentHandled == false) .ToList(); am.RegistrationList = registrationList; } am.Employee = LoginController.CurrentUser(); return View(am); }
public ActionResult Create(employee emp) { if (!LoginController.IsAdmin()) return View("~/Views/Login/Index.cshtml"); if (emp == null) return HttpNotFound(); using (glsoverviewdbEntities db = new glsoverviewdbEntities()) { emp.Password = Sha1.Encode(emp.Password); db.employees.Add(emp); try { db.SaveChanges(); } catch (DbEntityValidationException e) { foreach (var eve in e.EntityValidationErrors) { Console.WriteLine( "Entity of type \"{0}\" in state \"{1}\" has the following validation errors:", eve.Entry.Entity.GetType().Name, eve.Entry.State); foreach (var ve in eve.ValidationErrors) { System.Diagnostics.Debug.WriteLine("- Property: \"{0}\", Value: \"{1}\", Error: \"{2}\"", ve.PropertyName, eve.Entry.CurrentValues.GetValue<object>(ve.PropertyName), ve.ErrorMessage); } } throw; } } return RedirectToAction("Index", "AdminEmployees"); }
public ActionResult Index() { if (!LoginController.IsAdmin()) return View("~/Views/Login/Index.cshtml"); using (var _db = new glsoverviewdbEntities()) { var cars = _db.cars.ToList(); return View(cars); } }
public ActionResult Edit(employee emp) { if (!LoginController.IsAdmin()) return View("~/Views/Login/Index.cshtml"); if (emp == null) return HttpNotFound(); using (glsoverviewdbEntities db = new glsoverviewdbEntities()) { emp.Password = Sha1.Encode(emp.Password); db.Entry(emp).State = EntityState.Modified; db.SaveChanges(); } return RedirectToAction("Index"); }
public ActionResult Edit(int id) { if (!LoginController.IsAdmin()) return View("~/Views/Login/Index.cshtml"); using (glsoverviewdbEntities db = new glsoverviewdbEntities()) { employee emp = db.employees.Find(id); return View(emp); } }
public ActionResult PostDelete(int? id) { if (!LoginController.IsAdmin()) return View("~/Views/Login/Index.cshtml"); if (id == null) return HttpNotFound(); using (glsoverviewdbEntities db = new glsoverviewdbEntities()) { employee emp = db.employees.Find(id); db.employees.Remove(emp); db.SaveChanges(); } return RedirectToAction("Index"); }
// GET: AdminEmployee public ActionResult Index() { if (!LoginController.IsAdmin()) return View("~/Views/Login/Index.cshtml"); var resList = new List<employee>(); using (var db = new glsoverviewdbEntities()) { var query = from e in db.employees orderby e.Name descending select e; foreach (var emp in query) { resList.Add(emp); } } return View(resList); }