public void AddTeacherSubject(BCTeacherSubject subject)
 {
     using (var dbContext = new AttendanceSystemDB(_connectionString))
     {
         dbContext.BCTeacherSubjects.Add(subject);
         dbContext.SaveChanges();
     }
 }
        public void UpdateTeacherSubjects(int teacherId, BCTeacherSubject subject)
        {
            using (var dbContext = new AttendanceSystemDB(_connectionString))
            {
                if (subject.BCTeacherSubjectId != 0)
                {
                    dbContext.Entry <BCTeacherSubject>(subject).State = EntityState.Modified;
                }
                else
                {
                    BCTeacherSubject teacherSubject = new BCTeacherSubject {
                        BCTeacherId = teacherId, Subject = subject.Subject, IsActive = true
                    };

                    dbContext.BCTeacherSubjects.Add(teacherSubject);
                }

                dbContext.SaveChanges();
            }
        }