//POST: Classes/Filter/{} // ActionResult function to filter and display all the classes that follows the defined constraints. public ActionResult Filter(string class_id = null, string class_code = null, string teacher_id = null, string date_start = null, string date_end = null, string class_name = null, string teacher_name = null, string employee_number = null) { // setting default date here for testing if (date_start == null) { date_start = "2000-01-01"; } if (date_end == null) { date_end = "2200-01-01"; } Classes NewSearchClass = new Classes { classId = Convert.ToString(class_id), classCode = Convert.ToString(class_code), teacherId = Convert.ToInt32(teacher_id), startdate = DateTime.Parse(date_start), finishdate = DateTime.Parse(date_end), classname = Convert.ToString(class_name), teacherName = Convert.ToString(teacher_name), employeeNumber = Convert.ToString(employee_number) }; ClassesDataController controller = new ClassesDataController(); IEnumerable <Classes> filterClasses = controller.FilterClasses(NewSearchClass); return(View(filterClasses)); }
// GET: Teacher/Show/{id} public ActionResult Show(int id) { TeacherDataController controller = new TeacherDataController(); Teacher newTeacher = controller.FindTeacher(id); Classes NewSearchClass = new Classes { employeeNumber = Convert.ToString(newTeacher.employeeNumber) }; ClassesDataController class_controller = new ClassesDataController(); IEnumerable <Classes> filterClasses = class_controller.FilterClasses(NewSearchClass); TeacherClass newTeacherClass = new TeacherClass { classes = filterClasses, teacher = newTeacher }; return(View(newTeacherClass)); }
// GET: Student/Show public ActionResult Show(int id) { StudentDataController controller = new StudentDataController(); Student newStudent = controller.FindStudent(id); StuXCla filterClass = new StuXCla { student_id = id }; StudentXClassesDataController studentxclass_controller = new StudentXClassesDataController(); IEnumerable <StuXCla> listofStuXClass = studentxclass_controller.ListClassesOfStudent(filterClass); List <Classes> listofClassesStudentIsTaking = new List <Classes> { }; ClassesDataController class_controller = new ClassesDataController(); string StringOfClassIDs = ""; foreach (var StuXIns in listofStuXClass) { StringOfClassIDs += StuXIns.class_id + ","; } Classes listClass = new Classes { classId = StringOfClassIDs }; IEnumerable <Classes> ListOfClassesTakenByAStudent = class_controller.FilterClasses(listClass); StudentAndTheirClasses studentclass = new StudentAndTheirClasses { student = newStudent, classes = ListOfClassesTakenByAStudent }; return(View(studentclass)); }