/// <summary> /// Suppression del'article /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void OnClickDeleteItem(object sender, RoutedEventArgs e) { // the sender is a button try { var item = (ItemModel)((ListViewItem)lv_items.ContainerFromElement((Button)sender)).Content; var it = db.ITEM.FirstOrDefault(i => i.id_item == item.Id); db.ITEM.Remove(it); db.SaveChanges(); try { var liste = (CategoryModel)lv_itemsCategory.SelectedItem; if (liste != null) { lv_items.ItemsSource = mg.GetItemsByCat(liste.Id); } } catch { } } catch (Exception ex) { DialogHost.Show(new Message() { message_tb = { Text = "Supression impossible, vérifiez les affectations" } }, "RootDialog"); } }
private void OnCLickAddNewCat(object sender, RoutedEventArgs e) { try { if (IDSource == 2) { CATEGORY_INGREDIENT ci = new CATEGORY_INGREDIENT(); if (!string.IsNullOrEmpty(tb_nameCat.Text)) { ci.category_ingredient_title = tb_nameCat.Text.ToString(); db.CATEGORY_INGREDIENT.Add(ci); db.SaveChanges(); } } if (IDSource == 1) { CATEGORY c = new CATEGORY(); if (!string.IsNullOrEmpty(tb_nameCat.Text)) { c.category_title = tb_nameCat.Text.ToString(); c.category_description = ""; c.category_button_color = "#9b59b6"; db.CATEGORY.Add(c); db.SaveChanges(); } } } catch (Exception ex) { } }
private void OnCLickAddNewItem(object sender, RoutedEventArgs e) { if (lv_items.SelectedItem != null) { ITEM item = lv_items.SelectedItem as ITEM; MENU menu = new MENU(); menu.menu_title = tb_MenuName.Text; menu.menu_price = Decimal.Parse(tb_MenuPrice.Text); menu.actif = true; menu.id_item = item.id_item; var idOptionChoixMenu = lv_options.SelectedItems; int count = idOptionChoixMenu.Count; for (int i = 0; i < count; i++) { var result = (OPTION_CHOIX_MENU)idOptionChoixMenu[i]; menu.OPTION_CHOIX_MENU.Add(result); } db.MENU.Add(menu); db.SaveChanges(); } else { MessageBox.Show("Selectionnez un article"); } }
private void OnCLickAddMenuOption(object sender, RoutedEventArgs e) { OPTION_CHOIX_MENU ocm = new OPTION_CHOIX_MENU(); var idItem = (lv_items.SelectedItems); int count = idItem.Count; ocm.option_choix_menu_title = tb_nameMenuOption.Text; db.OPTION_CHOIX_MENU.Add(ocm); for (int i = 0; i < count; i++) { var item = (ITEM)idItem[i]; ITEM_OPTION_MENU iom = new ITEM_OPTION_MENU(); iom.id_option_choix_menu = ocm.id_option_choix_menu; iom.id_item = item.id_item; iom.item_option_menu_quantity = 1; db.ITEM_OPTION_MENU.Add(iom); } db.SaveChanges(); }
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; } } }
// 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"); } }
//Ajout/Modification d'un article private async void OnCLickAddNewItem(object sender, RoutedEventArgs e) { // A chaque "Click" sur le bouton ajouter, j'initialise les message tb_messageItem.Text = ""; string message = ""; // Message de resultat string infoMessage = ""; if (IDSource == 1) // Produit { try { ITEM item = new ITEM(); // If update if (IDItem > 0) { infoMessage = "modification"; ITEM itm = (from it in db.ITEM where it.id_item == IDItem select it).Single(); itm.item_title = tb_name.Text; itm.item_decription = tb_description.Text; if (!string.IsNullOrEmpty(tb_price.Text)) { itm.item_price = Decimal.Parse(tb_price.Text); } if (!string.IsNullOrEmpty(tb_pricePromo.Text)) { itm.item_promotion_price = Decimal.Parse(tb_pricePromo.Text); } if (color != null) { itm.item_button_color = color.ToString(); } itm.actif = (bool)tg_actif.IsChecked; itm.cooked = (bool)tg_cooked.IsChecked; db.SaveChanges(); message = "Le produit a été ajouté avec succès "; rvm.Result = true; _errors = new Errors(); gridForms.DataContext = _errors; tb_messageItem.Visibility = Visibility.Visible; icon_messageItem.Visibility = Visibility.Visible; tb_messageItem.Text = message; tb_messageItem.Foreground = Brushes.DarkGreen; icon_messageItem.Kind = PackIconKind.CheckCircleOutline; icon_messageItem.Foreground = Brushes.DarkGreen; } else// If add { infoMessage = "ajout"; if (!string.IsNullOrEmpty(tb_name.Text)) // Obligatoire { item.item_title = tb_name.Text; } else { return; } if (!string.IsNullOrEmpty(tb_description.Text)) { item.item_decription = tb_description.Text; } if (!string.IsNullOrEmpty(tb_price.Text))// Obligatoire { item.item_price = Decimal.Parse(tb_price.Text); } else { return; } if (!string.IsNullOrEmpty(tb_pricePromo.Text)) { item.item_promotion_price = Decimal.Parse(tb_pricePromo.Text); } if (color != null) { item.item_button_color = color.ToString(); } if (color == null) { item.item_button_color = "#9b59b6"; } item.actif = (bool)tg_actif.IsChecked; item.cooked = (bool)tg_cooked.IsChecked; item.id_category = IDCat; db.ITEM.Add(item); db.SaveChanges(); _errors = new Errors(); gridForms.DataContext = _errors; tb_messageItem.Visibility = Visibility.Visible; icon_messageItem.Visibility = Visibility.Visible; tb_messageItem.Text = message; tb_messageItem.Foreground = Brushes.DarkGreen; icon_messageItem.Kind = PackIconKind.CheckCircleOutline; icon_messageItem.Foreground = Brushes.DarkGreen; message = "Le produit a été ajouté avec succès "; rvm.Result = true; } } catch (Exception ex) { tb_messageItem.Visibility = Visibility.Visible; icon_messageItem.Visibility = Visibility.Visible; tb_messageItem.Text = "Echec " + infoMessage + " de l'article " + ex.Message; tb_messageItem.Foreground = Brushes.DarkRed; icon_messageItem.Kind = PackIconKind.AlertCircleOutline; icon_messageItem.Foreground = Brushes.DarkRed; rvm.Result = false; } } if (IDSource == 2) // INGREDIENT { try { INGREDIENT item = new INGREDIENT(); // If update if (IDItem > 0) { infoMessage = "modification"; INGREDIENT itm = (from it in db.INGREDIENT where it.id_ingredient == IDItem select it).Single(); itm.ingredient_title = tb_name.Text; itm.ingredient_description = tb_description.Text; if (!string.IsNullOrEmpty(tb_price.Text)) { itm.ingredient_price = Decimal.Parse(tb_price.Text); } itm.actif = (bool)tg_actif.IsChecked; db.SaveChanges(); message = "l'ingrédient a été modifié avec succès "; rvm.Result = true; } else// If add { infoMessage = "ajout"; if (!string.IsNullOrEmpty(tb_name.Text)) // Obligatoire { item.ingredient_title = tb_name.Text; } else { return; } if (!string.IsNullOrEmpty(tb_description.Text)) { item.ingredient_description = tb_description.Text; } if (!string.IsNullOrEmpty(tb_price.Text))// Obligatoire { item.ingredient_price = Decimal.Parse(tb_price.Text); } else { return; } item.actif = (bool)tg_actif.IsChecked; item.id_category_ingredient = IDCat; db.INGREDIENT.Add(item); db.SaveChanges(); _errors = new Errors(); gridForms.DataContext = _errors; tb_messageItem.Visibility = Visibility.Visible; icon_messageItem.Visibility = Visibility.Visible; tb_messageItem.Text = message; tb_messageItem.Foreground = Brushes.DarkGreen; icon_messageItem.Kind = PackIconKind.CheckCircleOutline; icon_messageItem.Foreground = Brushes.DarkGreen; message = "L'ingrédient a été ajouté avec succès "; rvm.Result = true; } } catch (Exception ex) { tb_messageItem.Visibility = Visibility.Visible; icon_messageItem.Visibility = Visibility.Visible; tb_messageItem.Text = "Echec " + infoMessage + " de l'article " + ex.Message; tb_messageItem.Foreground = Brushes.DarkRed; icon_messageItem.Kind = PackIconKind.AlertCircleOutline; icon_messageItem.Foreground = Brushes.DarkRed; rvm.Result = false; } } //try //{ // // If update // if (IDItem > 0) // { // infoMessage = "modification"; // ITEM itm = (from it in db.ITEM where it.id_item == IDItem select it).Single(); // itm.item_title = tb_name.Text; // itm.item_decription = tb_description.Text; // if (!string.IsNullOrEmpty(tb_price.Text)) // { // itm.item_price = Decimal.Parse(tb_price.Text); // } // if (!string.IsNullOrEmpty(tb_pricePromo.Text)) // { // itm.item_promotion_price = Decimal.Parse(tb_pricePromo.Text); // } // itm.item_button_color = color.ToString(); // itm.actif = (bool)tg_actif.IsChecked; // db.SaveChanges(); // message = "l'article a été modifié avec succès "; // rvm.Result = true; // } // If add // else // { // } // // OK => Init UI // _errors = new Errors(); // gridForms.DataContext = _errors; // tb_messageItem.Visibility = Visibility.Visible; // icon_messageItem.Visibility = Visibility.Visible; // tb_messageItem.Text = message; // tb_messageItem.Foreground = Brushes.DarkGreen; // icon_messageItem.Kind = PackIconKind.CheckCircleOutline; // icon_messageItem.Foreground = Brushes.DarkGreen; //} //catch (Exception ex) //{ // tb_messageItem.Visibility = Visibility.Visible; // icon_messageItem.Visibility = Visibility.Visible; // tb_messageItem.Text = "Echec " + infoMessage + " de l'article " + ex.Message; // tb_messageItem.Foreground = Brushes.DarkRed; // icon_messageItem.Kind = PackIconKind.AlertCircleOutline; // icon_messageItem.Foreground = Brushes.DarkRed; // rvm.Result = false; //} await Task.Run(() => { Thread.Sleep(2000); }); icon_messageItem.Visibility = Visibility.Collapsed; tb_messageItem.Text = "Ajouter " + TitleCat; tb_messageItem.Foreground = Brushes.DarkGreen; icon_messageItem.Kind = PackIconKind.AccessPoint; icon_messageItem.Foreground = Brushes.DarkGreen; }
private void eatin(object sender, RoutedEventArgs e) { ORDERS orderModel = new ORDERS(); item_selection itemSelection = new item_selection(); var testValue = db.ORDERS.OrderByDescending(p => p.orders_number).Where(p => p.id_orders_type == 1).Select(q => q.orders_number).FirstOrDefault(); orderModel.orders_number = Service.GetNextCode("SPL", testValue); orderModel.id_orders_status = 1; orderModel.id_orders_type = Convert.ToInt32(((Button)sender).Tag); orderModel.orders_date = DateTime.Today; orderModel.orders_delay_date = null; orderModel.orders_price = (decimal)totalPrice; // total commande orderModel.orders_leftToPay = (decimal)totalRestPrice; // reste à payer db.ORDERS.Add(orderModel); db.SaveChanges(); int idOrder = orderModel.id_orders; foreach (var item in cartList) { itemSelection = new item_selection(); if (item.SelectedIngredients != null && item.SelectedIngredients.Count > 0) { foreach (var subItem in item.SelectedIngredients) { itemSelection.id_item = item.ItemId; itemSelection.id_orders = idOrder; itemSelection.id_ingredient = subItem.IdIngredient; itemSelection.item_selection_quantity = item.ItemQuantity; db.item_selection.Add(itemSelection); db.SaveChanges(); } } else { itemSelection.id_item = item.ItemId; itemSelection.id_orders = idOrder; itemSelection.item_selection_quantity = item.ItemQuantity; db.item_selection.Add(itemSelection); db.SaveChanges(); } } cvm.Payement = new ObservableCollection <Payement>(); cvm.TotalCart = null; cvm.TotalRest = null; new Commandes(); #region PRINT // Show Print Dialog PrintDialog printDialog = new PrintDialog(); FlowDocument document = new FlowDocument(); System.Windows.Documents.Paragraph par = new System.Windows.Documents.Paragraph(); par.FontFamily = new System.Windows.Media.FontFamily("Times"); System.Windows.Documents.Paragraph subPar = new System.Windows.Documents.Paragraph(); document.ColumnWidth = printDialog.PrintableAreaWidth; document.PagePadding = new Thickness(25); Span s = new Span(); s = new Span(new Run("Le Cezar food")); s.Inlines.Add(new LineBreak()); //Line break is used for next line. par.Inlines.Add(s); // Add the span content into paragraph. par.Inlines.Add(new Span(new Run("Ticket fabrication"))); par.Inlines.Add(new LineBreak()); //Line break is used for next line. par.Inlines.Add(new Span(new Run("Sur place"))); par.Inlines.Add(new LineBreak()); //Line break is used for next line. par.Inlines.Add(new Span(new Run("Commande n° " + orderModel.orders_number))); par.Inlines.Add(new LineBreak()); //Line break is used for next line. par.Inlines.Add(new Span(new Run("-------------------------------------"))); document.Blocks.Add(par); foreach (var item in cartList.Where(c => c.Cooked == true)) { par = new System.Windows.Documents.Paragraph(new Run(item.ItemQuantity.ToString() + " x " + item.ItemTitle.ToString())); par.FontSize = 14; par.TextAlignment = TextAlignment.Left; document.Blocks.Add(par); if (item.SelectedIngredients != null) { subPar = new System.Windows.Documents.Paragraph(); foreach (var subItem in item.SelectedIngredients) { subPar.Inlines.Add(new Span(new Run(subItem.Ingredient_quantity + " x " + subItem.Ingredient_title.ToString()))); subPar.Inlines.Add(new Span(new Run(" "))); subPar.FontSize = 12; subPar.TextAlignment = TextAlignment.Center; document.Blocks.Add(subPar); } } } System.Windows.Documents.Paragraph par1 = new System.Windows.Documents.Paragraph(); par1.Inlines.Add(new LineBreak());//Line break is used for next line. par1.Inlines.Add(new Span(new Run("-------------------------------------"))); document.Blocks.Add(par1); foreach (var item in cartList.Where(c => c.Cooked == false)) { par1 = new System.Windows.Documents.Paragraph(new Run(item.ItemQuantity.ToString() + " x " + item.ItemTitle.ToString())); par1.FontSize = 14; par1.TextAlignment = TextAlignment.Left; document.Blocks.Add(par1); } //Config printer //var query = new ManagementObjectSearcher("SELECT * FROM Win32_Printer"); //var printers = query.Get(); //string printerName = Properties.Settings.Default.printerName; //foreach (ManagementObject p in printers) //{ // if (p["name"].ToString() == printerName.ToString()) // { // p.InvokeMethod("SetDefaultPrinter", null, null); // } //} //document.Blocks.Add(par); // fdViewer.Document = document; IDocumentPaginatorSource idpSource = document; printDialog.PrintDocument(idpSource.DocumentPaginator, "Receipt"); //Give style and formatting to paragraph content. //par.FontSize = 14; //par.FontStyle = FontStyles.Normal; //par.TextAlignment = TextAlignment.Left; //document.Blocks.Add(par); // DoThePrint(document); #endregion //ExportDataTableToPdf(cartList, @"C:\Users\Wave\Documents\Visual Studio 2015\Projects\Le cezar food caisse\CezarCaisse_v.0.1\Ecom\Resources\test.pdf", "Friend List"); cartList.Clear(); }