public ActionResult Create(AssignCourse assigncourse)
{
if (ModelState.IsValid)
{
var alreadyAssigned = db.AssignCourses.Any(a => a.CourseId == assigncourse.CourseId);
if (alreadyAssigned)
{
var teacherName =
db.AssignCourses.Include(a => a.Teacher)
.Where(a => a.CourseId == assigncourse.CourseId)
.Select(a => a.Teacher.Name);
var teacher = "";
foreach (var t in teacherName)
{
teacher = t;
}
TempData["error"] = "The Course is already Assigned to " + teacher;
}
else
{
int td = 0, cd = 0;
var teacherDept = db.Teachers.Where(a => a.Id == assigncourse.TeacherId).Select(a => a.DepartmentId);
foreach (var i in teacherDept)
{
td = i;
}
var courseDept = db.Courses.Where(a => a.Id == assigncourse.CourseId).Select(a => a.DepartmentId);
foreach (var i in courseDept)
{
cd = i;
}
if (td == cd)
{
db.AssignCourses.Add(assigncourse);
db.SaveChanges();
return RedirectToAction("Index");
}
else
{
TempData["error"] = "This course not belongs to teachers department(vice versa)";
}
}
}
ViewBag.DepartmentId = new SelectList(db.Departments, "Id", "Code", assigncourse.DepartmentId);
ViewBag.TeacherId = new SelectList(db.Teachers, "Id", "Name", assigncourse.TeacherId);
ViewBag.CourseId = new SelectList(db.Courses, "Id", "Code", assigncourse.CourseId);
return View(assigncourse);
}
public ActionResult Edit(AssignCourse assigncourse)
{
if (ModelState.IsValid)
{
db.Entry(assigncourse).State = EntityState.Modified;
db.SaveChanges();
return RedirectToAction("Index");
}
ViewBag.DepartmentId = new SelectList(db.Departments, "Id", "Code", assigncourse.DepartmentId);
ViewBag.TeacherId = new SelectList(db.Teachers, "Id", "Name", assigncourse.TeacherId);
ViewBag.CourseId = new SelectList(db.Courses, "Id", "Code", assigncourse.CourseId);
return View(assigncourse);
}