public List <Group> GetConnectionedList()
{
using (var db = new ElJournalDbContext())
{
return(db.Groups.Include(g => g.GroupToSubjects).ThenInclude(gts => gts.Subject).ToList());
}
}
public User GetItemByID(int id)
{
using (var db = new ElJournalDbContext())
{
return(db.Users.FirstOrDefault(u => u.UserID == id));
}
}
public ObservableCollection <Teacher> GetConnectionedList()
{
using (var db = new ElJournalDbContext())
{
return(new ObservableCollection <Teacher>(db.Teachers.Include(t => t.TeacherToSubjects).ThenInclude(tts => tts.Subject).ToList()));
}
}
public Teacher GetTeacherByUserID(int userid)
{
using (var db = new ElJournalDbContext())
{
return(db.Teachers.FirstOrDefault(t => t.UserID == userid));
}
}
public List <Teacher> GetList()
{
using (var db = new ElJournalDbContext())
{
return(db.Teachers.ToList());
}
}
public Admin GetItemByID(int id)
{
using (var db = new ElJournalDbContext())
{
return(db.Admins.FirstOrDefault(a => a.AdminID == id));
}
}
public Group GetItemByID(int id)
{
using (var db = new ElJournalDbContext())
{
return(db.Groups.FirstOrDefault(g => g.GroupID == id));
}
}
public Teacher GetItemByID(int id)
{
using (var db = new ElJournalDbContext())
{
return(db.Teachers.FirstOrDefault(t => t.TeacherID == id));
}
}
public List <Lesson> GetLessonsBySemester(int semesterid)
{
using (var db = new ElJournalDbContext())
{
return(db.Lessons.Where(l => l.SemesterID == semesterid).ToList());
}
}
public List <Student> GetStudentsByGroup(int groupid)
{
using (var db = new ElJournalDbContext())
{
return(db.Students.Where(s => s.GroupID == groupid).ToList());
}
}
public List <Student> GetConnectionedList()
{
using (var db = new ElJournalDbContext())
{
return(db.Students.Include(s => s.Group).ToList());
}
}
public List <Student> GetList()
{
using (var db = new ElJournalDbContext())
{
return(db.Students.ToList());
}
}
public Student GetItemByID(int id)
{
using (var db = new ElJournalDbContext())
{
return(db.Students.FirstOrDefault(s => s.StudentID == id));
}
}
public List <Group> GetList()
{
using (var db = new ElJournalDbContext())
{
return(db.Groups.ToList());
}
}
public Semester GetItemByID(int id)
{
using (var db = new ElJournalDbContext())
{
return(db.Semesters.FirstOrDefault(s => s.SemesterID == id));
}
}
public Mark GetItemByID(int id)
{
using (var db = new ElJournalDbContext())
{
return(db.Marks.FirstOrDefault(m => m.MarkID == id));
}
}
public GroupToSubject GetItemByID(int id)
{
using (var db = new ElJournalDbContext())
{
return(db.GroupToSubjects.FirstOrDefault(gts => gts.GroupToSubjectID == id));
}
}
public Lesson GetItemByID(int id)
{
using (var db = new ElJournalDbContext())
{
return(db.Lessons.Find(id));
}
}
public GroupToSubject GetGTSByIDs(int groupid, int subjectid)
{
using (var db = new ElJournalDbContext())
{
return(db.GroupToSubjects.FirstOrDefault(gts => gts.SubjectID == subjectid && gts.GroupID == groupid));
}
}
public List <TeacherToSubject> GetTTSsByTeacher(int teacherid)
{
using (var db = new ElJournalDbContext())
{
return(db.TeacherToSubjects.Where(tts => tts.TeacherID == teacherid).Include(tts => tts.Subject).ToList());
}
}
public TeacherToSubject GetItemByID(int id)
{
using (var db = new ElJournalDbContext())
{
return(db.TeacherToSubjects.FirstOrDefault(u => u.TeacherToSubjectID == id));
}
}
public void Remove(Subject subject)
{
using (var db = new ElJournalDbContext())
{
db.Subjects.Remove(subject);
db.SaveChanges();
}
}
public void Remove(Lesson lesson)
{
using (var db = new ElJournalDbContext())
{
db.Lessons.Remove(lesson);
db.SaveChanges();
}
}
public void Remove(GroupToSubject grouptosubject)
{
using (var db = new ElJournalDbContext())
{
db.GroupToSubjects.Remove(grouptosubject);
db.SaveChanges();
}
}
public void Remove(Student student)
{
using (var db = new ElJournalDbContext())
{
db.Students.Remove(student);
db.SaveChanges();
}
}
public void Remove(Group group)
{
using (var db = new ElJournalDbContext())
{
db.Groups.Remove(group);
db.SaveChanges();
}
}
public void Remove(TeacherToSubject teacherToSubject)
{
using (var db = new ElJournalDbContext())
{
db.TeacherToSubjects.Remove(teacherToSubject);
db.SaveChanges();
}
}
public void Remove(Semester semester)
{
using (var db = new ElJournalDbContext())
{
db.Semesters.Remove(semester);
db.SaveChanges();
}
}
public void Remove(Mark mark)
{
using (var db = new ElJournalDbContext())
{
db.Marks.Remove(mark);
db.SaveChanges();
}
}
public void Remove(Teacher teacher)
{
using (var db = new ElJournalDbContext())
{
db.Teachers.Remove(teacher);
db.SaveChanges();
}
}
