public ActionResult Create(Hole hole) { if (ModelState.IsValid) { db.hole.Add(hole); db.SaveChanges(); CalculatePar(hole); CalculateLength(hole); return RedirectToAction("ViewHoles", new { id = hole.CourseID }); } ViewBag.CourseID = new SelectList(db.course, "ID", "Name", hole.CourseID); return View(hole); }
public ActionResult Edit(Hole hole) { if (ModelState.IsValid) { db.Entry(hole).State = EntityState.Modified; db.SaveChanges(); CalculatePar(hole); CalculateLength(hole); return RedirectToAction("ViewHoles", new { id = hole.CourseID }); } ViewBag.CourseID = new SelectList(db.course, "ID", "Name", hole.CourseID); return View(hole); }
private void CalculatePar(Hole hole) { var totalPar = (from item in db.hole where item.CourseID == hole.CourseID select item.Par).Sum(); var course = db.course.Find(hole.CourseID); course.TotalPar = totalPar; db.SaveChanges(); }
private void CalculateLength(Hole hole) { var totalLength = (from item in db.hole where item.CourseID == hole.CourseID select item.Length).Sum(); var course = db.course.Find(hole.CourseID); course.TotalLength = totalLength; db.SaveChanges(); }