public void deleteMenu(FoodMenu menu) { using (IDbConnection connection = new System.Data.SqlClient.SqlConnection(Helper.CnnVal("MenuManagerDB"))) { connection.Execute("dbo.spFoodMenu_Delete @FoodMenuId", menu); } }
public void insertMenu(FoodMenu menu) { using (IDbConnection connection = new System.Data.SqlClient.SqlConnection(Helper.CnnVal("MenuManagerDB"))) { connection.Execute("dbo.spFoodMenu_Insert @Name", menu); } }
public void insertMenuCategory(FoodMenu foodMenu, Category category) { using (IDbConnection connection = new System.Data.SqlClient.SqlConnection(Helper.CnnVal("MenuManagerDB"))) { connection.Execute($"INSERT INTO dbo.MenuCategories VALUES ({foodMenu.FoodMenuId}, {category.CategoryId})"); } }
public static void AddDish(MenuManager menuManager, FoodMenu menu, Dish dish) { if (menu.Categories[0].ListOfDishes.Contains(dish) == false) { menu.Categories[0].ListOfDishes.Add(dish); } if (menuManager.AllDishes.Contains(dish) == false) { menuManager.AllDishes.Add(dish); } }
public List <Category> GetCategoriesBasedOnMenuId(FoodMenu menu) { using (IDbConnection connection = new System.Data.SqlClient.SqlConnection(Helper.CnnVal("MenuManagerDB"))) { List <Category> output = new List <Category>(); var categoryIds = connection.Query <int>("SELECT CategoryId FROM MenuCategories WHERE FoodMenuId = @FoodMenuId", menu).ToList(); foreach (int id in categoryIds) { output.AddRange(connection.Query <Category>($"SELECT * FROM dbo.Category WHERE CategoryId = {id}").ToList()); } return(output); } }
public bool menuExists(FoodMenu menu) { using (IDbConnection connection = new System.Data.SqlClient.SqlConnection(Helper.CnnVal("MenuManagerDB"))) { var menus = connection.Query <FoodMenu>("SELECT * FROM dbo.FoodMenu WHERE Name = @Name", menu).ToList(); if (menus.Count == 0) { return(false); } else { return(true); } } }
//public static BindableCollection<Category> UpdateBindableCollectionCategory(List<Category> list) //{ // BindableCollection<Category> output = new BindableCollection<Category>(list); // return output; //} public static List <Dish> UpdateMenuDishList(FoodMenu menu) { List <Dish> output = new List <Dish>(); foreach (Category category in menu.Categories) { foreach (Dish dish in category.ListOfDishes) { if (output.Contains(dish) == false) { output.Add(dish); } } } return(output); }
public static void UpdateAllCategories(FoodMenu menu, BindableCollection <Category> categoriesBinded) { menu.Categories.Clear(); menu.Categories.AddRange(new List <Category>(categoriesBinded)); }