private static void OutputMenu()
{
string input;
Console.Clear();
do
{
PrintOutputMenu();
input = Console.ReadLine();
switch (input)
{
case "1":
{
DatabaseUtilities.PrintAllStudents();
Console.WriteLine();
break;
}
case "2":
{
DatabaseUtilities.PrintAllTrainers();
Console.WriteLine();
break;
}
case "3":
{
DatabaseUtilities.PrintAllAssignments();
Console.WriteLine();
break;
}
case "4":
{
DatabaseUtilities.PrintAllCourses();
Console.WriteLine();
break;
}
case "5":
{
DatabaseUtilities.PrintStudentsPerCourse();
Console.WriteLine();
break;
}
case "6":
{
DatabaseUtilities.PrintTrainersPerCourse();
Console.WriteLine();
break;
}
case "7":
{
DatabaseUtilities.PrintAssignmentsPerCourse();
Console.WriteLine();
break;
}
case "8":
{
DatabaseUtilities.PrintAssignmentsPerCoursePerStudent();
Console.WriteLine();
break;
}
case "9":
{
DatabaseUtilities.PrintStudentsWithMultipleCourses();
Console.WriteLine();
break;
}
case "10":
{
Console.Clear();
break;
}
}
} while (input != "11");
Console.Clear();
}
private static void InsertMenu()
{
string input;
Console.Clear();
do
{
PrintInsertMenu();
input = Console.ReadLine();
switch (input)
{
case "1":
{
Student student = new Student();
DatabaseUtilities.InsertStudent(student);
Console.WriteLine();
break;
}
case "2":
{
Trainer trainer = new Trainer();
DatabaseUtilities.InsertTrainer(trainer);
Console.WriteLine();
break;
}
case "3":
{
Assignment assignment = new Assignment();
DatabaseUtilities.InsertAssignment(assignment);
Console.WriteLine();
break;
}
case "4":
{
Course course = new Course();
DatabaseUtilities.InsertCourse(course);
Console.WriteLine();
break;
}
case "5":
{
DatabaseUtilities.InsertStudentsPerCourse();
Console.WriteLine();
break;
}
case "6":
{
DatabaseUtilities.InsertTrainersPerCourse();
Console.WriteLine();
break;
}
case "7":
{
DatabaseUtilities.InsertAssignmentsPerStudentPerCourse();
Console.WriteLine();
break;
}
case "10":
{
Console.Clear();
break;
}
}
} while (input != "11");
Console.Clear();
}
