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