public ActionResult Create(Enrollment enrollment) { Student student = db.StudentDbSet.Find(enrollment.StudentID); ViewBag.Name = student.StudentName; ViewBag.Email = student.Email; ViewBag.Dept = student.Department.DeptName; if (ModelState.IsValid) { Enrollment testEnrollment = db.EnrollmentDbSet.FirstOrDefault( e => (e.StudentID == enrollment.StudentID) && (e.CourseID == enrollment.CourseID)); Course course = db.CourseDbSet.Find(enrollment.CourseID); if (testEnrollment==null) { enrollment.GradeID = 1; db.EnrollmentDbSet.Add(enrollment); if (db.SaveChanges() > 0) ViewBag.Message = "This Course : " + course.CourseCode + " has been successfully Enrolled to student " + student.StudentName; ViewBag.StudentID = new SelectList(db.StudentDbSet, "StudentID", "RegNo", enrollment.StudentID); ViewBag.CourseID = new SelectList(db.CourseDbSet, "CourseID", "CourseCode", enrollment.CourseID); ViewBag.GradeID = new SelectList(db.GradeDbSet, "GradeID", "GradeLetter", enrollment.GradeID); return View(enrollment); } else { ViewBag.Message = "This Course : " + course.CourseCode + " is already Enrolled to student " + student.StudentName; ViewBag.StudentID = new SelectList(db.StudentDbSet, "StudentID", "RegNo", enrollment.StudentID); ViewBag.CourseID = new SelectList(db.CourseDbSet, "CourseID", "CourseCode", enrollment.CourseID); ViewBag.GradeID = new SelectList(db.GradeDbSet, "GradeID", "GradeLetter", enrollment.GradeID); return View(enrollment); } } ViewBag.StudentID = new SelectList(db.StudentDbSet, "StudentID", "RegNo", enrollment.StudentID); ViewBag.CourseID = new SelectList(db.CourseDbSet, "CourseID", "CourseCode", enrollment.CourseID); ViewBag.GradeID = new SelectList(db.GradeDbSet, "GradeID", "GradeLetter", enrollment.GradeID); return View(enrollment); }
public ActionResult ResultEntry(Enrollment enrollment) { if (ModelState.IsValid) { Enrollment anEnrollment = db.EnrollmentDbSet.FirstOrDefault(e=>(e.CourseID==enrollment.CourseID)&&(e.StudentID==enrollment.StudentID)); Student student = db.StudentDbSet.Find(enrollment.StudentID); Course course = db.CourseDbSet.Find(enrollment.CourseID); if (anEnrollment.GradeID == 1) { anEnrollment.GradeID = enrollment.GradeID; if (db.SaveChanges() > 0) ViewBag.Message = "Result For This Course : " + course.CourseCode + " has been successfully Entered For student " + student.StudentName; ViewBag.StudentID = new SelectList(db.StudentDbSet, "StudentID", "RegNo"); ViewBag.CourseID = new SelectList("", "CourseID", "CourseCode"); ViewBag.GradeID = new SelectList(db.GradeDbSet.Where(g => g.GradeID != 1), "GradeID", "GradeLetter"); return View(); } ViewBag.Message = "Result For This Course : " + course.CourseCode + " has already been published For student " + student.StudentName; ViewBag.StudentID = new SelectList(db.StudentDbSet, "StudentID", "RegNo"); ViewBag.CourseID = new SelectList("", "CourseID", "CourseCode"); ViewBag.GradeID = new SelectList(db.GradeDbSet.Where(g => g.GradeID != 1), "GradeID", "GradeLetter"); return View(); } ViewBag.StudentID = new SelectList(db.StudentDbSet, "StudentID", "RegNo"); ViewBag.CourseID = new SelectList("", "CourseID", "CourseCode"); ViewBag.GradeID = new SelectList(db.GradeDbSet.Where(g => g.GradeID != 1), "GradeID", "GradeLetter"); return View(); }
public ActionResult Edit(Enrollment enrollment) { if (ModelState.IsValid) { db.Entry(enrollment).State = EntityState.Modified; db.SaveChanges(); return RedirectToAction("Index"); } ViewBag.StudentID = new SelectList(db.StudentDbSet, "StudentID", "RegNo", enrollment.StudentID); ViewBag.CourseID = new SelectList(db.CourseDbSet, "CourseID", "CourseCode", enrollment.CourseID); ViewBag.GradeID = new SelectList(db.GradeDbSet, "GradeID", "GradeLetter", enrollment.GradeID); return View(enrollment); }