public static int GetRestaurantId(string RestaurantName) { RestaurantsDbEntities dbutilities = new RestaurantsDbEntities(); Restaurant restaurant = dbutilities.Restaurants.SingleOrDefault(x => x.name == RestaurantName); return(restaurant.id); }
public static List <Review> GetAllReviews(int RestaurantId) { RestaurantsDbEntities dbutilities = new RestaurantsDbEntities(); Restaurant restaurant = dbutilities.Restaurants.SingleOrDefault(x => x.id == RestaurantId); return(restaurant.Reviews.ToList()); }
public int AddReview(Review review) { RestaurantsDbEntities dbutilities = new RestaurantsDbEntities(); dbutilities.Reviews.Add(review); dbutilities.SaveChanges(); return(review.id); }
public int AddRestaurant(Restaurant r) { RestaurantsDbEntities dbutilities = new RestaurantsDbEntities(); dbutilities.Restaurants.Add(r); dbutilities.SaveChanges(); return(r.id); }
public void DeleteRestaurant(int id) { RestaurantsDbEntities dbutilities = new RestaurantsDbEntities(); Restaurant r = GetRestaurantModels().SingleOrDefault(x => x.id == id); dbutilities.Restaurants.Attach(r); dbutilities.Restaurants.Remove(r); dbutilities.SaveChanges(); }
public void DeleteReview(int ReviewId) { RestaurantsDbEntities dbutilities = new RestaurantsDbEntities(); Review review = GetReviewModels().SingleOrDefault(x => x.id == ReviewId); dbutilities.Reviews.Attach(review); dbutilities.Reviews.Remove(review); dbutilities.SaveChanges(); }
public void EditReview(Review r, int ReviewId) { RestaurantsDbEntities dbutilities = new RestaurantsDbEntities(); Review review = GetReviewModels().SingleOrDefault(x => x.id == ReviewId); review.reviewer = r.reviewer; review.rating = r.rating; review.comments = r.comments; dbutilities.Reviews.Attach(review); dbutilities.Entry(review).State = EntityState.Modified; dbutilities.SaveChanges(); }
public void EditRestaurant(Restaurant restaurant, int restaurantId) { RestaurantsDbEntities dbutilities = new RestaurantsDbEntities(); Restaurant rest = GetRestaurantModels().SingleOrDefault(x => x.id == restaurantId); rest.name = restaurant.name; rest.address = restaurant.address; dbutilities.Restaurants.Attach(rest); dbutilities.Entry(rest).State = EntityState.Modified; dbutilities.SaveChanges(); }
public void DeleteRestaurant(int id) { RestaurantsDbEntities dbutilities = new RestaurantsDbEntities(); try { Restaurant r = dbutilities.Restaurants.Find(id); dbutilities.Restaurants.Remove(r); dbutilities.SaveChanges(); } catch (Exception ex) { throw ex; } }
public static List <Restaurant> GetRestaurants() { RestaurantsDbEntities dbutilities = new RestaurantsDbEntities(); List <Restaurant> restaurantList = dbutilities.Restaurants.ToList(); foreach (var restaurant in restaurantList) { double total = 0; int number = 0; foreach (var review in restaurant.Reviews) { total += (double)review.rating; number++; } restaurant.AvgRating = total / number; } return(restaurantList); }
public List <Review> GetReviewModels(int restaurantId) { RestaurantsDbEntities dbutilities = new RestaurantsDbEntities(); return(dbutilities.Reviews.AsNoTracking().Where(e => e.id.Equals(restaurantId)).ToList()); }
public List <Review> GetReviewModels() { RestaurantsDbEntities dbutilities = new RestaurantsDbEntities(); return(dbutilities.Reviews.ToList()); }
public IEnumerable <Restaurant> GetRestaurantModels() { RestaurantsDbEntities dbutilities = new RestaurantsDbEntities(); return(dbutilities.Restaurants.ToList()); }