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