public override void Create(Student student)
{
if (StudentValidation.IsValidStudent(student))
{
DataAccessProvider.ExecuteNonQuery($"INSERT INTO Students " +
$"(StudentName, StudentSurname, StudentAge, GroupID) " +
$"values (\'{student.StudentName}\'," +
$"\'{student.StudentSurname}\'," +
$" {student.StudentAge}, " +
$" {student.GroupId})");
}
}
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}");
}
}
