public static void TestDeleteOpertaion() { /// Delete : Deleting EnrollmentID = 1 var enrollments = courseEnrollmentContext.Enrollments.ToList(); var item = enrollments.FirstOrDefault(p => p.EnrollmentID == 1); if (item != null) { courseEnrollmentContext.Enrollments.Remove(item); courseEnrollmentContext.SaveChanges(); Console.WriteLine("\n******* New Enrolment List : ID=1 was deleted ************"); EnrollmentOperation.Retrieve(courseEnrollmentContext); } /// Deleting Will Smith /// var students = courseEnrollmentContext.Students.ToList(); var student = students.FirstOrDefault(p => p.FirstMidName == "Will" && p.LastName == "Smith"); if (student != null) { courseEnrollmentContext.Students.Remove(student); courseEnrollmentContext.SaveChanges(); Console.WriteLine("\n******* New Students List : Will Smith was deleted ************"); EnrollmentOperation.Retrieve(courseEnrollmentContext); } }
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); }
static void Main(string[] args) { PopulateDatabase(); TestUpdateOpertaion(); TestDeleteOpertaion(); ConsoleKeyInfo key; Console.WriteLine("\n**These operation only works with Enrollment"); Console.Write("\nCreat/Retrieve/Update/Delete/eXit:"); while ((key = Console.ReadKey(true)).Key != ConsoleKey.X) { switch (key.Key) { case ConsoleKey.C: EnrollmentOperation.Create(courseEnrollmentContext); break; case ConsoleKey.R: EnrollmentOperation.Retrieve(courseEnrollmentContext); break; case ConsoleKey.U: EnrollmentOperation.Update(courseEnrollmentContext); break; case ConsoleKey.D: EnrollmentOperation.Delete(courseEnrollmentContext); break; default: Console.WriteLine(" Try Again!"); break; } Console.Write("\nCreat/Retrieve/Update/Delete/eXit:"); } }
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); }