public ActionResult Edit(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } Coursework coursework = db.Coursework.Find(id); if (coursework == null) { return(HttpNotFound()); } var course = db.Courses.AsEnumerable().Select(s => new { ID = s.ID, CourseNum = s.CourseNum, Description = string.Format("{0} - {1} ({2} credits)", s.CourseNum, s.CourseName, s.Credits) }).ToList(); ViewBag.Student = coursework.Student; ViewBag.StudentID = coursework.StudentID; ViewBag.CourseID = new SelectList(course, "ID", "Description", coursework.CourseID); //ViewBag.CourseID = new SelectList(db.Courses, "ID", "CourseNum", coursework.CourseID); // ViewBag.SemestersID = new SelectList(db.CommonFields.Where(o => o.Category == "Season"), "ID", "Name", coursework.SemestersID); // ViewBag.GradeID = new SelectList(db.CommonFields.Where(o => o.Category == "Grade"), "Id", "Name", coursework.GradeID); return(View(coursework)); }
public ActionResult DeleteConfirmed(int id) { Coursework coursework = db.Coursework.Find(id); db.Coursework.Remove(coursework); db.SaveChanges(); TempData["msg"] = "<script>alert('This course has been successfully deleted.')</script>"; return(RedirectToAction("Index", "Coursework", new { id = coursework.StudentID })); }
public ActionResult Details(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } Coursework coursework = db.Coursework.Find(id); if (coursework == null) { return(HttpNotFound()); } return(View(coursework)); }
public ActionResult Delete(int?id) { if (id == null) { TempData["msg"] = "<script>alert('Sorry! No record found to delete.')</script>"; return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } Coursework coursework = db.Coursework.Find(id); if (coursework == null) { TempData["msg"] = "<script>alert('Sorry! No record found to delete.')</script>"; return(HttpNotFound()); } int sendId = (int)id; return(DeleteConfirmed(sendId)); }
public ActionResult Edit([Bind(Include = "ID, StudentID,SemestersID,Year,CourseID,GradeID,Comments")] Coursework coursework) { if (ModelState.IsValid) { db.Entry(coursework).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index", new { id = coursework.StudentID })); } var course = db.Courses.AsEnumerable().Select(s => new { ID = s.ID, CourseNum = s.CourseNum, Description = string.Format("{0} - {1} ({2} credits)", s.CourseNum, s.CourseName, s.Credits) }).ToList(); ViewBag.Student = coursework.Student; ViewBag.CourseID = new SelectList(course, "ID", "Description", coursework.CourseID); //ViewBag.CourseID = new SelectList(db.Courses, "ID", "CourseNum", coursework.CourseID); // ViewBag.SemestersID = new SelectList(db.CommonFields.Where(o => o.Category == "Season"), "ID", "Name", coursework.SemestersID); // ViewBag.GradeID = new SelectList(db.CommonFields.Where(o => o.Category == "Grade"), "Id", "Name", coursework.GradeID); return(View(coursework)); }