public static void Update(CourseEnrollmentContext courseEnrollmentContext) { var enrollments = courseEnrollmentContext.Enrollments.Include(p => p.Course).Include(p => p.Student).ToList(); Console.Write("\nEnrollment ID:"); var id = Console.ReadLine(); if (id != null) { var foundItem = courseEnrollmentContext.Enrollments.FirstOrDefault(p => p.EnrollmentID == Convert.ToInt16(id)); if (foundItem != null) { Console.WriteLine($"\n{ foundItem.Student.FirstMidName} {foundItem.Student.LastName} was enrolled for {foundItem.Course.CourseID}-{foundItem.Course.Title} "); Console.Write($"\nNew Course ID:"); var newCourseID = Convert.ToInt16(Console.ReadLine()); var newCourse = courseEnrollmentContext.Courses.FirstOrDefault(p => p.CourseID == newCourseID); foundItem.Course = newCourse; courseEnrollmentContext.SaveChanges(); Console.WriteLine("\nRecord was updated successfully."); } else { Console.WriteLine("\nRecord was not found."); } courseEnrollmentContext.SaveChanges(); } }
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 Create(CourseEnrollmentContext courseEnrollmentContext) { Course course = new Course(); Console.Write("\nCourse Name:"); course.Title = Console.ReadLine(); Console.Write("\nCredits:"); course.Credits = Convert.ToInt16(Console.ReadLine()); courseEnrollmentContext.Courses.Add(course); courseEnrollmentContext.SaveChanges(); }
public static void Create(CourseEnrollmentContext courseEnrollmentContext) { Student student = new Student(); Console.Write("\nStudent Name:"); student.FirstMidName = Console.ReadLine(); Console.Write("\nStudent Lastname:"); student.LastName = Console.ReadLine(); courseEnrollmentContext.Students.Add(student); courseEnrollmentContext.SaveChanges(); }
public static void Delete(CourseEnrollmentContext courseEnrollmentContext) { Console.Write("\nEnrollment ID:"); var id = Console.ReadLine(); Enrollment foundItem = courseEnrollmentContext.Enrollments.FirstOrDefault(p => p.EnrollmentID == Convert.ToInt16(id)); if (foundItem != null) { courseEnrollmentContext.Enrollments.Remove(foundItem); Console.WriteLine("\nRecord was deleted."); } else { Console.WriteLine("\nRecord was not found."); } courseEnrollmentContext.SaveChanges(); }
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); }