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"));
}
