public static void EditRestaurant(int id, RestaurantModels.Restaurant restaurant)
{
var rest = db.Restaurants.ToList();
var select = rest.Find(x => x.ID.Equals(id));
if (restaurant.Name != null && restaurant.Name != "")
{
select.Name = restaurant.Name;
}
if (restaurant.City != null && restaurant.City != "")
{
select.City = restaurant.City;
}
if (restaurant.State != null && restaurant.State != "")
{
select.State = restaurant.State;
}
if (restaurant.FoodType != null & restaurant.FoodType != "")
{
select.FoodType = restaurant.FoodType;
}
if (restaurant.OperationHours != null && restaurant.OperationHours != "")
{
select.OperationHours = restaurant.OperationHours;
}
db.SaveChanges();
}
public static void AddNewRestaurnt(RestaurantModels.Restaurant restaurant)
{
//using (RReviewsEntities db = new RReviewsEntities())
{
db.Restaurants.Add(LibraryToData(restaurant));
db.SaveChanges();
}
}
public static void DeleteRestaurnt(RestaurantModels.Restaurant restaurant)
{
//using (RReviewsEntities db = new RReviewsEntities())
{
var rest = db.Restaurants.ToList();
db.Restaurants.Remove(rest.Find(x => x.ID.Equals(restaurant.ID)));
db.SaveChanges();
}
}
public static double GetAvgReview(RestaurantModels.Restaurant restaurant)
{
//using (RReviewsEntities db = new RReviewsEntities())
{
var reviews = db.Reviews.ToList();
var lreviews = reviews.FindAll((x => x.RestaurantID.Equals(restaurant.ID)));
return(Math.Round(lreviews.Select(x => x.ReviewerRating).Average(), 2));
}
}
public static RestaurantModels.Restaurant DataToLibraryRestaurant(Restaurant dataModel)
{
var libModel = new RestaurantModels.Restaurant(dataModel.Name, dataModel.City, dataModel.State)
{
ID = dataModel.ID,
FoodType = dataModel.FoodType,
OperationHours = dataModel.OperationHours,
Reviews = new List <RestaurantModels.Review>()
};
foreach (var item in dataModel.Reviews)
{
libModel.Reviews.Add(DataToLibraryReview(item));
}
return(libModel);
}
public static Restaurant LibraryToData(RestaurantModels.Restaurant libModel)
{
var dataModel = new Restaurant()
{
ID = libModel.ID,
Name = libModel.Name,
City = libModel.City,
State = libModel.State,
FoodType = libModel.FoodType,
OperationHours = libModel.OperationHours,
Reviews = new List <Review>()
};
foreach (var item in libModel.Reviews)
{
dataModel.Reviews.Add(LibraryToData(item));
}
return(dataModel);
}
public static double GetAvgReview(RestaurantModels.Restaurant restaurant)
{
return(RestaurantAccessData.GetAvgReview(restaurant));
}
public static void AddNewRestaurnt(RestaurantModels.Restaurant restaurant)
{
RestaurantAccessData.AddNewRestaurnt(restaurant);
}
public static void EditRestaurant(int id, RestaurantModels.Restaurant restaurant)
{
RestaurantAccessData.EditRestaurant(id, restaurant);
}
public static void DeleteRestaurant(RestaurantModels.Restaurant restaurant)
{
RestaurantAccessData.DeleteRestaurnt(restaurant);
}