Ejemplo n.º 1
0
        public void modifier_Personel_Historique(HISTORIQUE_CONGE histo, out String erreur)
        {
            erreur = null;
            rsql   = "update  HISTORIQUE_CONGE set ARRIERE_CONGE='" + histo.Arrier_conge + "',DROIT_ANNER_COURANT='" + histo.Droit_annner_courant + "',PRIS_ANNER_COURANT='" + histo.Pris_anner_courant + "',ANNER_CONGE='" + histo.Anner_conge + "',DEPASEMMENT_CONGE='" + histo.Depasemment + "',CONGE_COMPENSATION='" + histo.Compsensation + "',COMMENTAIRE_CONGE='" + histo.Commentaire + "' where   ID_HISTORIQUE='" + histo.Id_Historique + "' ";

            cnx.maj(rsql, out erreur);
        }
Ejemplo n.º 2
0
 public void ajouter_Histo_PErso(HISTORIQUE_CONGE histo, out String erreur)
 {
     //  dr.Close();
     erreur = null;
     rsql   = "insert into  HISTORIQUE_CONGE values('" + histo.Id_Historique + "','" + histo.Arrier_conge + "','" + histo.Droit_annner_courant + "','" + histo.Pris_anner_courant + "','" + histo.Anner_conge + "','" + histo.Depasemment + "','" + histo.Compsensation + "','" + histo.Commentaire + "','" + histo.MATRICULE + "')";
     cnx.maj(rsql, out erreur);
 }
Ejemplo n.º 3
0
 public void chercher_Historique_conge_emp(String critere, String anner, out string erreur, out HISTORIQUE_CONGE histo, out Boolean exist)
 {
     erreur = null;
     histo  = new HISTORIQUE_CONGE();
     exist  = false;
     rsql   = "select * from  HISTORIQUE_CONGE where  HISTORIQUE_CONGE.MATRICULE='" + critere + "' and  HISTORIQUE_CONGE.ANNER_CONGE ='" + anner + "'  ";
     cnx.select(rsql, out erreur, out dr);
     if (erreur == null)
     {
         if (dr.HasRows == true)
         {
             exist = true;
             dr.Read();
             histo.Id_Historique        = dr.GetString(0);
             histo.Arrier_conge         = dr.GetDecimal(1);
             histo.Droit_annner_courant = dr.GetDecimal(2);
             histo.Pris_anner_courant   = dr.GetDecimal(3);
             histo.Anner_conge          = dr.GetString(4);
             histo.Depasemment          = dr.GetString(5);
             histo.Compsensation        = dr.GetString(6);
             histo.Commentaire          = dr.GetString(7);
             histo.MATRICULE            = dr.GetString(8);
         }
         dr.Close();
     }
 }
Ejemplo n.º 4
0
 public void Historique_annercourante(String anner, String mat, out string erreur, out HISTORIQUE_CONGE histo, out Boolean exist)
 {
     histo  = new HISTORIQUE_CONGE();
     erreur = null;
     exist  = false;
     rsql   = "select *  from HISTORIQUE_CONGE where ANNER_CONGE='" + anner + "' and MATRICULE='" + mat + "'";
     cnx.select(rsql, out erreur, out dr);
     if (erreur == null)
     {
         if (dr.HasRows == true)
         {
             exist = true;
             dr.Read();
             histo.Arrier_conge         = Convert.ToDecimal(dr[1]);
             histo.Droit_annner_courant = Convert.ToDecimal(dr[2]);
             histo.Pris_anner_courant   = Convert.ToDecimal(dr[3]);
             histo.Anner_conge          = Convert.ToString(dr[4]);
         }
         dr.Close();
     }
 }
Ejemplo n.º 5
0
        public void chercher_ListHistorique_conge_emp(String critere, out string erreur, out List <HISTORIQUE_CONGE> histolist, out Boolean exist)
        {
            erreur = null;
            HISTORIQUE_CONGE histoconger = new HISTORIQUE_CONGE();

            histolist = new List <HISTORIQUE_CONGE>();
            exist     = false;
            rsql      = "select * from  HISTORIQUE_CONGE where  HISTORIQUE_CONGE.MATRICULE='" + critere + "' ";
            cnx.select(rsql, out erreur, out dr);



            if (erreur == null)
            {
                if (dr.HasRows == true)
                {
                    exist = true;
                    while (dr.Read())
                    {
                        histoconger = new HISTORIQUE_CONGE();
                        histoconger.Id_Historique        = dr.GetString(0);
                        histoconger.Arrier_conge         = dr.GetDecimal(1);
                        histoconger.Droit_annner_courant = dr.GetDecimal(2);
                        histoconger.Pris_anner_courant   = dr.GetDecimal(3);
                        histoconger.Anner_conge          = dr.GetString(4);
                        histoconger.Depasemment          = dr.GetString(5);
                        histoconger.Compsensation        = dr.GetString(6);
                        histoconger.Commentaire          = dr.GetString(7);
                        histoconger.MATRICULE            = dr.GetString(8);


                        histolist.Add(histoconger);
                    }
                }
                dr.Close();
            }
        }
Ejemplo n.º 6
0
 public void supprimer_Histo_perso(HISTORIQUE_CONGE histo, out String erreur)
 {
     erreur = null;
     rsql   = "delete from  HISTORIQUE_CONGE  where ID_HISTORIQUE='" + histo.Id_Historique + "' ";
     cnx.maj(rsql, out erreur);
 }