public ActionResult Create(AssignedCourse assignedcourse)
{
if (ModelState.IsValid)
{
if(assignedcourse.CourseID==0||assignedcourse.TeacherID==0)
{
ViewBag.Message = "All the fields are required !!!";
ViewBag.DepartmentID = new SelectList(db.DepartmentDbSet, "DepartmentID", "DeptCode");
ViewBag.CourseID = new SelectList("", "CourseID", "CourseCode");
ViewBag.TeacherID = new SelectList("", "TeacherID", "TeacherName");
return View();
}
AssignedCourse testAsnCourse = db.AssignedCourseDbSet.FirstOrDefault(asc => asc.CourseID == assignedcourse.CourseID);
Course aCourse = db.CourseDbSet.FirstOrDefault(c => c.CourseID == assignedcourse.CourseID);
Teacher aTeacher = db.TeacherDbSet.FirstOrDefault(t => t.TeacherID == assignedcourse.TeacherID);
if (testAsnCourse != null)
{
Teacher assignTeacher =
db.TeacherDbSet.FirstOrDefault(asignt => asignt.TeacherID == testAsnCourse.TeacherID);
if (assignTeacher != null)
if (aCourse != null)
ViewBag.Message = "The course :- " + aCourse.CourseCode + " has already been assaigned to "+assignTeacher.TeacherName;
ViewBag.DepartmentID = new SelectList(db.DepartmentDbSet, "DepartmentID", "DeptCode");
ViewBag.CourseID = new SelectList(db.CourseDbSet.Where(c=>c.DepartmentID==aCourse.DepartmentID), "CourseID", "CourseCode");
ViewBag.TeacherID = new SelectList(db.TeacherDbSet.Where(t=>t.DepartmentID==aTeacher.DepartmentID), "TeacherID", "TeacherName");
return View();
}
if (aTeacher.CreditsRemaining < aCourse.Credit)
{
Session["Teacher"] = aTeacher;
Session["Course"] = aCourse;
Session["AssignedCourse"] = assignedcourse;
return RedirectToAction("AskToAssign");
}
aTeacher.CreditsHaveTaken += aCourse.Credit;
aTeacher.CreditsRemaining -= aCourse.Credit;
db.AssignedCourseDbSet.Add(assignedcourse);
aCourse.AssignedTo = aTeacher.TeacherName;
if (db.SaveChanges() >= 0)
ViewBag.Message = "The Course :- " + aCourse.CourseCode
+ " has been assigned to Teacher :- " + aTeacher.TeacherName
+ " successfully .";
ViewBag.DepartmentID = new SelectList(db.DepartmentDbSet, "DepartmentID", "DeptCode");
ViewBag.CourseID = new SelectList("", "CourseID", "CourseCode");
ViewBag.TeacherID = new SelectList("", "TeacherID", "TeacherName");
return View();
}
ViewBag.DepartmentID = new SelectList(db.DepartmentDbSet, "DepartmentID", "DeptCode");
ViewBag.CourseID = new SelectList("", "CourseID", "CourseCode");
ViewBag.TeacherID = new SelectList("", "TeacherID", "TeacherName");
return View();
}
public ActionResult Edit(AssignedCourse assignedcourse)
{
if (ModelState.IsValid)
{
db.Entry(assignedcourse).State = EntityState.Modified;
db.SaveChanges();
return RedirectToAction("Index");
}
ViewBag.CourseID = new SelectList(db.CourseDbSet, "CourseID", "CourseCode", assignedcourse.CourseID);
ViewBag.TeacherID = new SelectList(db.TeacherDbSet, "TeacherID", "TeacherName", assignedcourse.TeacherID);
return View(assignedcourse);
}
