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