public IEnumerable <CourseSubject> CreateCourseSubjectToChooseByCourseIdAndSubjectToDelete
(int courseId, int id, List <Subject> subjects)
{
subjectService = new SubjectService();
courseService = new CourseService();
Subject subjectToRemove = subjectService.getSubjectById(id);
Course course = courseService.GetCourseByCourseId(courseId);
if (subjectToRemove == null)
{
return(null);
}
subjects.Remove(subjectToRemove);
List <CourseSubject> subjectsToChoose = new List <CourseSubject>();
foreach (Subject subject in subjects)
{
CourseSubject courseSubject = new CourseSubject()
{
Course = course,
Subject = subject
};
subjectsToChoose.Add(courseSubject);
}
return(subjectsToChoose);
}
public List <TeacherSubjectPairsViewModel> GetListOfTeachers()
{
subjectService = new SubjectService();
List <Teacher> teachers = new List <Teacher>();
teachers = db.Teachers.ToList();
List <TeacherSubjectPairsViewModel> viewModel = new List <TeacherSubjectPairsViewModel>();
// get corresponding subjects
foreach (Teacher teacher in teachers)
{
Subject teachersSubject = subjectService.getTeacherSubjectByTeacherId(teacher.Id);
TeacherSubjectPairsViewModel model = new TeacherSubjectPairsViewModel()
{
Teacher = teacher,
Subject = teachersSubject
};
viewModel.Add(model);
}
return(viewModel);
}
public Dictionary <Subject, Teacher> getSubjectTeacherPairs(int courseId)
{
Dictionary <Subject, Teacher> subjectTeacherPairs =
new Dictionary <Subject, Teacher>();
IEnumerable <CourseSubject> allCourseSubjects = db.CourseSubjects.ToList();
teacherService = new TeacherService();
subjectService = new SubjectService();
foreach (CourseSubject courseSubject in allCourseSubjects)
{
if (courseSubject.CourseId == courseId)
{
Subject wantedSubject = subjectService
.getSubjectById(courseSubject.SubjectId);
Teacher wantedTeacher = teacherService
.getCorrespondingTeacher(wantedSubject.TeacherId);
subjectTeacherPairs.Add(wantedSubject, wantedTeacher);
}
}
return(subjectTeacherPairs);
}
public IEnumerable <Subject> getListOfChosenSubjects()
{
subjectService = new SubjectService();
IEnumerable <Subject> theSubjects = subjectService.getSubjectsByListOfId(SubjectIds);
return(theSubjects);
}
public Teacher GetTeacherByStudentSubjectId(int studentSubjectID)
{
subjectService = new SubjectService();
Subject subject = subjectService.GetSubjectByStudentSubjectID(studentSubjectID);
int teacherId = subject.TeacherId;
return(db.Teachers.Find(teacherId));
}
public Grade?GetStudentAverageGradePerCourse(Course course)
{
studentService = new StudentService();
subjectService = new SubjectService();
studentSubjectService = new StudentSubjectService();
gradeService = new GradeService();
int studentsAverageGrade;
int studentsAverageRounded;
Grade?averageGrade;
List <Subject> subjectsFromACourse = subjectService.GetSubjectsFromACourse(course);
int numberOfSubjectsInACourse = subjectsFromACourse.Count();
int numberOfStudentsRegisteredInACourse = studentService
.GetStudentsRegisteredInACourse(course).Count();
int studentsTotalGrades = studentSubjectService
.GetTotalStudentGradesFromACourse(course);
int numberOfStudentSubjectsGraded = GetNumberOfStudentsSubjectsGradedInACourse(subjectsFromACourse);
if (numberOfSubjectsInACourse != 0 && numberOfStudentSubjectsGraded != 0)
{
studentsAverageGrade =
studentsTotalGrades / numberOfStudentSubjectsGraded;
}
else
{
studentsAverageGrade = 0;
}
studentsAverageRounded = (int)Math.Round((decimal)studentsAverageGrade);
averageGrade = gradeService.ConvertIntToGrade(studentsAverageRounded);
return(averageGrade);
}
public List <Subject> GetSubjectsFromCourse(int courseId)
{
List <Subject> studentSubjects = new List <Subject>();
IEnumerable <CourseSubject> courseSubjects = db.CourseSubjects.ToList();
Subject subject = new Subject();
int subjectId;
subjectService = new SubjectService();
foreach (CourseSubject courseSubject in courseSubjects)
{
if (courseSubject.CourseId == courseId)
{
subjectId = courseSubject.SubjectId;
subject = subjectService.getSubjectById(subjectId);
studentSubjects.Add(subject);
}
}
return((List <Subject>)studentSubjects);
}
