public void AddDishReview(string owner, int dish_id, int mark, string text) { dishreview dr = new dishreview { Id_Owner = owner, Id_Dish = dish_id, Mark = (int)mark, Description = text }; context.dishreviews.Add(dr); context.SaveChanges(); double average = (double)context.dishreviews.Where(r=>r.Id_Dish == dish_id).Average(r => r.Mark); dish d = GetDishById(dish_id); d.Raiting = Convert.ToInt32(Math.Round(average, 0)); context.SaveChanges(); }
private void UpdateDishRating(dishreview dr) { var dishrev = context.dishreviews.Where(r => r.Id_Dish == dr.Id_Dish); dish d = GetDishById(dr.Id_Dish); if (dishrev.Count() != 0) { double average = (double)dishrev.Average(r => r.Mark); d.Raiting = Convert.ToInt32(Math.Round(average, 0)); } else { d.Raiting = 0; } context.SaveChanges(); }