public decimal CalcScoreLocal(Guid id)
{
decimal calculatedRating;
try
{
using (var db = new gmbdbEntities())
{
var review = db.Reviews.SingleOrDefault(u => u.Id == id);
int count = 0;
foreach (var usertorev in review.UserToReviews)
{
if (usertorev.Rating > 0)
{
count++;
}
}
int total = 0;
foreach (var usertorev in review.UserToReviews)
{
if (usertorev.Rating > 0)
{
total += (int)usertorev.Rating;
}
}
calculatedRating = decimal.Divide(total, count);
return(calculatedRating);
}
}
catch
{
calculatedRating = 0;
return(calculatedRating);
}
}
