public int BarReviewCount(string username)
{
var user = _barRepo.GetUserByUsername(username);
int barReviewCount = (from b in _barRepo.List().Where(b => b.UserId == user.Id)
select b).Count();
return(barReviewCount);
}
public double GetAverageRating(int id)
{
var something = _reviewRepo.List().Where(r => r.BarId == id).Select(r => r.Rating);
var ratingAverage = 0d;
try
{
ratingAverage = something.Average();
}
catch
{
ratingAverage = 0;
}
var roundedRating = Math.Round(ratingAverage);
return(roundedRating);
}
public List <BarReviewDTO> GetMyReviews(string UserId)
{
var result = _barReviewRepo.List().Where(r => r.UserId == UserId).Select(r => ProjectToViewModel(r)).ToList();
return(result);
}
