public void AverageRatingsRemove(int RestaurantID, int OldRating) { var temp = RRRavesDBEntities.Set <Review>().Where(x => x.Restaurant == RestaurantID); var temp2 = temp.Select(x => x.Rating).ToList(); temp2.Remove(OldRating); var temp3 = Convert.ToDecimal(temp2.DefaultIfEmpty().Average()); RRRavesDBEntities.Set <Restaurant>().Find(RestaurantID).AveRating = temp3; }
public void EditReview(int id, string field, string newvalue) { switch (field) { case "Rating": var oldRating = RRRavesDBEntities.Set <Review>().Find(id).Rating; RRRavesDBEntities.Set <Review>().Find(id).Rating = Convert.ToInt32(newvalue); var rid = (int)RRRavesDBEntities.Set <Review>().Find(id).Restaurant; this.AverageRatingsEdit(rid, oldRating, Convert.ToInt32(newvalue)); break; case "ReviewText": RRRavesDBEntities.Set <Review>().Find(id).ReviewText = newvalue; break; default: break; } }
public new void Remove(Review entity) { RRRavesDBEntities.Set <Review>().Remove(entity); int RestId = (int)entity.Restaurant; }
public IEnumerable <Restaurant> GetTopThree() { return(RRRavesDBEntities.Set <Restaurant>().OrderByDescending(x => x.AveRating).Take(3)); }
public new void Remove(Restaurant entity) { RRRavesDBEntities.Set <Restaurant>().Remove(entity); }