public void chercher_ListValidation_conge(String critere, out string erreur, out List <Validation_Conge_Class> val, out Boolean exist) { erreur = null; Validation_Conge_Class Validation = new Validation_Conge_Class(); val = new List <Validation_Conge_Class>(); exist = false; rsql = "select * from VALIDATION_CONGE" + critere; cnx.select(rsql, out erreur, out dr); if (erreur == null) { if (dr.HasRows == true) { exist = true; while (dr.Read()) { Validation = new Validation_Conge_Class(); Validation.Id_validation = dr.GetString(0); Validation.Date_Debut_Valider = dr.GetString(1); Validation.Date_fin_valider = dr.GetString(2); Validation.Heur_Debut_Valider = dr.GetString(3); Validation.Heur_Fin_Valider = dr.GetString(4); Validation.ID_CONGER_DEMANDER = dr.GetString(5); Validation.NombreJourValider = dr.GetDecimal(6); val.Add(Validation); } } dr.Close(); } }
public void modifier_Validation(Validation_Conge_Class val, out String erreur) { erreur = null; rsql = "update VALIDATION_CONGE set DATE_DEBUT_VALIDER='" + val.Date_Debut_Valider + "',DATE_FIN_VALIDER='" + val.Date_fin_valider + "',HEUR_DEBUT_VALIDER='" + val.Heur_Debut_Valider + "',HEUR_FIN_VALIDER='" + val.Heur_Fin_Valider + "',ID_DEMANDE_CONGE='" + val.ID_CONGER_DEMANDER + "',NOMBREJOUR_VALIDE='" + val.NombreJourValider + "' where ID_VALIDATION='" + val.Id_validation + "' "; cnx.maj(rsql, out erreur); }
public void ajouter_Validation(Validation_Conge_Class val, out String erreur) { // dr.Close(); erreur = null; rsql = "insert into VALIDATION_CONGE values('" + val.Id_validation + "','" + val.Date_Debut_Valider + "','" + val.Date_fin_valider + "','" + val.Heur_Debut_Valider + "','" + val.Heur_Fin_Valider + "','" + val.ID_CONGER_DEMANDER + "','" + val.NombreJourValider + "')"; cnx.maj(rsql, out erreur); }
public void chercher_Validation_conge_emp(String id, out string erreur, out Validation_Conge_Class Validation, out Boolean exist) { erreur = null; Validation = new Validation_Conge_Class(); exist = false; rsql = "select * from VALIDATION_CONGE where ID_VALIDATION='" + id + "' "; cnx.select(rsql, out erreur, out dr); if (erreur == null) { if (dr.HasRows == true) { exist = true; dr.Read(); Validation = new Validation_Conge_Class(); Validation.Id_validation = dr.GetString(0); Validation.Date_Debut_Valider = dr.GetString(1); Validation.Date_fin_valider = dr.GetString(2); Validation.Heur_Debut_Valider = dr.GetString(3); Validation.Heur_Fin_Valider = dr.GetString(4); Validation.ID_CONGER_DEMANDER = dr.GetString(5); Validation.NombreJourValider = dr.GetDecimal(6); } dr.Close(); } /* * */ }
public void supprimer_Validation(Validation_Conge_Class val, out String erreur) { erreur = null; rsql = "delete from VALIDATION_CONGE where ID_HISTORIQUE='" + val.Id_validation + "' "; cnx.maj(rsql, out erreur); }