private void Delete_Client(object sender, RoutedEventArgs e) { Cooking_BDD.cookingDataSet cookingDataSet = ((Cooking_BDD.cookingDataSet)(this.FindResource("cookingDataSet"))); DataRow data = cookingDataSet.clients[clientsDataGrid.SelectedIndex]; string items = Convert.ToString(data["createur_recette_id_createur"]); string id = Convert.ToString(data["id_client"]); if ((items == "") && (id == "")) { MessageBox.Show("Vous n'avez rien selectionné . "); } else { if (items != "") { Delete_Cdr(sender, e); Cooking_BDD.cookingDataSetTableAdapters.clientsTableAdapter cookingDataSetclientsTableAdapter = new Cooking_BDD.cookingDataSetTableAdapters.clientsTableAdapter(); cookingDataSetclientsTableAdapter.DeleteQuery(id); } else { Cooking_BDD.cookingDataSetTableAdapters.clientsTableAdapter cookingDataSetclientsTableAdapter = new Cooking_BDD.cookingDataSetTableAdapters.clientsTableAdapter(); cookingDataSetclientsTableAdapter.DeleteQuery(id); } } ActualiseClient(); }
private void Ajouter_produit(object sender, RoutedEventArgs e) { Cooking_BDD.cookingDataSet cookingDataSet = ((Cooking_BDD.cookingDataSet)(this.FindResource("cookingDataSet"))); DataRow data = cookingDataSet.product[name_productComboBox.SelectedIndex]; string name_product = Convert.ToString(data["name_product"]); if ((name_product != "") && (Convert.ToInt32(quantity_product.Text) > 0)) { if (quantity.Keys.Contains(name_product)) { ens_produit.Items.Remove(($"{name_product}.(x{quantity[name_product]})")); quantity[name_product] += Convert.ToSingle(quantity_product.Text); ens_produit.Items.Add($"{name_product}.(x{quantity[name_product]})"); } else { quantity.Add(name_product, Convert.ToSingle(quantity_product.Text)); ens_produit.Items.Add($"{name_product}.(x{quantity[name_product]})"); } } else { MessageBox.Show("Vous n'avez rien selectionné et/ou la quantité est mauvaise."); } }
private void ActualiseRecette() { Cooking_BDD.cookingDataSet cookingDataSet = ((Cooking_BDD.cookingDataSet)(this.FindResource("cookingDataSet"))); Cooking_BDD.cookingDataSetTableAdapters.recetteTableAdapter cookingDataSetrecetteTableAdapter = new Cooking_BDD.cookingDataSetTableAdapters.recetteTableAdapter(); cookingDataSetrecetteTableAdapter.FillBy(cookingDataSet.recette); System.Windows.Data.CollectionViewSource recetteViewSource = ((System.Windows.Data.CollectionViewSource)(this.FindResource("recetteViewSource"))); recetteViewSource.View.MoveCurrentToFirst(); }
private void ActualiseClient() { Cooking_BDD.cookingDataSet cookingDataSet = ((Cooking_BDD.cookingDataSet)(this.FindResource("cookingDataSet"))); Cooking_BDD.cookingDataSetTableAdapters.clientsTableAdapter cookingDataSetclientsTableAdapter = new Cooking_BDD.cookingDataSetTableAdapters.clientsTableAdapter(); cookingDataSetclientsTableAdapter.Fill(cookingDataSet.clients); System.Windows.Data.CollectionViewSource clientsViewSource = ((System.Windows.Data.CollectionViewSource)(this.FindResource("clientsViewSource"))); clientsViewSource.View.MoveCurrentToFirst(); }
private void Actualiser_Produit() { Cooking_BDD.cookingDataSet cookingDataSet = ((Cooking_BDD.cookingDataSet)(this.FindResource("cookingDataSet"))); Cooking_BDD.cookingDataSetTableAdapters.productTableAdapter cookingDataSetproductTableAdapter = new Cooking_BDD.cookingDataSetTableAdapters.productTableAdapter(); cookingDataSetproductTableAdapter.FillByProduct(cookingDataSet.product); System.Windows.Data.CollectionViewSource productViewSource = ((System.Windows.Data.CollectionViewSource)(this.FindResource("productViewSource"))); productViewSource.View.MoveCurrentToFirst(); }
private void AcualiserFournisseur() { Cooking_BDD.cookingDataSet cookingDataSet = ((Cooking_BDD.cookingDataSet)(this.FindResource("cookingDataSet"))); // Impossible de générer ce code, car la méthode cookingDataSetfournisseurTableAdapter.Fill est manquante ou a des paramètres non reconnus. Cooking_BDD.cookingDataSetTableAdapters.fournisseurTableAdapter cookingDataSetfournisseurTableAdapter = new Cooking_BDD.cookingDataSetTableAdapters.fournisseurTableAdapter(); cookingDataSetfournisseurTableAdapter.Fill(cookingDataSet.fournisseur); System.Windows.Data.CollectionViewSource fournisseurViewSource = ((System.Windows.Data.CollectionViewSource)(this.FindResource("fournisseurViewSource"))); fournisseurViewSource.View.MoveCurrentToFirst(); }
private void Delete_Cdr(object sender, RoutedEventArgs e) { Cooking_BDD.cookingDataSet cookingDataSet = ((Cooking_BDD.cookingDataSet)(this.FindResource("cookingDataSet"))); DataRow data = cookingDataSet.clients[clientsDataGrid.SelectedIndex]; string items = Convert.ToString(data["createur_recette_id_createur"]); MySqlCommand my_recette = mySql_cooking.CreateCommand(); my_recette.CommandText = "select nom_recette from recette where id_createur=@cdr"; my_recette.Parameters.AddWithValue("@cdr", items); MySqlDataReader dr; dr = my_recette.ExecuteReader(); while (dr.Read()) { string nom_recette = Convert.ToString(dr["nom_recette"]); Cooking_BDD.cookingDataSetTableAdapters.contientTableAdapter cookingDataSetingredientTableAdapter = new Cooking_BDD.cookingDataSetTableAdapters.contientTableAdapter(); cookingDataSetingredientTableAdapter.DeleteRecetteIngredient(nom_recette); Cooking_BDD.cookingDataSetTableAdapters.est_composeeTableAdapter cookingDataSetcontientTableAdapter = new Cooking_BDD.cookingDataSetTableAdapters.est_composeeTableAdapter(); cookingDataSetcontientTableAdapter.DeleteContientRecette(nom_recette); } dr.Close(); if (items == "") { MessageBox.Show("Vous n'avez rien selectionné et/ou le client n'est pas un CDR."); } else { Cooking_BDD.cookingDataSetTableAdapters.recetteTableAdapter cookingDataSetrecetteTableAdapter = new Cooking_BDD.cookingDataSetTableAdapters.recetteTableAdapter(); cookingDataSetrecetteTableAdapter.DeleteRecette(items); Cooking_BDD.cookingDataSetTableAdapters.createur_recetteTableAdapter cookingDataSetcdrTableAdapter = new Cooking_BDD.cookingDataSetTableAdapters.createur_recetteTableAdapter(); cookingDataSetcdrTableAdapter.DeleteQuery(items); Cooking_BDD.cookingDataSetTableAdapters.clientsTableAdapter cookingDataSetclientsTableAdapter = new Cooking_BDD.cookingDataSetTableAdapters.clientsTableAdapter(); cookingDataSetclientsTableAdapter.UpdateCDR_ID(items); ActualiseClient(); } }
private void Button_Click(object sender, RoutedEventArgs e) { Cooking_BDD.cookingDataSet cookingDataSet = ((Cooking_BDD.cookingDataSet)(this.FindResource("cookingDataSet"))); DataRow data = cookingDataSet.recette[recetteDataGrid.SelectedIndex]; string items = Convert.ToString(data["nom_recette"]); Cooking_BDD.cookingDataSetTableAdapters.contientTableAdapter cookingDataSetingredientTableAdapter = new Cooking_BDD.cookingDataSetTableAdapters.contientTableAdapter(); cookingDataSetingredientTableAdapter.DeleteRecetteIngredient(items); Cooking_BDD.cookingDataSetTableAdapters.est_composeeTableAdapter cookingDataSetcontientTableAdapter = new Cooking_BDD.cookingDataSetTableAdapters.est_composeeTableAdapter(); cookingDataSetcontientTableAdapter.DeleteContientRecette(items); Cooking_BDD.cookingDataSetTableAdapters.recetteTableAdapter cookingDataSetrecetteTableAdapter = new Cooking_BDD.cookingDataSetTableAdapters.recetteTableAdapter(); cookingDataSetrecetteTableAdapter.DeleteQuery(items); ActualiseRecette(); }
private void Historique(object sender, RoutedEventArgs e) { ActualiserSolde(); if (commandeDataGrid.Opacity == 0) { Cooking_BDD.cookingDataSet cookingDataSet = ((Cooking_BDD.cookingDataSet)(this.FindResource("cookingDataSet"))); commandeDataGrid.Opacity = 100; // Chargez les données dans la table commande. Vous pouvez modifier ce code selon les besoins. Cooking_BDD.cookingDataSetTableAdapters.commandeTableAdapter cookingDataSetcommandeTableAdapter = new Cooking_BDD.cookingDataSetTableAdapters.commandeTableAdapter(); cookingDataSetcommandeTableAdapter.FillCommande(cookingDataSet.commande, client.ID); System.Windows.Data.CollectionViewSource commandeViewSource = ((System.Windows.Data.CollectionViewSource)(this.FindResource("commandeViewSource"))); commandeViewSource.View.MoveCurrentToFirst(); } else { commandeDataGrid.Opacity = 0; } }
private void MesRecettes(object sender, RoutedEventArgs e) { Buy_cook.Opacity = 0; ADD_recette.Opacity = 0; if (recetteDataGrid.Opacity == 0) { recetteDataGrid.Opacity = 100; Cooking_BDD.cookingDataSet cookingDataSet = ((Cooking_BDD.cookingDataSet)(this.FindResource("cookingDataSet"))); // Chargez les données dans la table recette. Vous pouvez modifier ce code selon les besoins. Cooking_BDD.cookingDataSetTableAdapters.recetteTableAdapter cookingDataSetrecetteTableAdapter = new Cooking_BDD.cookingDataSetTableAdapters.recetteTableAdapter(); cookingDataSetrecetteTableAdapter.Fill_MyRecette(cookingDataSet.recette, client.ID_cdr); System.Windows.Data.CollectionViewSource recetteViewSource = ((System.Windows.Data.CollectionViewSource)(this.FindResource("recetteViewSource"))); recetteViewSource.View.MoveCurrentToFirst(); } else { recetteDataGrid.Opacity = 0; } }
private void Add_recette(object sender, RoutedEventArgs e) { Buy_cook.Opacity = 0; recetteDataGrid.Opacity = 0; if (ADD_recette.Opacity == 0) { Cooking_BDD.cookingDataSet cookingDataSet = ((Cooking_BDD.cookingDataSet)(this.FindResource("cookingDataSet"))); // TODO: ajoutez du code ici pour charger les données dans la table product. // Impossible de générer ce code, car la méthode cookingDataSetproductTableAdapter.Fill est manquante ou a des paramètres non reconnus. Cooking_BDD.cookingDataSetTableAdapters.productTableAdapter cookingDataSetproductTableAdapter = new Cooking_BDD.cookingDataSetTableAdapters.productTableAdapter(); cookingDataSetproductTableAdapter.FillByName(cookingDataSet.product); System.Windows.Data.CollectionViewSource productViewSource = ((System.Windows.Data.CollectionViewSource)(this.FindResource("productViewSource"))); productViewSource.View.MoveCurrentToFirst(); ADD_recette.Opacity = 100; } else { ADD_recette.Opacity = 0; } }