public IHttpActionResult GetProductReviews([FromBody] GetProductReviewsDTO model) { var productReviews = Product.FirstOrDefault(x => x.Sku == model.Sku && x.VariantSku == null).ProductReviews .Where(x => x.ProductReviewStatus.ProductReviewStatusId == 2000); return(Json(productReviews.Select(x => new ProductReviewDTO() { Name = x.CreatedBy, Rating = x.Rating.GetValueOrDefault(), Comments = x.ReviewText, Title = x.ReviewHeadline, Submitted = x.CreatedOn, }))); }
public IHttpActionResult GetProductReviews([FromBody] GetProductReviewsDTO model) { var productReviews = Ucommerce.EntitiesV2.ProductReview.Find(pr => pr.Product.Sku == model.Sku && pr.Product.VariantSku == null && pr.ProductReviewStatus.ProductReviewStatusId == (int)ProductReviewStatusCode.Approved && (pr.CultureCode == null || pr.CultureCode == string.Empty || pr.CultureCode == Thread.CurrentThread.CurrentUICulture.Name) ); return(Json(productReviews.OrderByDescending(pr => pr.CreatedOn).Select(x => new ProductReviewDTO() { Name = x.CreatedBy, Rating = x.Rating.GetValueOrDefault(), Comments = x.ReviewText, Title = x.ReviewHeadline, Submitted = x.CreatedOn, }))); }