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