public void ModuleList(AssignmentModelContext dbC)
{
var modules = dbC.Modules.OrderBy(m => m.ModuleID);
if (modules != null)
{
Console.WriteLine("MODULE LIST");
Console.WriteLine("___________");
var sb = new StringBuilder();
sb.Append(String.Format("{0,-15} {1,-10}\n", "MODULE CODE", "MODULE NAME"));
foreach (var item in modules)
{
sb.Append(String.Format("{0,-15} {1,-10}\n", item.ModuleCode, item.ModuleName));
}
Console.WriteLine(sb);
Console.WriteLine("____________________________");
}
else
{
Console.WriteLine("No modules found");
Console.WriteLine("____________________________");
}
}
static void Main(string[] args)
{
Program menu = new Program();
using (var db = new AssignmentModelContext())
{
Console.WriteLine("\nUNIVERSITY ATTEDNANCE REGISTER");
Console.WriteLine("______________________________");
while (true)
{
Console.WriteLine("Please Select from the following options.");
Console.WriteLine("1. Display All Modules");
Console.WriteLine("2. Find Instructor By Module");
Console.WriteLine("3. Display Module Learning Events");
Console.WriteLine("4. Display Attendance By Student");
Console.WriteLine("5. Display Students Missing Events");
Console.WriteLine("6. Display Attendance Report");
Console.WriteLine("0. Exit");
int choice = 0;
Console.Write("ENTER Your Selection: ");
while (!(int.TryParse(Console.ReadLine(), out choice) && (choice >= 0 && choice <= 6)))
{
Console.WriteLine("You need to enter a value 0..7\n");
Console.Write("ENTER Your Selection: ");
}
Console.WriteLine("____________________");
switch (choice)
{
case 1:
menu.ModuleList(db);
break;
case 2:
menu.StaffByModule(db);
break;
case 3:
menu.LearningEventByModule(db);
break;
case 4:
menu.StudentAttendanceByModule(db);
break;
case 5:
menu.StudentsMissing(db);
break;
case 6:
menu.ModuleAttendance(db);
break;
case 0:
Console.WriteLine("Thank you for using the system. Press any key to exit");
Console.ReadKey();
return;
}
}
}
}
