protected internal static void SqlQueries()
{
Console.Clear();
Console.WriteLine("Choose Action: ");
Console.WriteLine("1) Select * From Students.");
Console.WriteLine("2) Select * From Trainers.");
Console.WriteLine("3) Select * From Assignments.");
Console.WriteLine("4) Select * From Courses.");
Console.WriteLine("5) Students Per Course.");
Console.WriteLine("6) Trainers Per Course.");
Console.WriteLine("7) Assignment Per Course.");
Console.WriteLine("8) Assignment Per Course Per Student.");
Console.WriteLine("9) Students that belong to more than one course.");
Console.WriteLine("Press any other key to return to Main menu.");
ConsoleKeyInfo menuSelection;
menuSelection = Console.ReadKey(true);
SQL_Utils sQL_Utils = new SQL_Utils();
switch (menuSelection.KeyChar)
{
case '1':
Console.Clear();
Console.WriteLine("Select * From Students.\n");
sQL_Utils.SelectStudent();
Console.WriteLine("\n Press Enter to return to SQL queries execution menu. ");
Console.ReadLine();
SqlQueries();
break;
case '2':
Console.Clear();
Console.WriteLine("Select * From Trainers.\n");
sQL_Utils.SelectTrainer();
Console.WriteLine("\n Press Enter to return to SQL queries execution menu. ");
Console.ReadLine();
SqlQueries();
break;
case '3':
Console.Clear();
Console.WriteLine("Select * From Assignments.\n");
sQL_Utils.SelectAssignment();
Console.WriteLine("\n Press Enter to return to SQL queries execution menu. ");
Console.ReadLine();
SqlQueries();
break;
case '4':
Console.Clear();
Console.WriteLine("Select * From Courses.\n");
sQL_Utils.SelectCourse();
Console.WriteLine("\n Press Enter to return to SQL queries execution menu. ");
Console.ReadLine();
SqlQueries();
break;
case '5':
Console.Clear();
Console.WriteLine("Students Per Course.\n");
sQL_Utils.SelectStudentPerCourse();
Console.WriteLine("\n Press Enter to return to SQL queries execution menu. ");
Console.ReadLine();
SqlQueries();
break;
case '6':
Console.Clear();
Console.WriteLine("Trainers Per Course.\n");
sQL_Utils.SelectTrainerPerCourse();
Console.WriteLine("\n Press Enter to return to SQL queries execution menu. ");
Console.ReadLine();
SqlQueries();
break;
case '7':
Console.Clear();
Console.WriteLine("Assignment Per Course.\n");
sQL_Utils.SelectAssignment();
Console.WriteLine("\n Press Enter to return to SQL queries execution menu. ");
Console.ReadLine();
SqlQueries();
break;
case '8':
Console.Clear();
Console.WriteLine("Assignment Per Course Per Student.\n");
sQL_Utils.SelectAssignmentPerCoursePerStudent();
Console.WriteLine("\n Press Enter to return to SQL queries execution menu. ");
Console.ReadLine();
SqlQueries();
break;
case '9':
Console.Clear();
Console.WriteLine("Students that belong to more than one course.\n");
sQL_Utils.SelectStudentsWithMoreCourse();
Console.WriteLine("\n Press Enter to return to SQL queries execution menu. ");
Console.ReadLine();
SqlQueries();
break;
default:
Console.Clear();
Menu();
break;
}
}
