// GET: Classes/Show/{} // ActionResult function to display details about a particular class public ActionResult Show(int id) { ClassesDataController controller = new ClassesDataController(); Classes newClass = controller.FindClass(id); StuXCla filterClass = new StuXCla { class_id = id }; StudentXClassesDataController studentxclass_controller = new StudentXClassesDataController(); IEnumerable <StuXCla> listofStuXClass = studentxclass_controller.ListClassesOfStudent(filterClass); List <Student> listofStudentsTakingAClass = new List <Student> { }; StudentDataController student_controller = new StudentDataController(); string StringOfStudentIDs = ""; foreach (var StuXIns in listofStuXClass) { StringOfStudentIDs += StuXIns.student_id + ","; } IEnumerable <Student> ListOfStudentsInAClass = student_controller.FilterStudents(null, null, null, null, StringOfStudentIDs); ClassAndTheirStudents studentclass = new ClassAndTheirStudents { classes = newClass, students = ListOfStudentsInAClass }; return(View(studentclass)); }
public IEnumerable <StuXCla> ListClassesOfStudent(StuXCla studentClassFilter) { // Creating instance of the connection MySqlConnection Conn = School.AccessDatabase(); // Opening connection between server and DB Conn.Open(); // New command for query MySqlCommand cmd = Conn.CreateCommand(); // SQL query for filtering cmd.CommandText = "Select * from studentsxclasses where studentid = @studentkey or classid = @classkey;"; // Sanitizing the query to prevent SQL injection cmd.Parameters.AddWithValue("@studentkey", studentClassFilter.student_id); cmd.Parameters.AddWithValue("@classkey", studentClassFilter.class_id); cmd.Prepare(); // Storing the result of query execution into a variable MySqlDataReader ResultSet = cmd.ExecuteReader(); // empty list of type Student List <StuXCla> Details = new List <StuXCla> { }; // Read until the result set is complete while (ResultSet.Read()) { StuXCla NewStuXClassInstance = new StuXCla { class_id = Convert.ToInt32(ResultSet["classid"]), student_id = Convert.ToInt32(ResultSet["studentid"]) }; // Adding student object into a list Details.Add(NewStuXClassInstance); } // Close the connection Conn.Close(); // Return the list of objects return(Details); }
// 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)); }