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); }
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); }
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(); } }
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(); } }
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(); } }
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); }