// // GET: /SummonsDetail/Details/5 public ViewResult Details(int id) { //SummonsDetail summonsdetail = db.SummonsDetails.Find(id); //return View(summonsdetail); SummonsDetailDAL dal = new SummonsDetailDAL(); SummonsDetail summonsdetail = dal.SummonsDetailFindById(id); return View(summonsdetail); }
public ActionResult DeleteConfirmed(int id) { // SummonsDetail summonsdetail = db.SummonsDetails.Find(id); // db.SummonsDetails.Remove(summonsdetail); // db.SaveChanges(); // return RedirectToAction("Index"); SummonsDetailDAL dal = new SummonsDetailDAL(); SummonsDetail summonsdetail = dal.DeleteSummonsDetailById(id); return RedirectToAction("Index"); }
public ActionResult Create(SummonsDetail summonsdetail) { if (ModelState.IsValid) { // db.SummonsDetails.Add(summonsdetail); // db.SaveChanges(); // return RedirectToAction("Index"); SummonsDetailDAL dal = new SummonsDetailDAL(); dal.CreateSummonsDetail(summonsdetail); return RedirectToAction("Index"); } return View(summonsdetail); }
public string A56DayNotification() { List<DriverOffence> _driverOffenceDB = _DAL.ListOfDriverOffences(); //loop through existing driver offences. //compare driver offence committed date against current date. //If 56 days has passed mark driver offence as court summons //return results int currentDay = System.DateTime.Now.Day; //int currentYear = System.DateTime.; string message = "Drivers marked with a '56 days Year Penalty Point Deletion Notification' are: "; SummonsDetailDAL dal = new SummonsDetailDAL(); SummonsDetail summonsdetail = new SummonsDetail(); foreach (DriverOffence offence in _driverOffenceDB) { //IMPORTANT TO EXCLUDE DELETED if ((offence.doStatus != "Deleted") && (offence.doStatus != "Court Summons") && (offence.doStatus != "Fine Paid")) { if (offence.doOffenceDate.AddDays(56) <= (System.DateTime.Now)) //if (offence.doOffenceDate.DayOfYear > (currentDay - 55)) { message = message + offence.DriverDetail.DdFName + " " + offence.DriverDetail.DdSName + " (" + offence.DriverDetail.DdLicenceNo + "). "; //mark driver offence as court summons. SetDriverOffenceSummonsStatus(offence.Id); //summonsdetail.DriverOffence = offence; summonsdetail.SdDate = DateTime.Now; summonsdetail.SdFName = offence.DriverDetail.DdFName; summonsdetail.SdSName = offence.DriverDetail.DdSName; summonsdetail.SdAddress1 = offence.DriverDetail.DdAddress1; summonsdetail.SdAddress2 = offence.DriverDetail.DdAddress2; summonsdetail.SdAddress3 = offence.DriverDetail.DdAddress3; summonsdetail.SdLicenceNo = offence.DriverDetail.DdLicenceNo; summonsdetail.SdRegistration = offence.VehicleDetails.VdRegistration; //this. dal.CreateSummonsDetail(summonsdetail); } //end if }//end for _driverOffenceDB }//!Deleted return message; }
// // GET: /SummonsDetail/ public ViewResult Index() { //return View(db.SummonsDetails.ToList()); SummonsDetailDAL dal = new SummonsDetailDAL(); List<SummonsDetail> summonsdetail = dal.ListOfSummonsDetails(); return View(summonsdetail); }
public ActionResult Edit(SummonsDetail summonsdetail) { if (ModelState.IsValid) { db.Entry(summonsdetail).State = EntityState.Modified; //db.SaveChanges(); //return RedirectToAction("Index"); SummonsDetailDAL dal = new SummonsDetailDAL(); dal.EditSummonsDetail(summonsdetail); return RedirectToAction("Index"); } return View(summonsdetail); }