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