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