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 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 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 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 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 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 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"));
}
