public override void Create(University university) { if (UniversityValidation.IsValidUniversity(university)) { DataAccessProvider.ExecuteNonQuery($"INSERT INTO Universities (UniversityName) " + $"values (\'{university.UniversityName}\')"); } }
public override void Delete(int universityId) { if (UniversityValidation.IsValidUniversityId(universityId)) { DataAccessProvider.ExecuteNonQuery($"DELETE Universities " + $"WHERE UniversityID = {universityId}"); } }
public QualificationService() { _qualificationRepository = new QualificationRepository(); _modelValidation = new CourseTypeValidation(); _titleValidation = new CourseTitleValidation(); _majorValidation = new MajorValidation(); _universityValidation = new UniversityValidation(); _instituteValidation = new InstituteValidation(); }
public override void Update(University university) { if (UniversityValidation.IsValidUniversity(university) && UniversityValidation.IsValidUniversityId(university.UniversityId)) { DataAccessProvider.ExecuteNonQuery($"UPDATE Universities " + $"SET UniversityName = \'{university.UniversityName}\' " + $"WHERE UniversityID = {university.UniversityId}"); } }