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 GetStudentAssignmentPerCourse(int studentID, DataClasses1DataContext db)
{
StudentPerAssignment studentPerAssignment = new StudentPerAssignment();
var getStudentAssignmentPerCourse = from i in db.ASSIGNMENT_PER_COURSEs
from j in db.STUDENT_PER_COURSEs
where j.STUDENT_ID == studentID && j.COURSE_ID == i.COURSE_ID
select new
{
assignmentDesc = i.ASSIGNMENT.DESCRIPTIONN,
assignmentSubmisionDate = i.ASSIGNMENT.SUBMISSION_DATE_AND_TIME,
courseTitle = i.COURSE.TITLE
};
Console.WriteLine("\t" + "ASSIGNMENT PER COURSE PER STUDENT" + "\n" + "\t" + "---------------------------------");
getStudentAssignmentPerCourse.ToList().ForEach(i => Console.WriteLine("\n\t" + $"Course title: {i.courseTitle}" + "\n" +
"\t" + $"Assignment description: {i.assignmentDesc}" + "\n" +
"\t" + $"Assignment submision date: {i.assignmentSubmisionDate}" + "\n"));
studentPerAssignment.SubmitAssignment(studentID, db);
}
