public static void Create(CourseEnrollmentContext courseEnrollmentContext) { StudentOperation.Retrieve(courseEnrollmentContext); CourseOperation.Retrieve(courseEnrollmentContext); Console.Write("\nStudent ID:"); var studentID = Convert.ToInt16(Console.ReadLine()); var student = courseEnrollmentContext.Students.FirstOrDefault(p => p.StudentID == studentID); Console.Write("\nCourse ID:"); var courseID = Convert.ToInt16(Console.ReadLine()); var course = courseEnrollmentContext.Courses.FirstOrDefault(p => p.CourseID == courseID); if (course != null && student != null) { courseEnrollmentContext.Enrollments.Add(new Enrollment() { Course = course, Student = student }); courseEnrollmentContext.SaveChanges(); } }
public static void TestUpdateOpertaion() { /// update : Changing John Travelta -> to Kevin Travelta var students = courseEnrollmentContext.Students.ToList(); var student = students.FirstOrDefault(p => p.FirstMidName == "John" && p.LastName == "Travelta"); if (student != null) { student.FirstMidName = "Kevin"; } courseEnrollmentContext.SaveChanges(); Console.WriteLine("\n******* Students List after Changing ************"); StudentOperation.Retrieve(courseEnrollmentContext); Console.WriteLine("\n******* Enrolment List after Changing ************"); EnrollmentOperation.Retrieve(courseEnrollmentContext); }
public static void PopulateDatabase() { if (courseEnrollmentContext.Enrollments.Count() == 0) { Course course1 = new Course() { Title = "Adv C#", Credits = 4 }; Course course2 = new Course() { Title = "React/Redux", Credits = 3 }; Course course3 = new Course() { Title = "Angular", Credits = 3 }; Student st1 = new Student() { FirstMidName = "John", LastName = "Travelta", EnrollmentDate = DateTime.Now }; Student st2 = new Student() { FirstMidName = "Robert", LastName = "Deniro", EnrollmentDate = DateTime.Now }; Student st3 = new Student() { FirstMidName = "Will", LastName = "Smith", EnrollmentDate = DateTime.Now }; Enrollment en1 = new Enrollment() { Course = course1, Student = st1 }; Enrollment en2 = new Enrollment() { Course = course1, Student = st2 }; Enrollment en3 = new Enrollment() { Course = course2, Student = st3 }; Enrollment en4 = new Enrollment() { Course = course3, Student = st2 }; Enrollment en5 = new Enrollment() { Course = course2, Student = st1 }; courseEnrollmentContext.Enrollments.Add(en1); courseEnrollmentContext.Enrollments.Add(en2); courseEnrollmentContext.Enrollments.Add(en3); courseEnrollmentContext.Enrollments.Add(en4); courseEnrollmentContext.Enrollments.Add(en5); courseEnrollmentContext.SaveChanges(); Console.WriteLine("\nDatabase populated successfully."); } Console.WriteLine("\n******* Initial Students List ************"); StudentOperation.Retrieve(courseEnrollmentContext); Console.WriteLine("\n******* Initial Course List ************"); CourseOperation.Retrieve(courseEnrollmentContext); Console.WriteLine("\n******* Initial Enrolment List ************"); EnrollmentOperation.Retrieve(courseEnrollmentContext); }