// POST: /ListedOffence/Edit/5 public void EditOffence(ListedOffence _offence) { //offences cannot be updated as they are referenced in the driving offence table. //Instead a new offence will be created and assigned the updated values. //The existing offence status will be set to false so it cannot be used //in new driving offences but can be accessed by existing driving offences. //create new offence ListedOffence _newOffence = new ListedOffence(); //get existing offence from database ListedOffence _updatedOffence = _DAL.ListedOffenceFindById(_offence.Id); //assign new offence updated values of existing offence _newOffence.LoDesc = _offence.LoDesc.ToString(); _newOffence.Lo28Days = _offence.Lo28Days; _newOffence.Lo56days = _offence.Lo56days; _newOffence.LoFine28 = _offence.LoFine28; _newOffence.LoFine56 = _offence.LoFine56; _newOffence.LoMandatoryCourtAppearance = _offence.LoMandatoryCourtAppearance; _newOffence.LoStatus = true; _newOffence.LoDateCreated = _offence.LoDateCreated; _newOffence.LoDateLastModified = System.DateTime.Now; //add new offence to database _DAL.CreateListedOffence(_newOffence); //Update status of existing offence to false //so it is not accessable to new driver offences //but is available to existing driver offences. _updatedOffence.LoStatus = false; _updatedOffence.LoDateLastModified = System.DateTime.Now; //Update database record of existing offence _DAL.EditListedOffence(_updatedOffence); }
// cc - changed return type to int // public ListedOffence EditListedOffence(ListedOffence listedoffence) public int EditListedOffence(ListedOffence listedoffence) { db.Entry(listedoffence).State = EntityState.Modified; db.SaveChanges(); //return null; return listedoffence.Id; }
public ActionResult Create(ListedOffence listedoffence) { if (ModelState.IsValid) { // db.ListedOffences.Add(listedoffence); // db.SaveChanges(); // return RedirectToAction("Index"); ListedOffenceDAL dal = new ListedOffenceDAL(); dal.CreateListedOffence(listedoffence); return RedirectToAction("Index"); } return View(listedoffence); }
/// <method> /// CreateOffence() inserts a new offence object into the database /// </method> public void CreateOffence(ListedOffence _newOffence) { _newOffence.LoDateCreated = System.DateTime.Now; _newOffence.LoDateLastModified = System.DateTime.Now; _newOffence.LoStatus = true; //CC - To do: check if mandatoryCourtAppearance/Description is set correctly //because required is not working on all fields. if (_newOffence.LoMandatoryCourtAppearance == true) { _newOffence.Lo28Days = 0; //_newOffence.Lo56days = 0; _newOffence.LoFine28 = 0; _newOffence.LoFine56 = 0; }; _DAL.CreateListedOffence(_newOffence); }
public ListedOffence CreateListedOffence(ListedOffence listedoffence) { db.ListedOffences.Add(listedoffence); db.SaveChanges(); return null; }
public ActionResult Edit(ListedOffence _offence) { //offences cannot be updated as they are referenced in the driving offence table. //Instead a offence will be create and assiged the value of the existing offence. //The exiting offence will have its status set to false so it cannot be used //in new driving offences but can be accessed by existing driving offences. List<SelectListItem> count = new List<SelectListItem>(); //Define a driver offence status list count.Add(new SelectListItem { Text = "1", Value = "1", Selected = true }); count.Add(new SelectListItem { Text = "2", Value = "2" }); count.Add(new SelectListItem { Text = "3", Value = "3" }); count.Add(new SelectListItem { Text = "4", Value = "4" }); count.Add(new SelectListItem { Text = "5", Value = "5" }); count.Add(new SelectListItem { Text = "6", Value = "6" }); count.Add(new SelectListItem { Text = "7", Value = "7" }); count.Add(new SelectListItem { Text = "8", Value = "8" }); count.Add(new SelectListItem { Text = "9", Value = "9" }); ViewData["count28days"] = new SelectList(count, "Value", "Text", _offence.Lo28Days); ViewData["count56days"] = new SelectList(count, "Value", "Text", _offence.Lo56days); if (ModelState.IsValid) { _BLL.EditOffence(_offence); return RedirectToAction("Index"); } return View(); }
public ActionResult Create(ListedOffence _newOffence) { List<SelectListItem> count = new List<SelectListItem>(); //Define a driver offence status list count.Add(new SelectListItem { Text = "1", Value = "1", Selected = true }); count.Add(new SelectListItem { Text = "2", Value = "2" }); count.Add(new SelectListItem { Text = "3", Value = "3" }); count.Add(new SelectListItem { Text = "4", Value = "4" }); count.Add(new SelectListItem { Text = "5", Value = "5" }); count.Add(new SelectListItem { Text = "6", Value = "6" }); count.Add(new SelectListItem { Text = "7", Value = "7" }); count.Add(new SelectListItem { Text = "8", Value = "8" }); count.Add(new SelectListItem { Text = "9", Value = "9" }); ViewData["count"] = new SelectList(count, "Value", "Text"); if (ModelState.IsValid) { // model is valid, save to db _BLL.CreateOffence(_newOffence); return RedirectToAction("Index"); } // model is not valid return View(_newOffence); }
public ActionResult Edit(ListedOffence listedoffence) { if (ModelState.IsValid) { db.Entry(listedoffence).State = EntityState.Modified; //db.SaveChanges(); //return RedirectToAction("Index"); ListedOffenceDAL dal = new ListedOffenceDAL(); dal.EditListedOffence(listedoffence); return RedirectToAction("Index"); } return View(listedoffence); }
public ActionResult Create(ListedOffence _newOffence) { if (ModelState.IsValid) { // model is valid, save to db _BLL.CreateOffence(_newOffence); return RedirectToAction("Index"); } // model is not valid return View(_newOffence); }