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();
}
}
}
