// UPDATE public async Task UpdateRestaurantAsync(int id, string name, string location, string cuisine, string specialty, string phoneNumber, string webAddress, string type, string hours) { DL.Restaurant r; try { using (var db = new LocalGourmetDBEntities()) { r = db.Restaurants.Find(id); if (r == null) { throw new ArgumentOutOfRangeException("id"); } r.Name = name; r.Location = location; r.Cuisine = cuisine; r.Specialty = specialty; r.PhoneNumber = phoneNumber; r.WebAddress = webAddress; r.Type = type; r.Hours = hours; await db.SaveChangesAsync(); } } catch { throw; } }
// UPDATE public async Task UpdateReviewAsync(int id, string reviewerName, string comment, int foodRating, int serviceRating, int priceRating, int atmosphereRating, int restaurantID) { DL.Review r; try { using (var db = new LocalGourmetDBEntities()) { r = db.Reviews.Find(id); if (r == null) { throw new ArgumentOutOfRangeException("id"); } r.ReviewerName = reviewerName; r.Comment = comment; r.FoodRating = foodRating; r.ServiceRating = serviceRating; r.PriceRating = priceRating; r.AtmosphereRating = atmosphereRating; r.RestaurantID = restaurantID; await db.SaveChangesAsync(); } } catch { throw; } }
// CREATE public async Task AddRestaurantAsync(DL.Restaurant item) { using (var db = new LocalGourmetDBEntities()) { db.Restaurants.Add(item); await db.SaveChangesAsync(); } }
// DELETE public async Task DeleteRestaurantAsync(int id) { DL.Restaurant r; try { using (var db = new LocalGourmetDBEntities()) { r = db.Restaurants.Find(id); if (r == null) { throw new ArgumentOutOfRangeException("id"); } db.Restaurants.Remove(r); await db.SaveChangesAsync(); } } catch { throw; } }