public override void Create(Teacher teacher)
{
if (TeacherValidation.IsValidTeacher(teacher))
{
DataAccessProvider.ExecuteNonQuery($"INSERT INTO Teachers " +
$"(TeacherName, TeacherSurname, TeacherAge) " +
$"values (\'{teacher.TeacherName}\'," +
$"\'{teacher.TeacherSurname}\'," +
$" {teacher.TeacherAge})");
}
}
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}");
}
}
private void AddTeacherButton_Click(object sender, EventArgs e)
{
var teacherRepository = new TeacherRepository();
var name = addTeacherNameTextBox.Text;
var surname = addTeacherSurnameTextBox.Text;
var age = (int)addTeacherAgeNumericUpDown.Value;
var teacher = new Teacher(name, surname, age);
if (!TeacherValidation.IsValidTeacher(teacher))
{
return;
}
teacherRepository.Create(teacher);
RefreshForm();
}
