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