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 void AddStudentClass(BCStudentClass studentClass) { using (var dbContext = new AttendanceSystemDB(_connectionString)) { dbContext.BCStudentClasses.Add(studentClass); dbContext.SaveChanges(); } }