public void Add(RestaurantReview entity)
{
using (var db = new RestaurantGuideDb())
{
db.RestaurantReviews.Add(entity);
db.SaveChanges();
}
}
public void Update(RestaurantReview entity)
{
using (var db = new RestaurantGuideDb())
{
db.Entry(entity).State = EntityState.Modified;
db.SaveChanges();
}
}
public void Delete(int id)
{
using (var db = new RestaurantGuideDb())
{
var review = db.RestaurantReviews.Find(id);
db.RestaurantReviews.Remove(review);
db.SaveChanges();
}
}
public RestaurantReview Get(int id)
{
using (var db = new RestaurantGuideDb())
{
var review = db.RestaurantReviews.Find(id);
return(review);
}
}
public IEnumerable <RestaurantReview> GetAll(string filter = null)
{
using (var db = new RestaurantGuideDb())
{
var reviews = db.RestaurantReviews.ToList();
return(reviews);
}
}
public IEnumerable <RestaurantReview> GetReviewsByRestaurant(int restaurantId)
{
using (var db = new RestaurantGuideDb())
{
var reviews = db.RestaurantReviews
.Where(r => r.RestaurantId == restaurantId)
.ToList();
return(reviews);
}
}
public Restaurant GetBestRestaurant()
{
using (var context = new RestaurantGuideDb())
{
var restaurant = context.Restaurants
.OrderByDescending(r => r.Reviews.Average(review => review.Rating))
.FirstOrDefault();
return(restaurant);
}
}
public Restaurant Get(int id)
{
using (var db = new RestaurantGuideDb())
{
var restaurant = db.Restaurants
.Include(r => r.Reviews)
.FirstOrDefault(r => r.Id == id);
return(restaurant);
}
}
public IEnumerable <Restaurant> GetTopRestaurants()
{
using (var db = new RestaurantGuideDb())
{
var restaurants = db.Restaurants
.AsNoTracking()
.Include(r => r.Reviews)
.OrderByDescending(r => r.Reviews.Average(review => review.Rating))
.Take(10)
.ToList();
return(restaurants);
}
}
public IEnumerable <Restaurant> GetAll(string filter = null)
{
using (var db = new RestaurantGuideDb())
{
var restaurants = db.Restaurants
.AsNoTracking()
.Include(r => r.Reviews)
.Where(r => string.IsNullOrEmpty(filter) || r.Name.ToLower().Contains(filter.ToLower()))
.OrderBy(r => r.Name)
.ToList();
return(restaurants);
}
}
