public void DeleteOfStudentsAsUsers(DataClasses1DataContext db, int studentID, int userID, int courseID, int assignmentIDThisUser)
{
ASSIGNMENT_PER_STUDENT assignmnetPerStudent = new ASSIGNMENT_PER_STUDENT();
STUDENT_PER_COURSE sTudentPerCourse = new STUDENT_PER_COURSE();
StudentPerAssignment studentPerAssignment = new StudentPerAssignment();
StudentPerCourse studentPerCourse = new StudentPerCourse();
STUDENT sTudent = new STUDENT();
Student student = new Student();
USERR user = new USERR();
if (studentID < 1)
{
DeleteUser(user, userID, db);
}
else if (studentID > 0 && courseID < 1 && assignmentIDThisUser < 1)
{
student.DeleteStudent(db, sTudent, studentID);
DeleteUser(user, userID, db);
}
else if (studentID > 0 && courseID > 0 && assignmentIDThisUser < 1)
{
studentPerCourse.DeleteCourses(studentID, sTudentPerCourse, db);
student.DeleteStudent(db, sTudent, studentID);
DeleteUser(user, userID, db);
}
else if (studentID > 0 && courseID > 0 && assignmentIDThisUser > 0)
{
studentPerAssignment.DeleteAssignemnts(studentID, assignmnetPerStudent, db);
studentPerCourse.DeleteCourses(studentID, sTudentPerCourse, db);
student.DeleteStudent(db, sTudent, studentID);
DeleteUser(user, userID, db);
}
Console.WriteLine("\n\tDeleted Succesfully!!!");
}
public void CheckAvailableCoursesID(List <int> listNumbersOfCourses, Check_ID check_ID, int studentID, int courseID, DataClasses1DataContext db)
{
StudentPerCourse studentPerCourse = new StudentPerCourse();
STUDENT_PER_COURSE sTudentPerCourse = new STUDENT_PER_COURSE();
bool thisCourseIDExist = GetAvailableCoursesIdForThisStudentFromDB(studentID, courseID, db);
while (thisCourseIDExist)
{
Console.WriteLine("\tΥou are enrolled in this course!");
courseID = check_ID.GetTrueCourseID(studentID, courseID, db); // Έγκυρο COURSE ID
thisCourseIDExist = GetAvailableCoursesIdForThisStudentFromDB(studentID, courseID, db);
}
studentPerCourse.AddStudentsToCourses(studentID, courseID, sTudentPerCourse, check_ID, db);
listNumbersOfCourses.Add(courseID);
}
public void CreateStudentsPerCourses(STUDENT_PER_COURSE sTudentPerCourse, DataClasses1DataContext db)
{
StudentPerCourse studentPerCourse = new StudentPerCourse();
Student student = new Student();
Console.WriteLine("\n\n\t" + "CREATE STUDENTS PER COURSES" +
"\n\t----------------------------");
Console.WriteLine("\tFor Create a new student press --> {1}");
Console.WriteLine("\tAdd Student to course/s press --> {2}");
Console.Write("\tEnter a choice between --> {1 - 2}: ");
string stringChoice = Console.ReadLine();
Console.WriteLine();
int outChoice;
while (!int.TryParse(stringChoice, out outChoice) || outChoice < 1 || outChoice > 2)
{
Console.WriteLine("\n\tThe choice should be Only integer between {1- 2}!!!");
Console.Write("\tEnter a new choice: ");
stringChoice = Console.ReadLine();
}
int choice = outChoice;
int studentID;
switch (choice)
{
case (int)SelectionCreateStudentOrAdd.create:
int user_ID = CreateUser(db);
student.CreateStudent(user_ID, db);
break;
case (int)SelectionCreateStudentOrAdd.add:
Check_ID check_ID = new Check_ID();
studentID = check_ID.GetTrueStudentID(student, db); // Έγκυρο STUDENT ID
TimesToInsertToCourses(studentID, check_ID, db);
break;
}
}
public static void Login(DataClasses1DataContext db)
{
StudentPerCourse studentPerCourse = new StudentPerCourse();
TrainerPerCourse trainerPerCourse = new TrainerPerCourse();
User user = new User();
Menu menu = new Menu();
bool iWantTocontinue = true;
while (iWantTocontinue)
{
string newSelection;
Console.WriteLine("\n\tEnter Username and Password to Login!");
Console.Write("\tEnter Username: "******"\n\t" + "Username shouldn't be empty!!!");
Console.Write("\n\t" + "Give a newr username: "******"\tEnter Password: "******"\n\t" + "Password shouldn't be empty!!!");
Console.Write("\n\t" + "Give a new password: "******"{ ROLEE = STUDENT }":
studentPerCourse.GetStudentPerCourse(userID, db);
break;
case "{ ROLEE = TRAINER }":
trainerPerCourse.GetTrainerPerCourse(userID, db);
break;
case "{ ROLEE = HEADMASTER }":
menu.Selection(db);
break;
default:
Console.WriteLine("\n\tUser not exist !!!");
break;
}
}
else
{
Console.WriteLine("\n\tThis User not exist!");
}
Console.WriteLine("\n\t" + "Do you want a new logg in?");
Console.WriteLine("\t" + "If yes press --> {Y} or {y}");
Console.WriteLine("\t" + "If no press --> {N} or {n}");
Console.Write("\n\t" + "Give a new selection: ");
newSelection = Console.ReadLine();
while (newSelection != "Y" && newSelection != "y" && newSelection != "N" && newSelection != "n")
{
Console.WriteLine("\n\t" + " Wrong Choise" + "\n\t" + " ---------------");
Console.WriteLine("\t" + "If yes press --> {Y} or {y}");
Console.WriteLine("\t" + "If no press --> {N} or {n}");
Console.Write("\n\t" + "Give again a new selection: ");
newSelection = Console.ReadLine();
}
if (newSelection == "Y" || newSelection == "y")
{
iWantTocontinue = true;
}
else if (newSelection == "N" || newSelection == "n")
{
iWantTocontinue = false;
}
Console.WriteLine();
}
}
public void Selection(DataClasses1DataContext db)
{
STUDENT student = new STUDENT();
TRAINER trainer = new TRAINER();
USERR uSer = new USERR();
string selection;
string newSelection;
int choiceCategory;
bool iWantTocontinue = true;
while (iWantTocontinue)
{
Console.WriteLine("\t" + " SELECTION MENU" + "\n\t" + " ------------------");
Console.WriteLine("\t" + "For Course Press {1}");
Console.WriteLine("\t" + "For Student Press {2}");
Console.WriteLine("\t" + "For Assignment Press {3}");
Console.WriteLine("\t" + "For Trainer Press {4}");
Console.WriteLine("\t" + "For User Press (Only Delete) {5}");
Console.WriteLine("\t" + "For Student Per Course Press {6}");
Console.WriteLine("\t" + "For Trainer Per Course Press {7}");
Console.WriteLine("\t" + "For Assignment Per Course Press {8}");
Console.WriteLine("\t" + "For Schedule Per Course Press {9}");
Console.Write("\n\t" + "Give a choise between {1 - 8}: ");
selection = Console.ReadLine();
int choice;
while (!int.TryParse(selection, out choice) || string.IsNullOrEmpty(selection) || choice < 1 || choice > 9)
{
Console.Write("\n\t" + "Give choice again Only Integer between {1 - 9}!!!: ");
selection = Console.ReadLine();
}
choiceCategory = choice;
switch (choiceCategory)
{
case (int)SelectionCategory.course:
Course course = new Course();
course.MenuCourse(db);
break;
case (int)SelectionCategory.student:
Student sTudent = new Student();
Check_ID check_ID = new Check_ID();
sTudent.MenuStudent(db, student, sTudent, check_ID);
break;
case (int)SelectionCategory.assignment:
Assignment assignment = new Assignment();
assignment.MenuAssignment(db);
break;
case (int)SelectionCategory.trainer:
Trainer tRainer = new Trainer();
tRainer.MenuTrainer(db, trainer);
break;
case (int)SelectionCategory.user:
User user = new User();
user.MenuUser(db);
break;
case (int)SelectionCategory.student_per_course:
StudentPerCourse studentPerCourse = new StudentPerCourse();
studentPerCourse.MenuStudentPerCourse(db);
break;
case (int)SelectionCategory.trainer_per_course:
TrainerPerCourse trainerPerCourse = new TrainerPerCourse();
trainerPerCourse.MenuTrainerPerCourse(db);
break;
case (int)SelectionCategory.assgnment_per_course:
AssignmentPerCourse assignmentPerCourse = new AssignmentPerCourse();
assignmentPerCourse.MenuAssignmentPerCourse(db);
break;
case (int)SelectionCategory.schedule_per_course:
SchedulePerCourse schedulePerCourse = new SchedulePerCourse();
schedulePerCourse.MenuSchedulePerCourse(db);
break;
}
Console.WriteLine("\n\t" + "Do you want a new selection?");
Console.WriteLine("\t" + "If yes press --> {Y} or {y}");
Console.WriteLine("\t" + "If no press --> {N} or {n}");
Console.Write("\n\t" + "Give a new selection: ");
newSelection = Console.ReadLine();
while (newSelection != "Y" && newSelection != "y" && newSelection != "N" && newSelection != "n")
{
Console.WriteLine("\n\t" + " Wrong Choise" + "\n\t" + " ---------------");
Console.WriteLine("\t" + "If yes press --> {Y} or {y}");
Console.WriteLine("\t" + "If no press --> {N} or {n}");
Console.Write("\n\t" + "Give again a new selection: ");
newSelection = Console.ReadLine();
}
if (newSelection == "Y" || newSelection == "y")
{
iWantTocontinue = true;
}
else if (newSelection == "N" || newSelection == "n")
{
iWantTocontinue = false;
}
Console.WriteLine();
}
}