private void supprimer_typeconge_btn_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
        {
            Gestion_Demande_Class gdd = new Gestion_Demande_Class();
            String             nomserv; int xx1;
            gestion_Service    gs   = new gestion_Service();
            type_conge         tc   = new type_conge();
            gestion_type_conge gtc  = new gestion_type_conge();
            int indexDgpersonel     = gridView1.FocusedRowHandle;
            Demande_Conge_Class dem = new Demande_Conge_Class();

            gdd.chercher_Demande_conge_emp(gridView1.GetRowCellValue(indexDgpersonel, "ID_DEMANDE_CONGE").ToString(), out erreur, out dem, out exist);

            GestionPersonel gp   = new GestionPersonel();
            Personel_class  perr = new Personel_class();

            gp.chercher_Personel(gridView1.GetRowCellValue(indexDgpersonel, "MATRICULE") + "", out erreur, out perr, out exist);
            String s1 = perr.Matricule + "";

            var charArray = s1.ToCharArray(); //{'1','2','3','4','5'}

            gs.chercher_Service3(perr.Services, out erreur, out nomserv, out xx1, out exist);
            gtc.chercher_Type_conge_Valider(dem.ID_Conger, out erreur, out tc, out exist);
            Impression2 imp2 = new Impression2(Convert.ToString(charArray[0]), Convert.ToString(charArray[1]), Convert.ToString(charArray[2]), Convert.ToString(charArray[3]), Convert.ToString(charArray[4]), Convert.ToString(charArray[5]), Convert.ToDateTime(dem.Date_Debut), Convert.ToDateTime(dem.Date_fin), dem.Heur_Debut, dem.Heur_Fin, perr.Nom + "", perr.Prenom, nomserv, Convert.ToString(dem.NombreJour), tc.Desgination, Convert.ToDateTime(dem.Date_Demande));

            imp2.imprimer_fiche_deemande();
            imp2.ShowDialog();
        }
示例#2
0
        private void Dgpersonel_Click_1(object sender, EventArgs e)
        {
            if (Gestion_Paie_Oracle.Menu.pr.button_Employer_Depart_Responsable_WasClicked == true)

            {
                int index = gridView1.FocusedRowHandle;

                Gestion_Paie_Oracle.Menu.pr.cin_dep.Text    = gridView1.GetRowCellValue(index, "CIN").ToString();
                Gestion_Paie_Oracle.Menu.pr.nom_dep.Text    = gridView1.GetRowCellValue(index, "NOM").ToString();
                Gestion_Paie_Oracle.Menu.pr.prenom_dep.Text = gridView1.GetRowCellValue(index, "PRENOM").ToString();
                Gestion_Paie_Oracle.Menu.pr.mat_dep.Text    = gridView1.GetRowCellValue(index, "MATRICULE").ToString();

                Gestion_Paie_Oracle.Menu.pr.button_Employer_Depart_Responsable_WasClicked = false;
                this.Close();
            }
            else if (Gestion_Paie_Oracle.Menu.pr.button_Employer_Service_Responsable_WasClicked)
            {
                int index = gridView1.FocusedRowHandle;

                Gestion_Paie_Oracle.Menu.pr.cin_emp_sv.Text    = gridView1.GetRowCellValue(index, "CIN").ToString();
                Gestion_Paie_Oracle.Menu.pr.nom_emp_sv.Text    = gridView1.GetRowCellValue(index, "NOM").ToString();
                Gestion_Paie_Oracle.Menu.pr.prenom_emp_sv.Text = gridView1.GetRowCellValue(index, "PRENOM").ToString();
                Gestion_Paie_Oracle.Menu.pr.mat_emp_sv.Text    = gridView1.GetRowCellValue(index, "MATRICULE").ToString();
                Gestion_Paie_Oracle.Menu.pr.button_Employer_Service_Responsable_WasClicked = false;
                this.Close();
            }
            else if (Gestion_Paie_Oracle.Menu.pr.button_Employer_WasClicked == true)
            {
                int index = gridView1.FocusedRowHandle;

                Gestion_Paie_Oracle.Menu.pr.cin_salaries_demande1.Text = gridView1.GetRowCellValue(index, "MATRICULE").ToString();
                Gestion_Paie_Oracle.Menu.pr.nom_emp_demande.Text       = gridView1.GetRowCellValue(index, "NOM").ToString();
                Gestion_Paie_Oracle.Menu.pr.prenom_emp_demand.Text     = gridView1.GetRowCellValue(index, "PRENOM").ToString();

                Gestion_Historique_Cong ghc = new Gestion_Historique_Cong();
                HISTORIQUE_CONGE        hc;
                String  erreur = null;
                Boolean exit   = false;
                ghc.chercher_Historique_conge_emp(gridView1.GetRowCellValue(index, "MATRICULE").ToString(), Convert.ToString(DateTime.Now.Year), out erreur, out hc, out exit);
                Gestion_Paie_Oracle.Menu.pr.arrierconge.Text = hc.Arrier_conge + "";

                Gestion_Paie_Oracle.Menu.pr.droitannecourat.Text = hc.Droit_annner_courant + "";
                Gestion_Paie_Oracle.Menu.pr.prisanne.Text        = hc.Pris_anner_courant + "";
                Gestion_Paie_Oracle.Menu.pr.sommehisto.Text      = ((Convert.ToDecimal(Gestion_Paie_Oracle.Menu.pr.arrierconge.Text) + Convert.ToDecimal(Gestion_Paie_Oracle.Menu.pr.droitannecourat.Text)) - Convert.ToDecimal(Gestion_Paie_Oracle.Menu.pr.prisanne.Text)).ToString();

                //            MessageBox.Show(hc.Arrier_conge + " " + hc.Anner_conge + " " + hc.Droit_annner_courant + " " + hc.Depasemment);

                //     Gestion_Paie_Oracle.Menu.pr.cin_employer = gridView1.GetRowCellValue(index, "CIN").ToString();
                Gestion_Paie_Oracle.Menu.pr.matriculevisible.Text = gridView1.GetRowCellValue(index, "MATRICULE").ToString();

                /* Gestion_Historique_Cong ghisto = new Gestion_Historique_Cong();
                 * HISTORIQUE_CONGE historique;
                 * ghisto.chercher_Historique_conge_emp("where CIN=" + gridView1.GetRowCellValue(index, "CIN"), out erreur, out historique, out exit);
                 *
                 * Gestion_Paie_Oracle.Menu.pr.arrierconge.Text = historique.Arrier_conge + "";
                 * Gestion_Paie_Oracle.Menu.pr.droitannecourat.Text = historique.Droit_annner_courant + "";
                 * Gestion_Paie_Oracle.Menu.pr.prisanne.Text = historique.Pris_anner_courant + "";
                 */
                Gestion_Paie_Oracle.Menu.pr.button_Employer_WasClicked = false;
                this.Close();
            }
            else if (Gestion_Paie_Oracle.Menu.pr.button_Employer_WasClicked == false)
            {
                int index = gridView1.FocusedRowHandle;
                gridView1.FocusedRowHandle = index;
                gridView1.SelectRow(index);


                Gestion_Paie_Oracle.Menu.pr.remplirDG3(gridView1.GetRowCellValue(index, "MATRICULE").ToString(), Gestion_Paie_Oracle.Menu.pr.historique_dg);
                for (int i = 0; i < Gestion_Paie_Oracle.Menu.pr.historique_dg.Rows.Count - 1; i++)
                {
                    var cell = Gestion_Paie_Oracle.Menu.pr.historique_dg[0, i] = new DataGridViewTextBoxCell();
                    cell.ReadOnly = true;
                }

                Gestion_Paie_Oracle.Menu.pr.historique_dg.BackgroundColor = Gestion_Paie_Oracle.Menu.pr.historique_dg.DefaultCellStyle.BackColor;

                // Gestion_Paie_Oracle.Menu.pr.historique_dg.Columns[0].HeaderText = "Ajouter";
                Gestion_Paie_Oracle.Menu.pr.historique_dg.Columns[1].HeaderText = "Année Congé";
                Gestion_Paie_Oracle.Menu.pr.historique_dg.Columns[0].Width      = 20;

                Gestion_Paie_Oracle.Menu.pr.historique_dg.Columns[2].HeaderText = "Droit courante d'année Congé";
                Gestion_Paie_Oracle.Menu.pr.historique_dg.Columns[3].HeaderText = "Report Caclulé";
                Gestion_Paie_Oracle.Menu.pr.historique_dg.Columns[4].HeaderText = "Report Valider";


                Gestion_Paie_Oracle.Menu.pr.historique_dg.ClearSelection();

                #region lorsque click sur une ligne du gridcontrol
                if (gridView1.GetSelectedRows().Count() > 0)
                {
                    #region remplir datagirdview list de  congé accpeter dans fiche personel
                    Gestion_Paie_Oracle.Menu.pr.remplirDG2(gridView1.GetRowCellValue(index, "MATRICULE").ToString(), Gestion_Paie_Oracle.Menu.pr.DgAlldemand);
                    decimal summ = 0;
                    for (int i = 0; i < Gestion_Paie_Oracle.Menu.pr.gridView5.RowCount; i++)
                    {
                        summ += Convert.ToDecimal(Gestion_Paie_Oracle.Menu.pr.gridView5.GetRowCellValue(i, "NOMBREJOUR").ToString());

                        Gestion_Paie_Oracle.Menu.pr.sommenbjour.Text = summ + "";
                    }
                    Gestion_Paie_Oracle.Menu.pr.gridView5.Columns[0].Caption = "Date Demande Congé";
                    Gestion_Paie_Oracle.Menu.pr.gridView5.Columns[1].Caption = "Date Debut Congé";
                    Gestion_Paie_Oracle.Menu.pr.gridView5.Columns[2].Caption = "Date Fin Congé";
                    Gestion_Paie_Oracle.Menu.pr.gridView5.Columns[3].Caption = "Heur Debut Congé";
                    Gestion_Paie_Oracle.Menu.pr.gridView5.Columns[4].Caption = "Heur Fin Congé";
                    Gestion_Paie_Oracle.Menu.pr.gridView5.Columns[5].Caption = "Nombre de jours de congés pris";

                    #endregion

                    #region remplir datagridview historique de chaque anneéé
                    // historique_dg.DataSource = null;

                    gridView1.ClearSelection();
                    #endregion

                    #region le reste du travail quand on click sur une ligne !
                    Gestion_Paie_Oracle.Menu.pr.cin.Text        = gridView1.GetRowCellValue(index, "CIN").ToString();
                    Gestion_Paie_Oracle.Menu.pr.matriculee.Text = gridView1.GetRowCellValue(index, "MATRICULE").ToString();

                    Gestion_Paie_Oracle.Menu.pr.nom.Text      = gridView1.GetRowCellValue(index, "NOM").ToString();
                    Gestion_Paie_Oracle.Menu.pr.prenom.Text   = gridView1.GetRowCellValue(index, "PRENOM").ToString();
                    Gestion_Paie_Oracle.Menu.pr.datenais.Text = gridView1.GetRowCellValue(index, "DATENAISSENCE").ToString();
                    Gestion_Paie_Oracle.Menu.pr.emaill.Text   = gridView1.GetRowCellValue(index, "EMAIL").ToString();



                    if (gridView1.GetRowCellValue(index, "SEXE").ToString().Equals("Homme"))
                    {
                        Gestion_Paie_Oracle.Menu.pr.homme.Checked = true;
                    }
                    else
                    {
                        Gestion_Paie_Oracle.Menu.pr.femme.Checked = true;
                    }
                    String libellefn = "";

                    //gestion_fonction.chercher_fn3(Convert.ToInt32(gridView1.GetRowCellValue(index, "FONCTION").ToString()), out erreur, out libellefn, out exist);

                    //Gestion_Paie_Oracle.Menu.pr.combofonction.Text = libellefn;


                    gestion_Departement gd = new gestion_Departement();
                    gestion_Service     gs = new gestion_Service();

                    String nomdep  = "";
                    String nomserv = "";
                    int    xx1;
                    gs.chercher_Service3(gridView1.GetRowCellValue(index, "SERVICE").ToString(), out erreur, out nomserv, out xx1, out exist);

                    int    ss;
                    String s1;
                    gd.chercher_Departement3(gridView1.GetRowCellValue(index, "DEPARTEMENT").ToString(), out erreur, out nomdep, out ss, out s1, out exist);
                    Gestion_Paie_Oracle.Menu.pr.comb_depar.Text = nomdep;
                    Gestion_Paie_Oracle.Menu.pr.comb_serv.Text  = nomserv;


                    if (gridView1.GetRowCellValue(index, "ETAT_CIVIL").ToString().Equals("Marié"))
                    {
                        Gestion_Paie_Oracle.Menu.pr.marie.Checked        = true;
                        Gestion_Paie_Oracle.Menu.pr.groupboxEtat.Visible = false;
                    }

                    else
                    {
                        Gestion_Paie_Oracle.Menu.pr.celibataire.Checked  = true;
                        Gestion_Paie_Oracle.Menu.pr.groupboxEtat.Visible = true;
                    }



                    Gestion_Paie_Oracle.Menu.pr.adresse.Text             = gridView1.GetRowCellValue(index, "ADRESSE").ToString();
                    Gestion_Paie_Oracle.Menu.pr.daterecreutement.Text    = gridView1.GetRowCellValue(index, "DATE_RECRUTEMENT").ToString();
                    Gestion_Paie_Oracle.Menu.pr.telephone_societe.Text   = gridView1.GetRowCellValue(index, "TELEPHONESOCEITE").ToString();
                    Gestion_Paie_Oracle.Menu.pr.ville.Text               = gridView1.GetRowCellValue(index, "VILLE").ToString();
                    Gestion_Paie_Oracle.Menu.pr.telephone_personel.Text  = gridView1.GetRowCellValue(index, "TELEPHONEPRIVE").ToString();
                    Gestion_Paie_Oracle.Menu.pr.lieuuxx.Text             = gridView1.GetRowCellValue(index, "LIEUNAISSENCE").ToString();
                    Gestion_Paie_Oracle.Menu.pr.login_utilsateur.Text    = gridView1.GetRowCellValue(index, "LOGIN").ToString();
                    Gestion_Paie_Oracle.Menu.pr.Password_utlisateur.Text = gridView1.GetRowCellValue(index, "MOTPASS").ToString();

                    /*    if (Gestion_Paie_Oracle.Menu.pr.celibataire.Checked)
                     *  {
                     *  }
                     *  else if (Gestion_Paie_Oracle.Menu.pr.marie.Checked)
                     *  {
                     *  }*/
                }
                #endregion



                #region remplir congé anner courante
                HISTORIQUE_CONGE histo;
                string           nbjourdroit = "";
                string           pris        = "";
                string           arrrier     = "";
                try
                {
                    gestion_xdd.Droit_arrier_pris_conge_anner_precedent(DateTime.Now.Year, gridView1.GetRowCellValue(index, "MATRICULE").ToString(), out erreur, out nbjourdroit, out arrrier, out pris, out exist);

                    // MessageBox.Show("f" + arrrier + "" + nbjourdroit + "" + pris);
                    //    gestion_historique_emp_conge.chercher_Historique_conge_emp(gridView1.GetRowCellValue(index, "MATRICULE").ToString(), out erreur, out histo, out exist);

                    Gestion_Paie_Oracle.Menu.pr.arrier_courant_employer.Text = arrrier;     //histo.Arrier_conge + "";
                    Gestion_Paie_Oracle.Menu.pr.droit_anner_employe.Text     = nbjourdroit; //histo.Droit_annner_courant + "";
                    Gestion_Paie_Oracle.Menu.pr.pris_anner_employe.Text      = pris;        // histo.Pris_anner_courant + "";
                    Gestion_Paie_Oracle.Menu.pr.somme_hist_employe.Text      = ((Convert.ToDecimal(Gestion_Paie_Oracle.Menu.pr.arrier_courant_employer.Text) + Convert.ToDecimal(Gestion_Paie_Oracle.Menu.pr.droit_anner_employe.Text)) - Convert.ToDecimal(Gestion_Paie_Oracle.Menu.pr.pris_anner_employe.Text)).ToString();
                }catch (Exception ee)
                {
                }
                #endregion

                #endregion
            }

            Gestion_Paie_Oracle.Menu.pr.BringToFront();
        }