public IEnumerable <Restaurant> FindRestByName(string restName)
{
var db = new RestaurantsDBEntities();
var rest = db.Restaurants.Where(b => b.name.Contains(restName));
return(rest);
}
public Restaurant FindRestById(int id)
{
using (var db = new RestaurantsDBEntities())
{
return(db.Restaurants.Where(x => x.ID == id).ToList()[0]);
}
}
public IEnumerable <Restaurant> ShowRestaurants()
{
using (var db = new RestaurantsDBEntities())
{
return(db.Restaurants.ToList());
}
}
public double ShowAverageRating(int restId)
{
using (var db = new RestaurantsDBEntities())
{
double RatingAverage = db.Reviews.Where(r => r.RestaurantId == restId).Average(r => r.rating);
// INCORRECT: should update restaurant.avgRating
return(RatingAverage);
}
}
static public string SerializeToJSON()
{
var db = new RestaurantsDBEntities();
db.Configuration.LazyLoadingEnabled = false;
db.Configuration.ProxyCreationEnabled = false;
string json = JsonConvert.SerializeObject(db.Restaurants.ToList(), Formatting.Indented,
new JsonSerializerSettings()
{
ReferenceLoopHandling = Newtonsoft.Json.ReferenceLoopHandling.Ignore
});
return(json);
}
static public void JSONToDeserialize(string fp)
{
var db = new RestaurantsDBEntities();
// deserialize JSON directly from a file
using (StreamReader file = File.OpenText(fp))
{
string temp = file.ReadToEnd();
JsonSerializer serializer = new JsonSerializer();
List <Restaurant> rest = JsonConvert.DeserializeObject <List <Restaurant> >(temp);
foreach (var item in rest)
{
Console.WriteLine();
}
}
}
public IEnumerable <Review> ShowRestaurantReviews(int restId)
{
var db = new RestaurantsDBEntities();
return(db.Reviews.Where(r => r.RestaurantId == restId));
}
