public void CreateRestaurantCategory(RestaurantCategory res) { JustFeastDbDataContext db = new JustFeastDbDataContext(); db.ResCats.InsertOnSubmit(RestaurantCtrl.ConvertRestaurantCategoryToDatabase(res)); db.SubmitChanges(); }
public void DeleteRestaurant(ModelLibrary.Restaurant restaurant) { var db = new JustFeastDbDataContext(); db.Restaurants.DeleteOnSubmit(RestaurantCtrl.ConvertRestaurantToDatabase(restaurant)); db.SubmitChanges(); }
public ModelLibrary.Restaurant GetRestaurantWithMenu(int id) { var res = RestaurantCtrl.GetRestaurant(id); res.Menu = RestaurantCtrl.GetMenu(id); return(res); }
public void Controller_Will_Set_Created_Restaurant_As_Not_Verified() { // Setup //RestaurantCtrl ctrl = new RestaurantCtrl(); // Act var res = RestaurantCtrl.CreateRestaurant("Name", "Address", "*****@*****.**", "1234", "9000", null); // Assert Assert.IsTrue(!res.Verified); }
public IEnumerable <RestaurantCategory> GetAllRestaurantCategories() { JustFeastDbDataContext db = new JustFeastDbDataContext(); var cats = db.ResCats.ToList(); List <RestaurantCategory> mRes = new List <RestaurantCategory>(); foreach (var x in cats) { mRes.Add(RestaurantCtrl.ConvertRestaurantCategoryToModel(x)); } return(mRes); }
public void CreateRestaurant(ModelLibrary.Restaurant restaurant) { JustFeastDbDataContext db = new JustFeastDbDataContext(); var res = RestaurantCtrl.ConvertRestaurantToDatabase(restaurant); if (restaurant.Category != null) { res.ResCat = db.ResCats.FirstOrDefault(x => x.id == restaurant.Category.Id); } db.Restaurants.InsertOnSubmit(res); db.SubmitChanges(); }
public IEnumerable <ModelLibrary.Restaurant> GetAllRestaurantsByZipCode(int zipcode) { JustFeastDbDataContext db = new JustFeastDbDataContext(); var res = db.Restaurants.Where(x => x.zipcode == zipcode).ToList(); List <ModelLibrary.Restaurant> mRes = new List <ModelLibrary.Restaurant>(); foreach (var x in res) { mRes.Add(RestaurantCtrl.ConvertRestaurantToModel(x)); } return(mRes); }
public IEnumerable <ModelLibrary.Restaurant> GetAllRestaurantsByCategory(int categoryId) { JustFeastDbDataContext db = new JustFeastDbDataContext(); var res = db.Restaurants.Where(x => x.resCatId == categoryId).ToList(); List <ModelLibrary.Restaurant> mRes = new List <ModelLibrary.Restaurant>(); foreach (var x in res) { mRes.Add(RestaurantCtrl.ConvertRestaurantToModel(x)); } return(mRes); }
public IEnumerable <ModelLibrary.Restaurant> GetAllRestaurants() { JustFeastDbDataContext db = new JustFeastDbDataContext(); var res = db.Restaurants.ToList(); List <ModelLibrary.Restaurant> mRes = new List <ModelLibrary.Restaurant>(); foreach (var x in res) { mRes.Add(RestaurantCtrl.ConvertRestaurantToModel(x)); } return(mRes); }
public void UpdateRestaurant(ModelLibrary.Restaurant restaurant) { var db = new JustFeastDbDataContext(); var res = db.Restaurants.FirstOrDefault(x => x.id == restaurant.Id); var mRes = RestaurantCtrl.ConvertRestaurantToDatabase(restaurant); res.name = mRes.name; res.phoneNo = mRes.phoneNo; res.verified = mRes.verified; res.zipcode = mRes.zipcode; res.address = mRes.address; res.discontinued = mRes.discontinued; res.email = mRes.email; res.resCatId = mRes.resCatId; db.SubmitChanges(); }
public List <ModelLibrary.Restaurant> GetRestaurantsPaged(int zipcode = 0, int categoryId = 0, int page = 0, int amount = 10, bool verified = true, bool discontinued = false) { return(RestaurantCtrl.GetRestaurantsPaged(zipcode, categoryId, page, amount, verified, discontinued)); }
public RestaurantCategory GetRestaurantCategory(int id) { JustFeastDbDataContext db = new JustFeastDbDataContext(); return(RestaurantCtrl.ConvertRestaurantCategoryToModel(db.ResCats.FirstOrDefault(x => x.id == id))); }
public ModelLibrary.Restaurant GetRestaurant(int id) { return(RestaurantCtrl.GetRestaurant(id)); }