public void CreateFromNewAssignment(int assignmentID, int courseID)
{
ICollection <Course> courses = DBStudentsPerCourse.ReadCoursesWithStudents();
Course course = courses.Where(c => c.Id == courseID).First();
ICollection <Student> CourseStudents = course.Students;
int result = 0;
foreach (Student s in CourseStudents)
{
result = DBAssignmentPerStudent.CreateAssignmentPerNewStudent(s.Id, courseID, assignmentID);
if (result == 0)
{
ConsoleUI.ShowLine("an error occured");
ConsoleUI.ReadKey();
return;
}
else
{
ConsoleUI.ShowLine($"assignment id: {assignmentID} saved for student id: {s.Id} and course id {courseID}");
}
}
}
public void SubmitAssignmentPerCoursePerStudent(int studentid)
{
ICollection <StudentAssignment> saList = DBAssignmentPerStudent.Read().Where(s => s.StudentId == studentid).ToList();
if (saList.Count() == 0)
{
ConsoleUI.ShowLine("nothing to show");
}
else
{
ConsoleUI.ShowLine("my assignments");
foreach (StudentAssignment item in saList)
{
ConsoleUI.ShowLine(item);
}
}
bool exit;
exit = ConsoleUI.GetInt(out int selectedAssignment, "give assignment id: ");
if (exit)
{
ConsoleUI.ReadKey();
ConsoleUI.Clear();
return;
}
exit = ConsoleUI.GetInt(out int selectedCourse, "give course id: ");
if (exit)
{
ConsoleUI.ReadKey();
ConsoleUI.Clear();
return;
}
int result = DBAssignmentPerStudent.SubmitAssignment(studentid, selectedAssignment, selectedCourse);
if (result == 0)
{
ConsoleUI.ShowLine("error submitting assignment");
}
else
{
ConsoleUI.ShowLine("assignment submitted successfully");
}
ConsoleUI.ReadKey();
ConsoleUI.Clear();
}
public void ReadAssignmentsPerCoursePerStudent()
{
ICollection <StudentAssignment> saList = DBAssignmentPerStudent.Read();
if (saList.Count() == 0)
{
ConsoleUI.ShowLine("nothing to show");
}
else
{
foreach (StudentAssignment item in saList)
{
ConsoleUI.ShowLine(item);
}
}
ConsoleUI.ReadKey();
ConsoleUI.Clear();
}
public void ReadDueDates(int studentid)
{
ICollection <StudentAssignment> saList = DBAssignmentPerStudent.Read().Where(s => s.StudentId == studentid).ToList();
if (saList.Count() == 0)
{
ConsoleUI.ShowLine("nothing to show");
}
else
{
ConsoleUI.ShowLine("my assignments");
foreach (StudentAssignment item in saList)
{
Assignment a = item.Assignment;
Course c = item.Course;
ConsoleUI.ShowLine($"assignment {a.Id}: {a.Title} by course {c.Id}: {c.Title}, due {a.SubmissionDate}, submitted: {item.Submitted} ");
}
}
ConsoleUI.ReadKey();
ConsoleUI.Clear();
}
public void DeleteByStudent(int studentID, int courseID)
{
ICollection <StudentAssignment> sa = DBAssignmentPerStudent.Read();
List <StudentAssignment> toDelete = sa.Where(row => row.StudentId == studentID && row.CourseId == courseID).ToList();
int result = 0;
foreach (StudentAssignment item in toDelete)
{
result = DBAssignmentPerStudent.DeleteAssignmentPerStudent(studentID, item.AssignmentId, courseID);
if (result == 0)
{
ConsoleUI.ShowLine("error occured");
return;
}
else
{
ConsoleUI.ShowLine($"assignment {item.AssignmentId} for student {studentID} deleted");
}
}
}
public void MarkAssignmentsPerCoursePerStudent()
{
ICollection <StudentAssignment> saList = DBAssignmentPerStudent.Read();
if (saList.Count() == 0)
{
ConsoleUI.ShowLine("nothing to show");
}
else
{
foreach (StudentAssignment item in saList)
{
ConsoleUI.ShowLine(item);
}
}
ConsoleUI.ShowLine("select student, assignment and course to mark or type 0 to exit");
bool exit;
exit = ConsoleUI.GetInt(out int selectedStudent, "give student id: ");
if (exit)
{
ConsoleUI.ReadKey();
ConsoleUI.Clear();
return;
}
exit = ConsoleUI.GetInt(out int selectedAssignment, "give assignment id: ");
if (exit)
{
ConsoleUI.ReadKey();
ConsoleUI.Clear();
return;
}
exit = ConsoleUI.GetInt(out int selectedCourse, "give course id: ");
if (exit)
{
ConsoleUI.ReadKey();
ConsoleUI.Clear();
return;
}
StudentAssignment sa = saList.Where(i =>
i.StudentId == selectedStudent &&
i.CourseId == selectedCourse &&
i.AssignmentId == selectedAssignment
).First();
if (!sa.Submitted)
{
ConsoleUI.ShowLine("this assignment is not yet submitted, please choose another submission");
ConsoleUI.ReadKey();
ConsoleUI.Clear();
return;
}
exit = ConsoleUI.GetInt(out int oralMark, "give new oral mark: ");
if (exit)
{
ConsoleUI.ReadKey();
ConsoleUI.Clear();
return;
}
exit = ConsoleUI.GetInt(out int totalMark, "give new total mark: ");
if (exit)
{
ConsoleUI.ReadKey();
ConsoleUI.Clear();
return;
}
int result = DBAssignmentPerStudent.MarkAssignment(selectedStudent,
selectedAssignment,
selectedCourse,
oralMark,
totalMark);
if (result == 0)
{
ConsoleUI.ShowLine("error marking assignment");
}
else
{
ConsoleUI.ShowLine("assignment marked successfully");
}
ConsoleUI.ReadKey();
ConsoleUI.Clear();
}
