private void btnRemove_Click(object sender, RoutedEventArgs e) { if (productListView.SelectedValue != null) { using (IndividueelProjectEntities2 ctx = new IndividueelProjectEntities2()) { var bestel = ctx.BestellingProducts.Select(x => x).ToList(); if (bestel.Contains(productListView.SelectedValue)) { var bestelingId = ctx.BestellingProducts.Select(x => x).Where(x => x.ProductID == (int)productListView.SelectedValue).FirstOrDefault(); ctx.BestellingProducts.RemoveRange(ctx.BestellingProducts.Where(x => x.ProductID == (int)productListView.SelectedValue)).FirstOrDefault(); ctx.Bestellings.RemoveRange(ctx.Bestellings.Where(x => x.ID == bestelingId.BestellingID)); ctx.Products.RemoveRange(ctx.Products.Where(p => p.ID == (int)productListView.SelectedValue)).FirstOrDefault(); } else { ctx.Products.RemoveRange(ctx.Products.Where(p => p.ID == (int)productListView.SelectedValue)).FirstOrDefault(); } System.Windows.Forms.DialogResult result = MyMessageBox.Show("Are you sure want to delet the product?", MyMessageBox.CMessageBoxButton.Yes, MyMessageBox.CMessageBoxButton.No); if (result == System.Windows.Forms.DialogResult.Yes) { MessagBoxInfo.Show("Product successfully deleted", MessagBoxInfo.CmessageBoxTitle.Info); ctx.SaveChanges(); } } } updateListView(); }
private void btnJasonCreat_Click(object sender, RoutedEventArgs e) { using (IndividueelProjectEntities2 ctx = new IndividueelProjectEntities2()) { var products = ctx.Products.Select(x => x); List <object> listProducts = new List <object>(); foreach (var item in products) { Product productList = new Product() { ID = item.ID, Naam = item.Naam, Marge = item.Marge, Eenheid = item.Eenheid, BTW = item.BTW, LeverancierID = item.LeverancierID, CategorieID = item.CategorieID, Inkoopprijs = item.Inkoopprijs, InStock = item.InStock }; listProducts.Add(productList); } JsonCreat(listProducts); MessagBoxInfo.Show("Template created", MessagBoxInfo.CmessageBoxTitle.Info); } }
private void updateFilter() { using (IndividueelProjectEntities2 ctx = new IndividueelProjectEntities2()) { switch (cmbPerson.SelectedItem) { case "A->Z": var person = ctx.Personeelslids.Select(x => x).OrderBy(x => x.Voornaam); listViewPersonLid.ItemsSource = person.ToList(); break; case "Z->A": var person1 = ctx.Personeelslids.Select(x => x).OrderByDescending(x => x.Voornaam); listViewPersonLid.ItemsSource = person1.ToList(); break; case "UserType ↑": var userType = ctx.Personeelslids.Select(x => x).OrderBy(x => x.Usertype); listViewPersonLid.ItemsSource = userType.ToList(); break; case "UserType ↓": var userType1 = ctx.Personeelslids.Select(x => x).OrderByDescending(x => x.Usertype); listViewPersonLid.ItemsSource = userType1.ToList(); break; default: break; } } }
private void btnRemove_Click(object sender, RoutedEventArgs e) { if (listViewOrder.SelectedValue != null) { using (IndividueelProjectEntities2 ctx = new IndividueelProjectEntities2()) { var bestelingProd = ctx.BestellingProducts.Select(x => x).ToList(); if (bestelingProd.Contains(listViewOrder.SelectedValue)) { System.Windows.Forms.DialogResult result = MyMessageBox.Show("Are you sure you want to delete the order and all the datas? ", MyMessageBox.CMessageBoxButton.Yes, MyMessageBox.CMessageBoxButton.No); if (result == System.Windows.Forms.DialogResult.Yes) { var bestProd = ctx.BestellingProducts.RemoveRange(ctx.BestellingProducts.Where(x => x.BestellingID == (int)listViewOrder.SelectedValue)); var best = ctx.Bestellings.RemoveRange(ctx.Bestellings.Where(x => x.ID == (int)listViewOrder.SelectedValue)); MessagBoxInfo.Show("Data successfully deleted", MessagBoxInfo.CmessageBoxTitle.Info); ctx.SaveChanges(); updateTheList(); } } else { var best1 = ctx.Bestellings.RemoveRange(ctx.Bestellings.Where(x => x.ID == (int)listViewOrder.SelectedValue)); ctx.SaveChanges(); updateTheList(); } } } }
private void btnAdd_Click(object sender, RoutedEventArgs e) { int number = 0; using (IndividueelProjectEntities2 ctx = new IndividueelProjectEntities2()) { if (productListView.SelectedValue != null && Convert.ToInt32(txtQuantity.Text) != 0) { var product = ctx.Products.Select(x => x).Where(x => x.ID == (int)productListView.SelectedValue).FirstOrDefault(); foreach (var item in myProductinKars) { if (item.ProductinKarID == product.ID) { number++; } } if (number == 1) { MessagBoxInfo.Show("The product is already in the shopping car", MessagBoxInfo.CmessageBoxTitle.Info); } else { myProductinKars.Add(new ProductinKar(Convert.ToInt32(txtQuantity.Text), (double)product.Inkoopprijs, product.ID, product.Naam, (int)product.LeverancierID, (double)product.Marge, (double)product.BTW, product.Eenheid)); } } ctx.SaveChanges(); } lbShoppingCart.ItemsSource = null; lbShoppingCart.SelectedValuePath = "ProductinKarID"; lbShoppingCart.ItemsSource = myProductinKars; updateTotalPrice(); }
private void btnAddSave_Click(object sender, RoutedEventArgs e) { if (chekText(true)) { do { using (IndividueelProjectEntities2 ctx = new IndividueelProjectEntities2()) { try { var sup = ctx.Leveranciers.Where(x => x.Company == txtCompany.Text && x.Contactpersoon == txtContactPerson.Text).Count(); if (sup == 0) { ctx.Leveranciers.Add(new Leverancier() { Contactpersoon = txtContactPerson.Text, Company = txtCompany.Text, Telefoonnummer = txtPhone.Text, Emailadres = txtEmail.Text, Straatnaam = txtStreet.Text, Huisnummer = Convert.ToInt32(txtHouseNumber.Text), Bus = Convert.ToInt32(txtMailbox.Text), Postcode = Convert.ToInt32(txtZipcode.Text), Gemeente = txtTown.Text }); string newSuppplier = $"{txtCompany.Text}\n" + $"{txtContactPerson.Text}\n" + $"{txtPhone.Text}\n" + $"{txtEmail.Text}\n" + $"{txtStreet.Text} {txtHouseNumber.Text} {txtMailbox.Text}\n" + $"{txtZipcode.Text}\n" + $"{txtTown.Text}"; System.Windows.Forms.DialogResult result = MessagBoxInfo.Show(newSuppplier, MessagBoxInfo.CmessageBoxTitle.Info); if (result == System.Windows.Forms.DialogResult.OK) { ctx.SaveChanges(); updateTheList(); hidePanel(); } } else { MessagBoxInfo.Show("Company is already exist", MessagBoxInfo.CmessageBoxTitle.Error); } } catch (Exception) { MessagBoxInfo.Show("Something wrong", MessagBoxInfo.CmessageBoxTitle.Warning); } } } while (false); } else { MessagBoxInfo.Show("Something missing", MessagBoxInfo.CmessageBoxTitle.Warning); } }
private void UpdateListView() { using (IndividueelProjectEntities2 ctx = new IndividueelProjectEntities2()) { var cusList = ctx.Klants.Select(x => x); listViewCustomer.SelectedValuePath = "ID"; listViewCustomer.ItemsSource = cusList.ToList(); } }
private void updateTheList() { using (IndividueelProjectEntities2 ctx = new IndividueelProjectEntities2()) { var supl = ctx.Leveranciers.Select(l => l); supportList.SelectedValuePath = "ID"; supportList.ItemsSource = supl.ToList(); } }
private void updateTheList() { using (IndividueelProjectEntities2 ctx = new IndividueelProjectEntities2()) { var personLid = ctx.Personeelslids.Select(x => x); listViewPersonLid.SelectedValuePath = "ID"; listViewPersonLid.ItemsSource = personLid.ToList(); } }
private void updateCmbSupplier() { using (IndividueelProjectEntities2 ctx = new IndividueelProjectEntities2()) { var supl = ctx.Leveranciers.Select(x => x); cmbSupplier.SelectedValuePath = "ID"; cmbSupplier.DisplayMemberPath = "Company"; cmbSupplier.ItemsSource = supl.ToList(); } }
private void updateCmbKlant() { using (IndividueelProjectEntities2 ctx = new IndividueelProjectEntities2()) { var klant = ctx.Klants.Select(x => new { Id = x.ID, Name = x.Voornaam + " " + x.Achternaam }); cmbKlant.SelectedValuePath = "Id"; cmbKlant.DisplayMemberPath = "Name"; cmbKlant.ItemsSource = klant.ToList(); } }
private void fillTheList() { using (IndividueelProjectEntities2 ctx = new IndividueelProjectEntities2()) { var orderopro = ctx.BestellingProducts.Select(x => new { Id = x.BestellingProductID, BestelinId = x.BestellingID, ProductName = x.Product.Naam, Quantity = x.Pieces }); listViewOrderProduct.SelectedValuePath = "Id"; listViewOrderProduct.ItemsSource = orderopro.ToList(); } }
private void btnAll_Click(object sender, RoutedEventArgs e) { using (IndividueelProjectEntities2 ctx = new IndividueelProjectEntities2()) { var product = ctx.Products.Select(x => x); productListView.SelectedValuePath = "ID"; productListView.ItemsSource = product.ToList(); } txtQuantity.Text = 0.ToString(); txtPrice.Text = string.Empty; }
private void productListView_SelectionChanged(object sender, SelectionChangedEventArgs e) { using (IndividueelProjectEntities2 ctx = new IndividueelProjectEntities2()) { if (productListView.SelectedValue != null) { var product = ctx.Products.Select(x => x).Where(x => x.ID == (int)productListView.SelectedValue).FirstOrDefault(); txtPrice.Text = ((product.Inkoopprijs + product.Marge) * (1 + product.BTW / 100)) + "€"; } }; }
private void btnPc_Click(object sender, RoutedEventArgs e) { using (IndividueelProjectEntities2 ctx = new IndividueelProjectEntities2()) { var product = ctx.Products.Select(x => x).Where(x => x.CategorieID == 9); lbProduct.DisplayMemberPath = "Naam"; lbProduct.SelectedValuePath = "ID"; lbProduct.ItemsSource = product.ToList(); } txtQuantity.Text = 0.ToString(); txtTaxPrice.Text = string.Empty; }
private void btnEcs_Click(object sender, RoutedEventArgs e) { using (IndividueelProjectEntities2 ctx = new IndividueelProjectEntities2()) { foreach (var item in myProductinKars) { var product = ctx.Products.Select(x => x).Where(x => x.ID == item.ProductinKarID).FirstOrDefault(); product.InStock = product.InStock + item.Quantity; ctx.SaveChanges(); } } System.Windows.Application.Current.Shutdown(); }
private void btnBack_Click(object sender, RoutedEventArgs e) { using (IndividueelProjectEntities2 ctx = new IndividueelProjectEntities2()) { foreach (var item in myProductinKars) { var product = ctx.Products.Select(x => x).Where(x => x.ID == item.ProductinKarID).FirstOrDefault(); product.InStock = product.InStock + item.Quantity; ctx.SaveChanges(); } } MainMenu mainMenu = new MainMenu(loggedInUser); mainMenu.ShowDialog(); }
private void updateEditForm() { using (IndividueelProjectEntities2 ctx = new IndividueelProjectEntities2()) { if (listViewOrder.SelectedValue != null) { var select = ctx.Bestellings.Select(x => x).Where(x => x.ID == (int)listViewOrder.SelectedValue).FirstOrDefault(); cmbKlant.SelectedValue = select.KlantID; cmbPersonmember.SelectedValue = select.PersoneelslidID; cmbSupplier.SelectedValue = select.LeverancierID; dtDatum.SelectedDate = select.DatumOpgemaakt; } } }
private void lbProduct_SelectionChanged(object sender, SelectionChangedEventArgs e) { using (IndividueelProjectEntities2 ctx = new IndividueelProjectEntities2()) { if (lbProduct.SelectedValue != null) { var product = ctx.Products.Select(x => x).Where(x => x.ID == (int)lbProduct.SelectedValue).FirstOrDefault(); //txtPrice.Text = (product as Product).nettoPrice().ToString(); txtTaxPrice.Text = Convert.ToDouble((product.Inkoopprijs + product.Marge) * (1 + Convert.ToDouble(product.BTW) / 100)).ToString() + "€"; txtInfo.Text = product.Specifications; } }; }
private void btnAddSave_Click(object sender, RoutedEventArgs e) { using (IndividueelProjectEntities2 ctx = new IndividueelProjectEntities2()) { if (chekErrorsText(true)) { do { try { ctx.Klants.Add(new Klant() { Voornaam = txtFirstName.Text, Achternaam = txtLastName.Text, Straatnaam = txtStreet.Text, Huisnummer = Convert.ToInt32(txtHouseNumber.Text), Bus = Convert.ToInt32(txtMailbox.Text), Postcode = Convert.ToInt32(txtZipcode.Text), Gemeente = txtTown.Text, Telefoonnummer = txtPhone.Text, Emailadres = txtEmail.Text, AangemaaktOp = Convert.ToDateTime(DateTimePicker.Text), Opmerking = txtComment.Text }); var klant = ctx.Klants.Select(x => x).Where(y => y.Voornaam == txtFirstName.Text && y.Achternaam == txtLastName.Text).Count(); if (klant == 0) { MessagBoxInfo.Show("New Customer", MessagBoxInfo.CmessageBoxTitle.Info); ctx.SaveChanges(); UpdateListView(); hidePanel(); } else { MessagBoxInfo.Show("De customer alredy exist", MessagBoxInfo.CmessageBoxTitle.Error); } } catch { MessagBoxInfo.Show("Something wrong", MessagBoxInfo.CmessageBoxTitle.Error); } } while (false); } else { MessagBoxInfo.Show("Something missing", MessagBoxInfo.CmessageBoxTitle.Error); } } }
private void fillEditForm() { using (IndividueelProjectEntities2 ctx = new IndividueelProjectEntities2()) { if (listViewPersonLid.SelectedValue != null) { var select = ctx.Personeelslids.Select(x => x).Where(x => x.ID == (int)listViewPersonLid.SelectedValue).FirstOrDefault(); txtFirstname.Text = select.Voornaam; txtLastname.Text = select.Achternaam; txtPassword.Text = select.Password; txtUsername.Text = select.Username; cmbUsertype.SelectedItem = select.Usertype; } } }
private void updateTheList() { using (IndividueelProjectEntities2 ctx = new IndividueelProjectEntities2()) { var order = ctx.Bestellings.Select(x => new { Id = x.ID, Datum = x.DatumOpgemaakt, Person = x.Personeelslid.Voornaam + " " + x.Personeelslid.Achternaam, Leveran = x.Leverancier.Company, Klant = x.Klant.Voornaam + " " + x.Klant.Achternaam }); listViewOrder.SelectedValuePath = "Id"; listViewOrder.ItemsSource = order.ToList(); } }
private void fillComboBox() { using (IndividueelProjectEntities2 ctx = new IndividueelProjectEntities2()) { var supList = ctx.Leveranciers.Select(x => x); cmbSupplier.SelectedValuePath = "ID"; cmbSupplier.DisplayMemberPath = "Company"; cmbSupplier.ItemsSource = supList.ToList(); var catList = ctx.Categories.Select(x => x); cmbCategory.SelectedValuePath = "ID"; cmbCategory.DisplayMemberPath = "CategorieNaam"; cmbCategory.ItemsSource = catList.ToList(); } }
private void btnLogout_Click(object sender, RoutedEventArgs e) { using (IndividueelProjectEntities2 ctx = new IndividueelProjectEntities2()) { foreach (var item in myProductinKars) { var product = ctx.Products.Select(x => x).Where(x => x.ID == item.ProductinKarID).FirstOrDefault(); product.InStock = product.InStock + item.Quantity; ctx.SaveChanges(); } } MainWindow mainwindow = new MainWindow(); var myWindow = Window.GetWindow(this); myWindow.Close(); mainwindow.ShowDialog(); }
private void btnRemove_Click(object sender, RoutedEventArgs e) { if (listViewOrderProduct.SelectedValue != null) { using (IndividueelProjectEntities2 ctx = new IndividueelProjectEntities2()) { System.Windows.Forms.DialogResult result = MyMessageBox.Show("Are you sure want to delet the product?", MyMessageBox.CMessageBoxButton.Yes, MyMessageBox.CMessageBoxButton.No); if (result == System.Windows.Forms.DialogResult.Yes) { var bestPro = ctx.BestellingProducts.RemoveRange(ctx.BestellingProducts.Where(x => x.BestellingProductID == (int)listViewOrderProduct.SelectedValue)).FirstOrDefault(); ctx.SaveChanges(); MessagBoxInfo.Show("Data successfully deleted", MessagBoxInfo.CmessageBoxTitle.Info); fillTheList(); } } } }
private void btnDelete_Click(object sender, RoutedEventArgs e) { using (IndividueelProjectEntities2 ctx = new IndividueelProjectEntities2()) { if (lbShoppingCart.SelectedIndex != -1) { var product = ctx.Products.Select(x => x).Where(x => x.ID == (int)lbShoppingCart.SelectedValue).FirstOrDefault(); System.Windows.Forms.DialogResult result = MyMessageBox.Show("are you sure you want delete from shopping cart", MyMessageBox.CMessageBoxButton.Yes, MyMessageBox.CMessageBoxButton.No); if (result == System.Windows.Forms.DialogResult.Yes) { myProductinKars.RemoveAt(lbShoppingCart.SelectedIndex); } } } updateShoppingList(); updateTotalPrice(); }
// le kell frisiteni az osszes listat private void btnOrder_Click(object sender, RoutedEventArgs e) { using (IndividueelProjectEntities2 ctx = new IndividueelProjectEntities2()) { if (cmbCustomer.SelectedValue != null && myProductinKars.Count() != 0) { System.Windows.Forms.DialogResult result = MyMessageBox.Show("Do you confirm the order?", MyMessageBox.CMessageBoxButton.Yes, MyMessageBox.CMessageBoxButton.No); if (result == System.Windows.Forms.DialogResult.Yes) { ctx.Bestellings.Add(new Bestelling() { PersoneelslidID = loggedInUser.ID, KlantID = (int)cmbCustomer.SelectedValue, LeverancierID = null, DatumOpgemaakt = DateTime.Now }); ctx.SaveChanges(); var lastBesttelingId = ctx.Bestellings.Select(x => x.ID).Max(); foreach (var item in myProductinKars) { ctx.BestellingProducts.Add(new BestellingProduct() { BestellingID = lastBesttelingId, ProductID = item.ProductinKarID, Pieces = item.Quantity }); var product = ctx.Products.Select(x => x).Where(x => x.ID == item.ProductinKarID).FirstOrDefault(); product.InStock = product.InStock - item.Quantity; ctx.SaveChanges(); } myProductinKars.Clear(); txtQuantity.Text = 0.ToString(); txtPrice.Text = string.Empty; txtTotalPrice.Text = string.Empty; updateShoppingList(); MessagBoxInfo.Show("Order successful", MessagBoxInfo.CmessageBoxTitle.Info); } } else { MessagBoxInfo.Show("Something missing", MessagBoxInfo.CmessageBoxTitle.Error); } } }
private void btnRemove_Click(object sender, RoutedEventArgs e) { if (listViewPersonLid.SelectedValue != null) { using (IndividueelProjectEntities2 ctx = new IndividueelProjectEntities2()) { var bestelingperson = ctx.Bestellings.Select(x => x).ToList(); if (bestelingperson.Contains(listViewPersonLid.SelectedValue)) { var selectPerson = ctx.Personeelslids.Select(x => x).Where(x => x.ID == (int)listViewPersonLid.SelectedValue).FirstOrDefault(); var selectOrde = ctx.Bestellings.Select(x => x).Where(x => x.PersoneelslidID == selectPerson.ID).FirstOrDefault(); var selectOrderProduct = ctx.BestellingProducts.Select(x => x).Where(x => x.BestellingID == selectOrde.ID).FirstOrDefault(); System.Windows.Forms.DialogResult result = MyMessageBox.Show("Are you sure you want to delete the user and all the datas and orders?", MyMessageBox.CMessageBoxButton.Yes, MyMessageBox.CMessageBoxButton.No); if (result == System.Windows.Forms.DialogResult.Yes) { var ord = ctx.BestellingProducts.RemoveRange(ctx.BestellingProducts.Where(x => x.BestellingID == selectOrderProduct.BestellingID)); var order = ctx.Bestellings.RemoveRange(ctx.Bestellings.Where(x => x.PersoneelslidID == selectPerson.ID)); var person = ctx.Personeelslids.RemoveRange(ctx.Personeelslids.Where(x => x.ID == (int)listViewPersonLid.SelectedValue)).FirstOrDefault(); MessagBoxInfo.Show(selectPerson.Voornaam + " " + selectPerson.Achternaam + " " + "successfully deleted", MessagBoxInfo.CmessageBoxTitle.Info); ctx.SaveChanges(); } else { System.Windows.Forms.DialogResult result2 = MyMessageBox.Show("Would you like to delete only the person", MyMessageBox.CMessageBoxButton.Yes, MyMessageBox.CMessageBoxButton.No); if (result == System.Windows.Forms.DialogResult.Yes) { var person = ctx.Personeelslids.RemoveRange(ctx.Personeelslids.Where(x => x.ID == (int)listViewPersonLid.SelectedValue)).FirstOrDefault(); ctx.SaveChanges(); } } } else { System.Windows.Forms.DialogResult result2 = MyMessageBox.Show("Are you sure you want to delete the user?", MyMessageBox.CMessageBoxButton.Yes, MyMessageBox.CMessageBoxButton.No); if (result2 == System.Windows.Forms.DialogResult.Yes) { var person = ctx.Personeelslids.RemoveRange(ctx.Personeelslids.Where(x => x.ID == (int)listViewPersonLid.SelectedValue)).FirstOrDefault(); ctx.SaveChanges(); } } } updateTheList(); hideEditform(); } }
public CustomerOverview() { InitializeComponent(); List <string> sortCustomer = new List <string>() { "A->Z", "Z->A", "Bought ↑", "Bought ↓", }; cmbFilter.ItemsSource = sortCustomer; using (IndividueelProjectEntities2 ctx = new IndividueelProjectEntities2()) { var supl = ctx.Klants.Select(l => l); listViewCustomer.ItemsSource = supl.ToList(); } }
private void btnReg_Click(object sender, RoutedEventArgs e) { using (IndividueelProjectEntities2 ctx = new IndividueelProjectEntities2()) { ctx.Personeelslids.Add(new Personeelslid { Username = txtUserName.Text.ToString(), Password = txtPassword.Password.ToString(), Usertype = cmbUserType.SelectedItem.ToString() }); ctx.SaveChanges(); } //MessageBox.Show($"New user successfully created\n" + // $"{txtUserName.Text}\n" + // $"{txtPassword.Password.ToString()}\n" + // $"{cmbUserType.SelectedItem.ToString()}"); DialogResult = true; }