private void FormHoraire_Load(object sender, EventArgs e)
{
par1.chargementcombo_section_designe(cmbSectionBulletin);
//par1.chargementcombo_option_designe(cmbOptionBulletin);
ClIntelligence.GetInstance().chargementcombo_classe_designe(cmbClasseBulletin);
ClIntelligence.GetInstance().chargementcombo_annee_designe(cmbanneeBulletin);
}
private void FormPalmaress_Load(object sender, EventArgs e)
{
//chargeChat();
ClIntelligence.GetInstance().chargementcombo_annee_designe(cmbAnnee);
GridStatistique.DataSource = ClIntelligence.GetInstance().chargementStatistique();
}
private void simpleButton2_Click(object sender, EventArgs e)
{
try
{
if (txtcode.Text == "" | txtadresseEntreprise.Text == "" | txtmailEntreprise.Text == "" | txtnomentreprise.Text == "" | txttelephone.Text == "")
{
MessageBox.Show("Completez tous les champs svp !!!!");
}
else
{
ecole.CodeEcol = int.Parse(txtcode.Text);
ecole.NomEcol = txtnomentreprise.Text;
ecole.AdresseEcol = txtadresseEntreprise.Text;
ecole.TeleohoneEcol = txttelephone.Text;
ecole.MailEcol = txtmailEntreprise.Text;
ecole.Logo = photo.Image;
ecole.VilleEcole = txtVille.Text;
ecole.CommuneEcole = txtcommune.Text;
ecole.CodeEcole = txtCodeEcole.Text;
ClIntelligence.GetInstance().insertEcole(ecole);
dataGridView2.DataSource = ClIntelligence.GetInstance().chargement_Ecole();
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
private void button2_Click(object sender, EventArgs e)
{
try
{
if (txtcodeEleve.Text == "" || txtcomboPeriode.Text == "" || txtcomboconduite.Text == "")
{
MessageBox.Show("Completez tous les champs svp !!!", "Erreur", MessageBoxButtons.OKCancel, MessageBoxIcon.Exclamation);
}
else
{
if (ClIntelligence.GetInstance().teste_Discipline(txtcomboPeriode.Text, txtcodeEleve.Text) == true)
{
dis.RefEleve1 = int.Parse(txtcodeEleve.Text);
dis.RefMession1 = txtcomboconduite.Text;
dis.Periode = txtcomboPeriode.Text;
dis.UserCession = UserSession.GetInstance().AccessLevel;
ClIntelligence.GetInstance().insertDiscipline(dis);
gridControl1.DataSource = ClIntelligence.GetInstance().chargementDiscipline(UserSession.GetInstance().Annee);
}
else
{
MessageBox.Show("Cette affection est déjà faite svp!!!!", "Doublons", MessageBoxButtons.OKCancel, MessageBoxIcon.Exclamation);
}
}
}
catch (Exception ex) {
MessageBox.Show(ex.Message);
}
}
private void FormPresence_Load(object sender, EventArgs e)
{
txtDatePres.Text = DateTime.Now.ToString();
txtHeureArriver.Text = DateTime.Now.TimeOfDay.ToString();
gridControl1.DataSource = ClIntelligence.GetInstance().chargementPresence(UserSession.GetInstance().Annee);
gridControl2.DataSource = ClIntelligence.GetInstance().SearchInscriptionPresence(UserSession.GetInstance().Annee);
}
private void chargerComboAdresse2(string nomTable, string ChampDesigne, System.Windows.Forms.ComboBox combo, string champ, string valeur)
{
glo = new ClIntelligence();
deb = new clsBase();
deb.NomTable1 = nomTable;
deb.NomChamp1 = ChampDesigne;
glo.loadCombo(deb, combo, champ, valeur);
}
private void FormParametreEncours_Load(object sender, EventArgs e)
{
gridControl1.DataSource = ClIntelligence.GetInstance().chargement_Encours();
ClIntelligence.GetInstance().chargementcombo_periode_designe(cmbPeriode);
ClIntelligence.GetInstance().chargementcombo_annee_designe(cmbAnnee);
ClIntelligence.GetInstance().chargementcombo_classe_designe(cmbClasse);
}
private void FormRecouvrement_Load(object sender, EventArgs e)
{
par1.chargementcombo_section_designe(cmbSectionBulletin);
par1.chargementcombo_option_designe(cmbOptionBulletin);
el1.chargementcombotypefrais(CmbFrais);
ClIntelligence.GetInstance().chargementcombo_classe_designe(cmbClasseBulletin);
ClIntelligence.GetInstance().chargementcombo_annee_designe(cmbanneeBulletin);
}
private void FormRaport_Load(object sender, EventArgs e)
{
par1.chargementcombo_section_designe(cmbSectionBulletin);
//par1.chargementcombo_option_designe(cmbOptionBulletin);
ClIntelligence.GetInstance().chargementcombo_classe_designe(cmbClasseBulletin);
ClIntelligence.GetInstance().chargementcombo_annee_designe(cmbanneeBulletin);
ClIntelligence.GetInstance().chargementcombo_annee_designe(cmbAnneeAffect);
cr.chargementcombo_enseignant_designe(cmbEnseignant);
}
void SaveUpdateDelete(int i)
{
if (i == 1 | i == 2)
{
if (txtcodeEleve.Text == "" || txtHeureArriver.Text == "" || txtHeureSortie.Text == "" || txtDatePres.Text == "")
{
MessageBox.Show("Completez tous les champs svp !!!", "Erreur de Sauvegarde", MessageBoxButtons.OKCancel, MessageBoxIcon.Exclamation);
}
else
{
if (DateTime.Parse(txtHeureArriver.Text) < DateTime.Parse(txtHeureSortie.Text))
{
Pres.RefEleve1 = int.Parse(txtcodeEleve.Text);
Pres.HeuereArriver1 = txtHeureArriver.Text;
Pres.HeuerSortie1 = txtHeureSortie.Text;
Pres.DatePresence1 = DateTime.Parse(txtDatePres.Text);
Pres.Utilisateur1 = UserSession.GetInstance().AccessLevel;
if (i == 1)
{
ClIntelligence.GetInstance().insertPresence(Pres);
gridControl1.DataSource = ClIntelligence.GetInstance().chargementPresence(UserSession.GetInstance().Annee);
}
else if (i == 2)
{
if (txtcode.Text == "")
{
MessageBox.Show("Selection l'Enregistrement dans la liste ci-dessous !!!", "Erreur", MessageBoxButtons.OKCancel, MessageBoxIcon.Exclamation);
}
else
{
Pres.CodePres = int.Parse(txtcode.Text);
ClIntelligence.GetInstance().updatePresence(Pres);
gridControl1.DataSource = ClIntelligence.GetInstance().chargementPresence(UserSession.GetInstance().Annee);
}
}
}
else
{
MessageBox.Show("L'heure de sortie doit etre superieur a l'heure d'arriver svp", "Erreur", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
}
}
}
else if (i == 3)
{
if (txtcode.Text == "")
{
MessageBox.Show("Selection l'Enregistrement a supprimer dans la liste ci-dessous !!!", "Erreur", MessageBoxButtons.OKCancel, MessageBoxIcon.Exclamation);
}
else
{
Pres.CodePres = int.Parse(txtcode.Text);
ClIntelligence.GetInstance().supprimerPresence(Pres);
gridControl1.DataSource = ClIntelligence.GetInstance().chargementPresence(UserSession.GetInstance().Annee);
}
}
}
private void cmbOptionBulletin_SelectedIndexChanged(object sender, EventArgs e)
{
bool teste = ClIntelligence.GetInstance().teste_Option(cmbOptionBulletin.Text, txtComboSectionBulletin.Text);
if (teste == true)
{
par1.chargementcombo_option_saisir(cmbOptionBulletin, txtcomboOptionBulletin, cmbOptionBulletin.Text);
}
else
{
MessageBox.Show("Option est invalide a la section !!!!", "Erreur", MessageBoxButtons.OKCancel, MessageBoxIcon.Error);
}
}
void chargeChat()
{
try
{
chart1.Series["Nombre"].XValueMember = "Classe";
chart1.Series["Nombre"].YValueMembers = "NombreInscription";
chart1.DataSource = ClIntelligence.GetInstance().chargementStatistique(cmbAnnee.Text);
chart1.DataBind();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
private void simpleButton1_Click(object sender, EventArgs e)
{
try
{
if (cmbPriode.Text == "1erePeriode")
{
gridControl1.DataSource = ClIntelligence.GetInstance().chargementStatReussite("StatPeriode1", cmAnnee.Text);
}
else if (cmbPriode.Text == "2emePeriode")
{
gridControl1.DataSource = ClIntelligence.GetInstance().chargementStatReussite("StatPeriode2", cmAnnee.Text);
}
else if (cmbPriode.Text == "3emePeriode")
{
gridControl1.DataSource = ClIntelligence.GetInstance().chargementStatReussite("StatPeriode3", cmAnnee.Text);
}
else if (cmbPriode.Text == "4emePeriode")
{
gridControl1.DataSource = ClIntelligence.GetInstance().chargementStatReussite("StatPeriode4", cmAnnee.Text);
}
else if (cmbPriode.Text == "Examen1")
{
gridControl1.DataSource = ClIntelligence.GetInstance().chargementStatReussite("StatPeriodeExamen1", cmAnnee.Text);
}
else if (cmbPriode.Text == "Examen2")
{
gridControl1.DataSource = ClIntelligence.GetInstance().chargementStatReussite("StatPeriodeExamen2", cmAnnee.Text);
}
else if (cmbPriode.Text == "Total1")
{
gridControl1.DataSource = ClIntelligence.GetInstance().chargementStatReussite("StatPeriodeTotal1", cmAnnee.Text);
}
else if (cmbPriode.Text == "Total2")
{
gridControl1.DataSource = ClIntelligence.GetInstance().chargementStatReussite("StatPeriodeTotal2", cmAnnee.Text);
}
else if (cmbPriode.Text == "TotalGeneral")
{
gridControl1.DataSource = ClIntelligence.GetInstance().chargementStatReussite("StatPeriodeTG", cmAnnee.Text);
}
else
{
MessageBox.Show("Choisissez une periode svp !!!", "Section Obligatoire", MessageBoxButtons.OKCancel, MessageBoxIcon.Exclamation);
}
}
catch (Exception ex) {
MessageBox.Show("Selection la periode et l'annee svp !!!", "Sections Obligatoires", MessageBoxButtons.OKCancel, MessageBoxIcon.Exclamation);
}
}
private void simpleButton4_Click(object sender, EventArgs e)
{
try
{
if (txtcode.Text == "")
{
MessageBox.Show("Selectionnez l'ecole supprimer dans la liste des ecoles svp !!!!");
}
else
{
ecole.CodeEcol = int.Parse(txtcode.Text);
ClIntelligence.GetInstance().supprimer_Ecole(ecole);
dataGridView2.DataSource = ClIntelligence.GetInstance().chargement_Ecole();
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
private void button3_Click(object sender, EventArgs e)
{
try
{
if (txtcode.Text == "")
{
MessageBox.Show("Entrez le code de la mension a supprimer svp !!!");
}
else
{
mension.Code = txtcode.Text;
ClIntelligence.GetInstance().supprimerMenssion(mension);
gridControl1.DataSource = ClIntelligence.GetInstance().chargementMenssion();
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
private void button2_Click(object sender, EventArgs e)
{
try
{
if (txtcode.Text == "" || txtdesignation.Text == "")
{
MessageBox.Show("Completez tous les champs svp !!!");
}
else
{
mension.Code = txtcode.Text;
mension.Designation1 = txtdesignation.Text;
ClIntelligence.GetInstance().insertMenssion(mension);
gridControl1.DataSource = ClIntelligence.GetInstance().chargementMenssion();
}
}
catch (Exception ex) {
MessageBox.Show(ex.Message);
}
}
private void simpleButton3_Click(object sender, EventArgs e)
{
try
{
if (txtcodeEncours.Text == "")
{
MessageBox.Show("Entrez le code de l'encours a supprimer svp !!!!!");
}
else
{
encours.CodeEncours = int.Parse(txtcodeEncours.Text);
ClIntelligence.GetInstance().insertEcours(encours);
gridControl1.DataSource = ClIntelligence.GetInstance().chargement_Encours();
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
private void button4_Click(object sender, EventArgs e)
{
try
{
if (txtcode.Text == "")
{
MessageBox.Show("Entrez le code de la discipline a supprimer svp !!!", "Erreur", MessageBoxButtons.OKCancel, MessageBoxIcon.Exclamation);
}
else
{
dis.Code = int.Parse(txtcode.Text);
ClIntelligence.GetInstance().supprimerDiscipline(dis);
gridControl1.DataSource = ClIntelligence.GetInstance().chargementDiscipline(UserSession.GetInstance().Annee);
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
private void simpleButton1_Click(object sender, EventArgs e)
{
if (cmbAnnee.Text == "")
{
MessageBox.Show("Entrez l'annee svp !!!!!");
}
else
{
try
{
StatistiqueInscription rpt = new StatistiqueInscription();
rpt.DataSource = ClIntelligence.GetInstance().get_Report_X("viewStatistiqueInscription", "Annee", cmbAnnee.Text);
using (ReportPrintTool printTool = new ReportPrintTool(rpt))
{
printTool.ShowPreviewDialog();
}
}
catch (Exception ex)
{ MessageBox.Show(ex.Message); }
}
}
private void simpleButton2_Click(object sender, EventArgs e)
{
try
{
if (txtcodeEncours.Text == "" | txtcomboAnnee.Text == "" | txtcomboClasse.Text == "" | txtcomboPeriode.Text == "")
{
MessageBox.Show("Completez tous les champs svp !!!!!");
}
else
{
encours.CodeEncours = int.Parse(txtcodeEncours.Text);
encours.RefAnnee1 = int.Parse(txtcomboAnnee.Text);
encours.Refclasse1 = txtcomboClasse.Text;
encours.Refperiode1 = txtcomboPeriode.Text;
ClIntelligence.GetInstance().insertEcours(encours);
gridControl1.DataSource = ClIntelligence.GetInstance().chargement_Encours();
}
}
catch (Exception ex) {
MessageBox.Show(ex.Message);
}
}
private void simpleButton3_Click(object sender, EventArgs e)
{
try
{
bool teste = ClIntelligence.GetInstance().teste_Option(cmbOptionBulletin.Text, txtComboSectionBulletin.Text);
if (teste == true)
{
HoaraireCours rpt = new HoaraireCours();
rpt.DataSource = clreport.GetInstance().HoraireClasse("horaire", txtcomboClasseBulletin.Text, txtComboSectionBulletin.Text, txtcomboOptionBulletin.Text, txtcomboAnneeBulletin.Text, comboBox1.Text);
using (ReportPrintTool printTool = new ReportPrintTool(rpt))
{
printTool.ShowPreviewDialog();
}
}
else
{
MessageBox.Show("L'option est invalide a la section svp !!!!", "Erreur", MessageBoxButtons.OKCancel, MessageBoxIcon.Error);
}
}
catch (Exception ex)
{ MessageBox.Show(ex.Message); }
}
private void simpleButton3_Click(object sender, EventArgs e)
{
try
{
bool teste = ClIntelligence.GetInstance().teste_Option(cmbOptionBulletin.Text, txtComboSectionBulletin.Text);
if (teste == true)
{
ListeRecouvrement rpt = new ListeRecouvrement();
rpt.DataSource = clreport.GetInstance().Recouvrement("viewTotalRecouvrement", txtcomboClasseBulletin.Text, txtComboSectionBulletin.Text, txtcomboOptionBulletin.Text, txtcomboAnneeBulletin.Text, txtcomboFrais.Text, double.Parse(txtmontant.Text));
using (ReportPrintTool printTool = new ReportPrintTool(rpt))
{
printTool.ShowPreviewDialog();
}
}
else
{
MessageBox.Show("L'option est invalide a la section svp !!!!", "Erreur", MessageBoxButtons.OKCancel, MessageBoxIcon.Error);
}
}
catch (Exception ex)
{ MessageBox.Show(ex.Message); }
}
private void dataGridView2_CellClick(object sender, DataGridViewCellEventArgs e)
{
try
{
int i;
i = dataGridView2.CurrentRow.Index;
txtcode.Text = dataGridView2["codeEcol", i].Value.ToString();
txtnomentreprise.Text = dataGridView2["nomEcol", i].Value.ToString();
txtadresseEntreprise.Text = dataGridView2["adresseEcol", i].Value.ToString();
txttelephone.Text = dataGridView2["telephoneEcol", i].Value.ToString();
txtmailEntreprise.Text = dataGridView2["mailEcol", i].Value.ToString();
txtVille.Text = dataGridView2["villeEcole", i].Value.ToString();
txtcommune.Text = dataGridView2["CommuneEcole", i].Value.ToString();
txtCodeEcole.Text = dataGridView2["CodeEcole", i].Value.ToString();
ClIntelligence.GetInstance().affichepho_Ecole(txtcode.Text, photo);
//
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
private void cmbClasse_SelectedIndexChanged(object sender, EventArgs e)
{
ClIntelligence.GetInstance().chargementcombo_classe_text(cmbClasse, txtcomboClasse, cmbClasse.Text);
}
private void UserParametreEncours_Load(object sender, EventArgs e)
{
gridControl1.DataSource = ClIntelligence.GetInstance().chargement_Encours();
}
private void textEdit1_TextChanged(object sender, EventArgs e)
{
gridControl1.DataSource = ClIntelligence.GetInstance().recherche_Encours(textEdit1.Text);
}
private void cmbprevision_SelectedIndexChanged(object sender, EventArgs e)
{
ClIntelligence.GetInstance().chargementcombo_annee_text(cmbprevision, txtcomboprevision, cmbprevision.Text);
}
private void FormRapportComptabilite_Load(object sender, EventArgs e)
{
ClIntelligence.GetInstance().chargementcombo_annee_designe(cmbprevision);
}
private void comboBox1_SelectedIndexChanged(object sender, EventArgs e)
{
ClIntelligence.GetInstance().chargementcombo_Mension_text(txtcomboconduite, CmbConduite.Text);
}
private void textBox2_TextChanged(object sender, EventArgs e)
{
gridControl2.DataSource = ClIntelligence.GetInstance().rechercheInscription(textBox2.Text, UserSession.GetInstance().Annee);
}
