public List <Absence> AbsenceByEducation(Education education)
{
return(context.Absences.Include(a => a.Student).Include(a => a.Course).Include(a => a.Course.Education).Where(a =>
(a.Student.Education == education)).ToList());
}
public List <Course> CoursesByEducationAndDate(Education education, in DateTime date)
public IQueryable <Absence> AbsencesForDateEducation(Education education, DateTime date)
{
IQueryable <Absence> absences = context.Absences.Include(a => a.Student).Include(a => a.Course).Where(a => a.Date.Date == date.Date && a.Student.Education == education);
return(absences);
}
public void Update(Education education)
{
context.Educations.Update(education);
context.SaveChanges();
}
public void Create(Education education)
{
context.Educations.Add(education);
context.SaveChanges();
}
public List <Student> GetAllStudentsFromEducationSemester(Education education, int semester)
{
List <Student> students = context.Students.Where(s => s.Education.EducationId == education.EducationId && s.Semester == semester).ToList();
return(students);
}
public List <Student> GetAllStudentsFromEducation(Education education)
{
return(context.Students.Where(s => s.Education.EducationId == education.EducationId).ToList());
}
