public override void Delete(int teacherId)
{
if (TeacherValidation.IsValidTeacherId(teacherId))
{
DataAccessProvider.ExecuteNonQuery($"DELETE Teachers " +
$"WHERE TeacherID = {teacherId}");
}
}
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();
}
void AddTeacher()
{
Teacher teacher = new Teacher(
Name,
CivilNum,
PhoneNum,
Email,
TeacherFaculty,
TaughtSubjects.ToList());
TeacherValidation.ActionOnError act = Error;
TeacherValidation tv = new TeacherValidation(act);
if (tv.isTeacherValid(teacher))
{
users.Add(teacher);
ErrMsg = "Teacher " + teacher.Name + " added!";
Factory.GetTeachers().InsertOne(teacher);
}
}
