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