public List <Student> GetAll()
{
using (var context = new AttendanceContext())
{
return(context.Student.ToList());
}
}
public Lecturer GetByUserId(string id)
{
using (var context = new AttendanceContext())
{
return(context.Lecturer.FirstOrDefault(x => x.UserId == id));
}
}
public Student GetByUserId(string id)
{
using (var context = new AttendanceContext())
{
return(context.Student.FirstOrDefault(x => x.UserId == id));
}
}
public Student GetByCardNumber(string cardNumber)
{
using (var context = new AttendanceContext())
{
return(context.Student.FirstOrDefault(x => x.CardNumber == cardNumber));
}
}
public Group GetById(int id)
{
using (var context = new AttendanceContext())
{
return(context.Group.Include("Students").FirstOrDefault(x => x.Id == id));
}
}
public Group GetByStudent(int studentId)
{
using (var context = new AttendanceContext())
{
return(context.Group.FirstOrDefault(x => x.Students.FirstOrDefault(y => y.Id == studentId) != null));
}
}
public Lecture GetById(int id)
{
using (var context = new AttendanceContext())
{
return(context.Lecture.Include("Subject").Include("Auditorium").Include("Lecturer").Include("LectureTime")
.Include("LectureType").Include("Group").Include("Occurences").FirstOrDefault(x => x.Id == id));
}
}
public List <Lecture> GetByGroupId(int id)
{
using (var context = new AttendanceContext())
{
return(context.Lecture.Include("Subject").Include("Auditorium").Include("Lecturer").Include("LectureTime")
.Include("LectureType").Include("Group").Include("Occurences").Where(x => x.Group.Id == id).ToList());
}
}
public Attendance GetStudentAttendance(int studentId, int lectureId)
{
using (var context = new AttendanceContext())
{
return(context.Attendance.Include("Student").Include("Lecture")
.FirstOrDefault(x => x.Student.Id == studentId && x.Lecture.Id == lectureId));
}
}
public void Add(AttendanceEntry attendanceEntry)
{
using (var context = new AttendanceContext())
{
context.AttendanceEntry.Add(attendanceEntry);
context.SaveChanges();
}
}
public void UpdateLectures(Attendance attendance)
{
using (var context = new AttendanceContext())
{
if (context.Attendance.FirstOrDefault(x => x.Id == attendance.Id) != null)
{
context.Attendance.FirstOrDefault(x => x.Id == attendance.Id).AttendedLectures = attendance.AttendedLectures;
context.SaveChanges();
}
}
}
