Example #1
0
 public override void Create(University university)
 {
     if (UniversityValidation.IsValidUniversity(university))
     {
         DataAccessProvider.ExecuteNonQuery($"INSERT INTO Universities (UniversityName) " +
                                            $"values (\'{university.UniversityName}\')");
     }
 }
Example #2
0
 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}");
     }
 }