public ActionResult ClassSchedule(Department aDepartment) { ViewBag.DepartmentId = new SelectList(db.Departments, "DepartmentId", "DepartmentName"); List<Course> courses = (from c in db.Courses where c.Department.DepartmentId == aDepartment.DepartmentId select c).ToList(); List<AllocateRoom> allocations = db.AllocateRooms.ToList(); List<string> code = new List<string>(); List<string> name = new List<string>(); List<string> schdule = new List<string>(); foreach (Course course in courses) { string message = ""; foreach (AllocateRoom allocation in allocations) { int flag = 0; if (course.CourseId == allocation.CourseId) { if (flag == 0) { message += "R-No: "; flag = 1; } Room aRoom = (from r in db.Rooms where r.RoomId == allocation.RoomId select r).SingleOrDefault(); Day day = (from d in db.Days where d.DayId == allocation.DayId select d).SingleOrDefault(); allocation.Room = aRoom; allocation.Day = day; message += aRoom.RoomNo + ", " + day.DayName + ", " + allocation.StartingTime + " - " + allocation.EndingTime + ";"; } } if (message == "") message += "Couse Yet not Scheduled"; schdule.Add(message); code.Add(course.CourseCode); name.Add(course.CourseName); } ViewBag.CourseCode = code; ViewBag.CourseName = name; ViewBag.Schedules = schdule; return View(); }
private string ValidationForDepartment(Department department) { string message = ""; if (department.DepartmentCode == "") { message += "Code not given"; } if (department.DepartmentCode != "" && db.Departments.Count(d => d.DepartmentCode == department.DepartmentCode) != 0) { message += "Code already exists" + "\n"; } if (department.DepartmentName == "") { message += "Name not given"; } if (department.DepartmentName != "" && db.Departments.Count(d => d.DepartmentName == department.DepartmentName) != 0) { message += "Name already exists" + "\n"; } return message; }
public ActionResult Create(Department department) { department.DepartmentCode = department.DepartmentCode.ToUpper(); department.DepartmentName = department.DepartmentName.ToUpper(); // check validation string message = ValidationForDepartment(department); if (message != "") { ViewBag.Message = message; return View(department); } // save it to the database if (ModelState.IsValid) { db.Departments.Add(department); db.SaveChanges(); return RedirectToAction("Index"); } return View(department); }
public ActionResult CourseAssign(Department aDepartment, Course aCourse, Teacher aTeacher) { string message = ValidationForCourseAssign(aDepartment, aCourse, aTeacher); if (message != "") { ViewBag.DepartmentId = new SelectList(db.Departments, "DepartmentId", "DepartmentName"); ViewBag.TeacherId = new SelectList("", "", "TeacherName"); ViewBag.CourseId = new SelectList("", "", "CourseName"); ViewBag.Message = message; return View(); } aTeacher = db.Teachers.Find(aTeacher.TeacherId); aCourse = db.Courses.Find(aCourse.CourseId); // assiging teacher to this course aCourse.Teacher = aTeacher; // update remaining credit for teacher aTeacher.TeacherRemainingCredit -= aCourse.CourseCredit; //save data to database if (!ModelState.IsValid) { db.Entry(aCourse).State = EntityState.Modified; db.SaveChanges(); db.Entry(aTeacher).State = EntityState.Modified; db.SaveChanges(); return RedirectToAction("Index"); } return View(); }
private string ValidationForCourseAssign(Department aDepartment, Course aCourse, Teacher aTeacher) { string message = ""; if (aDepartment.DepartmentId == 0 || aCourse.CourseId == 0 || aTeacher.TeacherId == 0) { message += "Incomplete form submit, any field is not yet set "; } // is teacher and course is not from the same department aDepartment = db.Departments.Find(aDepartment.DepartmentId); aTeacher = db.Teachers.Find(aTeacher.TeacherId); aCourse = db.Courses.Find(aCourse.CourseId); if (aDepartment.DepartmentId != aTeacher.DepartmentId || aCourse.DepartmentId != aTeacher.DepartmentId) { ViewBag.DepartmentId = new SelectList(db.Departments, "DepartmentId", "DepartmentName"); ViewBag.TeacherId = new SelectList(db.Teachers, "TeacherId", "TeacherName"); ViewBag.CourseId = new SelectList(db.Courses, "CourseId", "CourseName"); if (aDepartment.DepartmentId != aCourse.DepartmentId) { message += "Your Course is not from the selected department"; } else if (aCourse.DepartmentId != aTeacher.DepartmentId) { message += "Your Teacher is not from the selected department"; } } // if course is already assigned if (aCourse.Teacher != null) { message += "Course Already Assigned"; } return message; }