public ActionResult RatingSummary() { ViewBag.AccountID = new SelectList(wpsModel.GetAllAccountsName(), "AccountID", "AccountName"); RatingSummary ratingTr = new RatingSummary(); return(View(ratingTr)); }
public async Task <RatingSummary> GetRatingSummaryAsync(string RestaurantId) { var relatedRatings = await mongoDb.GetCollection <BsonDocument>("Rating").Find(Builders <BsonDocument> .Filter.Eq("RestaurantId", RestaurantId)).As <Rating>().ToListAsync <Rating>(); var toReturn = new RatingSummary { RestaurantId = RestaurantId, NumberOfRatings = relatedRatings.Count, AverageRating = relatedRatings.Count > 0 ? relatedRatings.Average(r => r.Value) : 0 }; return(toReturn); }
public JsonResult RatingSummaryList(int?user, int?OrgId, int?CompanyID, int?SiteID, int?AccountID, int?AccountTypeID, DateTime?FromDate, int?Sqlqry) { try { RatingSummary ratingTr = new RatingSummary(); var respRating = wpsModel.SP_Reviews_Rating_Summary_Dashboard((CompanyID > 0 && CompanyID.HasValue) ? CompanyID.ToString() : "%", (SiteID > 0 && SiteID.HasValue) ? SiteID.ToString() : "%", (AccountID > 0 && AccountID.HasValue) ? AccountID.ToString() : "0", (AccountTypeID > 0 && AccountTypeID.HasValue) ? AccountTypeID.ToString() : "0", FromDate, (Sqlqry > 0 && Sqlqry.HasValue) ? Sqlqry.ToString() : null).ToList(); ratingTr.SP_Reviews_Rating_Summary_Dashboard = respRating.ToList(); return(Json(new { RatingSummary = ratingTr }, JsonRequestBehavior.AllowGet)); } catch (Exception ex) { var e = new Exception(string.Format("Review site list is failed. {0}", ex.Message)); throw e; } }
public async Task <RatingSummary> GetRatingSummaryAsync(string RestaurantId) { RatingSummary toReturn = new RatingSummary { RestaurantId = RestaurantId }; var ratings = context.Ratings.Where(r => r.RestaurantId == RestaurantId); toReturn.NumberOfRatings = ratings.Count(); if (toReturn.NumberOfRatings != 0) { toReturn.AverageRating = ratings.Average(r => r.Value); } else { toReturn.AverageRating = 0; } return(await Task.FromResult(toReturn)); }
public void Update(RatingSummary ratingSummary) { Guard.IsNotNull(ratingSummary, nameof(ratingSummary)); ReviewSummary = new ReviewSummary { AverageRating = ratingSummary.AverageRating, ReviewCount = ratingSummary.ReviewCount, Star1Count = ratingSummary.Star1Count, Star2Count = ratingSummary.Star2Count, Star3Count = ratingSummary.Star3Count, Star4Count = ratingSummary.Star4Count, Star5Count = ratingSummary.Star5Count, Star1ReviewCount = ratingSummary.Star1ReviewCount, Star2ReviewCount = ratingSummary.Star2ReviewCount, Star3ReviewCount = ratingSummary.Star3ReviewCount, Star4ReviewCount = ratingSummary.Star4ReviewCount, Star5ReviewCount = ratingSummary.Star5ReviewCount }; }