//chercher une liste de fonction selon un critére
public void chercher_ListeDepartement(String critere, out String erreur, out List <Departement_Class> list, out String dbb, out Boolean exist)
{
erreur = null;
dbb = "";
list = new List <Departement_Class>();
Departement_Class dep = new Departement_Class();
exist = false;
rsql = "select * from DEPARTEMENT " + critere;
cnx.select(rsql, out erreur, out dr);
if (erreur == null)
{
if (dr.HasRows == true)
{
exist = true;
while (dr.Read())
{
dep = new Departement_Class();
dep.ID_DEP = dr.GetString(0);
dep.DESG_Dep = dr.GetString(1);
dep.RESPONSABLE = dr.GetString(2);
dep.Seuuuilee = dr.GetInt32(3);
list.Add(dep);
}
dr.Close();
}
}
}
public void chercher_Departement3(String id, out string erreur, out string nom, out int seuil, out string rsp, out Boolean exist)
{
erreur = null;
rsp = "";
Departement_Class fn = new Departement_Class();
nom = null;
exist = false;
seuil = 0;
rsql = "select * from DEPARTEMENT where DEPARTEMENT.ID_DEPARTMENT='" + id + "' ";
cnx.select(rsql, out erreur, out dr);
if (erreur == null)
{
if (dr.HasRows == true)
{
exist = true;
while (dr.Read())
{
fn = new Departement_Class();
nom = fn.DESG_Dep = dr.GetString(1);
rsp = dr.GetString(2);
seuil = dr.GetInt32(3);
}
dr.Close();
}
}
}
public void modifier_DEPARTEMENT(Departement_Class dep, out String erreur)
{
erreur = null;
//update DEPARTEMENT d set d.DESGN_DEPARTEMENT ='XX' ,d.REPONSABLE_DEP='Emp5' where d.ID_DEPARTMENT='D6' and not exists
//(select 1 from DEPARTEMENT where 'Emp5' = REPONSABLE_DEP);
rsql = "update DEPARTEMENT set DESGN_DEPARTEMENT ='" + dep.DESG_Dep + "',REPONSABLE_DEP='" + dep.RESPONSABLE + "',SEUILE_DEPARTEMENT='" + dep.Seuuuilee + "' where ID_DEPARTMENT='" + dep.ID_DEP + "' ";
cnx.maj(rsql, out erreur);
}
//chercher fonction
public void Chercher_Departement(string id, out string erreur, out Departement_Class dep, out Boolean exist)
{
erreur = null;
dep = new Departement_Class();
exist = false;
rsql = "select * from DEPARTEMENT where DEPARTEMENT.ID_DEPARTMENT=" + id + " ";
cnx.select(rsql, out erreur, out dr);
if (erreur == null)
{
if (dr.HasRows == true)
{
exist = true;
dr.Read();
dep.ID_DEP = dr.GetString(0);
dep.DESG_Dep = dr.GetString(1);
dep.RESPONSABLE = dr.GetString(2);
dep.Seuuuilee = dr.GetInt32(3);
}
dr.Close();
}
}
public void supprimer_DEPARTEMENT(Departement_Class dep, out String erreur)
{
erreur = null;
rsql = "delete from DEPARTEMENT where ID_DEPARTMENT='" + dep.ID_DEP + "' ";
cnx.maj(rsql, out erreur);
}
public void ajouter_DEPARTEMENT(Departement_Class dep, out String erreur)
{
erreur = null;
rsql = "insert into DEPARTEMENT values('" + dep.ID_DEP + "','" + dep.DESG_Dep + "','" + dep.RESPONSABLE + "','" + dep.Seuuuilee + "')";
cnx.maj(rsql, out erreur);
}
