public SortieArticleUI()
{
InitializeComponent();
dpiDateOp.SelectedDate = DateTime.Today;
dpiDateOp.IsTodayHighlighted = true;
dpiDateOp.Text = DateTime.Now.ToString();
eleves = new List <string>();
classes = new List <string>();
achats_setarticle = new List <string>();
articleBL = new GestionArticleBL();
stockers = new List <StockerBE>();
ListeArticles1 = new ObservableCollection <ArticleBE>();
ListeArticles2 = new ObservableCollection <ArticleQTBE>();
CultureInfo ci = CultureInfo.CreateSpecificCulture(CultureInfo.CurrentCulture.Name);
ci.DateTimeFormat.ShortDatePattern = "yyyy-MM-dd";
Thread.CurrentThread.CurrentCulture = ci;
ancien_acheter = new AcheterBE();
classes = articleBL.listerValeurColonneClasse("codeclasse");
cmbClasse.ItemsSource = classes;
cmbClasse.SelectedIndex = 0;
setarticle = new SetarticleBE();
eleve = new EleveBE();
annee = articleBL.anneeEnCours();
txtAnnee.Text = " / " + annee;
txtAnneeScolaire.Text = (annee - 1).ToString();
chargerListeEleves();
LArticleBE = articleBL.listerTousLesArticle();
RemplirDataGrid1(LArticleBE);
typeOperation = ENREGISTRER;
radioEnregistrement.IsChecked = true;
}
private void grdListePaiement_KeyUp(object sender, KeyEventArgs e)
{
if (e.Key == Key.Delete)
{
if (MessageBox.Show("Voulez vous supprimer?", "School : Confirmation", System.Windows.MessageBoxButton.YesNo) == MessageBoxResult.Yes)
{
if (grdListePaiement.SelectedIndex != -1)
{
AcheterBE acheter = new AcheterBE();
SetarticleBE setarticle = new SetarticleBE();
acheter = acheters.ElementAt(grdListePaiement.SelectedIndex);
setarticle.codesetarticle = acheter.codesetarticle;
setarticle = articleBL.rechercherSetArticle(setarticle);
articleBL.incrementerStock(setarticle, acheter.quantite, annee);
acheters.Remove(acheter);
articleBL.supprimerAcheter(acheter);
grdListePaiement.ItemsSource = acheters;
grdListePaiement.Items.Refresh();
}
else
{
MessageBox.Show("Aucune ligne sélectionnée", "School brain:Alerte");
}
}
}
}
internal string obtenirNomSetArticle(string p)
{
SetarticleBE set = new SetarticleBE();
set.codesetarticle = p;
set = setArticleDA.rechercher(set);
return(set.nomsetarticle);
}
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;
}
// modifier un set Article
public bool modifierSetArticle(SetarticleBE setArticle)
{
if (setArticleDA.modifier(setArticle))
{
journalDA.journaliser("modification du set article de code " + setArticle.codesetarticle + ". nouveau code : " + setArticle.codesetarticle + ", nouveau nom : " + setArticle.nomsetarticle);
return(true);
}
return(false);
}
// supprimer un set Article
public bool supprinerSetArticle(SetarticleBE setArticle)
{
if (setArticleDA.supprimer(setArticle))
{
journalDA.journaliser("suppression du set article de code " + setArticle.codesetarticle + " et de nom " + setArticle.nomsetarticle);
return(true);
}
return(false);
}
//creer un Set Article
public bool creerSetArticle(SetarticleBE setArticle)
{
if (setArticleDA.ajouter(setArticle))
{
journalDA.journaliser("enregistrement d'un set article de code " + setArticle.codesetarticle + " et de nom " + setArticle.nomsetarticle);
return(true);
}
return(false);
}
private void cmdSupprimer_Click(object sender, RoutedEventArgs e)
{
if (cmbCodeSet.Text != null && cmbCodeSet.Text != "")
{
if (MessageBox.Show("Voulez-vous vraiment le supprimer ? ", "School : Confimation", MessageBoxButton.YesNo) == MessageBoxResult.Yes)
{
SetarticleBE setArticle = new SetarticleBE();
setArticle.codesetarticle = cmbCodeSet.Text;
if (modifierSetArticleBL.supprinerSetArticle(setArticle))
{
MessageBox.Show("Set Article supprimé ! ");
//on met à jour le formulaire
cmbCodeSet.Text = null;
//txtAnnee.Text = "";
ParametresBE param = modifierSetArticleBL.getParametres();
if (param != null)
{
annee = param.annee;
txtAnnee.Text = Convert.ToString(param.annee);
txtAnneeScolaire.Text = (param.annee - 1).ToString();
}
else
{
txtAnnee.Text = "";
txtAnneeScolaire.Text = "";
}
txtMontant.Text = "";
txtNomSet.Text = "";
ListeArticles1.Clear();
ListeArticles2.Clear();
grdListeArticle1.ItemsSource = ListeArticles1;
grdListeArticle2.ItemsSource = ListeArticles2;
List <SetarticleBE> LSetArticle = modifierSetArticleBL.listerTousLesSetArticle();
//lister les codes des sets Articles
cmbCodeSet.ItemsSource = getListCodeSetArticle(LSetArticle);
//fin de mise à jour du formulaire
}
else
{
MessageBox.Show("Echec de suppression du Set Article ! ");
}
}
}
else
{
MessageBox.Show("Vous devez dabor choisir le Set à supprimer !");
}
}
private void cmbArticle_SelectionChanged(object sender, SelectionChangedEventArgs e)
{
CultureInfo elGR = CultureInfo.CreateSpecificCulture("el-GR");
if (cmbArticle.SelectedValue != null)
{
setarticle = new SetarticleBE();
setarticle.codesetarticle = cmbArticle.SelectedValue.ToString();
setarticle = articleBL.rechercherSetArticle(setarticle);
lblMontant.Content = setarticle.montant.ToString("0,0", elGR);
}
}
private void cmbArticle_DropDownClosed(object sender, EventArgs e)
{
if (cmbArticle.SelectedValue != null && cmbArticle.Text != "")
{
setarticle = new SetarticleBE();
setarticle.codesetarticle = cmbArticle.SelectedValue.ToString();
setarticle = articleBL.rechercherSetArticle(setarticle);
lblNomSetArticle.Content = setarticle.nomsetarticle;
lblPrix.Content = setarticle.montant.ToString();
AcheterBE a = acheters.ElementAt(achats_setarticle.IndexOf(cmbArticle.Text));
txtQuantite.Text = a.quantite.ToString();
lignesStockerDuneVente();
}
}
private void cmbEleve_DropDownClosed(object sender, EventArgs e)
{
if (cmbEleve.Text != null && cmbEleve.Text != "")
{
string nommat = cmbEleve.Text;
txtMatricule.Text = nommat.Split('-')[0].Trim();
acheters = new List <AcheterBE>();
achats_setarticle = new List <string>();
acheters = articleBL.listerSuivantCritereAcheters(" matricule = " + "'" + txtMatricule.Text + "' AND annee = " + "'" + annee + "'");
if (acheters != null && acheters.Count > 0)
{
foreach (AcheterBE a in acheters)
{
achats_setarticle.Add(a.codesetarticle);
}
cmbArticle.ItemsSource = achats_setarticle;
cmbArticle.Items.Refresh();
cmbArticle.SelectedIndex = 0;
setarticle = new SetarticleBE();
setarticle.codesetarticle = achats_setarticle.ElementAt(0);
setarticle = articleBL.rechercherSetArticle(setarticle);
lblNomSetArticle.Content = setarticle.nomsetarticle;
lblPrix.Content = setarticle.montant.ToString();
txtQuantite.Text = acheters.ElementAt(0).quantite.ToString();
lignesStockerDuneVente();
}
else
{
achats_setarticle = new List <string>();
cmbArticle.Text = "";
cmbArticle.ItemsSource = achats_setarticle;
cmbArticle.Items.Refresh();
lblNomSetArticle.Content = "";
lblPrix.Content = "";
txtQuantite.Text = "";
ListeArticles2.Clear();
grdListeArticle2.ItemsSource = ListeArticles2;
RemplirDataGrid1(LArticleBE);
}
}
}
public VenteArticleUI()
{
InitializeComponent();
listSet = new List <string>();
listSet2 = new List <string>();
eleves = new List <string>();
classes = new List <string>();
articleBL = new GestionArticleBL();
dpiDate.SelectedDate = DateTime.Today;
dpiDate.IsTodayHighlighted = true;
dpiDate.Text = DateTime.Now.ToString();
dpiDateOp.SelectedDate = DateTime.Today;
dpiDateOp.IsTodayHighlighted = true;
dpiDateOp.Text = DateTime.Now.ToString();
CultureInfo ci = CultureInfo.CreateSpecificCulture(CultureInfo.CurrentCulture.Name);
ci.DateTimeFormat.ShortDatePattern = "yyyy-MM-dd";
Thread.CurrentThread.CurrentCulture = ci;
ancien_acheter = new AcheterBE();
classes = articleBL.listerValeurColonneClasse("codeclasse");
cmbClasse.ItemsSource = classes;
typeValidation = "enregistrer";
acheters = articleBL.listerSuivantCritereAcheters("dateachat = " + "'" + DateTime.Today.Date.ToShortDateString() + "'");
setarticle = new SetarticleBE();
eleve = new EleveBE();
listSet = articleBL.listerValeursColonneSetArticle("codesetarticle");
listSet2 = articleBL.listerValeursColonneSetArticle("codesetarticle");
listSet2.Add(TOUT);
cmbArticle.ItemsSource = listSet;
cmbArticle2.ItemsSource = listSet2;
annee = articleBL.anneeEnCours();
txtAnnee.Text = " / " + annee;
txtAnneeScolaire.Text = (annee - 1).ToString();
grdListePaiement.ItemsSource = acheters;
}
private void cmdNouveauSet_Click(object sender, RoutedEventArgs e)
{
NouveauSetArticleUI dialog = new NouveauSetArticleUI();
dialog.ShowDialog();
try
{
string code = dialog.code;
string designation = dialog.designation;
decimal montant = dialog.montant;
if (code == "" & designation == "" & montant == 0)
{
}
else if (code == "" || designation == "" || montant == 0)
{
MessageBox.Show("Un set ne peut pas avoir les champs vides", "School brain:Information", MessageBoxButton.OK, MessageBoxImage.Information);
}
else
{
SetarticleBE set = new SetarticleBE(code, annee, designation, montant);
if (articleBL.ajouterSetArticle(set))
{
listSet.Add(code);
cmbArticle.ItemsSource = listSet;
cmbArticle.SelectedIndex = listSet.IndexOf(code);
cmbArticle.Items.Refresh();
CultureInfo elGR = CultureInfo.CreateSpecificCulture("el-GR");
lblMontant.Content = montant.ToString("0,0", elGR);
MessageBox.Show("Nouveau set créé", "School brain:Information", MessageBoxButton.OK, MessageBoxImage.Information);
}
else
{
MessageBox.Show("Nouveau set non enregistré, il doit être déjà créé dans le système", "School brain:Information", MessageBoxButton.OK, MessageBoxImage.Information);
}
}
}
catch (Exception) { }
}
internal void decrementerStock(SetarticleBE setarticle, int nombre, int annee)
{
if (setarticle != null)
{
StockerBE stocker = new StockerBE();
composers = composerDA.listerSuivantCritere("codesetarticle LIKE " + "'" + setarticle.codesetarticle + "'");
foreach (ComposerBE c in composers)
{
stocker = new StockerBE();
stocker.annee = annee;
stocker.codeArticle = c.codeArticle;
StockerBE dernier_stock = new StockerBE();
dernier_stock.codeArticle = c.codeArticle;
dernier_stock = stockerDA.rechercherDernierEnregistrement(stocker);
if (dernier_stock != null)
{
if (dernier_stock.annee < stocker.annee)
{
stocker.stockDebut = dernier_stock.stockRestant;
}
else
{
stocker.stockDebut = dernier_stock.stockDebut;
}
stocker.stockRestant = dernier_stock.stockRestant - (nombre * c.quantite);
stocker.quantiteVendue = (nombre * c.quantite);
stocker.quantiteAchetee = 0;
stocker.puArticle = dernier_stock.puArticle;
stocker.dateOperation = DateTime.Today;
stocker.codeMagasin = dernier_stock.codeMagasin;
stockerDA.ajouter(stocker);
}
}
}
}
internal bool ajouterSetArticle(SetarticleBE set)
{
return(setarticleDA.ajouter(set));
}
// rechercher un set Article
public SetarticleBE rechercherSetArticle(SetarticleBE setArticle)
{
return(setArticleDA.rechercher(setArticle));
}
private void cmdValider_Click(object sender, RoutedEventArgs e)
{
//MessageBox.Show("code : " + articleQt.codeArticle+" Quantite : "+articleQt.quantite);
if ((txtCodeSet.Text != null && txtNomSet.Text != null && txtMontant.Text != null && txtAnneeScolaire.Text != null) && (txtCodeSet.Text != "" && txtNomSet.Text != "" && txtMontant.Text != "" && txtAnneeScolaire.Text != ""))
{
SetarticleBE setArticle = new SetarticleBE();
setArticle.codesetarticle = Convert.ToString(txtCodeSet.Text);
setArticle.nomsetarticle = Convert.ToString(txtNomSet.Text);
setArticle.annee = Convert.ToInt16(txtAnnee.Text);
setArticle.montant = Convert.ToDecimal(txtMontant.Text);
// on recherche si un set ayant le même code n'existe pas deja
if (creerSetArticleBL.rechercherSetArticle(setArticle) != null)
{
MessageBox.Show("Un set Article de code '" + setArticle.codesetarticle + "' existe deja dans le système \n \n Veuillez changer le code SVP !");
}
else
{ //on vérifit que toutes les quantités saisis sont des entiers et qu'ils sont positif
bool trouve = false;
foreach (var row in grdListeArticle2.ItemsSource)
{
ArticleQTBE articleQt = (ArticleQTBE)row;
// maintenant on enregistre la composition des articles dans le set
ComposerBE composer = new ComposerBE();
composer.codeArticle = articleQt.codeArticle;
composer.annee = Convert.ToInt16(txtAnnee.Text);
composer.codeSetArticle = txtCodeSet.Text;
composer.quantite = articleQt.quantite;
// on enregistre les informations dans la table composer
if (composer.quantite < 0)
{
trouve = true;
break;
}
}
if (trouve == true)
{
MessageBox.Show("Les quantités ne peuvent pas êtres des valeurs négatives !");
}
else if (creerSetArticleBL.creerSetArticle(setArticle))
{ // le set Article est enregistré
MessageBox.Show("Enregistrement Set Article [code set : " + setArticle.codesetarticle + ", annee : " + setArticle.annee + ", nom set : " + setArticle.nomsetarticle + ", Montant : " + setArticle.montant + "] réussit !");
bool verif = true; // vérifi si tous les enregistrements ont été effectuées
foreach (var row in grdListeArticle2.ItemsSource)
{
ArticleQTBE articleQt = (ArticleQTBE)row;
// maintenant on enregistre la composition des articles dans le set
ComposerBE composer = new ComposerBE();
composer.codeArticle = articleQt.codeArticle;
composer.annee = Convert.ToInt16(txtAnnee.Text);
composer.codeSetArticle = txtCodeSet.Text;
composer.quantite = articleQt.quantite;
// on enregistre les informations dans la table composer
if (!creerSetArticleBL.creerCompositionSetArticle(composer))
{
verif = false;
}
}
if (verif == true)
{
MessageBox.Show("Enregistrement de la composition du set réussit !");
// on reinitialise les champs du formulaire
//txtAnnee.Text = "";
ParametresBE param = creerSetArticleBL.getParametres();
if (param != null)
{
annee = param.annee;
txtAnnee.Text = Convert.ToString(param.annee);
txtAnneeScolaire.Text = (param.annee - 1).ToString();
}
else
{
txtAnnee.Text = "";
txtAnneeScolaire.Text = "";
}
txtCodeSet.Text = "";
txtMontant.Text = "";
txtNomSet.Text = "";
List <ArticleBE> listArticle = creerModifierArticleBL.listerTousLesArticle();
RemplirDataGrid1(listArticle);
ListeArticles2.Clear();
grdListeArticle2.ItemsSource = ListeArticles2;
}
else
{
MessageBox.Show("Echec Enregistrement de la composition du set !");
}
}
else
{
MessageBox.Show("Echec l'ors de l'enregistrement du set Article");
}
}
}
else
{
MessageBox.Show("tous les champs doivent êtres remplis !");
}
}
private void cmdValider_Click(object sender, RoutedEventArgs e)
{
//MessageBox.Show("code : " + articleQt.codeArticle+" Quantite : "+articleQt.quantite);
if ((cmbCodeSet.Text != null && txtNomSet.Text != null && txtMontant.Text != null && txtAnneeScolaire.Text != null) && (cmbCodeSet.Text != "" && txtNomSet.Text != "" && txtMontant.Text != "" && txtAnneeScolaire.Text != ""))
{
SetarticleBE setArticle = new SetarticleBE();
setArticle.codesetarticle = Convert.ToString(cmbCodeSet.Text);
setArticle.nomsetarticle = Convert.ToString(txtNomSet.Text);
setArticle.annee = Convert.ToInt16(txtAnnee.Text);
setArticle.montant = Convert.ToDecimal(txtMontant.Text);
//on vérifit que toutes les quantités saisis sont des entiers et qu'ils sont positif
bool trouve = false;
foreach (var row in grdListeArticle2.ItemsSource)
{
ArticleQTBE articleQt = (ArticleQTBE)row;
// maintenant on enregistre la composition des articles dans le set
ComposerBE composer = new ComposerBE();
composer.codeArticle = articleQt.codeArticle;
composer.annee = Convert.ToInt16(txtAnnee.Text);
composer.codeSetArticle = cmbCodeSet.Text;
composer.quantite = articleQt.quantite;
// on enregistre les informations dans la table composer
if (composer.quantite < 0)
{
trouve = true;
break;
}
}
if (trouve == true)
{
MessageBox.Show("Les quantités ne peuvent pas êtres des valeurs négatives !");
}
else if (modifierSetArticleBL.modifierSetArticle(setArticle))
{ // le set Article est enregistré
MessageBox.Show("Enregistrement Set Article [code set : " + setArticle.codesetarticle + ", annee : " + setArticle.annee + ", nom set : " + setArticle.nomsetarticle + ", Montant : " + setArticle.montant + "] réussit !");
//on supprime l'ancienne composition du set
List <ComposerBE> LComposer = modifierSetArticleBL.listerComposerSuivantCrietere("codesetarticle ='" + setArticle.codesetarticle + "'");
for (int i = 0; i < LComposer.Count; i++)
{
modifierSetArticleBL.supprimerComposer(LComposer.ElementAt(i));
}
bool verif = true; // vérifi si tous les enregistrements ont été effectuées
foreach (var row in grdListeArticle2.ItemsSource)
{
ArticleQTBE articleQt = (ArticleQTBE)row;
// maintenant on enregistre la composition des articles dans le set
ComposerBE composer = new ComposerBE();
composer.codeArticle = articleQt.codeArticle;
composer.annee = Convert.ToInt16(txtAnnee.Text);
composer.codeSetArticle = cmbCodeSet.Text;
composer.quantite = articleQt.quantite;
// on enregistre les informations dans la table composer
if (!modifierSetArticleBL.creerCompositionSetArticle(composer))
{
verif = false;
}
}
if (verif == true)
{
MessageBox.Show("Enregistrement de la composition du set réussit !");
cmbCodeSet.Text = null;
//txtAnnee.Text = "";
ParametresBE param = modifierSetArticleBL.getParametres();
if (param != null)
{
annee = param.annee;
txtAnnee.Text = Convert.ToString(param.annee);
txtAnneeScolaire.Text = (param.annee - 1).ToString();
}
else
{
txtAnnee.Text = "";
txtAnneeScolaire.Text = "";
}
txtMontant.Text = "";
txtNomSet.Text = "";
ListeArticles1.Clear();
ListeArticles2.Clear();
grdListeArticle1.ItemsSource = ListeArticles1;
grdListeArticle2.ItemsSource = ListeArticles2;
List <SetarticleBE> LSetArticle = modifierSetArticleBL.listerTousLesSetArticle();
//lister les codes des sets Articles
cmbCodeSet.ItemsSource = getListCodeSetArticle(LSetArticle);
}
else
{
MessageBox.Show("Echec mise à jour de la composition du set !");
}
}
else
{
MessageBox.Show("Echec l'ors de la mise à jour du set Article");
}
}
else
{
MessageBox.Show("tous les champs doivent êtres remplis !");
}
}
internal SetarticleBE rechercherSetArticle(SetarticleBE setarticle)
{
return(setarticleDA.rechercher(setarticle));
}
