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