private static void DropRegistration(string studentNum, string courseCode)// b. { using (SRS1179Entities db = new SRS1179Entities()) { Student s = db.Students.Where(st => st.StudentNum == studentNum).First(); Course c = db.Courses.Where(cr => cr.CourseCode == courseCode).First(); s.Courses.Remove(c); db.SaveChanges(); Console.WriteLine($"Registration dropped: {s.FirstName} -> {c.CourseName}"); } }
private static void DisplayCourseRegistrationsCourse(string sn) //d. { using (SRS1179Entities db = new SRS1179Entities()) { Student s = db.Students.Where(st => st.StudentNum.Equals(sn)).First(); Console.WriteLine($"Course registration for {s.FirstName} {s.LastName}:"); foreach (Course c in s.Courses) { Console.WriteLine($"{c.CourseName} - {c.CourseCode}"); } } }
private static void DisplayCourseRegistrationsStudent(string cn)// e. { using (SRS1179Entities db = new SRS1179Entities()) { Course c = db.Courses.Where(cr => cr.CourseCode.Equals(cn)).First(); Console.WriteLine($"Student registration for {c.CourseCode} {c.CourseName}:"); foreach (Student s in c.Students) { Console.WriteLine($"{s.FirstName} - {s.LastName}"); } } }
private static void DropAllCourseRegistrations()// f. { using (SRS1179Entities db = new SRS1179Entities()) { List <Course> courses = db.Courses.ToList(); foreach (Course c in courses) { c.Students.Clear(); } db.SaveChanges(); Console.WriteLine("All course registrations dropped"); } }
private static void DisplayCourseRegistrations()// c. { using (SRS1179Entities db = new SRS1179Entities()) { List <Course> courses = db.Courses.ToList(); foreach (Course c in courses) { List <Student> StudentEnrollCourses = c.Students.ToList(); Console.WriteLine($"{c.CourseName} - {c.CourseCode}:"); foreach (Student s in StudentEnrollCourses) { Console.WriteLine($"{s.FirstName} {s.LastName}"); } Console.WriteLine(); } } }