public IEnumerable <Restaurant> ShowRestaurantsByName(string name)
{
using (var db = new RestaurantsDBEntities())
{
return((IEnumerable <Restaurant>)db.Restaurants.Where(b => b.name.Contains(name)).ToList());
}
}
public Restaurant ShowRestaurantById(int id)
{
using (var db = new RestaurantsDBEntities())
{
return(DataToLibrary(db.Restaurants.Where(x => x.ID == id).ToList()[0]));
}
}
public void AddRestaurant(Restaurant item)
{
using (var db = new RestaurantsDBEntities())
{
db.Restaurants.Add(LibraryToData(item));
db.SaveChanges();
}
}
public void RemoveRestaurant(int id)
{
using (var db = new RestaurantsDBEntities())
{
var tempRestaurant = db.Restaurants.Where(x => x.ID == id).ToList()[0];
db.Restaurants.Remove(tempRestaurant);
db.SaveChanges();
}
}
public double ShowAverageRating(int restId)
{
using (var db = new RestaurantsDBEntities())
{
double RatingAverage = db.Reviews.Where(r => r.RestaurantId == restId).Average(r => r.rating);
var temp = db.Restaurants.Where(x => x.ID == restId).First();
temp.avgRating = RatingAverage;
db.SaveChanges();
return(RatingAverage);
}
}
public IEnumerable <Review> GetReviews()
//public Restaurant GetRestaurants()
{
IEnumerable <Review> result;
using (var db = new RestaurantsDBEntities())
{
var dataList = db.Reviews.ToList();
result = dataList.Select(x => DataToLibraryReview(x)).ToList();
}
return(result);
}
public IEnumerable <Review> GetRestaurantReviews(int restId)
{
IEnumerable <Review> result;
using (var db = new RestaurantsDBEntities())
{
var dataList = db.Reviews.Where(r => r.RestaurantId == restId).ToList();
result = dataList.Select(x => DataToLibraryReview(x)).ToList();
}
return(result);
//IEnumerable<Restaurant> result;
//var db = new RestaurantsDBEntities();
//var temp = db.Reviews.Where(r => r.RestaurantId == restId).ToList();
//return LibraryToDataReview(temp);
}
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 <Restaurant> ShowTopThree()
{
using (var db = new RestaurantsDBEntities())
{
var dataList = db.Restaurants.ToList();
var topThree = (IEnumerable <Restaurant>)dataList.Select(x => DataToLibrary(x)).ToList();
topThree.OrderByDescending(x => x.avgRating);
int numItems = topThree.Count();
var returnThree = new List <Restaurant>();
returnThree.Add((topThree.ToList()[numItems - 1]));
returnThree.Add((topThree.ToList()[numItems - 2]));
returnThree.Add((topThree.ToList()[numItems - 3]));
//var temp = DataToLibrary(topThree.ToList()[numItems - 1]);
//dataList.Add((IEnumerable<Restaurant>)(topThree.ToList()[numItems-1]));
return(returnThree);
}
}
public void UpdateRestaurant(Restaurant item)
{
using (var db = new RestaurantsDBEntities())
{
Restaurant restaurant = new Restaurant();
var temp = db.Restaurants.Find(item.ID);
restaurant.ID = temp.ID;
restaurant.name = temp.name;
restaurant.address = temp.address;
restaurant.city = temp.city;
restaurant.state = temp.state;
restaurant.zipCode = temp.zipCode;
restaurant.phoneNumber = temp.phoneNumber;
restaurant.avgRating = temp.avgRating;
db.Restaurants.Add(LibraryToData(restaurant));
db.SaveChanges();
}
}
public double UpdateAverageRating(int restId)
{
using (var db = new RestaurantsDBEntities())
{
double RatingAverage = db.Reviews.Where(r => r.RestaurantId == restId).Average(r => (double?)r.rating) ?? 0;
var temp = db.Restaurants.Where(x => x.ID == restId).First();
temp.avgRating = RatingAverage;
db.SaveChanges();
return(RatingAverage);
}
//double cafeSales = db.InvoiceLines
// .Where(x =>
// x.UserId == user.UserId &&
// x.DateCharged >= dateStart &&
// x.DateCharged <= dateEnd)
// .Sum(x => (double?)(x.Quantity * x.Price)) ?? 0;
}
public BaseRepository()
{
Context = new RestaurantsDBEntities();
}
