public override void Delete(int teacherId) { if (TeacherValidation.IsValidTeacherId(teacherId)) { DataAccessProvider.ExecuteNonQuery($"DELETE Teachers " + $"WHERE TeacherID = {teacherId}"); } }
public override void Update(Teacher teacher) { if (TeacherValidation.IsValidTeacher(teacher) && TeacherValidation.IsValidTeacherId(teacher.TeacherId)) { DataAccessProvider.ExecuteNonQuery($"UPDATE Teachers " + $"SET TeacherName = \'{teacher.TeacherName}\'," + $" TeacherSurname = \'{teacher.TeacherName}\', " + $" TeacherAge = {teacher.TeacherAge} " + $"WHERE TeacherID = {teacher.TeacherId}"); } }