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}");
}
}
