public ActionResult DeleteConfirmed(String id) { CHPOfficer CHPOfficer = db.CHPOfficers.Single(r => r.BadgeID == id); db.CHPOfficers.DeleteOnSubmit(CHPOfficer); db.SubmitChanges(); return(RedirectToAction("Index")); }
// // GET: /AdminArea/Freeways/Edit/5 public ActionResult Edit(String id) { CHPOfficer CHPOfficer = db.CHPOfficers.Single(r => r.BadgeID == id); if (CHPOfficer == null) { return(HttpNotFound()); } return(View(CHPOfficer)); }
public ActionResult Create(CHPOfficer CHPOfficer) { if (ModelState.IsValid) { //if CHPOfficer does not exist yet db.CHPOfficers.InsertOnSubmit(CHPOfficer); db.SubmitChanges(); return(RedirectToAction("Index")); } return(View(CHPOfficer)); }
public ActionResult Save(CHPOfficer chpOfficer, List <BeatViewModel> Beats) { var isNew = chpOfficer.Id == 0 ? true : false; CHPOfficer officer = null; if (isNew) { officer = new CHPOfficer(); } else { officer = db.CHPOfficers.Find(chpOfficer.Id); } officer.BadgeID = chpOfficer.BadgeID; officer.OfficerLastName = chpOfficer.OfficerLastName; officer.OfficerFirstName = chpOfficer.OfficerFirstName; officer.Email = chpOfficer.Email; officer.Phone = chpOfficer.Phone; if (isNew) { db.CHPOfficers.Add(officer); } db.SaveChanges(); if (db.CHPOfficerBeats.Any(p => p.CHPOfficerId == officer.Id)) { db.CHPOfficerBeats.RemoveRange(db.CHPOfficerBeats.Where(p => p.CHPOfficerId == officer.Id).ToList()); } if (Beats != null) { foreach (var beat in Beats) { db.CHPOfficerBeats.Add(new CHPOfficerBeat { CHPOfficerId = officer.Id, BeatId = beat.BeatId }); } } db.SaveChanges(); return(Json(officer.Id, JsonRequestBehavior.AllowGet)); }
public ActionResult Edit(CHPOfficer CHPOfficer) { try { if (ModelState.IsValid) { db.CHPOfficers.Attach(CHPOfficer); db.Refresh(RefreshMode.KeepCurrentValues, CHPOfficer); db.SubmitChanges(); return(RedirectToAction("Index")); } } catch (Exception ex) { Debug.WriteLine(ex.Message); } return(View(CHPOfficer)); }