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