public ActionResult AssignFacultyToDivisions(int DivisionId, int CourseId, int[] FacultyIds) { bool flag = false; TempData["Message"] = "<ul>"; foreach (int fId in FacultyIds) { if (db.FacultyDivisions.Where(fd => fd.DivisionId == DivisionId && fd.FacultyId == fId).FirstOrDefault() != null) { TempData["Message"] += "<li>" + "Faculty " + db.Faculties.Where(f => f.FacultyId == fId).FirstOrDefault().FacultyName + " Is Already Assigned To " + db.Divisions.Where(d => d.DivisionId == DivisionId).FirstOrDefault().DivisionName + ". " + "for Course Name : " + db.Courses.Where(c => c.CourseId == CourseId).FirstOrDefault().CourseName + "</li>"; flag = true; } if (!flag) { FacultyDivision fDivision = new FacultyDivision(); fDivision.DivisionId = DivisionId; fDivision.FacultyId = fId; //fDivision.CourseId = CourseId; db.FacultyDivisions.Add(fDivision); db.SaveChanges(); } } if (flag) { TempData["Message"] += "</ul>"; return(RedirectToAction("AssignFacultyToDivisions")); } return(RedirectToAction("Index", "FacultyDivisions")); }
public ActionResult DeleteConfirmed(int id) { FacultyDivision facultyDivision = db.FacultyDivisions.Find(id); db.FacultyDivisions.Remove(facultyDivision); db.SaveChanges(); return(RedirectToAction("Index")); }
public ActionResult Edit([Bind(Include = "FacultyId,DivisionId")] FacultyDivision facultyDivision) { if (ModelState.IsValid) { db.Entry(facultyDivision).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.DivisionId = new SelectList(db.Divisions, "DivisionId", "DivisionId", facultyDivision.DivisionId); ViewBag.FacultyId = new SelectList(db.Faculties, "FacultyId", "FacultyName", facultyDivision.FacultyId); return(View(facultyDivision)); }
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: FacultyDivisions/Details/5 public ActionResult Details(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } FacultyDivision facultyDivision = db.FacultyDivisions.Find(id); if (facultyDivision == null) { return(HttpNotFound()); } return(View(facultyDivision)); }
// GET: FacultyDivisions/Edit/5 public ActionResult Edit(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } FacultyDivision facultyDivision = db.FacultyDivisions.Find(id); if (facultyDivision == null) { return(HttpNotFound()); } ViewBag.DivisionId = new SelectList(db.Divisions, "DivisionId", "DivisionId", facultyDivision.DivisionId); ViewBag.FacultyId = new SelectList(db.Faculties, "FacultyId", "FacultyName", facultyDivision.FacultyId); return(View(facultyDivision)); }
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")); }