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