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