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