public RechercherEleveUI()
{
InitializeComponent();
eleves = new List <string>();
eleveBL = new GestionEleveBL();
annee = eleveBL.AnneeEnCours();
txtAnnee.Text = " / " + annee;
txtAnneeScolaire.Text = (annee - 1).ToString();
classes = new List <string>();
classes = eleveBL.listerValeurColonneClasse("codeclasse");
cmbClasse.ItemsSource = classes;
}
/**
* fonction qui recupere les conditions pour alimenter la datagrid
*/
private void chargerDataGrid()
{
GestionEleveBL eleveBL = new GestionEleveBL();
// List<LigneInsolvable> listLigneInsolvable=new List<LigneInsolvable>();
int annee;
string classe;
string date;
if ((txtAnnee.Text != "") && (cmbClasse.Text.ToString() != "") && (dpiDate.Text.ToString() != ""))
{
annee = Convert.ToInt32(txtAnnee.Text);
classe = cmbClasse.Text.ToString();
date = dpiDate.SelectedDate.Value.Date.ToShortDateString();
listLigneInsolvable = eleveBL.getListeInsolvable(classe, annee, date);
//grdInsolvable.ItemsSource = listLigneInsolvable;
//grdInsolvable.Items.Refresh();
List <LigneInsolvable> tampon = new List <LigneInsolvable>();
int numero = 0;
if (listLigneInsolvable != null)
{
foreach (LigneInsolvable l in listLigneInsolvable)
{
if (cmbObservation.SelectedValue.ToString() == CODE_MIXTE || l.observation.ToUpper().Contains(cmbObservation.SelectedValue.ToString().ToUpper()))
{
numero = numero + 1;
l.numero = numero;
tampon.Add(l);
}
}
listLigneInsolvable = new List <LigneInsolvable>();
foreach (LigneInsolvable l in tampon)
{
listLigneInsolvable.Add(l);
}
}
grdInsolvable.ItemsSource = listLigneInsolvable;
grdInsolvable.Items.Refresh();
}
//List<RealiserBE> listes = new List<RealiserBE>();
//List<AcheterBE> acheters_avant = new List<AcheterBE>();
//List<PayerBE> payers_avant = new List<PayerBE>();
//lignes = new List<LigneEtat>();
//decimal montantEntrees, montantSorties, solde;
//if (dpiDateFin.SelectedDate != null)
// datefin = dpiDateFin.SelectedDate.Value.Date.ToShortDateString();
//if (dpiDateDebut.SelectedDate != null)
// datedebut = dpiDateDebut.SelectedDate.Value.Date.ToShortDateString();
//if (cmbOperation.SelectedValue != null)
// code = cmbOperation.SelectedValue.ToString();
// OperationBE operation = new OperationBE();
//if (datefin.CompareTo(datedebut) >= 0)
//{
// listes = caisseBL.listerSuivantCritereRealisers("dateop between " + "'" + datedebut + "' AND " + "'" + datefin + "'");
// realisers = new List<RealiserBE>();
// acheters = new List<AcheterBE>();
// payers = new List<PayerBE>();
// //if (code == CODE_MIXTE)
// //{
// // foreach (RealiserBE r in listes)
// // realisers.Add(r);
// //}
// //else
// //{
// // foreach (RealiserBE r in listes)
// // {
// // operation.codeOp = r.codeop;
// // operation = caisseBL.rechercherOperation(operation);
// // if (operation.codeTypeOp == code)
// // realisers.Add(r);
// // }
// //}
// //if (code != "sortie")
// //{
// // acheters = caisseBL.listerSuivantCritereAcheters("dateachat between " + "'" + datedebut + "' AND " + "'" + datefin + "'");
// // payers = caisseBL.listerSuivantCriterePayers("datepaiement between " + "'" + datedebut + "' AND " + "'" + datefin + "'");
// //}
// foreach (RealiserBE r in listes)
// realisers.Add(r);
// acheters = caisseBL.listerSuivantCritereAcheters("dateachat between " + "'" + datedebut + "' AND " + "'" + datefin + "'");
// payers = caisseBL.listerSuivantCriterePayers("datepaiement between " + "'" + datedebut + "' AND " + "'" + datefin + "'");
// lignes = creerDataSource(realisers,acheters,payers);
// //grdEtatCaisse.ItemsSource = lignes;
// //grdEtatCaisse.Items.Refresh();
// //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 (acheters != null)
// foreach (AcheterBE a in acheters)
// montantEntrees += a.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 + "'");
// acheters_avant = caisseBL.listerSuivantCritereAcheters("dateachat < " + "'" + 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 (acheters_avant != null)
// foreach (AcheterBE a in acheters_avant)
// solde += a.montant;
// if (payers_avant != null)
// foreach (PayerBE p in payers_avant)
// solde += (decimal)p.montant;
// listes = caisseBL.listerTousRealiser();
// acheters_avant = caisseBL.listerTousAcheter();
// 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 (acheters_avant != null)
// foreach (AcheterBE a in acheters_avant)
// soldetotal += a.montant;
// if (payers_avant != null)
// foreach (PayerBE p in payers_avant)
// soldetotal += (decimal)p.montant;
// //txtEntreePeriode.Text = Convert.ToString(montantEntrees); Console.WriteLine(montantEntrees.ToString("#,#", CultureInfo.InvariantCulture));
// //txtSortiePeriode.Text = Convert.ToString(montantSorties); Console.WriteLine(montantSorties.ToString("#,#", CultureInfo.InvariantCulture));
// //txtSoldePeriode.Text = Convert.ToString(montantEntrees - montantSorties);
// //txtAncienSolde.Text = Convert.ToString(solde);
// //txtSoldeTotal.Text = Convert.ToString(soldetotal);
// //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;
// }
// //txtTotalEntree.Text = Convert.ToString(entree);
// //txtTotalSolde.Text = Convert.ToString(entree - sortie);
// //txtTotalSortie.Text = Convert.ToString(sortie);
//}
//else
// MessageBox.Show("La date de debut doit être plus petite ou égale à la date de fin");
}
public EleveUI()
{
CultureInfo ci = CultureInfo.CreateSpecificCulture(CultureInfo.CurrentCulture.Name);
ci.DateTimeFormat.ShortDatePattern = "dd-MM-yyyy";
Thread.CurrentThread.CurrentCulture = ci;
classes = new List <string>();
categories = new List <string>();
nomclasses = new List <string>();
nomcategories = new List <string>();
sexes = new List <string>()
{
"Masculin", "Feminin"
};
etats = new List <string>()
{
"CLASSE", "NON CLASSE"
};
nationalites = new List <string>();
langues = new List <string> {
"Français", "Anglais", "Espagnol", "Allemand", "Chinois", "Japonais"
};
regions = new List <string>();
departements = new List <string>();
eleveBL = new GestionEleveBL();
Console.WriteLine(DateTime.Now.ToLongTimeString());
matricule = "";
photo = ""; //Environment.GetFolderPath(Environment.SpecialFolder.MyDocuments) + "\\PhotosEtudiants\\default.jpg";
telephone = "";
email = "";
diplome = "";
telParent = "";
anneeDiplome = 0;
typeValidation = TYPE_ENREGISTRER;
InitializeComponent();
classes = eleveBL.listerValeurColonneClasse("codeclasse");
categories = eleveBL.listerValeurColonneCategorie("codecateleve");
nomclasses = eleveBL.listerValeurColonneClasse("nomclasse");
nomcategories = eleveBL.listerValeurColonneCategorie("nomcateleve");
nationalites = eleveBL.listerValeurColonnePays("codepays");
regions = eleveBL.listerValeurColonneRegion("coderegion");
departements = eleveBL.listerValeurColonneDepartement("codedept");
annee = eleveBL.AnneeEnCours();
txtAnnee.Text = " / " + annee;
txtAnneeScolaire.Text = (annee - 1).ToString();
cmbCategorie.ItemsSource = categories;
cmbCategorie.SelectedIndex = 0;
cmbClasse.ItemsSource = classes;
cmbClasse.SelectedIndex = 0;
/*cmbDepartement.ItemsSource = departements;
* cmbDepartement.SelectedIndex = 0;*/
cmbLangue.ItemsSource = langues;
cmbLangue.SelectedIndex = 0;
cmbNationalite.ItemsSource = nationalites;
cmbNationalite.SelectedIndex = 0;
/*cmbRegion.ItemsSource = regions;
* cmbRegion.SelectedIndex = 0;*/
cmbSexe.ItemsSource = sexes;
cmbSexe.SelectedIndex = 0;
cmbEtat.ItemsSource = etats;
cmbEtat.SelectedIndex = 0;
radioEnregistrement.IsChecked = true;
radioNonRedoublant.IsChecked = true;
txtMatricule.IsEnabled = false;
//-------------MOI----------------------------------------------------
txtMatricule.Text = nouveauMatricule(eleveBL.getDernierMatricule());
//--------------------------------------------------------------------
fonctionPere = "";
fonctionMere = "";
particulariteMedicale = "";
txtFonctionPere.Text = "";
txtFonctionMere.Text = "";
txtParticulariteMedicale.Text = "";
}
