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