public List <AssignmentsPerCourse> GetAssignmetsPerCourse() { List <AssignmentsPerCourse> assignmentsPerCourse = new List <AssignmentsPerCourse>(); try { using (SqlConnection con = new SqlConnection(conString)) { string queryString = "select Course.Title as Course , Assignment.title as [Assignment title], " + "description as Description from Assignment, Course where Assignment.Cid = Course.Cid"; con.Open(); SqlCommand cmd = new SqlCommand(queryString, con); SqlDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { AssignmentsPerCourse apc = new AssignmentsPerCourse(courseTitle: reader[0].ToString(), assignmentTitle: reader[1].ToString(), description: reader[2].ToString()); assignmentsPerCourse.Add(apc); } } } catch (Exception) { Console.WriteLine("Something went wrong Code: S_S_GAPC"); } return(assignmentsPerCourse); }
public List <AssignmentsPerCourse> AllAssignmentsPerAllCourses() { List <Course> courses = GetAll(); List <Assignment> assignments = new AssignmentService().GetAll(); List <AssignmentCourse> assigns = new AssignmentCourseService().GetAll(); var querySql = from a in assignments join ass in assigns on a.AssignmentId equals ass.AssignmentId join c in courses on ass.CourseId equals c.CourseId select new { Assignment = a, Course = c }; List <AssignmentsPerCourse> allAssignmentsPerAllCourses = new List <AssignmentsPerCourse>(); var groupedByCourses = querySql.GroupBy(g => g.Course); foreach (var group in groupedByCourses) { AssignmentsPerCourse assignmentsPerCourse = new AssignmentsPerCourse(); assignmentsPerCourse.Course = group.Key; foreach (var item in group) { assignmentsPerCourse.Assignments.Add(item.Assignment); } allAssignmentsPerAllCourses.Add(assignmentsPerCourse); } return(allAssignmentsPerAllCourses); }
/// <summary> /// The database constructor where all entities are constructed and connected accordingly in the database /// </summary> public Database() { Student s1 = new Student("Alex", "Perikleous", new DateTime(1993, 12, 06), 2500); Student s2 = new Student("Xenofon", "Vlachogiannis", new DateTime(1989, 06, 01), 2200); Student s3 = new Student("Zack", "Drimiskianakis", new DateTime(1993, 12, 11), 3000); Student s4 = new Student("Eleni", "Parisi", new DateTime(1989, 06, 03), 2400); Student s5 = new Student("Panagiotis", "Rizos", new DateTime(1993, 07, 02), 2600); Student s6 = new Student("Alexandros", "Nomikos", new DateTime(1973, 04, 25), 2700); Student s7 = new Student("Konstantinos", "Argyropoulos", new DateTime(1990, 08, 01), 2800); Student s8 = new Student("Chris", "Vasilakis", new DateTime(1989, 04, 09), 2900); Student s9 = new Student("Thanasis", "Kontodimas", new DateTime(1991, 08, 03), 2000); Student s10 = new Student("Thanos", "Katrakis", new DateTime(1988, 02, 01), 3000); students.Add(s1); students.Add(s2); students.Add(s3); students.Add(s4); students.Add(s5); students.Add(s6); students.Add(s7); students.Add(s8); students.Add(s9); students.Add(s10); Course c1 = new Course("CB9", "C#", "Full-Time", new DateTime(2019, 11, 11), new DateTime(2020, 03, 01)); Course c2 = new Course("CB8", "C#", "Part-Time", new DateTime(2019, 11, 18), new DateTime(2020, 06, 01)); Course c3 = new Course("JB9", "Java", "Full-Time", new DateTime(2019, 11, 11), new DateTime(2020, 06, 03)); Course c4 = new Course("JB8", "Java", "Part-Time", new DateTime(2019, 11, 18), new DateTime(2020, 06, 01)); courses.Add(c1); courses.Add(c2); courses.Add(c3); courses.Add(c4); Assignment a1 = new Assignment("ChessMaster", "Assign random pieces to chessboard", new DateTime(2020, 03, 06), 30, 100); Assignment a2 = new Assignment("Databases", "Connect to database", new DateTime(2020, 02, 01), 20, 100); Assignment a3 = new Assignment("String assignment", "Randomize string inputs", new DateTime(2020, 04, 01), 15, 100); Assignment a4 = new Assignment("C#", "Fundamentals of OOP", new DateTime(2020, 05, 20), 30, 100); Assignment a5 = new Assignment("Headfirst", "Advanced abstract classes", new DateTime(2020, 04, 22), 30, 100); assignments.Add(a1); assignments.Add(a2); assignments.Add(a3); assignments.Add(a4); assignments.Add(a5); Trainer t1 = new Trainer("Panagiotis", "Bozas", "OOP"); Trainer t2 = new Trainer("Kostas", "Zitis", "SQL"); Trainer t3 = new Trainer("George", "Pasparakis", "Databases"); Trainer t4 = new Trainer("Ektoras", "Gantzos", "C#"); trainers.Add(t1); trainers.Add(t2); trainers.Add(t3); trainers.Add(t4); StudentCourse SC1 = new StudentCourse(students[0], courses[0]); StudentCourse SC2 = new StudentCourse(students[1], courses[0]); StudentCourse SC3 = new StudentCourse(students[2], courses[0]); StudentCourse SC4 = new StudentCourse(students[3], courses[0]); StudentCourse SC5 = new StudentCourse(students[3], courses[1]); StudentCourse SC6 = new StudentCourse(students[4], courses[1]); StudentCourse SC7 = new StudentCourse(students[5], courses[1]); StudentCourse SC8 = new StudentCourse(students[6], courses[2]); StudentCourse SC9 = new StudentCourse(students[7], courses[2]); StudentCourse SC10 = new StudentCourse(students[8], courses[3]); StudentCourse SC11 = new StudentCourse(students[9], courses[3]); studentCourses.Add(SC1); studentCourses.Add(SC2); studentCourses.Add(SC3); studentCourses.Add(SC4); studentCourses.Add(SC5); studentCourses.Add(SC6); studentCourses.Add(SC7); studentCourses.Add(SC8); studentCourses.Add(SC9); studentCourses.Add(SC10); studentCourses.Add(SC11); TrainerCourse TC1 = new TrainerCourse(trainers[0], courses[0]); TrainerCourse TC2 = new TrainerCourse(trainers[1], courses[0]); TrainerCourse TC3 = new TrainerCourse(trainers[1], courses[1]); TrainerCourse TC4 = new TrainerCourse(trainers[2], courses[1]); TrainerCourse TC5 = new TrainerCourse(trainers[2], courses[2]); TrainerCourse TC6 = new TrainerCourse(trainers[3], courses[3]); trainerCourses.Add(TC1); trainerCourses.Add(TC2); trainerCourses.Add(TC3); trainerCourses.Add(TC4); trainerCourses.Add(TC5); trainerCourses.Add(TC6); List <Assignment> assignments1 = new List <Assignment> { assignments[0], assignments[1] }; AssignmentsPerCourse APC1 = new AssignmentsPerCourse(courses[0], assignments1); List <Assignment> assignments2 = new List <Assignment> { assignments[2] }; AssignmentsPerCourse APC2 = new AssignmentsPerCourse(courses[1], assignments2); List <Assignment> assignments3 = new List <Assignment> { assignments[3] }; AssignmentsPerCourse APC3 = new AssignmentsPerCourse(courses[2], assignments3); List <Assignment> assignments4 = new List <Assignment> { assignments[4] }; AssignmentsPerCourse APC4 = new AssignmentsPerCourse(courses[3], assignments4); assignmentsPerCourse.Add(APC1); assignmentsPerCourse.Add(APC2); assignmentsPerCourse.Add(APC3); assignmentsPerCourse.Add(APC4); StudentAssignment SA1 = new StudentAssignment(students[0], assignments[0]); StudentAssignment SA2 = new StudentAssignment(students[0], assignments[1]); StudentAssignment SA3 = new StudentAssignment(students[1], assignments[0]); StudentAssignment SA4 = new StudentAssignment(students[1], assignments[1]); StudentAssignment SA5 = new StudentAssignment(students[2], assignments[0]); StudentAssignment SA6 = new StudentAssignment(students[2], assignments[1]); StudentAssignment SA7 = new StudentAssignment(students[3], assignments[0]); StudentAssignment SA8 = new StudentAssignment(students[3], assignments[1]); StudentAssignment SA9 = new StudentAssignment(students[3], assignments[2]); StudentAssignment SA10 = new StudentAssignment(students[4], assignments[2]); StudentAssignment SA11 = new StudentAssignment(students[5], assignments[2]); StudentAssignment SA12 = new StudentAssignment(students[6], assignments[3]); StudentAssignment SA13 = new StudentAssignment(students[7], assignments[3]); StudentAssignment SA14 = new StudentAssignment(students[8], assignments[4]); StudentAssignment SA15 = new StudentAssignment(students[9], assignments[4]); studentAssignments.Add(SA1); studentAssignments.Add(SA2); studentAssignments.Add(SA3); studentAssignments.Add(SA4); studentAssignments.Add(SA5); studentAssignments.Add(SA6); studentAssignments.Add(SA7); studentAssignments.Add(SA8); studentAssignments.Add(SA9); studentAssignments.Add(SA10); studentAssignments.Add(SA11); studentAssignments.Add(SA12); studentAssignments.Add(SA13); studentAssignments.Add(SA14); studentAssignments.Add(SA15); }
public static void Run() { Course c1 = new Course(); Assignment a1 = new Assignment(); Trainer tr1 = new Trainer(); Student s1 = new Student(); StudentsPerCourse sPC = new StudentsPerCourse(); TrainersPerCourse tPC = new TrainersPerCourse(); AssignmentsPerCourse aPC = new AssignmentsPerCourse(); AssignmetsPerStudent aPS = new AssignmetsPerStudent(); AssignmentsPerCoursePerStudent aPCPS = new AssignmentsPerCoursePerStudent(); StudentsWithMoreThanOneCourse sMTOC = new StudentsWithMoreThanOneCourse(); ServiceGet serviseGet = new ServiceGet(); ServiceInsert serviseInsert = new ServiceInsert(); ServiceCheck serviceCheck = new ServiceCheck(); string userInput2 = "", userInput3 = "", userInput5 = ""; int selectCourse; do { Console.ForegroundColor = ConsoleColor.Yellow; Console.WriteLine(); Console.WriteLine("\tWellcome to Private School! What would you like to do?"); Console.WriteLine(); Console.ForegroundColor = ConsoleColor.White; Console.WriteLine("\t0. Exit."); Console.WriteLine("\t1. Course."); Console.WriteLine("\t2. Assignment."); Console.WriteLine("\t3. Trainer."); Console.WriteLine("\t4. Student."); Console.Write("\n\tPlease enter the appropriate number to select the field you are interested in : "); userInput2 = Console.ReadLine(); Console.ForegroundColor = ConsoleColor.Green; Console.WriteLine("\n\t=================================================================================\n"); Console.ForegroundColor = ConsoleColor.White; //UserInput2 = 1, normal mode, Course-------------------------------------------------------------------------------------------------------------------- if (userInput2 == "1") { do { Console.ForegroundColor = ConsoleColor.Yellow; Console.WriteLine(); Console.WriteLine("\tYou are in the course mode! What would you like to do?"); Console.WriteLine(); Console.ForegroundColor = ConsoleColor.White; Console.WriteLine("\t0. Exit."); Console.WriteLine("\t1. New course."); Console.WriteLine("\t2. Output list with all courses."); Console.WriteLine("\t3. Add students at courses."); Console.WriteLine("\t4. Output students per course."); Console.WriteLine("\t5. Add trainers at courses."); Console.WriteLine("\t6. Output trainers per course."); Console.WriteLine("\t7. Add assignments at courses."); Console.WriteLine("\t8. Output assignments per course."); Console.WriteLine("\t9. Go back."); Console.Write("\n\tPlease enter the appropriate number to select the field you are interested in : "); userInput3 = Console.ReadLine(); Console.ForegroundColor = ConsoleColor.Green; Console.WriteLine("\n\t=================================================================================\n"); Console.ForegroundColor = ConsoleColor.White; //UserInput3 = 1, normal mode, New course------------------------------------------------------------------------------------------------------- if (userInput3 == "1") { serviseInsert.InsertCourse(); } //UserInput3 = 2, normal mode, List of courses------------------------------------------------------------------------------------------------------- else if (userInput3 == "2") { c1.ListOfCoursecOutput(serviseGet.GetAllCourses()); MyStaticClass.PressKeyToContinue(); } //UserInput3 = 3, normal mode, Add students at courses------------------------------------------------------------------------------------------------------- else if (userInput3 == "3") { Console.ForegroundColor = ConsoleColor.Yellow; Console.WriteLine(); Console.WriteLine("\tSelect the number of course that you want to add students."); Console.WriteLine(); Console.ForegroundColor = ConsoleColor.White; List <Course> allCourses = serviseGet.GetAllCourses(); c1.ListOfCoursecOutput(allCourses); Console.WriteLine(); do { Console.Write("\tEnter the apropriate number : "); selectCourse = MyStaticClass.InputTryToConvertToInt(); } while (selectCourse <= 0 || selectCourse > allCourses.Count); Console.ForegroundColor = ConsoleColor.Green; Console.WriteLine("\n\t=================================================================================\n"); Console.ForegroundColor = ConsoleColor.White; do { Console.ForegroundColor = ConsoleColor.Yellow; Console.WriteLine("\tSelect how you want to add a student."); Console.ForegroundColor = ConsoleColor.White; Console.WriteLine(); Console.WriteLine("\t1. Add a new student."); Console.WriteLine("\t2. Add an excisting student."); Console.WriteLine("\t9. Go back."); Console.Write("\n\tPlease enter the appropriate number to select the field you are interested in : "); userInput5 = Console.ReadLine(); Console.ForegroundColor = ConsoleColor.Green; Console.WriteLine("\n\t=================================================================================\n"); Console.ForegroundColor = ConsoleColor.White; if (userInput5 == "1") { serviseInsert.InsertStudent(); List <Student> students = serviseGet.GetAllStudents(); serviseInsert.InsertStudentAtCourse((int)students[students.Count - 1].Sid, (int)allCourses[selectCourse - 1].Cid); } else if (userInput5 == "2") { string addAnotherStudentfromList; bool notSuccededAdd = true; do { Console.ForegroundColor = ConsoleColor.Yellow; Console.WriteLine(); Console.WriteLine("\tSelect the number of student."); Console.WriteLine(); Console.ForegroundColor = ConsoleColor.White; List <Student> allStudents = serviseGet.GetAllStudents(); s1.ListOfStudentsOutput(allStudents); do { int userSelectStudent = 0; try { Console.WriteLine(); Console.Write("\tEnter a propriate number : "); userSelectStudent = Convert.ToInt32(Console.ReadLine()); if (userSelectStudent >= 0 && userSelectStudent <= allStudents.Count) { if (serviceCheck.ExistStudentsPerCourse((int)allStudents[userSelectStudent - 1].Sid, (int)allCourses[selectCourse - 1].Cid)) { Console.ForegroundColor = ConsoleColor.Red; Console.WriteLine(); Console.WriteLine("\tThe student already exist in the course."); Console.ForegroundColor = ConsoleColor.White; notSuccededAdd = true; } else { serviseInsert.InsertStudentAtCourse((int)allStudents[userSelectStudent - 1].Sid, (int)allCourses[selectCourse - 1].Cid); notSuccededAdd = false; } } else { Console.ForegroundColor = ConsoleColor.Red; Console.WriteLine("\tPlease select a propriate number."); Console.ForegroundColor = ConsoleColor.White; notSuccededAdd = true; } } catch (Exception) { Console.ForegroundColor = ConsoleColor.Red; Console.WriteLine("\tPlease select a propriate number."); Console.ForegroundColor = ConsoleColor.White; notSuccededAdd = true; } } while (notSuccededAdd); //Ask to add another student from the list in course do { Console.WriteLine(); Console.Write("\tWould you like to add another student from the list in course? Y/N : "); addAnotherStudentfromList = Console.ReadLine(); Console.WriteLine(); } while (addAnotherStudentfromList.ToUpper() != "Y" && addAnotherStudentfromList.ToUpper() != "N"); } while (addAnotherStudentfromList.ToUpper() != "N"); } } while ((userInput5 != "1" && userInput5 != "2") && userInput5 != "9"); } //UserInput3 = 4, normal mode, Output students per course------------------------------------------------------------------------------------------------------- else if (userInput3 == "4") { sPC.ListOfStudentsPerCourseOutput(serviseGet.GetStudentsPerCourse()); MyStaticClass.PressKeyToContinue(); } //UserInput3 = 5, normal mode, Add trainers at courses------------------------------------------------------------------------------------------------------- else if (userInput3 == "5") { Console.ForegroundColor = ConsoleColor.Yellow; Console.WriteLine(); Console.WriteLine("\tSelect the number of course that you want to add trainers."); Console.WriteLine(); Console.ForegroundColor = ConsoleColor.White; List <Course> allCourses = serviseGet.GetAllCourses(); c1.ListOfCoursecOutput(allCourses); Console.WriteLine(); do { Console.Write("\tEnter the apropriate number : "); selectCourse = MyStaticClass.InputTryToConvertToInt(); } while (selectCourse <= 0 || selectCourse > allCourses.Count); Console.ForegroundColor = ConsoleColor.Green; Console.WriteLine("\n\t=================================================================================\n"); Console.ForegroundColor = ConsoleColor.White; do { Console.ForegroundColor = ConsoleColor.Yellow; Console.WriteLine("\tSelect how you want to add a trainer."); Console.ForegroundColor = ConsoleColor.White; Console.WriteLine(); Console.WriteLine("\t1. Add a new trainer."); Console.WriteLine("\t2. Add an excisting trainer."); Console.WriteLine("\t9. Go back."); Console.Write("\n\tPlease enter the appropriate number to select the field you are interested in : "); userInput5 = Console.ReadLine(); Console.ForegroundColor = ConsoleColor.Green; Console.WriteLine("\n\t=================================================================================\n"); Console.ForegroundColor = ConsoleColor.White; } while ((userInput5 != "1" && userInput5 != "2") && userInput5 != "9"); if (userInput5 == "1") { serviseInsert.InsertTrainer(); List <Trainer> trainers = serviseGet.GetAllTrainers(); serviseInsert.InsertTrainerAtCourse((int)trainers[trainers.Count - 1].Tid, (int)allCourses[selectCourse - 1].Cid); } else if (userInput5 == "2") { string addAnotherTrainerfromList; bool notSuccededAdd = true; do { Console.ForegroundColor = ConsoleColor.Yellow; Console.WriteLine(); Console.WriteLine("\tSelect the number of trainer."); Console.WriteLine(); Console.ForegroundColor = ConsoleColor.White; List <Trainer> allTrainers = serviseGet.GetAllTrainers(); tr1.ListOfTrainersOutput(allTrainers); do { int selectTrainer = 0; try { Console.WriteLine(); Console.Write("\tEnter a propriate number : "); selectTrainer = Convert.ToInt32(Console.ReadLine()); if (selectTrainer >= 0 && selectTrainer <= allTrainers.Count) { if (serviceCheck.ExistTrainerPerCourse((int)allTrainers[selectTrainer - 1].Tid, (int)allCourses[selectCourse - 1].Cid)) { Console.ForegroundColor = ConsoleColor.Red; Console.WriteLine(); Console.WriteLine("\tThe trainer already exist in the course."); Console.ForegroundColor = ConsoleColor.White; notSuccededAdd = true; } else { serviseInsert.InsertTrainerAtCourse((int)allTrainers[selectTrainer - 1].Tid, (int)allCourses[selectCourse - 1].Cid); notSuccededAdd = false; } } else { Console.ForegroundColor = ConsoleColor.Red; Console.WriteLine("\tPlease select a propriate number."); Console.ForegroundColor = ConsoleColor.White; notSuccededAdd = true; } } catch (Exception) { Console.ForegroundColor = ConsoleColor.Red; Console.WriteLine("\tPlease select a propriate number."); Console.ForegroundColor = ConsoleColor.White; notSuccededAdd = true; } } while (notSuccededAdd); //Ask to add another student from the list in course do { Console.WriteLine(); Console.Write("\tWould you like to add another student from the list in course? Y/N : "); addAnotherTrainerfromList = Console.ReadLine(); Console.WriteLine(); } while (addAnotherTrainerfromList.ToUpper() != "Y" && addAnotherTrainerfromList.ToUpper() != "N"); } while (addAnotherTrainerfromList.ToUpper() != "N"); } } //UserInput3 = 6, normal mode, Output trainers per course------------------------------------------------------------------------------------------------------- else if (userInput3 == "6") { tPC.ListOfTrainersPerCourseOutput(serviseGet.GetTrainersPerCourse()); MyStaticClass.PressKeyToContinue(); } //UserInput3 = 7, normal mode, Add assignments at courses------------------------------------------------------------------------------------------------------- else if (userInput3 == "7") { Console.ForegroundColor = ConsoleColor.Yellow; Console.WriteLine(); Console.WriteLine("\tSelect the number of course that you want to add assignments."); Console.WriteLine(); Console.ForegroundColor = ConsoleColor.White; List <Course> allCourses = serviseGet.GetAllCourses(); c1.ListOfCoursecOutput(allCourses); Console.WriteLine(); do { Console.Write("\tEnter the apropriate number : "); selectCourse = MyStaticClass.InputTryToConvertToInt(); } while (selectCourse <= 0 || selectCourse > allCourses.Count); Console.ForegroundColor = ConsoleColor.Green; Console.WriteLine("\n\t=================================================================================\n"); Console.ForegroundColor = ConsoleColor.White; Console.ForegroundColor = ConsoleColor.Yellow; Console.WriteLine("\tSelect how you want to add an assignment."); Console.ForegroundColor = ConsoleColor.White; do { Console.WriteLine(); Console.WriteLine("\t1. Add a new assignment."); Console.WriteLine("\t2. Add an excisting assignment."); Console.WriteLine("\t9. Go back."); Console.Write("\n\tPlease enter the appropriate number to select the field you are interested in : "); userInput5 = Console.ReadLine(); Console.ForegroundColor = ConsoleColor.Green; Console.WriteLine("\n\t=================================================================================\n"); Console.ForegroundColor = ConsoleColor.White; } while ((userInput5 != "1" && userInput5 != "2") && userInput5 != "9"); if (userInput5 == "1") { serviseInsert.InsertNewAssignmentAtCourse((int)allCourses[selectCourse - 1].Cid); } else if (userInput5 == "2") { string addAnotherAssignmentfromList; bool notSuccededAdd = true; Console.ForegroundColor = ConsoleColor.Yellow; Console.WriteLine(); Console.WriteLine("\tSelect the number of the assignment."); Console.WriteLine(); Console.ForegroundColor = ConsoleColor.White; List <Assignment> allAssignments = serviseGet.GetAllAssignments(); a1.ListOfAssignmentsOutput(allAssignments); do { int selectAssignment = 0; try { Console.WriteLine(); Console.Write("\tEnter a propriate number : "); selectAssignment = Convert.ToInt32(Console.ReadLine()); if (selectAssignment >= 0 && selectAssignment <= allAssignments.Count) { serviseInsert.InsertAssignmentAtCourse((int)allAssignments[selectAssignment - 1].Aid, (int)allCourses[selectCourse - 1].Cid); notSuccededAdd = false; } else { Console.ForegroundColor = ConsoleColor.Red; Console.WriteLine("\tPlease select a propriate number."); Console.ForegroundColor = ConsoleColor.White; notSuccededAdd = true; } } catch (Exception) { Console.ForegroundColor = ConsoleColor.Red; Console.WriteLine("\tPlease select a propriate number."); Console.ForegroundColor = ConsoleColor.White; notSuccededAdd = true; } } while (notSuccededAdd); } Console.ForegroundColor = ConsoleColor.Green; Console.WriteLine("\n\t=================================================================================\n"); Console.ForegroundColor = ConsoleColor.White; } //UserInput3 = 8, normal mode, Output assignments per course------------------------------------------------------------------------------------------------------- else if (userInput3 == "8") { aPC.OutputAssignmetsPerCourse(serviseGet.GetAssignmetsPerCourse()); MyStaticClass.PressKeyToContinue(); } } while (userInput3 != "0" && userInput3 != "9"); } //UserInput2 = 2, normal mode, Assignment-------------------------------------------------------------------------------------------------------------------- else if (userInput2 == "2") { do { Console.ForegroundColor = ConsoleColor.Yellow; Console.WriteLine(); Console.WriteLine("\tYou are in the assignment mode! What would you like to do?"); Console.WriteLine(); Console.ForegroundColor = ConsoleColor.White; Console.WriteLine("\t0. Exit."); Console.WriteLine("\t1. New assignment."); Console.WriteLine("\t2. Output list with all assignments."); Console.WriteLine("\t3. Output list with assignments per course per student."); Console.WriteLine("\t9. Go back."); Console.Write("\n\tPlease enter the appropriate number to select the field you are interested in : "); userInput3 = Console.ReadLine(); Console.ForegroundColor = ConsoleColor.Green; Console.WriteLine("\n\t=================================================================================\n"); Console.ForegroundColor = ConsoleColor.White; //UserInput3 = 1, normal mode, New Assignment------------------------------------------------------------------------------------------------------- if (userInput3 == "1") { serviseInsert.InsertAssignment(); } //UserInput3 = 2, normal mode, List of assignments------------------------------------------------------------------------------------------------------- else if (userInput3 == "2") { a1.ListOfAssignmentsWithoutMarkOutput(serviseGet.GetAllAssignments()); MyStaticClass.PressKeyToContinue(); } else if (userInput3 == "3") { aPCPS.ListOfAssignmentsPerCoursePerStudentOutput(serviseGet.GetAssignmentsPerCoursePerStudents()); MyStaticClass.PressKeyToContinue(); } } while ((userInput3 != "0" && userInput3 != "9") && (userInput3 != "1" && (userInput3 != "2" && userInput3 != "3"))); } //UserInput2 = 3, normal mode, Trainer-------------------------------------------------------------------------------------------------------------------- else if (userInput2 == "3") { do { Console.ForegroundColor = ConsoleColor.Yellow; Console.WriteLine(); Console.WriteLine("\tYou are in the trainer mode! What would you like to do?"); Console.WriteLine(); Console.ForegroundColor = ConsoleColor.White; Console.WriteLine("\t0. Exit."); Console.WriteLine("\t1. New trainer."); Console.WriteLine("\t2. Output list with all trainers."); Console.WriteLine("\t9. Go back."); Console.Write("\n\tPlease enter the appropriate number to select the field you are interested in : "); userInput3 = Console.ReadLine(); Console.ForegroundColor = ConsoleColor.Green; Console.WriteLine("\n\t=================================================================================\n"); Console.ForegroundColor = ConsoleColor.White; //UserInput3 = 1, normal mode, New trainer------------------------------------------------------------------------------------------------------- if (userInput3 == "1") { serviseInsert.InsertTrainer(); } //UserInput3 = 2, normal mode, List of trainers------------------------------------------------------------------------------------------------------- else if (userInput3 == "2") { tr1.ListOfTrainersOutput(serviseGet.GetAllTrainers()); MyStaticClass.PressKeyToContinue(); } } while ((userInput3 != "0" && userInput3 != "9") && (userInput3 != "1" && userInput3 != "2")); } //UserInput2 = 4, normal mode, Student-------------------------------------------------------------------------------------------------------------------- else if (userInput2 == "4") { do { Console.ForegroundColor = ConsoleColor.Yellow; Console.WriteLine(); Console.WriteLine("\tYou are in the student mode! What would you like to do?"); Console.WriteLine(); Console.ForegroundColor = ConsoleColor.White; Console.WriteLine("\t0. Exit."); Console.WriteLine("\t1. New student."); Console.WriteLine("\t2. Output list with all students."); Console.WriteLine("\t3. Output list witn students who belongs to more than one course."); Console.WriteLine("\t9. Go back."); Console.Write("\n\tPlease enter the appropriate number to select the field you are interested in : "); userInput3 = Console.ReadLine(); Console.ForegroundColor = ConsoleColor.Green; Console.WriteLine("\n\t=================================================================================\n"); Console.ForegroundColor = ConsoleColor.White; //UserInput3 = 1, normal mode, New Student------------------------------------------------------------------------------------------------------- if (userInput3 == "1") { serviseInsert.InsertStudent(); } //UserInput3 = 2, normal mode, List of students------------------------------------------------------------------------------------------------------- else if (userInput3 == "2") { s1.ListOfStudentsOutput(serviseGet.GetAllStudents()); MyStaticClass.PressKeyToContinue(); } //UserInput3 = 3, normal mode, List of students who belongs to more than one course------------------------------------------------------------------------------------------------------ - else if (userInput3 == "3") { sMTOC.ListOfStudentsOutput(serviseGet.GetStudentsWithMoreThanOneCourses()); MyStaticClass.PressKeyToContinue(); } } while ((userInput3 != "0" && userInput3 != "9") && (userInput3 != "1" && userInput3 != "2") && (userInput3 != "3")); } } while ((userInput2 != "0" && userInput2 != "9") && userInput3 != "0"); Console.WriteLine("\n\tTHANK YOU!!!"); Console.ReadKey(); }
public Data() { //creating students Student s1 = new Student("Panagiotis", "Grigoriou", new DateTime(1987, 3, 4), 3000); Student s2 = new Student("Konstantinos", "Pantelidis", new DateTime(1991, 6, 2), 4000); Student s3 = new Student("Spiros", "Aggelatos", new DateTime(1996, 4, 7), 3500); Student s4 = new Student("Dimitris", "Pantelopoulos", new DateTime(2000, 5, 2), 6200); Student s5 = new Student("Antonis", "Mixelakakis", new DateTime(1989, 10, 3), 5800); Students.Add(s1); Students.Add(s2); Students.Add(s3); Students.Add(s4); Students.Add(s5); //creating courses Course c1 = new Course("Javascript", "Web Development", "Practical Subject", new DateTime(2020, 1, 10), new DateTime(2020, 3, 11)); Course c2 = new Course("C++", "Object-Oriented Programming", "Practical Subject", new DateTime(2020, 1, 18), new DateTime(2020, 4, 2)); Course c3 = new Course("Pascal", "Procedural Programming", "Theoretical Subject", new DateTime(2020, 2, 15), new DateTime(2020, 5, 20)); Course c4 = new Course("Visual Basic", "Windows Application Development", "Practical Subject", new DateTime(2020, 3, 20), new DateTime(2020, 6, 1)); Courses.Add(c1); Courses.Add(c2); Courses.Add(c3); Courses.Add(c4); //creating trainers Trainer t1 = new Trainer("Giannis", "Aggelopoulos", "Object-Oriented Programming"); Trainer t2 = new Trainer("Manolis", "Daskalakis", "Procedural Programming"); Trainer t3 = new Trainer("Giorgos", "Mpatzoglou", "Procedural Programming"); Trainer t4 = new Trainer("Thanassis", "Giorgakopoulos", "Object-Oriented Programming"); Trainers.Add(t1); Trainers.Add(t2); Trainers.Add(t3); Trainers.Add(t4); //creating assignments Assignment a1 = new Assignment("Project Bank", "Banking application for android phones", new DateTime(2020, 4, 24), 40, 200); Assignment a2 = new Assignment("Project E-shop", "Shopping website", new DateTime(2020, 6, 11), 20, 100); Assignment a3 = new Assignment("Project Library", "Book rental service", new DateTime(2020, 4, 15), 35, 200); Assignment a4 = new Assignment("Project Cinema", "Movie distribution to cinemas", new DateTime(2020, 1, 2), 73, 100); Assignment a5 = new Assignment("Project Stocks", "Stock change notifications", new DateTime(2020, 3, 27), 110, 200); Assignment a6 = new Assignment("Project Architecture", "Blueprint making software", new DateTime(2020, 3, 24), 40, 150); Assignments.Add(a1); Assignments.Add(a2); Assignments.Add(a3); Assignments.Add(a4); Assignments.Add(a5); Assignments.Add(a6); //putting students in mini-lists (students per Course) List <Student> C1Stu = new List <Student>(); List <Student> C2Stu = new List <Student>(); List <Student> C3Stu = new List <Student>(); C1Stu.Add(s2); C1Stu.Add(s3); C2Stu.Add(s1); C2Stu.Add(s2); C2Stu.Add(s3); C3Stu.Add(s1); //putting mini-lists in big lists (students per Course) StudentPerCourse stuPerCour1 = new StudentPerCourse(c1, C1Stu); StudentPerCourse stuPerCour2 = new StudentPerCourse(c2, C2Stu); StudentPerCourse stuPerCour3 = new StudentPerCourse(c3, C3Stu); StudentsPerCourse.Add(stuPerCour1); StudentsPerCourse.Add(stuPerCour2); StudentsPerCourse.Add(stuPerCour3); //putting trainers in mini-lists (trainers per Course) List <Trainer> C1Train = new List <Trainer>(); List <Trainer> C2Train = new List <Trainer>(); List <Trainer> C3Train = new List <Trainer>(); C1Train.Add(t1); C1Train.Add(t2); C2Train.Add(t1); C2Train.Add(t3); C3Train.Add(t4); C3Train.Add(t1); //putting mini-lists in big lists (trainers per Course) TrainerPerCourse trainPerCour1 = new TrainerPerCourse(c1, C1Train); TrainerPerCourse trainPerCour2 = new TrainerPerCourse(c2, C2Train); TrainerPerCourse trainPerCour3 = new TrainerPerCourse(c3, C3Train); TrainersPerCourse.Add(trainPerCour1); TrainersPerCourse.Add(trainPerCour2); TrainersPerCourse.Add(trainPerCour3); //putting assignments in mini-lists (assignments per Course) List <Assignment> C1Assign = new List <Assignment>(); List <Assignment> C2Assign = new List <Assignment>(); List <Assignment> C3Assign = new List <Assignment>(); C1Assign.Add(a1); C1Assign.Add(a2); C2Assign.Add(a3); C3Assign.Add(a5); C3Assign.Add(a4); //putting mini-lists in big lists (assignments per Course) AssignmentPerCourse assignPerCour1 = new AssignmentPerCourse(c1, C1Assign); AssignmentPerCourse assignPerCour2 = new AssignmentPerCourse(c2, C2Assign); AssignmentPerCourse assignPerCour3 = new AssignmentPerCourse(c3, C2Assign); AssignmentsPerCourse.Add(assignPerCour1); AssignmentsPerCourse.Add(assignPerCour2); AssignmentsPerCourse.Add(assignPerCour3); //putting assignments in mini-lists (assignments per Student) List <Assignment> S1Assign = new List <Assignment>(); List <Assignment> S2Assign = new List <Assignment>(); List <Assignment> S3Assign = new List <Assignment>(); S1Assign.Add(a1); S1Assign.Add(a2); S2Assign.Add(a3); S2Assign.Add(a4); S2Assign.Add(a5); S3Assign.Add(a6); //putting mini-lists in big lists (assignments per Student) AssignmentPerStudent assignPerStu1 = new AssignmentPerStudent(s1, S1Assign); AssignmentPerStudent assignPerStu2 = new AssignmentPerStudent(s2, S2Assign); AssignmentPerStudent assignPerStu3 = new AssignmentPerStudent(s3, S3Assign); AssignmentsPerStudent.Add(assignPerStu1); AssignmentsPerStudent.Add(assignPerStu2); AssignmentsPerStudent.Add(assignPerStu3); //putting courses in mini-lists (courses per Student) List <Course> S1Cour = new List <Course>(); List <Course> S2Cour = new List <Course>(); List <Course> S3Cour = new List <Course>(); S1Cour.Add(c2); S1Cour.Add(c3); S2Cour.Add(c1); S2Cour.Add(c2); S3Cour.Add(c1); S3Cour.Add(c2); //putting mini-lists in big lists (courses per Student) CoursePerStudent courPerStu1 = new CoursePerStudent(s1, S1Cour); CoursePerStudent courPerStu2 = new CoursePerStudent(s2, S2Cour); CoursePerStudent courPerStu3 = new CoursePerStudent(s3, S3Cour); CoursesPerStudent.Add(courPerStu1); CoursesPerStudent.Add(courPerStu2); CoursesPerStudent.Add(courPerStu3); //------------------------------------------------------- //AssignmentCourseStudent ACS1 = new AssignmentCourseStudent(s1, c2, a3); //AssignmentCourseStudent ACS2 = new AssignmentCourseStudent(s1, c3, a6); //AssignmentCourseStudent ACS3 = new AssignmentCourseStudent(s2, c1, a1); //AssignmentCourseStudent ACS4 = new AssignmentCourseStudent(s2, c2, a4); //AssignmentCourseStudent ACS5 = new AssignmentCourseStudent(s3, c1, a2); //AssignmentCourseStudent ACS6 = new AssignmentCourseStudent(s3, c2, a5); //ACSList.Add(ACS1); //ACSList.Add(ACS2); //ACSList.Add(ACS3); //ACSList.Add(ACS4); //ACSList.Add(ACS5); //ACSList.Add(ACS6); }