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(); } }