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 Add_product(object sender, RoutedEventArgs e)
{
Cooking_BDD.cookingDataSetTableAdapters.productTableAdapter cookingDataSetproductTableAdapter = new Cooking_BDD.cookingDataSetTableAdapters.productTableAdapter();
cookingDataSetproductTableAdapter.InsertProduct(name_produit.Text, cat_produit.Text, unit_produit.Text, Convert.ToInt32(stock.Text), Convert.ToInt32(max_stock.Text), Convert.ToInt32(min_stock.Text));
Actualiser_Produit();
Cooking_BDD.cookingDataSetTableAdapters.vendTableAdapter vendDataSetproductTableAdapter = new Cooking_BDD.cookingDataSetTableAdapters.vendTableAdapter();
string id = Convert.ToString(CommandR("select id_fournisseur from fournisseur where name_fournisseur='" + Name_fournisseur.Text + "';")[0]);
vendDataSetproductTableAdapter.InsertQuery(name_produit.Text, id);
name_produit.Text = "";
cat_produit.Text = "";
unit_produit.Text = "";
stock.Text = "";
min_stock.Text = "";
max_stock.Text = "";
}
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;
}
}
