private void cmdDoubleFlecheGauche_Click(object sender, RoutedEventArgs e)
{
if (ListeArticles2.Count != 0)
{
int numerovente = articleBL.rechercherNumeroAchat(acheters.ElementAt(cmbArticle.SelectedIndex));
for (int i = 0; i < ListeArticles2.Count; i++)
{
ArticleQTBE articleQt = ListeArticles2.ElementAt(i);
ArticleBE article = new ArticleBE();
article.codeArticle = articleQt.codeArticle;
article.codeCatArticle = articleQt.codeCatArticle;
article.designation = articleQt.designation;
ListeArticles1.Add(article);
if (typeOperation == MODIFIER)
{
articleBL.incrementerStock(articleQt.codeArticle, articleQt.quantite, annee, dpiDateOp.SelectedDate.Value, numerovente);
}
}
ListeArticles2.Clear();
//RemplirDataGrid1(LArticleBE);
grdListeArticle1.ItemsSource = ListeArticles1;
grdListeArticle2.ItemsSource = ListeArticles2;
}
}
private void cmdSimpleFlecheGauche_Click(object sender, RoutedEventArgs e)
{
if (grdListeArticle2.SelectedIndex != -1)
{
try
{
ArticleQTBE articleQt = ListeArticles2.ElementAt(grdListeArticle2.SelectedIndex);
ArticleBE article = new ArticleBE();
article.codeArticle = articleQt.codeArticle;
article.codeCatArticle = articleQt.codeCatArticle;
article.designation = articleQt.designation;
ListeArticles2.Remove(ListeArticles2.ElementAt(grdListeArticle2.SelectedIndex));
ListeArticles1.Add(article);
grdListeArticle1.ItemsSource = ListeArticles1;
grdListeArticle2.ItemsSource = ListeArticles2;
if (typeOperation == MODIFIER)
{
int numerovente = articleBL.rechercherNumeroAchat(acheters.ElementAt(cmbArticle.SelectedIndex));
articleBL.incrementerStock(articleQt.codeArticle, articleQt.quantite, annee, dpiDateOp.SelectedDate.Value, numerovente);
}
}
catch (Exception exp) { Console.WriteLine(exp.Message); }
}
}
private void cmbCodeSet_SelectionChanged(object sender, SelectionChangedEventArgs e)
{
// on récupère le code du Set choisi
String codeSetArticle = Convert.ToString(cmbCodeSet.SelectedItem);
//on recherche le set dans la BD
if (modifierSetArticleBL.listerSetArticleSuivantCritere("codesetarticle = '" + codeSetArticle + "'").Count != 0)
{
SetarticleBE setArticle = modifierSetArticleBL.listerSetArticleSuivantCritere("codesetarticle = '" + codeSetArticle + "'")[0];
//on charge les informations du set dans le formulaire
txtNomSet.Text = setArticle.nomsetarticle;
txtAnnee.Text = Convert.ToString(setArticle.annee);
txtMontant.Text = Convert.ToString(setArticle.montant).Split(',')[0];
}
//on recherche la composition du set Article
List <ComposerBE> LCompser = modifierSetArticleBL.listerComposerSuivantCrietere("codesetarticle ='" + codeSetArticle + "'");
//on charge les articles obtenu dans la datagrid2
List <ArticleQTBE> LArticleQt = new List <ArticleQTBE>();
ListeArticles2.Clear();
for (int i = 0; i < LCompser.Count; i++)
{
ArticleQTBE articleQt = new ArticleQTBE();
ComposerBE composer = LCompser.ElementAt(i);
List <ArticleBE> listArticle = creerModifierArticleBL.listerArticleSuivantCritere("codearticle ='" + composer.codeArticle + "'");
if (listArticle != null && listArticle.Count != 0)
{
ArticleBE article = listArticle.ElementAt(0);
articleQt.codeArticle = article.codeArticle;
articleQt.codeCatArticle = article.codeCatArticle;
articleQt.designation = article.designation;
articleQt.quantite = composer.quantite;
}
ListeArticles2.Add(articleQt);
}
grdListeArticle2.ItemsSource = ListeArticles2;
//on charge le reste d'article dans le datagrid1
List <ArticleBE> LArticle = creerModifierArticleBL.listerTousLesArticle();
ListeArticles1.Clear();
for (int i = 0; i < LArticle.Count; i++)
{
if (modifierSetArticleBL.listerComposerSuivantCrietere("codearticle ='" + LArticle.ElementAt(i).codeArticle + "' AND codesetarticle ='" + codeSetArticle + "'") != null)
{
if (modifierSetArticleBL.listerComposerSuivantCrietere("codearticle ='" + LArticle.ElementAt(i).codeArticle + "' AND codesetarticle ='" + codeSetArticle + "'").Count == 0)
{
ListeArticles1.Add(LArticle.ElementAt(i));
}
}
}
grdListeArticle1.ItemsSource = ListeArticles1;
}
private void cmdDoubleFlecheGau_Click(object sender, RoutedEventArgs e)
{
if (ListeArticles2.Count != 0)
{
for (int i = 0; i < ListeArticles2.Count; i++)
{
ArticleQTBE articleQt = ListeArticles2.ElementAt(i);
ArticleBE article = new ArticleBE();
article.codeArticle = articleQt.codeArticle;
article.codeCatArticle = articleQt.codeCatArticle;
article.designation = articleQt.designation;
ListeArticles1.Add(article);
}
ListeArticles2.Clear();
//RemplirDataGrid1(LArticleBE);
grdListeArticle1.ItemsSource = ListeArticles1;
grdListeArticle2.ItemsSource = ListeArticles2;
}
}
// Fonction permettant de remplir le DataGrid avec les informations de la base de données
// @param : - listObjet : la liste des objets à afficher dans le DataGrid
public void RemplirDataGrid1(List <ArticleBE> listObjet)
{
// Ajout de données dans la DataTable :
var table = new DataTable();
table.Columns.Add(new DataColumn("code", typeof(string)));
table.Columns.Add(new DataColumn("designation", typeof(string)));
if (listObjet != null)
{
for (int i = 0; i < listObjet.Count; i++)
{
DataRow dr = table.NewRow();
dr["code"] = listObjet.ElementAt(i).codeArticle;
//dr["categorie"] = listObjet.ElementAt(i).codeCatArticle;
dr["designation"] = listObjet.ElementAt(i).designation;
table.Rows.Add(dr);
}
}
string vCode = "";
//string vCategorie = "";
string vDesignation = "";
ListeArticles1.Clear();
//Personnes_Table = LoadDataTable();
foreach (DataRow row in table.Rows)
{
vCode = Convert.ToString(row["code"]);
//vCategorie = Convert.ToString(row["categorie"]);
vDesignation = Convert.ToString(row["designation"]);
ArticleBE article = new ArticleBE();
article.codeArticle = vCode;
article.designation = vDesignation;
ListeArticles1.Add(article);
}
}
private void cmdSimpleFlecheGauche_Click(object sender, RoutedEventArgs e)
{
if (grdListeArticle2.SelectedIndex != -1)
{
try
{
ArticleQTBE articleQt = ListeArticles2.ElementAt(grdListeArticle2.SelectedIndex);
ArticleBE article = new ArticleBE();
article.codeArticle = articleQt.codeArticle;
article.codeCatArticle = articleQt.codeCatArticle;
article.designation = articleQt.designation;
ListeArticles2.Remove(ListeArticles2.ElementAt(grdListeArticle2.SelectedIndex));
ListeArticles1.Add(article);
//RemplirDataGrid1(LArticleBE);
grdListeArticle1.ItemsSource = ListeArticles1;
grdListeArticle2.ItemsSource = ListeArticles2;
}
catch (Exception exp) { Console.WriteLine(exp.Message); }
}
}
private void lignesStockerDuneVente()
{
stockers = new List <StockerBE>();
List <ArticleBE> articles = new List <ArticleBE>();
ListeArticles2.Clear();
int numero = articleBL.rechercherNumeroAchat(acheters.ElementAt(cmbArticle.SelectedIndex));
stockers = articleBL.rechercherLigneStocker(numero);
ArticleBE article;
ArticleQTBE a;
articles = articleBL.listerTousLesArticle();
foreach (StockerBE s in stockers)
{
a = new ArticleQTBE();
article = new ArticleBE();
article.codeArticle = s.codeArticle;
article = articleBL.rechercherArticle(article);
a.codeArticle = article.codeArticle;
a.designation = article.designation;
a.codeCatArticle = article.codeCatArticle;
a.quantite = s.quantiteVendue;
ListeArticles2.Add(a);
article = articles.Find(c => c.codeArticle.Equals(article.codeArticle));
articles.Remove(article);
}
ListeArticles1.Clear();
foreach (ArticleBE art in articles)
{
ListeArticles1.Add(art);
}
grdListeArticle2.ItemsSource = ListeArticles2;
grdListeArticle2.Items.Refresh();
grdListeArticle1.ItemsSource = ListeArticles1;
grdListeArticle1.Items.Refresh();
}
public void RemplirDataGrid1(List <ArticleBE> listObjet)
{
var table = new DataTable();
table.Columns.Add(new DataColumn("code", typeof(string)));
table.Columns.Add(new DataColumn("designation", typeof(string)));
if (listObjet != null)
{
for (int i = 0; i < listObjet.Count; i++)
{
DataRow dr = table.NewRow();
dr["code"] = listObjet.ElementAt(i).codeArticle;
dr["designation"] = listObjet.ElementAt(i).designation;
table.Rows.Add(dr);
}
}
string vCode = "";
string vDesignation = "";
ListeArticles1.Clear();
foreach (DataRow row in table.Rows)
{
vCode = Convert.ToString(row["code"]);
vDesignation = Convert.ToString(row["designation"]);
ArticleBE article = new ArticleBE();
article.codeArticle = vCode;
article.designation = vDesignation;
ListeArticles1.Add(article);
}
grdListeArticle1.ItemsSource = ListeArticles1;
grdListeArticle1.Items.Refresh();
}
