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;
}
}