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