private void MainWindow_Loaded(object sender, RoutedEventArgs e)
{
db = new ModelCezar();
OrderList oList = new OrderList();
lv_OrdersList.ItemsSource = oList.GetNotPayedOrderList();
}
public CUItem(ItemModel itemModel, int source) // For update
{
InitializeComponent();
IDSource = source;
db = new ModelCezar();
// Initialisation des erreurs
itemModelLocal = itemModel;
_noOfErrorsOnScreen = 0;
this.Loaded += new RoutedEventHandler(CUItem_Loaded);
_errors = new Errors();
gridForms.DataContext = _errors;
}
public CUMenu()
{
InitializeComponent();
db = new ModelCezar();
_errors = new Errors();
_noOfErrorsOnScreen = 0;
gridMenuCrud.DataContext = _errors;
lv_items.ItemsSource = db.ITEM.ToList();
lv_options.ItemsSource = db.OPTION_CHOIX_MENU.ToList();
}
// Cette méthode est appelée lorsque l'utilisateur souhaite ajouter un article dans le panier
public ItemOption(ITEM item, List <CATEGORY_INGREDIENT> catIng)
{
InitializeComponent();
db = new ModelCezar();
cvm.IngredientCounter = 0;
/*
* catIng : la liste des catégories d'ingrédients liées à l'article
* item : l'article selectionné
* catIngLocalCount : le nombre total des catégories d'ingrédients liées à l'article
* counter : compteur
*/
itemLocal = item;
catIngLocal = catIng;
catIngLocalCount = catIng.Count;
counter = 0;
if (catIng.Count <= 1)
{
bt_NextOption.Visibility = Visibility.Collapsed;
}
bt_BackOption.Visibility = Visibility.Collapsed;
CATEGORY_INGREDIENT ci = new CATEGORY_INGREDIENT();
ci = catIng[counter];
int id = catIng[counter].id_category_ingredient;
//.Where(i => i.id_category_ingredient == id)
var optionQuery = (from ing in db.INGREDIENT
join ingCat in db.CATEGORY_INGREDIENT on ing.id_category_ingredient equals ingCat.id_category_ingredient
select new ItemIngredient()
{
IdItem = item.id_item,
IdIngredient = ing.id_ingredient,
Item_title = item.item_title,
Ingredient_title = ing.ingredient_title,
Ingredient_category_id = ingCat.id_category_ingredient,
Ingredient_category_tutle = ingCat.category_ingredient_title,
Ingredient_price = (double)ing.ingredient_price,
Ingredient_quantity = 0
});
listIngredient = new ObservableCollection <ItemIngredient>(optionQuery.ToList());
//Affiche la première liste des ingrédients
icItem.ItemsSource = listIngredient.Where(i => i.Ingredient_category_id == id);
}
private void PosLoaded(object sender, RoutedEventArgs e)
{
if (Network.BddConnection())
{
try
{
db = new ModelCezar();
cvm = new CartViewModel();
cvm.TotalPrice = 0.00;
cvm.TotalRestPrice = 0.00;
cvm.TotalPayed = 0.00;
listCategories.Clear();
lv_cartItems.ItemsSource = cartList;
lb_payement.ItemsSource = listPayement;
var categoryQuery = db.CATEGORY.ToList();
foreach (CATEGORY cat in categoryQuery)
{
listCategories.Add(new CATEGORY
{
id_category = cat.id_category,
category_title = cat.category_title,
category_description = cat.category_description,
category_button_color = cat.category_button_color
});
}
icCat.ItemsSource = listCategories;
}
catch (Exception ex)
{
DialogHost.Show(new Message()
{
message_tb = { Text = "Problème réseau " + ex.Message }
}, "RootDialog");
}
}
else
{
DialogHost.Show(new Message()
{
message_tb = { Text = "Connexion imossible" }
}, "RootDialog");
}
}
public ObservableCollection <ItemsCategoryModel> GetItemsOptionsByItem(int id)
{
if (BddOk)
{
db = new ModelCezar();
var itemOptionQuery = (from itm in db.ITEM.Where(c => c.CATEGORY_INGREDIENT.Any() && c.id_item == id)
from cIng in db.CATEGORY_INGREDIENT.Where(ci => ci.ITEM.Contains(itm))
select new ItemsCategoryModel()
{
Id = cIng.id_category_ingredient,
Title = cIng.category_ingredient_title
});
return(new ObservableCollection <ItemsCategoryModel>(itemOptionQuery.ToList()));
}
else
{
return(null);
}
}
internal IEnumerable GetMenuOptions()
{
if (BddOk)
{
using (ModelCezar db = new ModelCezar())
{
var menuOptionQuery = db.OPTION_CHOIX_MENU.Select(c => new MenuOptions
{
Id = c.id_option_choix_menu,
Title = c.option_choix_menu_title
});
return(new ObservableCollection <MenuOptions>(menuOptionQuery.ToList()));
}
}
else
{
return(null);
}
}
internal IEnumerable GetAllMenu()
{
if (BddOk)
{
using (ModelCezar db = new ModelCezar())
{
var menuQuery = db.MENU.Select(c => new MenuModel
{
Id = c.id_menu,
Title = c.menu_title
});
return(new ObservableCollection <MenuModel>(menuQuery.ToList()));
}
}
else
{
return(null);
}
}
// Get all ingredient categories
public ObservableCollection <ItemsCategoryModel> GetAllIngredientCat()
{
if (BddOk)
{
db = new ModelCezar();
var allIngredientQuery =
(from cIng in db.CATEGORY_INGREDIENT
select new ItemsCategoryModel()
{
Id = cIng.id_category_ingredient,
Title = cIng.category_ingredient_title
});
return(new ObservableCollection <ItemsCategoryModel>(allIngredientQuery.ToList()));
}
else
{
return(null);
}
}
public ObservableCollection <CategoryModel> GetAllCategory()
{
if (BddOk)
{
using (ModelCezar db = new ModelCezar())
{
var categoryQuery = db.CATEGORY.Select(c => new CategoryModel
{
Id = c.id_category,
Title = c.category_title
});
return(new ObservableCollection <CategoryModel>(categoryQuery.ToList()));
}
}
else
{
return(null);
}
// db = new ModelCezar();
}
internal IEnumerable GetMenuItemsOptions(int id)
{
if (BddOk)
{
db = new ModelCezar();
var itemMenuItemsOptionsQuery = (from menu in db.ITEM_OPTION_MENU.Where(c => c.id_option_choix_menu == id)
from itm in db.ITEM.Where(ci => ci.id_item == menu.id_item)
select new ItemsCategoryModel()
{
Id = itm.id_item,
Title = itm.item_title
});
return(new ObservableCollection <ItemsCategoryModel>(itemMenuItemsOptionsQuery.ToList()));
}
else
{
return(null);
}
}
internal IEnumerable GetMenuSelectedOptions(int id)
{
if (BddOk)
{
db = new ModelCezar();
var itemMenuSelectedOptionQuery = (from menu in db.MENU.Where(c => c.OPTION_CHOIX_MENU.Any() && c.id_menu == id)
from ocm in db.OPTION_CHOIX_MENU.Where(ci => ci.MENU.Contains(menu))
select new ItemsCategoryModel()
{
Id = ocm.id_option_choix_menu,
Title = ocm.option_choix_menu_title
});
return(new ObservableCollection <ItemsCategoryModel>(itemMenuSelectedOptionQuery.ToList()));
}
else
{
return(null);
}
}
public ObservableCollection <IngredientModel> GetIngredientByCat(int id)
{
if (BddOk)
{
db = new ModelCezar();
var IngredientByCatQuery = (from ing in db.INGREDIENT
where ing.id_category_ingredient == id
select new IngredientModel()
{
Id = ing.id_ingredient,
Title = ing.ingredient_title
});
return(new ObservableCollection <IngredientModel>(IngredientByCatQuery.ToList()));
}
else
{
return(null);
}
}
private void OnClickAffect(object sender, RoutedEventArgs e)
{
int count = 0;
// var idCat = ((ItemsCategoryModel)lv_ingredientCategoryList.SelectedItem).Id;
var idCatList = (lv_ingredientCategoryList.SelectedItems);
count = idCatList.Count;
using (var db = new ModelCezar())
{
try
{
ITEM item = new ITEM {
id_item = IdItem
};
db.ITEM.Add(item);
db.ITEM.Attach(item);
for (int i = 0; i < count; i++)
{
var result = (ItemsCategoryModel)idCatList[i];
CATEGORY_INGREDIENT catIng = new CATEGORY_INGREDIENT {
id_category_ingredient = result.Id
};
db.CATEGORY_INGREDIENT.Add(catIng);
db.CATEGORY_INGREDIENT.Attach(catIng);
item.CATEGORY_INGREDIENT.Add(catIng);
db.SaveChanges();
rvm.Result = true;
rvm.Resultmessage = "Validé";
}
}
catch (Exception ex)
{
rvm.Resultmessage = "Erreur " + ex.InnerException;
rvm.Result = false;
}
}
}
public ObservableCollection <ItemModel> GetItemsByCat(int id)
{
if (BddOk)
{
db = new ModelCezar();
var itemQuery = db.ITEM.Where(i => i.id_category == id).Select(i => new ItemModel
{
Id = i.id_item,
Title = i.item_title,
Price = (double)i.item_price,
Actif = i.actif,
Color = i.item_button_color,
Cooked = i.cooked,
Status = i.actif ? "Actif" : "Inactif",
StatusColor = i.actif ? "#2ecc71" : "#e74c3c"
});
return(new ObservableCollection <ItemModel>(itemQuery.ToList()));
}
else
{
return(null);
}
}
//Constructeur paramétré, id est l'id de la catégorie et le title est le bom de la catégorie
public CUItem(int idCat, string titleCat, int source)
{
// source : 1 = Produit, 2 = Ingrédient
InitializeComponent();
db = new ModelCezar();
// Initialisation des erreurs
_errors = new Errors();
_noOfErrorsOnScreen = 0;
gridForms.DataContext = _errors;
// Recuperer l'id de la catégorie dans une variable globale
IDCat = idCat;
TitleCat = titleCat;
IDSource = source;
//Publication de la collection dans la vue
tb_messageItem.Visibility = Visibility.Visible;
tb_messageItem.Text = "Ajouter " + TitleCat;
if (source == 1)
{
icColorsPalette.ItemsSource = GetPalette();
}
}
// Suppression d'une option
private void OnClickDeleteOption(object sender, RoutedEventArgs e)
{
try
{
mg = new ManagementModel();
ModelCezar db = new ModelCezar();
var itm = (ItemModel)lv_items.SelectedItem;
var selectedOption = (ItemsCategoryModel)((ListViewItem)lv_itemsOptions.ContainerFromElement((Button)sender)).Content;
var item = db.ITEM.FirstOrDefault(it => it.id_item == idItem);
var categoryIngredient = db.CATEGORY_INGREDIENT.FirstOrDefault(c => c.id_category_ingredient == selectedOption.Id);
item.CATEGORY_INGREDIENT.Remove(categoryIngredient);
db.SaveChanges();
lv_itemsOptions.ItemsSource = mg.GetItemsOptionsByItem(itm.Id);
}
catch (Exception ex)
{
DialogHost.Show(new Message()
{
message_tb = { Text = "Suppression impossible" }
}, "RootDialog");
}
}
public OrderList()
{
db = new ModelCezar();
orderList = new ObservableCollection <Cart>();
}
public ObservableCollection <Cart> GetOrderDetail(int id)
{
if (BddOk)
{
using (ModelCezar db = new ModelCezar())
{
//var orderDetailQuery = (from itmSel in db.item_selection
// join itm in db.ITEM on itmSel.id_item equals itm.id_item
// join ing in db.INGREDIENT on itmSel.id_ingredient equals ing.id_ingredient
// where itmSel.id_orders == id
// select new Cart()
// {
// ItemId = itm.id_item,
// ItemTitle = itm.item_title,
// ItemQuantity = (int)(itm.item_quantity == null ? 1 : itm.item_quantity)
// });
ObservableCollection <ItemIngredient> ingredients = new ObservableCollection <ItemIngredient>();
ObservableCollection <Cart> cart = new ObservableCollection <Cart>();
ItemIngredient itg = new ItemIngredient();
List <int> idItem = new List <int>();
//var res = (from selection in db.item_selection where selection.id_orders == id select selection).ToList();
var res = (
from itmSel in db.item_selection
join itm in db.ITEM on itmSel.id_item equals itm.id_item
join ing in db.INGREDIENT on itmSel.id_ingredient equals ing.id_ingredient into ingredient
from x in ingredient.DefaultIfEmpty()
where itmSel.id_orders == id
select new
{
itmSel
}).ToList();
var test = res;
foreach (var var in res.GroupBy(x => x.itmSel.ITEM.id_item).Select(s => s.First()).ToList())
{
var ingred = test.Where(z => z.itmSel.id_item == var.itmSel.id_item).ToList();
if (ingred != null)
{
foreach (var i in ingred)
{
if (i.itmSel.INGREDIENT != null)
{
ingredients.Add(new ItemIngredient()
{
IdIngredient = i.itmSel.INGREDIENT.id_ingredient,
Ingredient_title = i.itmSel.INGREDIENT.ingredient_title
});
}
}
cart.Add(new Cart()
{
ItemId = var.itmSel.id_item,
ItemTitle = var.itmSel.ITEM.item_title,
ItemQuantity = (int)(var.itmSel.item_selection_quantity == null ? 1 : var.itmSel.item_selection_quantity),
SelectedIngredients = ingredients
});
}
else
{
cart.Add(new Cart()
{
ItemId = var.itmSel.id_item,
ItemTitle = var.itmSel.ITEM.item_title,
ItemQuantity = (int)(var.itmSel.item_selection_quantity == null ? 1 : var.itmSel.item_selection_quantity),
});
}
ingredients = new ObservableCollection <ItemIngredient>();
}
//var result = (from order in db.ORDERS
// from itmSel in order.item_selection
// join itm in db.ITEM on itmSel.id_item equals itm.id_item
// join ing in db.INGREDIENT.DefaultIfEmpty() on itmSel.id_ingredient equals ing.id_ingredient
// where order.id_orders == id
// select new
// {
// itmSel
// }).ToList();
//var orderDetailQuery = (from itmSel in db.item_selection
// join order in db.ORDERS on itmSel.id_orders equals order.id_orders
// join itm in db.ITEM on itmSel.id_item equals itm.id_item
// join ing in db.INGREDIENT.DefaultIfEmpty() on itmSel.id_ingredient equals ing.id_ingredient
// where order.id_orders == id
// select new
// {
// itmSel
// })
// .ToList();
//foreach (var item in result)
//{
// //GroupBy(x => x.itmSel.ITEM.id_item).Select(s => s.First()).ToList()
// if (item.itmSel.INGREDIENT.id_ingredient > 0)
// {
// ingredients.Add(new ItemIngredient()
// {
// IdIngredient = item.itmSel.INGREDIENT.id_ingredient,
// Ingredient_title = item.itmSel.INGREDIENT.ingredient_title
// });
// cart.Add(new Cart()
// {
// ItemId = item.itmSel.ITEM.id_item,
// ItemTitle = item.itmSel.ITEM.item_title,
// SelectedIngredients = ingredients
// });
// }
// else
// {
// cart.Add(new Cart()
// {
// ItemId = item.itmSel.ITEM.id_item,
// ItemTitle = item.itmSel.ITEM.item_title,
// });
// }
//}
return(cart);
}
}
else
{
return(null);
}
}
// Cette méthode est appelée lorsque l'utilisateur veut modifier un article ajouter dans le panier
public ItemOption(Cart list, int idItem, int index, List <CATEGORY_INGREDIENT> catIng, ObservableCollection <ItemIngredient> ingredients)
{
InitializeComponent();
counter = 0;
if (index > -1)
{
indexLocal = index;
db = new ModelCezar();
_cart = list;
lst = list.SelectedIngredients;
if (catIng.Count <= 1)
{
bt_NextOption.Visibility = Visibility.Collapsed;
}
bt_BackOption.Visibility = Visibility.Collapsed;
itemLocal.id_item = list.ItemId;
itemLocal.item_price = (decimal)list.ItemPriceWithoutSupp;
itemLocal.item_title = list.ItemTitle;
itemLocal.cooked = list.Cooked;
catIngLocalCount = catIng.Count;
catIngLocal = catIng;
CATEGORY_INGREDIENT ci = new CATEGORY_INGREDIENT();
ci = catIng[counter];
int id = catIng[counter].id_category_ingredient;
var optionQuery = (from ing in db.INGREDIENT
join ingCat in db.CATEGORY_INGREDIENT on ing.id_category_ingredient equals ingCat.id_category_ingredient
select new ItemIngredient()
{
IdItem = idItem,
IdIngredient = ing.id_ingredient,
Ingredient_category_tutle = ingCat.category_ingredient_title,
Item_title = list.ItemTitle,
Ingredient_category_id = ingCat.id_category_ingredient,
Ingredient_title = ing.ingredient_title,
Ingredient_price = (double)ing.ingredient_price,
Ingredient_quantity = 0
});
listIngredient = new ObservableCollection <ItemIngredient>(optionQuery.ToList());
icItem.ItemsSource = listIngredient.Where(i => i.Ingredient_category_id == id);
ItemIngredient ingrr = new ItemIngredient();
for (int i = 0; i < listIngredient.Count; i++)
{
ingrr = listIngredient[i] as ItemIngredient;
foreach (var itm in ingredients)
{
if (ingrr.IdIngredient == itm.IdIngredient)
{
itemIngredientLocal.Add(new ItemIngredient()
{
IdItem = itm.IdItem,
IdIngredient = itm.IdIngredient,
Item_title = itm.Item_title,
Ingredient_title = itm.Ingredient_title,
Ingredient_price = itm.Ingredient_category_id == 3 ? ingrr.Ingredient_price : 0,
Ingredient_quantity = itm.Ingredient_quantity
});
ingrr.Ingredient_quantity = itm.Ingredient_quantity;
break;
}
}
}
#region COMMENT
//var reqForMeat = (from ing in db.INGREDIENT.Where(i => i.ITEM.Any() && i.id_category_ingredient == 1)
// from itm in db.ITEM.Where(it => it.INGREDIENT.Contains(ing) && it.id_item == idItem)
// select new ItemIngredient()
// {
// IdItem = itm.id_item,
// IdIngredient = ing.id_ingredient,
// Item_title = itm.item_title,
// Ingredient_title = ing.ingredient_title,
// Ingredient_quantity = 0
// });
// var reqForMeat = (from ing in db.INGREDIENT.Where(i => i.ITEM.Any() && i.id_category_ingredient == 1)
// from itm in db.ITEM.Where(it => it.INGREDIENT.Contains(ing) && it.id_item == idItem)
// select new ItemIngredient()
// {
// IdItem = itm.id_item,
// IdIngredient = ing.id_ingredient,
// Item_title = itm.item_title,
// Ingredient_title = ing.ingredient_title,
// Ingredient_quantity = 0
// }
//);
// tb_optionTitle.Text = "Options " + itemLocal.item_title;
// var reqForSauce = (from ing in db.INGREDIENT.Where(i => i.ITEM.Any() && i.id_category_ingredient == 2)
// from itm in db.ITEM.Where(it => it.INGREDIENT.Contains(ing) && it.id_item == idItem)
// select new ItemIngredient()
// {
// IdItem = itm.id_item,
// IdIngredient = ing.id_ingredient,
// Item_title = itm.item_title,
// Ingredient_title = ing.ingredient_title,
// Ingredient_quantity = 0
// }
//);
// var reqForSupp = (from ing in db.INGREDIENT.Where(i => i.ITEM.Any() && i.id_category_ingredient == 3)
// from itm in db.ITEM.Where(it => it.INGREDIENT.Contains(ing) && it.id_item == idItem)
// select new ItemIngredient()
// {
// IdItem = itm.id_item,
// IdIngredient = ing.id_ingredient,
// Item_title = itm.item_title,
// Ingredient_title = ing.ingredient_title,
// Ingredient_price = (double)ing.ingredient_price,
// Ingredient_quantity = 0
// }
//);
// lb_choixViande.ItemsSource = new ObservableCollection<ItemIngredient>(reqForMeat.ToList());
// lb_choixSauce.ItemsSource = new ObservableCollection<ItemIngredient>(reqForSauce.ToList());
// lb_choixSupp.ItemsSource = new ObservableCollection<ItemIngredient>(reqForSupp.ToList());
#endregion
}
// lb_choixViande.SelectedIndex = lb_choixViande.Items.IndexOf(lst[0].Ingredient_title)
}
public AddMenuOption()
{
InitializeComponent();
db = new ModelCezar();
lv_items.ItemsSource = db.ITEM.ToList();
}
public CUCat(int source)
{
InitializeComponent();
db = new ModelCezar();
IDSource = source;
}
