public void TimesToInsertToCourses(int studentID, Check_ID check_ID, DataClasses1DataContext db) // Λίστα με τυς αριθμούς των μαθημάτων που θέλουμε να εγγραφούμε
{
Course course = new Course();
int count = 1;
int limitNumberOfCourses = check_ID.AvailableNumberOfCourses(studentID, db);
if (limitNumberOfCourses > 0)
{
Console.WriteLine($"\n\tNumber Of available course/s for register {check_ID.AvailableNumberOfCourses(studentID, db)}!");
int numberTocourses = GetNumberToInsertToCourses();
while (numberTocourses > limitNumberOfCourses)
{
Console.WriteLine("\n\tΥou have overtaken the limit of Courses!!!");
Console.Write($"\tEnter again a number of courses between 1-{limitNumberOfCourses}: ");
numberTocourses = GetNumberToInsertToCourses();
}
int courseID = course.GetCourseIDFromStudentID(studentID, db);
var listNumbersOfcoursesID = new List <int>();
while (count <= numberTocourses)
{
courseID = check_ID.GetTrueCourseID(studentID, courseID, db); // Έγκυρο COURSE ID
check_ID.CheckAvailableCoursesID(listNumbersOfcoursesID, check_ID, studentID, courseID, db);
count += 1;
Console.WriteLine("\tEnrolled successfully");
}
}
else
{
Console.WriteLine("\n\tΥou have completed the courses limit!!!");
}
}
public int GetTrueCourseIDForCreate(Check_ID check_ID, DataClasses1DataContext db) // Για δημιουργία
{
Console.Write("\n\tEnter Course ID: ");
string courseId = Console.ReadLine();
int courseidOut;
while (!int.TryParse(courseId, out courseidOut))
{
Console.WriteLine("\n\t" + "Course ID should be Only Integer!!!");
Console.Write("\t" + "Give a new Course ID: ");
courseId = Console.ReadLine();
}
int courseID = courseidOut;
bool exist = check_ID.CheckCourseID(courseID, db);
while (!exist)
{
Console.Write("\n\tThis Course ID not Exist!!! ");
Console.Write("\n\tEnter New Course ID: ");
courseId = Console.ReadLine();
while (!int.TryParse(courseId, out courseidOut))
{
Console.WriteLine("\n\t" + "Course ID should be Only Integer!!!");
Console.Write("\t" + "Give a new Course ID: ");
courseId = Console.ReadLine();
}
courseID = courseidOut;
exist = check_ID.CheckCourseID(courseID, db);
}
return(courseID);
}
public TRAINER CreateTrainer(int user_ID, DataClasses1DataContext db, TRAINER trainer)
{
Check_ID check_ID = new Check_ID();
User user = new User();
Console.WriteLine("\n\n\t" + "CREATE TRAINER" + "\n\t--------------");
trainer = new TRAINER();
Console.Write("\t" + "Firstname (Only Letter!): ");
trainer.F_NAME = Console.ReadLine();
while (!trainer.F_NAME.All(char.IsLetter) || string.IsNullOrEmpty(trainer.F_NAME))
{
Console.Write("\n\t" + "Trainer firstname should be Only Letter!!!");
Console.Write("\n\t" + "Give a new Trainer firtsname: ");
trainer.F_NAME = Console.ReadLine();
}
trainer.F_NAME = char.ToUpper(trainer.F_NAME[0]) + trainer.F_NAME.Substring(1);
Console.Write("\t" + "Lastname (Only Letter!): ");
trainer.L_NAME = Console.ReadLine();
while (!trainer.L_NAME.All(char.IsLetter) || string.IsNullOrEmpty(trainer.L_NAME))
{
Console.Write("\n\t" + "Trainer lastname should be Only Letter!!!");
Console.Write("\n\t" + "Give a new Trainer lastname: ");
trainer.L_NAME = Console.ReadLine();
}
trainer.L_NAME = char.ToUpper(trainer.L_NAME[0]) + trainer.L_NAME.Substring(1);
Console.Write("\t" + "Subject (Only Letter!): ");
trainer.SUBJECT = Console.ReadLine();
while (!trainer.SUBJECT.All(char.IsLetter) || string.IsNullOrEmpty(trainer.SUBJECT))
{
Console.Write("\n\t" + "Trainer Subject should be Only Letter!!!");
Console.Write("\n\t" + "Give a new Trainer Subject: ");
trainer.SUBJECT = Console.ReadLine();
}
trainer.SUBJECT.ToUpper();
Console.Write("\t" + "Trainer ID (Only Integer!): ");
string trainerId = Console.ReadLine();
int trainerIdOut;
while (!int.TryParse(trainerId, out trainerIdOut) || trainerIdOut <= 0)
{
Console.WriteLine("\n\t" + "Trainer ID should be Only Integer and not Zero!!!");
Console.Write("\t" + "Give a new Trainer ID: ");
trainerId = Console.ReadLine();
}
int trainerIDAfterCheck = check_ID.positiveIntegerForTrainerID(trainerIdOut);
trainer.TRAINER_ID = check_ID.UniqueTrainerID(trainerIDAfterCheck, db);
trainer.USERR_ID = user_ID;
InsertTrainer(trainer, db);
Console.WriteLine("\n\tCreate Trainer Cuccessfully!!!");
return(trainer);
}
public void DeleteStudentsPerCourses(STUDENT_PER_COURSE studentPerCourse, DataClasses1DataContext db)
{
STUDENT sTudent = new STUDENT();
Student student = new Student();
Course course = new Course();
Check_ID check_ID = new Check_ID();
var listTotalNumbersOfCourses = new List <int>();
Console.WriteLine("\n\n\t" + "DELETE STUDENTS PER COURSES" +
"\n\t----------------------------");
Console.WriteLine("\t" + "For Dalete one only course press --> {1}");
Console.WriteLine("\t" + "For Delete all courses prees --> {2}");
Console.Write("\t" + "Give a choise between v --> {1 - 2}: ");
string selection = Console.ReadLine();
int choice;
while (!int.TryParse(selection, out choice) || string.IsNullOrEmpty(selection) || choice < 1 || choice > 2)
{
Console.Write("\n\t" + "Give choice again Only Integer between {1 - 2}!!!: ");
selection = Console.ReadLine();
}
int studentID = check_ID.GetTrueStudentIDWhoHaveCourses(student, db);
if (choice == 1)
{
int courseID = course.GetTrueCourseIDForCreate(check_ID, db);
studentPerCourse = db.STUDENT_PER_COURSEs.Single(i => i.STUDENT_ID == studentID && i.COURSE_ID == courseID);
studentPerCourse.STUDENT_ID = studentID;
studentPerCourse.COURSE_ID = courseID;
db.STUDENT_PER_COURSEs.DeleteOnSubmit(studentPerCourse);
db.SubmitChanges();
}
else
{
listTotalNumbersOfCourses = GetListTotalNumbersOfCourses(db, studentID);
int count = 1;
while (count <= listTotalNumbersOfCourses.Count())
{
foreach (int i in listTotalNumbersOfCourses)
{
studentPerCourse = db.STUDENT_PER_COURSEs.Single(j => j.STUDENT_ID == studentID && j.COURSE_ID == i);
studentPerCourse.STUDENT_ID = studentID;
studentPerCourse.COURSE_ID = i;
db.STUDENT_PER_COURSEs.DeleteOnSubmit(studentPerCourse);
db.SubmitChanges();
count += 1;
}
}
}
Console.WriteLine("\n\tDeleted Succesfully!!!");
}
public void MenuUser(DataClasses1DataContext db)
{
Check_ID check_ID = new Check_ID();
string userID;
Console.WriteLine("\n\tUSER MENU\n\t" + "---------\n");
check_ID.AvailableUserID(db);
Console.Write("\n\n\tEnter User ID for Deleted (Only Integer!): ");
userID = Console.ReadLine();
int userIDOut;
while (!int.TryParse(userID, out userIDOut))
{
Console.WriteLine("\n\tUser ID should be Only Integer!!!");
Console.Write("\tEnter again User ID: ");
userID = Console.ReadLine();
}
int user_ID = userIDOut;
int userIdAfterCheck = check_ID.GetTrueUserID(user_ID, db);
var getUser = from i in db.USERRs
where i.USERR_ID == userIdAfterCheck
select i;
var user = getUser.ToList().FirstOrDefault();
Console.WriteLine($"\tRole: {user.ROLEE}");
switch (user.ROLEE)
{
case "STUDENT":
case "student":
int studentID = getStudentIdFromUserID(userIdAfterCheck, db);
int courseID = getCourseIdFromStudentID(studentID, db);
int assignmnetID = getAssignmentIDFromCourseIDThisUser(courseID, db);
DeleteOfStudentsAsUsers(db, studentID, userIdAfterCheck, courseID, assignmnetID);
break;
case "TRAINER":
case "trainer":
int trainerID = getTrainerIdFromUserID(userIdAfterCheck, db);
int courseId = getCourseIdFromTrainerID(trainerID, db);
DeleteOfTrainersAsUsers(db, userIdAfterCheck, courseId, trainerID);
break;
default:
Console.WriteLine("\tThis User not exist!");
break;
}
}
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 MenuStudentPerCourse(DataClasses1DataContext db)
{
STUDENT_PER_COURSE studentPerCourse = new STUDENT_PER_COURSE();
Student student = new Student();
Check_ID check_ID = new Check_ID();
string stringChoice;
Console.WriteLine("\n\tSTUDENT PER COURSE MENU\n\t" + "-----------------------");
Console.WriteLine("\tCreate STUDENT PER COURSE press ---> {1}");
Console.WriteLine("\tRead STUDENT PER COURSE press ---> {2}");
Console.WriteLine("\tUpdate STUDENT PER COURSE press ---> {3}");
Console.WriteLine("\tDelete STUDENT PER COURSE press ---> {4}");
Console.Write("\tEnter a choice between ---> {1 - 4}: ");
stringChoice = Console.ReadLine();
Console.WriteLine();
int outChoice;
while (!int.TryParse(stringChoice, out outChoice) || outChoice < 1 || outChoice > 4)
{
Console.WriteLine("\n\tThe choice should be Only integer between {1- 4}!!!");
Console.Write("\tEnter a new choice: ");
stringChoice = Console.ReadLine();
}
int choice = outChoice;
switch (choice)
{
case (int)SelectionStudentPerCourse.create:
CreateStudentsPerCourses(studentPerCourse, db);
break;
case (int)SelectionStudentPerCourse.read:
int studentID = check_ID.GetTrueStudentIDWhoHaveCourses(student, db);
ReadStudentsPerCourses(db, studentID);
break;
case (int)SelectionStudentPerCourse.update:
UpdateStudentsPerCourses(studentPerCourse, db);
break;
case (int)SelectionStudentPerCourse.delete:
DeleteStudentsPerCourses(studentPerCourse, db);
break;
}
}
public void MenuTrainer(DataClasses1DataContext db, TRAINER trainer)
{
Check_ID check_ID = new Check_ID();
string stringChoice;
Console.WriteLine("\n\tTRAINER MENU\n\t" + "------------");
Console.WriteLine("\tCreate Trainer press ---> {1}");
Console.WriteLine("\tRead Trainer press ---> {2}");
Console.WriteLine("\tUpdate Trainer press ---> {3}");
Console.WriteLine("\tDelete Trainer press ---> {4}");
Console.Write("\tEnter a choice between ---> {1 - 4}: ");
stringChoice = Console.ReadLine();
int outChoice;
while (!int.TryParse(stringChoice, out outChoice) || outChoice < 1 || outChoice > 4)
{
Console.WriteLine("\n\tThe choice should be Only integer between {1- 4}!!!");
Console.Write("\tEnter a new choice: ");
stringChoice = Console.ReadLine();
}
int choice = outChoice;
switch (choice)
{
case (int)SelectionTrainer.create:
int user_ID = CreateUser(db);
CreateTrainer(user_ID, db, trainer);
break;
case (int)SelectionTrainer.read:
ReadTrainer(db);
break;
case (int)SelectionTrainer.update:
UpdateTrainer(db, trainer);
break;
case (int)SelectionTrainer.delete:
int trainerID = check_ID.GetTrueTrainerID(db);
int uSer_ID = getUserIdFromTrainerID(trainerID, db);
int courseId = getCourseIdFromTrainerID(trainerID, db);
DeleteOfTrainersAsUsers(db, uSer_ID, courseId, trainerID);
break;
}
}
public void UpdateStudentsPerCourses(STUDENT_PER_COURSE studentPerCourse, DataClasses1DataContext db)
{
STUDENT sTudent = new STUDENT();
Student student = new Student();
Check_ID check_ID = new Check_ID();
int studentID = check_ID.GetTrueStudentIDWhoHaveCourses(student, db);
Console.WriteLine("\n\n\t" + "UPATE STUDENTS PER COURSES" +
"\n\t---------------------------");
sTudent = student.UpdateStudent(db, sTudent, studentID);
int courseID = GetCourseIdFromStudent(db, sTudent.STUDENT_ID);
studentPerCourse.STUDENT_ID = sTudent.STUDENT_ID;
studentPerCourse.COURSE_ID = courseID;
db.SubmitChanges();
Console.WriteLine("\n\tStudents Per Courses was successfully enrolled!!!");
}
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 void DeleteCourses(int studentID, STUDENT_PER_COURSE studentPerCourse, DataClasses1DataContext db) // Χρησιμοποιείται στη κλάση USER στη μέθοδο
{ // DeleteOfAll για γενική διαγραφή
Student student = new Student();
Check_ID check_ID = new Check_ID();
var listTotalNumbersOfCourses = new List <int>();
listTotalNumbersOfCourses = GetListTotalNumbersOfCourses(db, studentID);
int count = 1;
while (count <= listTotalNumbersOfCourses.Count())
{
foreach (int i in listTotalNumbersOfCourses)
{
studentPerCourse = db.STUDENT_PER_COURSEs.Single(j => j.STUDENT_ID == studentID && j.COURSE_ID == i);
studentPerCourse.STUDENT_ID = studentID;
studentPerCourse.COURSE_ID = i;
db.STUDENT_PER_COURSEs.DeleteOnSubmit(studentPerCourse);
db.SubmitChanges();
count += 1;
}
}
}
public void DeleteTrainersGeneral(int trainerID, TRAINER_PER_COURSE tRainerPerCourse, DataClasses1DataContext db) // Χρησιμοποιείται στη κλάση USER στη μέθοδο
{ // DeleteOfAll για γενική διαγραφή
Trainer trainer = new Trainer();
Check_ID check_ID = new Check_ID();
var listTotalNumbersOfCourses = new List <int>();
listTotalNumbersOfCourses = GetListTotalNumbersOfCourses(db, trainerID);
int count = 1;
while (count <= listTotalNumbersOfCourses.Count())
{
foreach (int i in listTotalNumbersOfCourses)
{
tRainerPerCourse = db.TRAINER_PER_COURSEs.Single(j => j.TRAINER_ID == trainerID && j.COURSE_ID == i);
tRainerPerCourse.TRAINER_ID = trainerID;
tRainerPerCourse.COURSE_ID = i;
db.TRAINER_PER_COURSEs.DeleteOnSubmit(tRainerPerCourse);
db.SubmitChanges();
count += 1;
}
}
}
public void ReadStudentsPerCourses(DataClasses1DataContext db, int studentID)
{
Check_ID check_ID = new Check_ID();
STUDENT_PER_COURSE studentPerCourse = new STUDENT_PER_COURSE();
Student student = new Student();
var resultStudentPerCourse = from i in db.STUDENT_PER_COURSEs
where i.STUDENT_ID == studentID
select i;
studentPerCourse = resultStudentPerCourse.ToList().FirstOrDefault();
var studentName = resultStudentPerCourse.ToList().Take(1);
studentName.ToList().ForEach(i => Console.WriteLine("\n\t" + "STUDENT" + "\n" +
"\t" + "-------" + "\n" +
"\t" + $"Firstname: {i.STUDENT.F_NAME}" + "\n" +
"\t" + $"Lastname: {i.STUDENT.L_NAME}" + "\n"));
Console.WriteLine("\t" + "COURSES" + "\n" + "\t" + "-------");
resultStudentPerCourse.ToList().ForEach(i => Console.WriteLine("\t" + $"Course Stream: { i.COURSE.STREAM }" + "\n" +
"\t" + $"Week Day: {i.COURSE.WEEK_DAY}" + "\n"));
}
public void DeleteAssignemnts(int studentID, ASSIGNMENT_PER_STUDENT aSSignmentPerStudent, DataClasses1DataContext db) // Χρησιμοποιείται στη κλάση USER στη μέθοδο
{ // DeleteOfAll για γενική διαγραφή
Student student = new Student();
Check_ID check_ID = new Check_ID();
var listTotalNumbersOfAssignemnts = new List <int>();
listTotalNumbersOfAssignemnts = GetListTotalNumbersOfAssignments(db, studentID);
int count = 1;
while (count <= listTotalNumbersOfAssignemnts.Count())
{
foreach (int i in listTotalNumbersOfAssignemnts)
{
aSSignmentPerStudent = db.ASSIGNMENT_PER_STUDENTs.Single(j => j.STUDENT_ID == studentID && j.ASSIGNMENT_ID == i);
aSSignmentPerStudent.STUDENT_ID = studentID;
aSSignmentPerStudent.ASSIGNMENT_ID = i;
db.ASSIGNMENT_PER_STUDENTs.DeleteOnSubmit(aSSignmentPerStudent);
db.SubmitChanges();
count += 1;
}
}
}
public int CreateUser(DataClasses1DataContext db)
{
Check_ID check_ID = new Check_ID();
USERR uSer = new USERR();
string password;
Console.WriteLine("\n\tWe must first create a new User!\n\t" +
"--------------------------------");
Console.Write("\tEnter Username: "******"\n\tUsername shouldn't be empty!!!");
Console.Write("\n\t" + "Give a new Username: "******"\tEnter Password: "******"\n\tPassword shouldn't be empty!!!");
Console.Write("\n\t" + "Give a new Password: "******"\tEncrypted Password: {" + $"{hashedpass}" + "}");
Console.Write("\tEnter User Role between {STUDENT - TRAINER - HEADMASTER}: ");
string role = Console.ReadLine().ToUpper();
while (!role.All(char.IsLetter) || string.IsNullOrEmpty(role))
{
Console.Write("\n\tUser role should be Only Letter!!!");
Console.Write("\n\t" + "Give a new User role: ");
role = Console.ReadLine().ToUpper();
}
uSer.ROLEE = check_ID.CheckRole(role);
Console.Write("\tEnter User ID (Only Integer!): ");
string userId = Console.ReadLine();
int userIDOut;
while (!int.TryParse(userId, out userIDOut) || userIDOut <= 0)
{
Console.Write("\n\tUser ID should be Only Integer and not Zero!!!");
Console.Write("\n\t" + "Give a new User ID: ");
userId = Console.ReadLine();
}
int userIDAfterCheck = check_ID.positiveInteger(userIDOut);
uSer.USERR_ID = check_ID.UniqueUserID(userIDAfterCheck, db);
db.USERRs.InsertOnSubmit(uSer);
db.SubmitChanges();
ReadUser(uSer.USERR_ID, db);
return(uSer.USERR_ID);
}
public COURSE CreateCourse(DataClasses1DataContext db, COURSE course)
{
Check_ID check_ID = new Check_ID();
DateTime date = new DateTime();
Console.WriteLine("\n\n\t" + "CREATE COURSE" + "\n\t-------------");
Console.Write("\t" + "Course ID (Only Integer!): ");
string courseID = Console.ReadLine();
int courseIdOut;
while (!int.TryParse(courseID, out courseIdOut) || courseIdOut <= 0)
{
Console.WriteLine("\n\t" + "Course ID should be Only Integer and not Zero!!!");
Console.Write("\t" + "Give a new Course ID: ");
courseID = Console.ReadLine();
}
int courseIDAfterCheck = check_ID.positiveIntegerForCourseID(courseIdOut);
course.COURSE_ID = check_ID.UniqueCourseID(courseIDAfterCheck, db);
Console.Write("\t" + "Title (Only Letter!): ");
course.TITLE = Console.ReadLine();
while (!course.TITLE.All(char.IsLetter) || string.IsNullOrEmpty(course.TITLE))
{
Console.Write("\n\t" + "Course Title should be Only Letter!!!");
Console.Write("\n\t" + "Give a new Course Title: ");
course.TITLE = Console.ReadLine();
}
course.TITLE = char.ToUpper(course.TITLE[0]) + course.TITLE.Substring(1);
Console.Write("\t" + "Stream (Only Letter!): ");
course.STREAM = Console.ReadLine();
while (!course.STREAM.All(char.IsLetter) || string.IsNullOrEmpty(course.STREAM))
{
Console.Write("\n\t" + "Course Stream should be Only Letter!!!");
Console.Write("\n\t" + "Give a new Course Stream: ");
course.STREAM = Console.ReadLine();
}
course.STREAM = char.ToUpper(course.STREAM[0]) + course.STREAM.Substring(1);
Console.Write("\t" + "Type (Only Letter!): ");
course.TYPE = Console.ReadLine();
while (!course.TYPE.All(char.IsLetter) || string.IsNullOrEmpty(course.TYPE))
{
Console.Write("\n\t" + "Course Type should be Only Letter!!!");
Console.Write("\n\t" + "Give a new Course Type: ");
course.TYPE = Console.ReadLine();
}
course.TYPE = char.ToUpper(course.TYPE[0]) + course.TYPE.Substring(1);
Console.Write("\t" + "Start Date (Example: {" + $"{DateTime.Now.ToShortDateString()}" + "}): ");
string startDate = Console.ReadLine();
while (!DateTime.TryParse(startDate, out date))
{
Console.Write("\n\tInvalid Date Type!!!\n\tExample {" + $"{DateTime.Now.ToShortDateString()}" + "}: ");
startDate = Console.ReadLine();
}
DateTime dateTime = date;
course.START_DATE = dateTime;
Console.Write("\t" + "End Time (Example: {" + $"{DateTime.Now.ToShortDateString()}" + "}): ");
string endDate = Console.ReadLine();
while (!DateTime.TryParse(endDate, out date))
{
Console.Write("\n\tInvalid Date Type!!!\n\tExample {" + $"{DateTime.Now.ToShortDateString()}" + "}: ");
endDate = Console.ReadLine();
}
DateTime datetime = date;
course.END_TIME = datetime;
Console.Write("\t" + "Week Day (Only Letter!): ");
course.WEEK_DAY = Console.ReadLine().ToUpper();
while (!course.WEEK_DAY.All(char.IsLetter) || string.IsNullOrEmpty(course.WEEK_DAY))
{
Console.Write("\n\t" + "Course Week Day should be Only Letter!!!");
Console.Write("\n\t" + "Give a new Course Week Day: ");
course.WEEK_DAY = Console.ReadLine().ToUpper();
}
InsertCourse(course, db);
Console.WriteLine("\n\tInsert Course Cuccessfully!!!");
return(course);
}
public void AddStudentsToCourses(int studentID, int courseID, STUDENT_PER_COURSE studentPerCourse, Check_ID check_ID, DataClasses1DataContext db)
{
studentPerCourse.COURSE_ID = courseID;
studentPerCourse.STUDENT_ID = studentID;
db.STUDENT_PER_COURSEs.InsertOnSubmit(studentPerCourse);
db.SubmitChanges();
}
public ASSIGNMENT CreateAssignment(ASSIGNMENT assignment, DataClasses1DataContext db)
{
Check_ID check_ID = new Check_ID();
DateTime date = new DateTime();
Console.WriteLine("\n\n\t" + "CREATE ASSIGNMENT" + "\n\t-----------------");
assignment = new ASSIGNMENT();
Console.Write("\t" + "Assignment ID (Only Integer!): ");
string assignmentId = Console.ReadLine();
int assignmentIdOut;
while (!int.TryParse(assignmentId, out assignmentIdOut) || assignmentIdOut <= 0)
{
Console.WriteLine("\n\t" + "Assignment ID should be Only Integer and not Zero!!!");
Console.Write("\t" + "Give a new Assignment ID: ");
assignmentId = Console.ReadLine();
}
int assignmnetIDAfterCheck = check_ID.positiveIntegerForAssignmnetID(assignmentIdOut);
assignment.ASSIGNMENT_ID = check_ID.UniqueAssignmentID(assignmnetIDAfterCheck, db);
Console.Write("\t" + "Title (Only Letter!): ");
assignment.TITLE = Console.ReadLine();
while (!assignment.TITLE.All(char.IsLetter) || string.IsNullOrEmpty(assignment.TITLE))
{
Console.Write("\n\t" + "Assignment Title should be Only Letter!!!");
Console.Write("\n\t" + "Give a new Assignment Title: ");
assignment.TITLE = Console.ReadLine();
}
assignment.TITLE.ToUpper();
Console.Write("\t" + "Description (Only Letter!): ");
assignment.DESCRIPTIONN = Console.ReadLine();
while (!assignment.DESCRIPTIONN.All(char.IsLetter) || string.IsNullOrEmpty(assignment.DESCRIPTIONN))
{
Console.Write("\n\t" + "Assignment Description should be Only Letter!!!");
Console.Write("\n\t" + "Give a new Assignment Description: ");
assignment.DESCRIPTIONN = Console.ReadLine();
}
assignment.DESCRIPTIONN.ToUpper();
Console.Write("\t" + "Subbmision date and time (Example: {" + $"{DateTime.Now.ToShortDateString()}" + "}): ");
string subbmisionDateAndTime = Console.ReadLine();
while (!DateTime.TryParse(subbmisionDateAndTime, out date))
{
Console.Write("\n\tInvalid Date Type!!!\n\tExample {" + $"{DateTime.Now.ToShortDateString()}" + "}: ");
subbmisionDateAndTime = Console.ReadLine();
}
DateTime dateTime = date;
assignment.SUBMISSION_DATE_AND_TIME = dateTime;
Console.Write("\t" + "Assignment Oral Mark (Only Decimal!): ");
string assignmentOralMark = Console.ReadLine();
decimal assignmentOralMarkOut;
while (!decimal.TryParse(assignmentOralMark, out assignmentOralMarkOut))
{
Console.WriteLine("\n\t" + "Assignment Oral Mark should be Only Decimal!!!");
Console.Write("\t" + "Give a new Assignment Oral Mark: ");
assignmentOralMark = Console.ReadLine();
}
decimal assignmentORalMark = assignmentOralMarkOut;
assignment.ORAL_MARK = assignmentORalMark;
Console.Write("\t" + "Assignment Total Mark (Only Decimal!): ");
string assignmentTotalMark = Console.ReadLine();
decimal assignmentTotalMarkOut;
while (!decimal.TryParse(assignmentTotalMark, out assignmentTotalMarkOut))
{
Console.WriteLine("\n\t" + "Assignment Total Mark should be Only Decimal!!!");
Console.Write("\t" + "Give a new Assignment Total Mark: ");
assignmentTotalMark = Console.ReadLine();
}
decimal assignmenTOtalMark = assignmentTotalMarkOut;
assignment.TOTAL_MARK = assignmenTOtalMark;
InsertAssignment(assignment, db);
Console.WriteLine("\n\tCreate Assignment Cuccessfully!!!");
return(assignment);
}
public STUDENT CreateStudent(int user_ID, DataClasses1DataContext db)
{
DateTime date = new DateTime();
STUDENT student = new STUDENT();
User user = new User();
Check_ID check_ID = new Check_ID();
Console.WriteLine("\n\n\t" + "CREATE STUDENT" + "\n\t--------------");
student = new STUDENT();
Console.Write("\t" + "Firstname (Only Letter!): ");
student.F_NAME = Console.ReadLine();
while (!student.F_NAME.All(char.IsLetter) || string.IsNullOrEmpty(student.F_NAME)) // Μόνο γράμματα όχι αριθμούς και κενή συμβολοσειρά
{
Console.Write("\n\t" + "Student firstname should be Only Letter!!!");
Console.Write("\n\t" + "Give a new Student firtsname: ");
student.F_NAME = Console.ReadLine();
}
student.F_NAME = char.ToUpper(student.F_NAME[0]) + student.F_NAME.Substring(1); // Πρώτο γράμμα κεφαλαίο
Console.Write("\t" + "Lastname (Only Letter!): ");
student.L_NAME = Console.ReadLine();
while (!student.L_NAME.All(char.IsLetter) || string.IsNullOrEmpty(student.L_NAME))
{
Console.Write("\n\t" + "Student lastname should be Only Letter!!!");
Console.Write("\n\t" + "Give a new Student lastname: ");
student.L_NAME = Console.ReadLine();
}
student.L_NAME = char.ToUpper(student.L_NAME[0]) + student.L_NAME.Substring(1);
Console.Write("\t" + "Student ID (Only Integer!): ");
string studentId = Console.ReadLine();
int studentIdOut;
while (!int.TryParse(studentId, out studentIdOut) || studentIdOut <= 0)
{
Console.WriteLine("\n\t" + "Student ID should be Only Integer and not Zero!!!");
Console.Write("\t" + "Give a new Student ID: ");
studentId = Console.ReadLine();
}
int studentIDAfterCheck = check_ID.positiveIntegerForStudentID(studentIdOut);
student.STUDENT_ID = check_ID.UniqueStudentID(studentIDAfterCheck, db);
Console.Write("\t" + "Tuition (Only Decimal!): ");
string studentTuition = Console.ReadLine();
decimal studentTuitionOut;
while (!decimal.TryParse(studentTuition, out studentTuitionOut))
{
Console.WriteLine("\n\t" + "Student tuition should be Only Decimal!!!");
Console.Write("\t" + "Give a new student tuition: ");
studentTuition = Console.ReadLine();
}
decimal studentTuiTion = studentTuitionOut;
student.TUITION = studentTuiTion;
Console.Write("\t" + "Date of birth (Example: {" + $"{DateTime.Now.ToShortDateString()}" + "}): ");
string dateOfBirth = Console.ReadLine();
while (!DateTime.TryParse(dateOfBirth, out date))
{
Console.Write("\n\tInvalid Date Type!!!\n\tExample {" + $"{DateTime.Now.ToShortDateString()}" + "}: ");
dateOfBirth = Console.ReadLine();
}
DateTime dateTime = date;
student.DATE_OF_BIRTH = dateTime;
student.USERR_ID = user_ID;
InsertStudent(student, db);
Console.WriteLine("\n\tCreate Student Cuccessfully!!!");
return(student);
}
public void MenuStudent(DataClasses1DataContext db, STUDENT sTuDent, Student student, Check_ID check_ID)
{
Course course = new Course();
Assignment assignment = new Assignment();
Console.WriteLine("\n\tSTUDENT MENU\n\t" + "------------");
Console.WriteLine("\tCreate Student press ---> {1}");
Console.WriteLine("\tRead Student press ---> {2}");
Console.WriteLine("\tUpdate Student press ---> {3}");
Console.WriteLine("\tDelete Student press ---> {4}");
Console.Write("\tEnter a choice between ---> {1 - 4}: ");
string stringChoice;
stringChoice = Console.ReadLine();
int outChoice;
while (!int.TryParse(stringChoice, out outChoice) || outChoice < 1 || outChoice > 4)
{
Console.WriteLine("\n\tThe choice should be Only integer between {1- 4}!!!");
Console.Write("\tEnter a new choice: ");
stringChoice = Console.ReadLine();
}
int choice = outChoice;
switch (choice)
{
case (int)SelectionforStudent.create:
int user_ID = CreateUser(db);
student.CreateStudent(user_ID, db);
break;
case (int)SelectionforStudent.read:
int studentID = check_ID.GetTrueStudentID(student, db);
student.ReadStudent(db, studentID);
break;
case (int)SelectionforStudent.update:
studentID = check_ID.GetTrueStudentID(student, db);
student.UpdateStudent(db, sTuDent, studentID);
break;
case (int)SelectionforStudent.delete:
studentID = check_ID.GetTrueStudentID(student, db);
user_ID = GetUserID(studentID, db);
int courseID = course.GetCourseIDFromStudentID(studentID, db);
int assignmentID = getAssignmentIDFromCourseIDThisUser(courseID, db);
DeleteOfStudentsAsUsers(db, studentID, user_ID, courseID, assignmentID);
break;
}
}
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();
}
}
