//SCHEDULE public List <BCSchedule> GetSchedule(int classId) { using (var dbContext = new AttendanceSystemDB(_connectionString)) { return(dbContext.BCSchedule.Where(s => s.BCClassId == classId).ToList()); } }
public Settings GetSettings() { using (var dbContext = new AttendanceSystemDB(_connectionString)) { return(dbContext.Settings.FirstOrDefault()); } }
public BCClass GetClass(int classId) { using (var dbContext = new AttendanceSystemDB(_connectionString)) { return(dbContext.BCClasses.FirstOrDefault(c => c.BCClassId == classId)); } }
public List <BCTeacherSubject> GetActiveTeacherSubjects() { using (var dbContext = new AttendanceSystemDB(_connectionString)) { return(dbContext.BCTeacherSubjects.Where(t => t.IsActive).Include(t => t.Teacher).ToList()); } }
public BCStudent GetStudent(int studentId) { using (var dbContext = new AttendanceSystemDB(_connectionString)) { return(dbContext.BCStudents.FirstOrDefault(s => s.BCStudentId == studentId)); } }
//Classes public List <BCClass> GetAllClasses() { using (var dbContext = new AttendanceSystemDB(_connectionString)) { return(dbContext.BCClasses.ToList()); } }
public List <BCSchedule> GetDailySchedule(int classId, DayOfWeek day) { using (var dbContext = new AttendanceSystemDB(_connectionString)) { return(dbContext.BCSchedule.Where(s => s.BCClassId == classId && s.DayOfWeek == day).ToList()); } }
public void EditRecord(BCAttendance record) { using (var dbContext = new AttendanceSystemDB(_connectionString)) { dbContext.Database.ExecuteSqlCommand(@"UPDATE BCAttendances SET Status = {0} WHERE BCAttendanceId = {1}", record.Status, record.BCAttendanceId); } }
public void UpdateStudentClass(int studentId, BCStudentClass studentClass) { using (var dbContext = new AttendanceSystemDB(_connectionString)) { //var alreadyExists = dbContext.StudentClasses.FirstOrDefault(s => s.StudentId == studentId && s.ClassId == classId) != null ? true : false; if (studentClass.BCStudentClassId != 0) { //StudentClass studentClass = dbContext.StudentClasses.FirstOrDefault(s => s.StudentId == studentId && s.ClassId == classId); //studentClass.IsActive = true; dbContext.Entry <BCStudentClass>(studentClass).State = EntityState.Modified; } else { BCStudentClass NewStudentClass = new BCStudentClass { BCStudentId = studentId, BCClassId = studentClass.BCClassId, IsActive = true }; dbContext.BCStudentClasses.Add(NewStudentClass); } dbContext.SaveChanges(); } }
public User GetUser(string userName) { using (var dbContext = new AttendanceSystemDB(_connectionString)) { return(dbContext.Users.FirstOrDefault(u => u.UserName == userName)); } }
public List <BCTeacherSubject> GetTeacherSubjects(int teacherId) { using (var dbContext = new AttendanceSystemDB(_connectionString)) { return(dbContext.BCTeacherSubjects.Where(t => t.BCTeacherId == teacherId).ToList()); } }
public BCTeacher GetTeacher(int teacherId) { using (var dbContext = new AttendanceSystemDB(_connectionString)) { return(dbContext.BCTeachers.FirstOrDefault(t => t.BCTeacherId == teacherId)); } }
public List <BCClass> GetActiveClasses() { using (var dbContext = new AttendanceSystemDB(_connectionString)) { return(dbContext.BCClasses.Where(c => c.IsActive).ToList()); } }
//Teachers public List <BCTeacher> GetAllTeachers() { using (var dbContext = new AttendanceSystemDB(_connectionString)) { return(dbContext.BCTeachers.Include(t => t.TeacherSubjects).ToList()); } }
public void DeleteSchedule(int classId, DayOfWeek day) { using (var dbContext = new AttendanceSystemDB(_connectionString)) { dbContext.Database.ExecuteSqlCommand("DELETE FROM BCSchedules WHERE DayOfWeek = {0} and BCClassId = {1}", day, classId); } }
public List <BCStudent> GetAllStudents() { using (var dbContext = new AttendanceSystemDB(_connectionString)) { var settings = dbContext.Settings.FirstOrDefault(); return(dbContext.BCStudents.Where(s => s.YearStart == settings.YearStart && s.YearEnd == settings.YearEnd).ToList()); } }
public void UpdateTeacher(BCTeacher teacher) { using (var dbContext = new AttendanceSystemDB(_connectionString)) { dbContext.Entry <BCTeacher>(teacher).State = EntityState.Modified; dbContext.SaveChanges(); } }
public void UpdateStudent(BCStudent student) { using (var dbContext = new AttendanceSystemDB(_connectionString)) { dbContext.Entry <BCStudent>(student).State = EntityState.Modified; dbContext.SaveChanges(); } }
public void UpdateClass(BCClass c) { using (var dbContext = new AttendanceSystemDB(_connectionString)) { dbContext.Entry <BCClass>(c).State = EntityState.Modified; dbContext.SaveChanges(); } }
public void AddClass(BCClass c) { using (var dbContext = new AttendanceSystemDB(_connectionString)) { dbContext.BCClasses.Add(c); dbContext.SaveChanges(); } }
public void AddStudentClass(BCStudentClass studentClass) { using (var dbContext = new AttendanceSystemDB(_connectionString)) { dbContext.BCStudentClasses.Add(studentClass); dbContext.SaveChanges(); } }
public void AddTeacher(BCTeacher teacher) { using (var dbContext = new AttendanceSystemDB(_connectionString)) { dbContext.BCTeachers.Add(teacher); dbContext.SaveChanges(); } }
public void AddUser(User user) { using (var dbContext = new AttendanceSystemDB(_connectionString)) { dbContext.Users.Add(user); dbContext.SaveChanges(); } }
public void AddTeacherSubject(BCTeacherSubject subject) { using (var dbContext = new AttendanceSystemDB(_connectionString)) { dbContext.BCTeacherSubjects.Add(subject); dbContext.SaveChanges(); } }
public void UpdateAttendance(BCAttendance attendance) { using (var dbContext = new AttendanceSystemDB(_connectionString)) { dbContext.Entry <BCAttendance>(attendance).State = EntityState.Modified; dbContext.SaveChanges(); } }
public void DeleteDaysAttendance(DateTime date, int classId) { using (var dbContext = new AttendanceSystemDB(_connectionString)) { dbContext.Database.ExecuteSqlCommand("DELETE a FROM BCAttendances a JOIN BCStudentClasses s ON s.BCStudentClassId = a.BCStudentClassId" + " WHERE a.Date = {0} AND s.BCClassId = {1}", date, classId); } }
public void AddAttendance(List <BCAttendance> attendance) { using (var dbContext = new AttendanceSystemDB(_connectionString)) { dbContext.BCAttendances.AddRange(attendance); dbContext.SaveChanges(); } }
public List <BCStudentClass> GetStudentClasses(int studentId) { using (var dbContext = new AttendanceSystemDB(_connectionString)) { return(dbContext.BCStudentClasses .Where(s => s.BCStudentId == studentId) .ToList()); } }
public BCTeacher GetTeacherWithSubjects(int teacherId) { using (var dbContext = new AttendanceSystemDB(_connectionString)) { return(dbContext.BCTeachers .Include(t => t.TeacherSubjects) .FirstOrDefault(t => t.BCTeacherId == teacherId)); } }
public void AddSchedule(List <BCSchedule> schedule) { using (var dbContext = new AttendanceSystemDB(_connectionString)) { dbContext.BCSchedule.AddRange(schedule); dbContext.SaveChanges(); } }