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