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