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