public async Task <IActionResult> PutFacultyCourse([FromRoute] int id, [FromBody] FacultyCourse facultyCourse) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } if (id != facultyCourse.CourseId) { return(BadRequest()); } _context.Entry(facultyCourse).State = EntityState.Modified; try { await _context.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!FacultyCourseExists(id)) { return(NotFound()); } else { throw; } } return(NoContent()); }
public async Task <IActionResult> PostFacultyCourse([FromBody] FacultyCourse facultyCourse) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } _context.FacultyCourse.Add(facultyCourse); try { await _context.SaveChangesAsync(); } catch (DbUpdateException) { if (FacultyCourseExists(facultyCourse.CourseId)) { return(new StatusCodeResult(StatusCodes.Status409Conflict)); } else { throw; } } return(CreatedAtAction("GetFacultyCourse", new { id = facultyCourse.CourseId }, facultyCourse)); }
public ActionResult DeleteConfirmed(int id) { FacultyCourse facultyCourse = db.FacultyCourses.Find(id); db.FacultyCourses.Remove(facultyCourse); db.SaveChanges(); return(RedirectToAction("Index")); }
public ActionResult Edit([Bind(Include = "ID,SupervisorID,CourseID")] FacultyCourse facultyCourse) { if (ModelState.IsValid) { db.Entry(facultyCourse).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.CourseID = new SelectList(db.Courses, "ID", "Code", facultyCourse.CourseID); ViewBag.SupervisorID = new SelectList(db.Supervisors, "ID", "Name", facultyCourse.SupervisorID); return(View(facultyCourse)); }
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: FacultyCourses/Details/5 public ActionResult Details(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } FacultyCourse facultyCourse = db.FacultyCourses.Find(id); if (facultyCourse == null) { return(HttpNotFound()); } return(View(facultyCourse)); }
public ActionResult Delete(int?id1, int?id2, int?id3) { if (id1 == null || id2 == null || id3 == null) { return(RedirectToAction("Index")); } if (Session["userType"] == null || (Session["userType"] != null && !Session["userType"].Equals("Admin"))) { return(RedirectToAction("Index", "Login")); } FacultyCourse fd1 = db.FacultyCourses.Where(fd => fd.CourseId == id1 && fd.FacultyId == id2 && fd.DivisionId == id3).FirstOrDefault(); return(View(fd1)); }
// GET: FacultyCourses/Edit/5 public ActionResult Edit(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } FacultyCourse facultyCourse = db.FacultyCourses.Find(id); if (facultyCourse == null) { return(HttpNotFound()); } ViewBag.CourseID = new SelectList(db.Courses, "ID", "Code", facultyCourse.CourseID); ViewBag.SupervisorID = new SelectList(db.Supervisors, "ID", "Name", facultyCourse.SupervisorID); return(View(facultyCourse)); }
private async Task <Tuple <Course, FacultyCourse> > Assign(Faculty faculty, int courseID) { bool assignedCourse = faculty.FacultyCourses.Any(fc => fc.Course.CourseID == courseID); if (!assignedCourse) { Course course = await courseRepo.Courses.FirstOrDefaultAsync(c => c.CourseID == courseID); if (course != null) { FacultyCourse facultyCourse = new FacultyCourse { Course = course, Faculty = faculty }; course.FacultyCourses.Add(facultyCourse); Tuple <Course, FacultyCourse> content = new Tuple <Course, FacultyCourse>(course, facultyCourse); return(content); } } return(null); }
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")); }