public override void Delete(int studentId)
{
if (StudentValidation.IsValidStudentId(studentId))
{
DataAccessProvider.ExecuteNonQuery($"DELETE Students " +
$"WHERE StudentID = {studentId}");
}
}
public override void Update(Student student)
{
if (StudentValidation.IsValidStudent(student) &&
StudentValidation.IsValidStudentId(student.StudentId))
{
DataAccessProvider.ExecuteNonQuery($"UPDATE Students " +
$"SET StudentName = \'{student.StudentName}\'," +
$" StudentSurname = \'{student.StudentSurname}\', " +
$" StudentAge = {student.StudentAge}, " +
$" GroupID = {student.GroupId} " +
$"WHERE StudentID = {student.StudentId}");
}
}