public GenericSearchResult <CustomerReview> SearchCustomerReviews(CustomerReviewSearchCriteria criteria)
{
if (criteria == null)
{
throw new ArgumentNullException($"{nameof(criteria)} must be set");
}
var retVal = new GenericSearchResult <CustomerReview>();
using (var repository = _repositoryFactory())
{
var query = repository.CustomerReviews;
if (!criteria.ProductIds.IsNullOrEmpty())
{
query = query.Where(x => criteria.ProductIds.Contains(x.ProductId));
}
if (criteria.IsActive.HasValue)
{
query = query.Where(x => x.IsActive == criteria.IsActive);
}
if (!criteria.SearchPhrase.IsNullOrEmpty())
{
query = query.Where(x => x.Content.Contains(criteria.SearchPhrase));
}
var sortInfos = criteria.SortInfos;
if (sortInfos.IsNullOrEmpty())
{
sortInfos = new[] { new SortInfo {
SortColumn = "CreatedDate", SortDirection = SortDirection.Descending
} };
}
retVal.TotalCount = query.Count();
query = query.OrderBySortInfos(sortInfos);
retVal.TotalCount = query.Count();
var customerReviewIds = query.Skip(criteria.Skip)
.Take(criteria.Take)
.Select(x => x.Id)
.ToList();
//TODO rewrite for a 1 query
var customerReviews = _customerReviewService.GetReviewByIds(customerReviewIds.ToArray())
.OrderBy(x => customerReviewIds.IndexOf(x.Id)).ToList();
foreach (var item in customerReviews)
{
item.UserReviewRate = repository.CustomerReviewVotes
.Where(x => criteria.AuthorId.Equals(x.AuthorId) && item.Id.Equals(x.CustomerReviewId))
.Select(x => x.ReviewRate)
.FirstOrDefault();
}
retVal.Results = customerReviews;
return(retVal);
}
}