//f. A method to remove all course registrations for all students in the database public static void removeCourseRegistrations() { Console.WriteLine("removeCourseRegistration() invoked."); using (var db = new Winter2015Lab1DBEntities()) { var q = from c in db.Courses select c; foreach (Course course in q) { course.Students.Clear(); } } }
//c. A method to display all course registrations for all students to the console. This method should display course names, course codes and student names public static void displayCourseRegistration() { Console.WriteLine("displayCourseRegistration() invoked."); using (var db = new Winter2015Lab1DBEntities()) { var q = from c in db.Courses select c; foreach (Course course in q) { Console.WriteLine("{0} - {1}", course.courseCode, course.courseName); } } }
//e. A method to display all students who are registered for a particular course on the console based on a course parameter. This method should display course names, course codes and student names public static void allStudentsOneCourse(String courseCode) { Console.WriteLine("allStudentsOneCourse(String courseCode) invoked."); using (var db = new Winter2015Lab1DBEntities()) { Course cou = (from c in db.Courses where c.courseCode == courseCode select c).First(); Console.WriteLine("{0} - {1}", cou.courseCode, cou.courseName); foreach (Student student in cou.Students) { Console.WriteLine("\t\t{0} {1}", student.firstName, student.lastName); } } }
//d. A method to display all course registrations for one student to the console based on a student number parameter. This method should display course names, course codes and student names public static void allCoursesOneStudent(String studentNum) { Console.WriteLine("allCoursesOneStudent(String studentNum) invoked."); using (var db = new Winter2015Lab1DBEntities()) { Student stu = (from s in db.Students where s.StudentNum == studentNum select s).First(); Console.WriteLine("{0} - {1} {2}", stu.StudentNum, stu.firstName, stu.lastName); foreach (Course course in stu.Courses) { Console.WriteLine("\t\t{0} - {1}", course.courseCode, course.courseName); } } }
//a. A method to add a new course registration with parameters for the student number and course code public static void addCourseRegistration(String studentNum, string courseCode) { Console.WriteLine("addCourseRegistration() invoked."); using (var db = new Winter2015Lab1DBEntities()) { Student stu = (from s in db.Students where s.StudentNum == studentNum select s).First(); Course cou = (from c in db.Courses where c.courseCode == courseCode select c).First(); cou.Students.Add(stu); db.SaveChanges(); } }