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 Retrieve(CourseEnrollmentContext courseEnrollmentContext) { var students = courseEnrollmentContext.Students.ToList(); Console.WriteLine("\n\t\tStudents List:"); foreach (var student in students) { Console.WriteLine($"\t\t\t{student.StudentID}- {student.FirstMidName} {student.LastName}"); } }
public static void Retrieve(CourseEnrollmentContext courseEnrollmentContext) { var courses = courseEnrollmentContext.Courses.ToList(); Console.WriteLine("\n\t\tCourses List:"); foreach (var course in courses) { Console.WriteLine($"\t\t\t{course.CourseID}- {course.Title} , {course.Credits} credits"); } Console.WriteLine(); }
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 Retrieve(CourseEnrollmentContext courseEnrollmentContext) { //var enrollments = courseEnrollmentContext.Enrollments.Include(p => p.Course).Include(p => p.Student).ToList(); var enrollments = courseEnrollmentContext.Enrollments.ToList(); Console.WriteLine("\n\nEnrollments List:"); foreach (var enrollment in enrollments) { Console.WriteLine($"{enrollment.EnrollmentID}- {enrollment.Student.FirstMidName} {enrollment.Student.LastName} , {enrollment.Course.Title} , {enrollment.Course.Credits} credits"); } Console.WriteLine(); }
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 CourseRepository(CourseEnrollmentContext context) { Context = context ?? throw new ArgumentNullException(nameof(context)); }