public int AddRestaurant(Model.Restaurant restaurant) { using (var context = new RestaurantDBEntities()) { Restaurant newRest = context.Restaurants.Add(new Restaurant() { restname = restaurant.Name, food = restaurant.Food }); context.SaveChanges(); log.Info("Added restaurant: " + newRest.restid + ": " + newRest.restname); return(newRest.restid); } }
public int AddReview(Model.Review review) { using (var context = new RestaurantDBEntities()) { Review newRev = context.Reviews.Add(new Review() { revscore = review.Score, reviewer = review.Reviewer, comment = review.Comment, revsubject = review.Subject }); context.SaveChanges(); log.Info("Added review: " + newRev.revid); return(newRev.revid); } }
public bool UpdateRestaurant(Model.Restaurant r) { using (var context = new RestaurantDBEntities()) { var std = context.Restaurants.Find(r.Id); if (std == null) { log.Error("Update failed to locate restaurant: " + r.Id); return(false); } std.restname = r.Name; std.food = r.Food; context.SaveChanges(); log.Info("Updated restaurant " + r.Id); return(true); } }
public bool RemoveRestaurant(int id) { using (var context = new RestaurantDBEntities()) { var std = context.Restaurants.Find(id); context.Restaurants.Remove(std); context.SaveChanges(); if (std != null) { log.Info("Removed restaurant " + id); } else { log.Info("Failed to remove restaurant " + id); } return(std != null); } }
public bool UpdateReview(Model.Review rev) { using (var context = new RestaurantDBEntities()) { var std = context.Reviews.Find(rev.Id); if (std == null) { log.Error("Update failed to locate Review: " + rev.Id); return(false); } std.revscore = rev.Score; std.reviewer = rev.Reviewer; std.comment = rev.Comment; std.revsubject = rev.Subject; context.SaveChanges(); log.Info("Updated review " + rev.Id); return(true); } }