public void Create(CustomerReview customerReview) { using (var conn = DbContextFactory.CreateConnection()) { } }
public void AddCustomerReview(Provider provider, CustomerReview review) { using (var conn = DbContextFactory.CreateConnection()) { // Add the customer review var newReview = conn.Add(review); // Then add the relationship to the provider conn.Execute("ProviderCustomerReview_Add", new { ProviderId = provider.ProviderId, CustomerReviewId = newReview.CustomerReviewId }, commandType: CommandType.StoredProcedure); } }
public void ReviewProvider(int providerId, decimal score, string reviewComment, string reviewerName) { CustomerReview review = new CustomerReview { Score = score, Comment = reviewComment, CreatedByUser = reviewerName, CreatedDateTime = DateTime.Now, LastModifiedByUser = reviewerName, LastModifiedDateTime = DateTime.Now, Active = true }; var provider = _providerRepository.Get(providerId); if (provider == null) { throw new ArgumentException("Provider ID " + providerId + " does not exist"); } provider.CustomerReviews.Add(review); var numberOfReviews = provider.CustomerReviews.Count; var newScore = provider.CustomerReviews.Sum(r => r.Score)/numberOfReviews; provider.Rating = newScore; provider.LastModifiedByUser = reviewerName; provider.LastModifiedDateTime = DateTime.Now; _providerRepository.AddCustomerReview(provider, review); _providerRepository.UpdateProviderRating(provider); }