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