public ActionResult Create([Bind(Include = "DivisionId,CourseId")] DivisionCourse divisionCourse) { if (ModelState.IsValid) { var students = from s in db.Students where s.DivisionId == divisionCourse.DivisionId select s; foreach (var s in students) { StudentCourse sc = new StudentCourse(); sc.StudentId = s.StudentId; sc.CourseId = divisionCourse.CourseId; Console.WriteLine(sc); db.StudentCourses.Add(sc); } db.SaveChanges(); db.DivisionCourses.Add(divisionCourse); db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.CourseId = new SelectList(db.Courses, "CourseId", "CourseName", divisionCourse.CourseId); ViewBag.DivisionId = new SelectList(db.Divisions, "DivisionId", "DivisionId", divisionCourse.DivisionId); return(View(divisionCourse)); }
public ActionResult DeleteConfirmed(int id1, int id2) { DivisionCourse divisionCourse = db.DivisionCourses.Where(s => s.DivisionId == id1 && s.CourseId == id2).FirstOrDefault(); db.DivisionCourses.Remove(divisionCourse); db.SaveChanges(); return(RedirectToAction("Index")); }
public ActionResult Edit([Bind(Include = "DivisionId,CourseId")] DivisionCourse divisionCourse) { if (ModelState.IsValid) { db.Entry(divisionCourse).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.CourseId = new SelectList(db.Courses, "CourseId", "CourseName", divisionCourse.CourseId); ViewBag.DivisionId = new SelectList(db.Divisions, "DivisionId", "DivisionName", divisionCourse.DivisionId); return(View(divisionCourse)); }
public ActionResult AssignCoursesToFaculties(int CourseId, int [] FacultyIds, int DivisionId) { bool flag = false; TempData["Message"] = "<ul>"; foreach (int fId in FacultyIds) { if (db.FacultyCourses.Where(fd => fd.CourseId == CourseId && fd.FacultyId == fId && fd.DivisionId == DivisionId).FirstOrDefault() != null) { TempData["Message"] += "<li>" + "Faculty " + db.Faculties.Where(f => f.FacultyId == fId).FirstOrDefault().FacultyName + " Is Already Assigned To " + db.Courses.Where(d => d.CourseId == CourseId).FirstOrDefault().CourseName + ". " + "</li>"; flag = true; } if (!flag) { FacultyCourse fCourse = new FacultyCourse(); fCourse.CourseId = CourseId; fCourse.FacultyId = fId; fCourse.DivisionId = DivisionId; db.FacultyCourses.Add(fCourse); db.SaveChanges(); try { FacultyDivision fDivision = new FacultyDivision(); fDivision.FacultyId = fId; fDivision.DivisionId = DivisionId; db.FacultyDivisions.Add(fDivision); db.SaveChanges(); }catch (Exception e) { } try { DivisionCourse dCourse = new DivisionCourse(); dCourse.CourseId = CourseId; dCourse.DivisionId = DivisionId; db.DivisionCourses.Add(dCourse); db.SaveChanges(); } catch (Exception e) { } } } if (flag) { TempData["Message"] += "</ul>"; return(RedirectToAction("AssignCoursesToFaculties")); } return(RedirectToAction("Index", "CourseFaculties")); }
// GET: DivisionCourses/Details/5 public ActionResult Details(int?id) { if (Session["userId"] == null && !Session["userType"].Equals("Admin")) { RedirectToAction("Index", "Login"); } if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } DivisionCourse divisionCourse = db.DivisionCourses.Find(id); if (divisionCourse == null) { return(HttpNotFound()); } return(View(divisionCourse)); }
// GET: DivisionCourses/Delete/5 public ActionResult Delete(int?id1, int?id2) { if (Session["userId"] == null && !Session["userType"].Equals("Admin")) { RedirectToAction("Index", "Login"); } if (id1 == null || id2 == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } DivisionCourse divisionCourse = db.DivisionCourses.Where(s => s.DivisionId == id1 && s.CourseId == id2).FirstOrDefault(); if (divisionCourse == null) { return(HttpNotFound()); } return(View(divisionCourse)); }
// GET: DivisionCourses/Edit/5 public ActionResult Edit(int?id1, int?id2) { if (Session["userId"] == null && !Session["userType"].Equals("Admin")) { RedirectToAction("Index", "Login"); } if (id1 == null || id2 == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } DivisionCourse divisionCourse = db.DivisionCourses.Where(s => s.DivisionId == id1 && s.CourseId == id2).FirstOrDefault(); if (divisionCourse == null) { return(HttpNotFound()); } ViewBag.CourseId = new SelectList(db.Courses, "CourseId", "CourseName", divisionCourse.CourseId); ViewBag.DivisionId = new SelectList(db.Divisions, "DivisionId", "DivisionName", divisionCourse.DivisionId); return(View(divisionCourse)); }
public ActionResult DeleteFacultyCourse(int id1, int id2, int id3) { FacultyCourse fd1 = db.FacultyCourses.Where(fd => fd.CourseId == id1 && fd.FacultyId == id2 && fd.DivisionId == id3).FirstOrDefault(); db.FacultyCourses.Remove(fd1); db.SaveChanges(); FacultyDivision fd2 = db.FacultyDivisions.Where(fd => fd.FacultyId == id2 && fd.DivisionId == id3).FirstOrDefault(); db.FacultyDivisions.Remove(fd2); db.SaveChanges(); var count = db.FacultyCourses.Where(fd => fd.CourseId == id1 && fd.DivisionId == id3).Count(); if (count == 0) { DivisionCourse fd = db.DivisionCourses.Where(fd3 => fd3.DivisionId == id3 && fd3.CourseId == id1).FirstOrDefault(); db.DivisionCourses.Remove(fd); db.SaveChanges(); } return(RedirectToAction("Index")); }