public void AddNewReview(int id, Review newReview) { newReview.RestaurantId = id; newReview.reviewer = ""; _db.Reviews.Add(ToDataReview(newReview)); //_db.SaveChanges(); try { _db.SaveChanges(); } catch (System.Data.Entity.Validation.DbEntityValidationException dbEx) { Exception raise = dbEx; foreach (var validationErrors in dbEx.EntityValidationErrors) { foreach (var validationError in validationErrors.ValidationErrors) { string message = string.Format("{0}:{1}", validationErrors.Entry.Entity.ToString(), validationError.ErrorMessage); // raise a new exception nesting // the current instance as InnerException raise = new InvalidOperationException(message, raise); } } throw raise; } }
public void AddRestaurant(Restaurant item) { using (var db = new RestaurantsDBEntities()) { db.Restaurants.Add(LibraryToData(item)); db.SaveChanges(); } }
public void RemoveRestaurant(int id) { using (var db = new RestaurantsDBEntities()) { var tempRestaurant = db.Restaurants.Where(x => x.ID == id).ToList()[0]; db.Restaurants.Remove(tempRestaurant); db.SaveChanges(); } }
public double ShowAverageRating(int restId) { using (var db = new RestaurantsDBEntities()) { double RatingAverage = db.Reviews.Where(r => r.RestaurantId == restId).Average(r => r.rating); var temp = db.Restaurants.Where(x => x.ID == restId).First(); temp.avgRating = RatingAverage; db.SaveChanges(); return(RatingAverage); } }
public void UpdateRestaurant(Restaurant item) { using (var db = new RestaurantsDBEntities()) { Restaurant restaurant = new Restaurant(); var temp = db.Restaurants.Find(item.ID); restaurant.ID = temp.ID; restaurant.name = temp.name; restaurant.address = temp.address; restaurant.city = temp.city; restaurant.state = temp.state; restaurant.zipCode = temp.zipCode; restaurant.phoneNumber = temp.phoneNumber; restaurant.avgRating = temp.avgRating; db.Restaurants.Add(LibraryToData(restaurant)); db.SaveChanges(); } }
public double UpdateAverageRating(int restId) { using (var db = new RestaurantsDBEntities()) { double RatingAverage = db.Reviews.Where(r => r.RestaurantId == restId).Average(r => (double?)r.rating) ?? 0; var temp = db.Restaurants.Where(x => x.ID == restId).First(); temp.avgRating = RatingAverage; db.SaveChanges(); return(RatingAverage); } //double cafeSales = db.InvoiceLines // .Where(x => // x.UserId == user.UserId && // x.DateCharged >= dateStart && // x.DateCharged <= dateEnd) // .Sum(x => (double?)(x.Quantity * x.Price)) ?? 0; }
public void Create(T entity) { Context.Set <T>().Add(entity); Context.SaveChanges(); }
public void AddNewReview(Review newReview) { _db.Reviews.Add(ToDataReview(newReview)); _db.SaveChanges(); }