// Définition d'une liste 'ListeSeries' observable de 'Série' public Ops_caisse() { InitializeComponent(); dpiDateOperation.IsTodayHighlighted = true; dpiDateOperation.SelectedDate = DateTime.Today; dpiDateOperation.IsTodayHighlighted = true; dpiDateOperation2.SelectedDate = DateTime.Today; dpiDateOperation2.IsTodayHighlighted = true; CultureInfo ci = CultureInfo.CreateSpecificCulture(CultureInfo.CurrentCulture.Name); ci.DateTimeFormat.ShortDatePattern = "yyyy-MM-dd"; Thread.CurrentThread.CurrentCulture = ci; objet_realiser = new RealiserBE(); string op = "%"; if (cmbOperation2.SelectedValue != null) { op = cmbOperation2.SelectedValue.ToString(); } date = DateTime.Today.Date.ToShortDateString(); motif = txtMotif2.Text; string critere = "dateop = " + "'" + date + "' AND codeop LIKE " + "'" + op + "' AND motif LIKE " + "'" + motif + "%'"; //MessageBox.Show(critere); List <String> listTypes = new List <string>(); //operations = new List<OperationBE>(); types = new List <TypeoperationBE>(); realisers = new List <RealiserBE>(); caisseBL = new GestionCaisseBL(); types = caisseBL.listerTypeOperation(); listTypes = caisseBL.listerValeursColonneTypeOperation("codetypeop"); cmbTypeOperation.ItemsSource = listTypes; cmbTypeOperation.SelectedIndex = 0; List <string> liste = new List <string>(); liste = caisseBL.listerValeursColonneTypeOperation("codetypeop"); if (liste != null) { liste.Add("Tout"); cmbOperation2.ItemsSource = liste; } grdListe.DataContext = this; realisers = caisseBL.listerSuivantCritereRealisers(critere); grdListe.ItemsSource = realisers; //initialisation du type pour l'enregistrement typeValidation = "enregistrer"; }
//private DateTime datedebut, datefin; public Etat() { totalEntree = 0; totalSolde = 0; totalSortie = 0; realisers = new List <RealiserBE>(); acheters = new List <AcheterBE>(); payers = new List <PayerBE>(); lignes = new List <LigneEtat>(); InitializeComponent(); List <String> listOps = new List <string>(); caisseBL = new GestionCaisseBL(); dpiDateFin.IsTodayHighlighted = true; dpiDateFin.SelectedDate = DateTime.Today; dpiDateFin.Text = DateTime.Now.ToString(); dpiDateDebut.SelectedDate = DateTime.Today; dpiDateDebut.IsTodayHighlighted = true; dpiDateDebut.Text = DateTime.Now.ToString(); CultureInfo ci = CultureInfo.CreateSpecificCulture(CultureInfo.CurrentCulture.Name); ci.DateTimeFormat.ShortDatePattern = "yyyy-MM-dd"; Thread.CurrentThread.CurrentCulture = ci; listOps = caisseBL.listerValeursColonneTypeOperation("codetypeop"); listOps.Add(CODE_MIXTE); cmbOperation.ItemsSource = listOps; cmbOperation.SelectedIndex = cmbOperation.Items.IndexOf(CODE_MIXTE); realisers = caisseBL.listerSuivantCritereRealisers("dateop = " + "'" + DateTime.Today.Date.ToShortDateString() + "'"); acheters = caisseBL.listerSuivantCritereAcheters("dateachat = " + "'" + DateTime.Today.Date.ToShortDateString() + "'"); payers = caisseBL.listerSuivantCriterePayers_historique("datepaiement = " + "'" + DateTime.Today.Date.ToShortDateString() + "'"); lignes = creerDataSource(realisers, acheters, payers); changementMotif(); grdEtatCaisse.ItemsSource = lignes; grdEtatCaisse.Items.Refresh(); txtEntreePeriode.IsEnabled = false; txtSortiePeriode.IsEnabled = false; txtTotalEntree.IsEnabled = false; txtSoldeTotal.IsEnabled = false; txtAncienSolde.IsEnabled = false; txtSoldePeriode.IsEnabled = false; txtSoldeTotal.IsEnabled = false; txtTotalSolde.IsEnabled = false; txtTotalSortie.IsEnabled = false; }
public Etat_Operation_PrestationUI() { totalEntree = 0; totalSolde = 0; totalSortie = 0; realisers = new List <RealiserBE>(); //acheters = new List<AcheterBE>(); payers = new List <PayerBE>(); lignes = new List <LigneEtat>(); InitializeComponent(); caisseBL = new GestionCaisseBL(); dpiDateFin.IsTodayHighlighted = true; dpiDateFin.SelectedDate = DateTime.Today; dpiDateFin.Text = DateTime.Now.ToString(); dpiDateDebut.SelectedDate = DateTime.Today; dpiDateDebut.IsTodayHighlighted = true; dpiDateDebut.Text = DateTime.Now.ToString(); CultureInfo ci = CultureInfo.CreateSpecificCulture(CultureInfo.CurrentCulture.Name); ci.DateTimeFormat.ShortDatePattern = "yyyy-MM-dd"; Thread.CurrentThread.CurrentCulture = ci; realisers = caisseBL.listerSuivantCritereRealisers("dateop = " + "'" + DateTime.Today.Date.ToShortDateString() + "'"); payers = caisseBL.listerSuivantCriterePayers("datepaiement = " + "'" + DateTime.Today.Date.ToShortDateString() + "'"); lignes = creerDataSource(realisers, payers); changementMotif(); grdEtatCaisse.ItemsSource = lignes; grdEtatCaisse.Items.Refresh(); txtEntreePeriode.IsEnabled = false; txtSortiePeriode.IsEnabled = false; txtTotalEntree.IsEnabled = false; txtSoldeTotal.IsEnabled = false; txtAncienSolde.IsEnabled = false; txtSoldePeriode.IsEnabled = false; txtSoldeTotal.IsEnabled = false; txtTotalSolde.IsEnabled = false; txtTotalSortie.IsEnabled = false; }
private void valider_Click(object sender, RoutedEventArgs e) { if (validerFormulaire()) { string typeop = ""; //c'est un nouvel enregistrement if (typeValidation == "enregistrer") { stype = cmbTypeOperation.SelectedValue.ToString(); //soperation = cmbOperation.SelectedValue.ToString(); smotif = txtMotif.Text; if (stype == "entree") { smotif = "Encaissement - " + smotif; typeop = "Bon d'Encaissement"; } else { smotif = "Decaissement - " + smotif; typeop = "Bon de Decaissement"; } smontant = Convert.ToDecimal(txtMontant.Text); sdate = (DateTime)dpiDateOperation.SelectedDate; concerne = txtConcerne.Text; numero = caisseBL.getNumeroSuivant(); RealiserBE realiser = new RealiserBE(stype, Ecole.UI.ConnexionUI.utilisateur.login, numero, smotif, smontant, sdate, concerne); //MessageBox.Show(numero); //enregistrement dans la BD if (caisseBL.enregistrerRealiser(realiser)) { CreerEtat etat = new CreerEtat("bordorau-" + DateTime.Today.ToShortDateString(), typeop + " N° " + realiser.numeroop); etat.bordoreauOperation(realiser); } else { MessageBox.Show("Enregistrement échoué"); } } else //c'est une modification { RealiserBE realiser = new RealiserBE(); realiser = caisseBL.rechercherByNumeroRealiser(objet_realiser); realiser.motif = txtMotif.Text; realiser.montant = Convert.ToDecimal(txtMontant.Text); realiser.dateop = (DateTime)dpiDateOperation.SelectedDate; realiser.concerne = txtConcerne.Text; //modification dans la BD if (caisseBL.modifierRealiser(realiser)) { CreerEtat etat = new CreerEtat("bordorau-" + DateTime.Today.ToShortDateString(), "Bon d' " + realiser.motif.Split('-')[0] + " N° " + realiser.numeroop); etat.bordoreauOperation(realiser); } else { MessageBox.Show("Mise à jour échouée"); } cmbTypeOperation.IsEnabled = true; //cmbOperation.IsEnabled = true; typeValidation = "enregistrer"; } //recuperation des valeurs des conditions pour la recherche des objets realisers string op = "%"; if (cmbOperation2.SelectedValue != null) { op = cmbOperation2.SelectedValue.ToString(); } //if (dpiDateOperation2.SelectedDate != null) // date = dpiDateOperation2.SelectedDate.Value.Date.ToShortDateString(); motif = txtMotif2.Text; string critere = "dateop = " + "'" + date + "' AND codeop LIKE " + "'" + op + "' AND motif LIKE " + "'%" + motif + "%'"; //MessageBox.Show(critere); realisers = caisseBL.listerSuivantCritereRealisers(critere); grdListe.ItemsSource = realisers; grdListe.Items.Refresh(); txtMontant.Clear(); txtMotif.Clear(); txtConcerne.Clear(); cmbTypeOperation.Text = ""; //cmbOperation.Text = ""; dpiDateOperation.IsTodayHighlighted = true; dpiDateOperation2.IsTodayHighlighted = true; } else { MessageBox.Show("Renseigner tous les champs", "School brain : Message d'alerte"); } }
/** * fonction qui recupere les conditions pour alimenter la datagrid */ private void chargerDataGrid() { CultureInfo ci = CultureInfo.CreateSpecificCulture(CultureInfo.CurrentCulture.Name); ci.DateTimeFormat.ShortDatePattern = "yyyy-MM-dd"; Thread.CurrentThread.CurrentCulture = ci; CultureInfo elGR = CultureInfo.CreateSpecificCulture("el-GR"); List <RealiserBE> listes = new List <RealiserBE>(); List <PayerBE> payers_avant = new List <PayerBE>(); lignes = new List <LigneEtat>(); decimal montantEntrees, montantSorties, solde; string datefin = DateTime.Today.Date.ToShortDateString(); string datedebut = DateTime.Today.Date.ToShortDateString(); if (dpiDateFin.SelectedDate != null) { datefin = dpiDateFin.SelectedDate.Value.Date.ToShortDateString(); } if (dpiDateDebut.SelectedDate != null) { datedebut = dpiDateDebut.SelectedDate.Value.Date.ToShortDateString(); } OperationBE operation = new OperationBE(); if (datefin.CompareTo(datedebut) >= 0) { listes = caisseBL.listerSuivantCritereRealisers("dateop between " + "'" + datedebut + "' AND " + "'" + datefin + "'"); realisers = new List <RealiserBE>(); payers = new List <PayerBE>(); foreach (RealiserBE r in listes) { realisers.Add(r); } payers = caisseBL.listerSuivantCriterePayers("datepaiement between " + "'" + datedebut + "' AND " + "'" + datefin + "'"); lignes = creerDataSource(realisers, payers); //calcul du montant des entrees et des sorties montantSorties = 0; montantEntrees = 0; if (listes != null) { foreach (RealiserBE r in listes) { //operation.codeOp = r.codeop; //operation = caisseBL.rechercherOperation(operation); if (r.codeop == "entree") { montantEntrees += r.montant; } else { montantSorties += r.montant; } } } if (payers != null) { foreach (PayerBE p in payers) { montantEntrees += (decimal)p.montant; } } //calcul du solde avant la date de debut listes = caisseBL.listerSuivantCritereRealisers("dateop < " + "'" + datedebut + "'"); payers_avant = caisseBL.listerSuivantCriterePayers("datepaiement < " + "'" + datedebut + "'"); //operation = new OperationBE(); solde = 0; if (listes != null) { foreach (RealiserBE r in listes) { //operation.codeOp = r.codeop; //operation = caisseBL.rechercherOperation(operation); if (r.codeop == "entree") { solde += r.montant; } else { solde -= r.montant; } } } if (payers_avant != null) { foreach (PayerBE p in payers_avant) { solde += (decimal)p.montant; } } listes = caisseBL.listerTousRealiser(); payers_avant = caisseBL.listerTousPayer(); //operation = new OperationBE(); soldetotal = 0; if (listes != null) { foreach (RealiserBE r in listes) { //operation.codeOp = r.codeop; //operation = caisseBL.rechercherOperation(operation); if (r.codeop == "entree") { soldetotal += r.montant; } else { soldetotal -= r.montant; } } } if (payers_avant != null) { foreach (PayerBE p in payers_avant) { soldetotal += (decimal)p.montant; } } txtEntreePeriode.Text = montantEntrees.ToString("0,0", elGR); txtSortiePeriode.Text = montantSorties.ToString("0,0", elGR); txtSoldePeriode.Text = (montantEntrees - montantSorties).ToString("0,0", elGR); txtAncienSolde.Text = solde.ToString("0,0", elGR); txtSoldeTotal.Text = soldetotal.ToString("0,0", elGR); string motif = txtMotif.Text; decimal entree = 0, sortie = 0; List <LigneEtat> tampon = new List <LigneEtat>(); foreach (LigneEtat l in lignes) { if (motif == "" || l.motif.ToUpper().Contains(motif.ToUpper())) { tampon.Add(l); } } lignes = new List <LigneEtat>(); foreach (LigneEtat l in tampon) { lignes.Add(l); if (l.type.ToLower() == "entree") { entree += l.montant; } else { sortie += l.montant; } } grdEtatCaisse.ItemsSource = lignes; grdEtatCaisse.Items.Refresh(); txtTotalEntree.Text = entree.ToString("0,0", elGR); txtTotalSolde.Text = (entree - sortie).ToString("0,0", elGR); txtTotalSortie.Text = sortie.ToString("0,0", elGR); totalEntree = entree; totalSortie = sortie; totalSolde = (entree - sortie); } else { MessageBox.Show("La date de debut doit être plus petite ou égale à la date de fin"); lignes = new List <LigneEtat>(); grdEtatCaisse.ItemsSource = lignes; grdEtatCaisse.Items.Refresh(); } }
//private DateTime datedebut, datefin; public InsolvablesUI() { classe = new ClasseBE(); listClasses = new List <string>(); listInscrits = new List <InscrireBE>(); listLigneInsolvable = new List <LigneInsolvable>(); eleveBL = new GestionEleveDuneClasseBL(); journalBL = new GestionJournalBL(); InitializeComponent(); //Obtenir la liste des classes et les ajouter au comboBox des classes listClasses = eleveBL.listerValeursColonneClasse("codeclasse"); cmbClasse.ItemsSource = listClasses; txtAnnee.Text = eleveBL.anneeEnCours().ToString(); txtAnneeScolaire.Text = ((Convert.ToInt32(txtAnnee.Text.ToString())) - 1).ToString() + "/" + txtAnnee.Text; //Charger le comboBox des observations List <String> listObservations = new List <string>(); listObservations.Add("OK"); listObservations.Add("INSOLVABLE"); listObservations.Add(CODE_MIXTE); cmbObservation.ItemsSource = listObservations; cmbObservation.SelectedIndex = cmbObservation.Items.IndexOf(CODE_MIXTE); //mettre la date d'aujourdui dpiDate.SelectedDate = DateTime.Today; dpiDate.Text = DateTime.Today.ToShortDateString(); //charger la grille caisseBL = new GestionCaisseBL(); CultureInfo ci = CultureInfo.CreateSpecificCulture(CultureInfo.CurrentCulture.Name); ci.DateTimeFormat.ShortDatePattern = "yyyy-MM-dd"; Thread.CurrentThread.CurrentCulture = ci; // cmbOperation.ItemsSource = listOps; // cmbOperation.SelectedIndex = cmbOperation.Items.IndexOf(CODE_MIXTE); realisers = caisseBL.listerSuivantCritereRealisers("dateop = " + "'" + DateTime.Today.Date.ToShortDateString() + "'"); acheters = caisseBL.listerSuivantCritereAcheters("dateachat = " + "'" + DateTime.Today.Date.ToShortDateString() + "'"); payers = caisseBL.listerSuivantCriterePayers("datepaiement = " + "'" + DateTime.Today.Date.ToShortDateString() + "'"); lignes = creerDataSource(realisers, acheters, payers); // changementMotif(); //grdEtatCaisse.ItemsSource = lignes; //grdEtatCaisse.Items.Refresh(); //dpiDateFin.IsTodayHighlighted = true; //dpiDateFin.SelectedDate = DateTime.Today; //dpiDateFin.Text = DateTime.Now.ToString(); //dpiDateDebut.SelectedDate = DateTime.Today; //dpiDateDebut.IsTodayHighlighted = true; //dpiDateDebut.Text = DateTime.Now.ToString(); //txtEntreePeriode.IsEnabled = false; //txtSortiePeriode.IsEnabled = false; //txtTotalEntree.IsEnabled = false; //txtSoldeTotal.IsEnabled = false; //txtAncienSolde.IsEnabled = false; //txtSoldePeriode.IsEnabled = false; //txtSoldeTotal.IsEnabled = false; //txtTotalSolde.IsEnabled = false; //txtTotalSortie.IsEnabled = false; }