public static void Show()
{
privateschoolEntities dbContex = new privateschoolEntities();
int counter = 0;
Console.WriteLine();
Console.ForegroundColor = ConsoleColor.Gray;
Console.WriteLine("*******************************************");
Console.ForegroundColor = ConsoleColor.Red;
Console.WriteLine($"Students enlisted in more than one Courses: ");
Console.ForegroundColor = ConsoleColor.Gray;
Console.WriteLine("*******************************************");
foreach (var student in dbContex.students)
{
if (student.courses.Count > 1)
{
Console.ForegroundColor = ConsoleColor.Magenta;
Console.WriteLine($"{student.firstname} {student.lastname}");
counter++;
}
Console.ForegroundColor = ConsoleColor.White;
}
if (counter == 0)
{
Console.WriteLine("There aren't any Students Enlisted in more than one Courses.");
Console.WriteLine();
}
}
public void InputCourseID()
{
privateschoolEntities dbContex = new privateschoolEntities();
bool valid = true;
do
{
try
{
Console.WriteLine("Type the ID of the COURSE of the Assignment: ");
Assignment.courseid = Convert.ToInt32(Console.ReadLine());
var courseExists = dbContex.courses.Any(c => c.id == Assignment.courseid);
if (!courseExists)
{
Console.WriteLine("The course ID you typed doesn't Exist !!!");
}
else
{
Console.WriteLine($"You successfully added the assignment to Course with ID: {Assignment.courseid} !!! ");
valid = false;
}
}
catch (Exception)
{
Console.WriteLine("Type a Correct Course ID !!!");
}
} while (valid);
}
public static void Show()
{
privateschoolEntities dbContex = new privateschoolEntities();
Console.WriteLine();
Console.ForegroundColor = ConsoleColor.Magenta;
Console.WriteLine("++++++++++ ASSIGNMENTS PER COURSE +++++++++ ");
Console.ForegroundColor = ConsoleColor.Yellow;
foreach (var course in dbContex.courses)
{
Console.WriteLine();
Console.ForegroundColor = ConsoleColor.Cyan;
Console.WriteLine($"Course {course.title} Has {course.assignments.Count} Assignments:");
Console.ForegroundColor = ConsoleColor.Yellow;
Console.WriteLine("---------------------+--------------------------------+----------------------+------------+--------------+");
Console.WriteLine("{0,-21}| {1,-30 } | {2,-20} | {3,-9} | {4,-12} ", "Title", "Description", "Submission Date", "Oral Mark", "Total Mark");
Console.WriteLine("---------------------+--------------------------------+----------------------+------------+--------------+");
Console.ForegroundColor = ConsoleColor.White;
foreach (var item in course.assignments)
{
Console.WriteLine($"{item.title,-20} | {item.description,-30} | {item.subdatetime.ToString("dd/MM/yyyy"),-20} | {item.oralmark,-10} | {item.totalmark,-12}");
}
Console.WriteLine("---------------------+--------------------------------+----------------------+------------+--------------+");
}
}
public void InputID()
{
privateschoolEntities dbContex = new privateschoolEntities();
bool valid = true;
do
{
try
{
Console.WriteLine(" Type the Trainer ID: ");
Trainer.id = Convert.ToInt32(Console.ReadLine());
var trainerExists = dbContex.trainers.Any(t => t.id == Trainer.id);
if (trainerExists)
{
Console.ForegroundColor = ConsoleColor.Magenta;
Console.WriteLine("The Trainer ID already exists !!! ");
Console.ForegroundColor = ConsoleColor.White;
}
else
{
valid = false;
}
}
catch (Exception)
{
Console.ForegroundColor = ConsoleColor.Red;
Console.WriteLine("Type a correct ID !!!!");
Console.ForegroundColor = ConsoleColor.White;
}
} while (valid);
}
public void MultipleTrainerInput()
{
bool valid = true;
do
{
TrainerDataCapture trainerCapture = new TrainerDataCapture();
trainers trainer = trainerCapture.Capture();
using (privateschoolEntities dbContex = new privateschoolEntities())
{
dbContex.trainers.Add(trainer);
dbContex.SaveChanges();
}
Console.WriteLine();
Music.EndBeep();
Console.ForegroundColor = ConsoleColor.Cyan;
Console.WriteLine("TRAINER HAS BEEN CREATED");
Console.ForegroundColor = ConsoleColor.Yellow;
Console.WriteLine("Do you want to create another Trainer? Press 'NO' or 'no' to exit.");
Console.WriteLine("Type anything else to continue creating another Trainer");
Console.ForegroundColor = ConsoleColor.White;
string value = Console.ReadLine();
if (value == "NO" || value == "No" || value == "no")
{
valid = false;
}
} while (valid);
}
public void MultipleCourseInput()
{
bool valid = true;
do
{
CourseDataCapture courseCapture = new CourseDataCapture();
courses course = courseCapture.Capture();
using (privateschoolEntities dbContex = new privateschoolEntities())
{
dbContex.courses.Add(course);
dbContex.SaveChanges();
}
Music.EndBeep();
Console.WriteLine();
Console.ForegroundColor = ConsoleColor.Cyan;
Console.WriteLine("COURSE HAS BEEN CREATED");
Console.ForegroundColor = ConsoleColor.Yellow;
Console.WriteLine("Do you want to create another course? Press 'NO' or 'no' to exit.");
Console.WriteLine("Type anything else to continue creating another Course");
Console.ForegroundColor = ConsoleColor.White;
string value = Console.ReadLine();
if (value == "NO" || value == "No" || value == "no")
{
valid = false;
}
} while (valid);
}
public static void Show()
{
privateschoolEntities dbContex = new privateschoolEntities();
Console.WriteLine();
Console.ForegroundColor = ConsoleColor.Magenta;
Console.WriteLine("++++++++++ STUDENTS PER COURSE +++++++++ ");
Console.ForegroundColor = ConsoleColor.Yellow;
foreach (var course in dbContex.courses)
{
Console.WriteLine();
Console.ForegroundColor = ConsoleColor.Cyan;
Console.WriteLine($"Course {course.title} Has {course.students.Count} students:");
Console.ForegroundColor = ConsoleColor.Yellow;
Console.ForegroundColor = ConsoleColor.Yellow;
Console.WriteLine("----------------+----------------------+----------------------+-----------------+--------------------+");
Console.WriteLine("{0,-16}| {1,-20 } | {2,-20} | {3,-15} | {4,-15} ", "First Name", "Last Name", "Date of Birth", "Tuition Fees", "Student ID");
Console.WriteLine("----------------+----------------------+----------------------+-----------------+--------------------+");
Console.ForegroundColor = ConsoleColor.White;
foreach (var item in course.students)
{
Console.WriteLine($"{item.firstname,-15 } | {item.lastname,-20} | {item.dateofbirth.ToString("dd/MM/yyyy"),-20} | {item.tuitionfees,-15} | {item.id,-15} ");
}
Console.WriteLine("----------------+----------------------+----------------------+-----------------+--------------------+");
}
}
public static void Show()
{
privateschoolEntities dbContex = new privateschoolEntities();
Console.WriteLine();
Console.ForegroundColor = ConsoleColor.Magenta;
Console.WriteLine("++++++++++ TRAINERS PER COURSE +++++++++ ");
Console.ForegroundColor = ConsoleColor.Yellow;
foreach (var course in dbContex.courses)
{
Console.WriteLine();
Console.ForegroundColor = ConsoleColor.Cyan;
Console.WriteLine($"Course {course.title} Has {course.trainers.Count} Trainers:");
Console.ForegroundColor = ConsoleColor.Yellow;
Console.ForegroundColor = ConsoleColor.Yellow;
Console.WriteLine("----------------+----------------------+----------------------+-----------------+--------------------+");
Console.WriteLine("{0,-16}| {1,-20 } | {2,-20} | {3,-15} | {4,-20} ", "First Name", "Last Name", "Teaching Subject", "Trainer ID", "Teaching Course");
Console.WriteLine("----------------+----------------------+----------------------+-----------------+--------------------+");
Console.ForegroundColor = ConsoleColor.White;
foreach (var item in course.trainers)
{
Console.WriteLine($"{item.firstname,-15 } | {item.lastname,-20} | {item.subject,-15} | {item.id,-15} | {item.courses.title,-20} ");
}
Console.WriteLine("----------------+----------------------+----------------------+-----------------+--------------------+");
}
}
public void InputID()
{
privateschoolEntities dbContex = new privateschoolEntities();
bool valid = true;
do
{
try
{
Console.WriteLine(" Type the ID of the Assignment: ");
Assignment.id = Convert.ToInt32(Console.ReadLine());
var assignExists = dbContex.assignments.Any(a => a.id == Assignment.id);
if (assignExists)
{
Console.ForegroundColor = ConsoleColor.Red;
Console.WriteLine("The Assignment ID already exists !!! ");
Console.ForegroundColor = ConsoleColor.White;
}
else
{
valid = false;
}
}
catch (Exception)
{
Console.ForegroundColor = ConsoleColor.Yellow;
Console.WriteLine("Type a correct ID !!!!");
Console.ForegroundColor = ConsoleColor.White;
}
} while (valid);
}
public static void Enroll()
{
//List<assignments> assignments = new List<assignments>();
StudentDataCapture studentCapture = new StudentDataCapture();
students student = studentCapture.Capture();
privateschoolEntities dbContex = new privateschoolEntities();
try
{
Console.WriteLine("which course do you want the student to attend?(type course ID!): ");
int studentcourse = Convert.ToInt32(Console.ReadLine());
var courseExists = dbContex.courses.Any(c => c.id == studentcourse);
bool validd = true;
do
{
if (!courseExists)
{
Console.WriteLine("The course ID you typed doesn't Exist !!!");
validd = false;
}
else
{
courses course = dbContex.courses.First(c => c.id == studentcourse);
student.courses.Add(course);
foreach (var assign in dbContex.assignments)
{
if (course.assignments.Contains(assign))
{
student.assignments.Add(assign);
}
}
Console.WriteLine($"You successfully added the Student to Course with ID: {studentcourse} !!! ");
validd = false;
}
} while (validd);
}
catch (Exception)
{
Console.WriteLine("Type a Correct Course ID !!!");
}
dbContex.students.Add(student);
dbContex.SaveChanges();
}
public static void Show()
{
privateschoolEntities dbContex = new privateschoolEntities();
Console.WriteLine();
Console.ForegroundColor = ConsoleColor.Green;
Console.WriteLine("List of All Courses ");
Console.ForegroundColor = ConsoleColor.Yellow;
Console.WriteLine("----------------------+-----------------+------------+------------+------------+-----------+");
Console.WriteLine("{0,-23}| {1,-15 } | {2,-10} | {3,9} | {4,-9} | {5,-10}", "Title", "Type", "Stream", "Start Date", "End Date", "Course ID");
Console.WriteLine("----------------------+-----------------+------------+------------+------------+-----------+");
Console.ForegroundColor = ConsoleColor.White;
foreach (var item in dbContex.courses)
{
Console.WriteLine($" {item.title,-20 } | {item.type,-15} | {item.stream,-10} | {item.start_date.ToString("dd/MM/yyyy"),-10} | {item.end_date.ToString("dd/MM/yyyy"),-9} | {item.id,-4} ");
}
Console.WriteLine("----------------------+-----------------+------------+------------+------------+-----------+");
}
public static void Show()
{
privateschoolEntities dbContex = new privateschoolEntities();
Console.WriteLine();
Console.ForegroundColor = ConsoleColor.Blue;
Console.WriteLine("List of All Assignments ");
Console.ForegroundColor = ConsoleColor.Yellow;
Console.WriteLine("---------------------+--------------------------------+----------------------+------------+--------------+-----------------+");
Console.WriteLine("{0,-21}| {1,-30 } | {2,-20} | {3,-9} | {4,-12} | {5,-10} ", "Title", "Description", "Submission Date", "Oral Mark", "Total Mark", "Course Name");
Console.WriteLine("---------------------+--------------------------------+----------------------+------------+--------------+-----------------+");
Console.ForegroundColor = ConsoleColor.White;
foreach (var item in dbContex.assignments)
{
Console.WriteLine($"{item.title,-20} | {item.description,-30} | {item.subdatetime.ToString("dd/MM/yyyy"),-20} | {item.oralmark,-10} | {item.totalmark,-12} | {item.courses.title,-10}");
}
Console.WriteLine("---------------------+--------------------------------+----------------------+------------+--------------+-----------------+");
}
public static void Show()
{
privateschoolEntities dbContex = new privateschoolEntities();
Console.WriteLine();
Console.ForegroundColor = ConsoleColor.Red;
Console.WriteLine("List of All Trainers ");
Console.ForegroundColor = ConsoleColor.Yellow;
Console.WriteLine("----------------+----------------------+--------------------------------+----------------+");
Console.WriteLine("{0,-16}| {1,-20 } | {2,-30} | {3,-15}", "First Name", "Last Name", "Subject", "Teaching Course");
Console.WriteLine("----------------+----------------------+--------------------------------+----------------+");
Console.ForegroundColor = ConsoleColor.White;
foreach (var item in dbContex.trainers)
{
Console.WriteLine($"{item.firstname,-15 } | {item.lastname,-20} | {item.subject,-30} | {item.courses.title,-15}");
}
Console.WriteLine("----------------+----------------------+--------------------------------+----------------+");
}
public static void Show()
{
privateschoolEntities dbContex = new privateschoolEntities();
Console.WriteLine();
Console.ForegroundColor = ConsoleColor.Magenta;
Console.WriteLine("List of All Students");
Console.ForegroundColor = ConsoleColor.Yellow;
Console.WriteLine("----------+----------------+----------------------+----------------------+-----------------+-");
Console.WriteLine("{0,-10} | {1,-16} | {2,-20 } | {3,-20} | {4,-15} ", "student ID", "First Name", "Last Name", "Date of Birth", "Tuition Fees");
Console.WriteLine("----------+----------------+----------------------+----------------------+-----------------+-");
Console.ForegroundColor = ConsoleColor.White;
var studs = dbContex.students.OrderBy(s => s.firstname).ThenBy(l => l.lastname);
foreach (var item in studs)
{
Console.WriteLine($"{item.id, -10} | {item.firstname,-15 } | {item.lastname,-20} | {item.dateofbirth.ToString("dd/MM/yyyy"),-20} | {item.tuitionfees,-15} ");
}
Console.WriteLine("---------+----------------+----------------------+----------------------+-----------------+-");
}
public static void Show()
{
privateschoolEntities dbContex = new privateschoolEntities();
Console.WriteLine();
Console.ForegroundColor = ConsoleColor.Magenta;
Console.WriteLine("++++++++++ ASSIGNMENTS PER COURSE PER STUDENT +++++++++ ");
Console.ForegroundColor = ConsoleColor.Yellow;
foreach (var student in dbContex.students)
{
var courseAsssingments = student.assignments.Join(student.courses,
a => a.courseid,
c => c.id,
(assignment, course) => new
{
assignmentname = assignment.title,
assignmentdescription = assignment.description,
assignmentDate = assignment.subdatetime,
courseid = course.id,
courseTitle = course.title
});
Console.WriteLine();
Console.ForegroundColor = ConsoleColor.Cyan;
Console.WriteLine($"Student {student.firstname} {student.lastname} Has to submit the following assignments per course:");
Console.ForegroundColor = ConsoleColor.Yellow;
Console.WriteLine("---------------------+--------------------------------+----------------------+------------+-------------------+");
Console.WriteLine("{0,-21}| {1,-30 } | {2,-20} | {3,-9} | {4,-12} ", "Assignment Title", "Assignment Description", "Submission Date", "Course ID", "Course Title");
Console.WriteLine("---------------------+--------------------------------+----------------------+------------+-------------------+");
Console.ForegroundColor = ConsoleColor.White;
foreach (var item in courseAsssingments)
{
Console.WriteLine($"{item.assignmentname,-20} | {item.assignmentdescription,-30} | {item.assignmentDate.ToString("dd/MM/yyyy"),-20} | {item.courseid,-10} | {item.courseTitle,-20}");
}
Console.WriteLine("---------------------+--------------------------------+----------------------+------------+-------------------+");
}
}
public void MultipleAssignmentInput()
{
bool valid = true;
do
{
AssignmentDataCapture assignmentCapture = new AssignmentDataCapture();
assignments assignment = assignmentCapture.Capture();
using (privateschoolEntities dbContex = new privateschoolEntities())
{
dbContex.assignments.Add(assignment);
foreach (var student in dbContex.students)
{
if (student.courses.Contains(assignment.courses))
{
student.assignments.Add(assignment);
}
}
dbContex.SaveChanges();
}
Console.WriteLine();
Music.EndBeep();
Console.ForegroundColor = ConsoleColor.Cyan;
Console.WriteLine("ASSIGNMENT HAS BEEN CREATED");
Console.ForegroundColor = ConsoleColor.Yellow;
Console.WriteLine("Do you want to create another assignment? Press 'NO' or 'no' to exit.");
Console.WriteLine("Type anything else to continue creating another Assignment");
Console.ForegroundColor = ConsoleColor.White;
string value = Console.ReadLine();
if (value == "NO" || value == "No" || value == "no")
{
valid = false;
}
} while (valid);
}
public void InputID()
{
privateschoolEntities dbContex = new privateschoolEntities();
bool valid = true;
do
{
try
{
Console.ForegroundColor = ConsoleColor.Green;
Console.WriteLine("+++++++++< CREATE A NEW COURSE >++++++++++");
Console.WriteLine();
Console.ForegroundColor = ConsoleColor.White;
Console.WriteLine(" Type the Course ID: ");
Course.id = Convert.ToInt32(Console.ReadLine());
var courseExists = dbContex.courses.Any(c => c.id == Course.id);
if (courseExists)
{
Console.ForegroundColor = ConsoleColor.Magenta;
Console.WriteLine("The Course ID already exists !!! ");
Console.ForegroundColor = ConsoleColor.White;
}
else
{
valid = false;
}
}
catch (Exception)
{
Console.ForegroundColor = ConsoleColor.Red;
Console.WriteLine("Type a correct ID !!!!");
Console.ForegroundColor = ConsoleColor.White;
}
} while (valid);
}
public void InputCourseID()
{
privateschoolEntities dbContex = new privateschoolEntities();
bool valid = true;
do
{
try
{
Console.ForegroundColor = ConsoleColor.Yellow;
Console.WriteLine(" Type the ID of the COURSE of the Trainer: ");
Trainer.courseid = Convert.ToInt32(Console.ReadLine());
Console.ForegroundColor = ConsoleColor.White;
var trainerExists = dbContex.courses.Any(c => c.id == Trainer.courseid);
if (!trainerExists)
{
Console.ForegroundColor = ConsoleColor.Magenta;
Console.WriteLine("The course ID you typed doesn't Exist !!!");
Console.ForegroundColor = ConsoleColor.White;
}
else
{
Console.ForegroundColor = ConsoleColor.Cyan;
Console.WriteLine($"You successfully added the assignment to Course with ID: {Trainer.courseid} !!! ");
Console.ForegroundColor = ConsoleColor.White;
valid = false;
}
}
catch (Exception)
{
Console.ForegroundColor = ConsoleColor.Red;
Console.WriteLine("Type a Correct Course ID !!!");
Console.ForegroundColor = ConsoleColor.White;
}
} while (valid);
}
public static void Now()
{
Console.ForegroundColor = ConsoleColor.Yellow;
AppMessages.EnrollHiMessage();
for (int i = 0; i < 10; i++)
{
Console.WriteLine();
}
Console.ForegroundColor = ConsoleColor.Red;
Console.WriteLine("++++++++++ INPUT STUDENT TO ANOTHER COURSE +++++++++++");
Console.WriteLine();
Console.ForegroundColor = ConsoleColor.Yellow;
Console.WriteLine(" Do you want to input a Student into another Course? ");
Console.WriteLine(" Press 'NO' or 'no' to exit or ENTER to Continue!");
Console.ForegroundColor = ConsoleColor.White;
privateschoolEntities dbContex = new privateschoolEntities();
string value = Console.ReadLine();
if (value == "NO" || value == "No" || value == "no")
{
return;
}
Console.WriteLine("COURSES: ");
foreach (var item in dbContex.courses)
{
Console.WriteLine($" {item.id,-5} | {item.title} ");
}
Console.WriteLine();
Console.WriteLine("STUDENTS: ");
foreach (var student1 in dbContex.students)
{
Console.WriteLine($" { student1.id,-5} | {student1.firstname} {student1.lastname}");
}
Console.WriteLine();
bool validd = true;
do
{
try
{
Console.WriteLine("which Student do you want to select ??? (type student ID!): ");
int studentid = Convert.ToInt32(Console.ReadLine());
//
var studentExists = dbContex.students.Any(s => s.id == studentid);
if (!studentExists)
{
throw new Exception("The Student ID you typed doesn't Exist !!!");
}
//
students student = dbContex.students.First(s => s.id == studentid);
Console.WriteLine();
Console.ForegroundColor = ConsoleColor.Magenta;
Console.WriteLine($"You Selected the Student {student.firstname.ToString().ToUpper()} {student.lastname.ToString().ToUpper()} with ID: {student.id}");
Console.ForegroundColor = ConsoleColor.Yellow;
//
Console.WriteLine("Which Course do you want him/her to Enroll to???? (TYPE A COURSE ID!!)");
int courseid = Convert.ToInt32(Console.ReadLine());
Console.ForegroundColor = ConsoleColor.White;
//
courses course = dbContex.courses.First(c => c.id == courseid);
student.courses.Add(course);
foreach (var assign in course.assignments)
{
student.assignments.Add(assign);
}
course.students.Add(student);
dbContex.SaveChanges();
Console.WriteLine($"You successfully added {student.firstname} {student.lastname} to another Course !!! ");
validd = false;
}
catch (Exception)
{
Console.WriteLine("Wrong ID please try again!!!");
}
} while (validd);
}