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