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