/// <summary> /// Adds the course offering. /// </summary> /// <param name="courseOffering">The course offering.</param> public void AddCourseOffering(CourseOffering courseOffering) { using (_courseOfferingRepository) { if (_courseOfferingRepository.HasCourseOffering(courseOffering)) throw new CourseOfferingExistsException(); _courseOfferingRepository.InsertCourseOffering(courseOffering); } }
public void InsertCourseOffering(CourseOffering courseOffering) { using (var dbTransaction = _db.Database.BeginTransaction()) { try { _db.CourseOfferings.Add(courseOffering); _db.SaveChanges(); dbTransaction.Commit(); } catch (Exception) { dbTransaction.Rollback(); } } }
/// <summary> /// Check if a Course Offering exists /// </summary> /// <param name="courseOffering">The course offering.</param> /// <returns></returns> public bool HasCourseOffering(CourseOffering courseOffering) => _db.CourseOfferings.Any( offering => offering.Semester == courseOffering.Semester && offering.Year == courseOffering.Year && offering.CourseId == courseOffering.CourseId);