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