public void chercher_entreprise(int id, out string erreur, out entreprise_class ent, out Boolean exist)
{
erreur = null;
ent = new entreprise_class();
exist = false;
rsql = "select * from entreprise where id_ent=" + id + " ";
cnx.select(rsql, out erreur, out dr);
if (erreur == null)
{
if (dr.HasRows == true)
{
exist = true;
dr.Read();
ent = new entreprise_class();
ent.id_entreprise = dr.GetInt32(0);
ent.designiation_ent = dr.GetString(1);
ent.adresse = dr.GetString(2);
ent.email_entreprise = dr.GetString(3);
ent.telephone_entreprise = dr.GetString(4);
ent.fax_entreprise = dr.GetString(5);
ent.matricule_fiscale = dr.GetString(6);
ent.nbjoursmois = dr.GetInt32(7);
ent.nbheurjours = dr.GetInt32(8);
ent.cnsss = dr.GetInt32(9);
ent.DCreat = dr.GetString(10);
ent.CodeCP = dr.GetInt32(11);
ent.Ville = dr.GetString(12);
ent.Repot1 = dr.GetString(13);
ent.Repot2 = dr.GetString(14);
}
dr.Close();
}
}
public void modifier_En(entreprise_class en, out String erreur)
{
erreur = null;
// rsql = "update entreprise set desg_ent ='" + en.designiation_ent + "',adr_ent='"+en.adresse+ "',email_ent='"+en.email_entreprise+ "',mat_fisc='" + en.matricule_fiscale + "', tel_ent='" + en.telephone_entreprise+ "',fax_ent='"+en.fax_entreprise+ "',nb_jour_mois="+en.nbjoursmois+ ",nb_heur_jour="+en.nbheurjours+ ",cnss="+en.cnsss+ ",date_creation='"+en.DCreat.ToString("dd-MM-yyyy")+ "',codepostal="+en.CodeCP+ ",ville='"+en.Ville+"' where id_ent=" + en.id_entreprise + " ";
rsql = "update entreprise set desg_ent ='" + en.designiation_ent + "',adr_ent='" + en.adresse + "',email_ent='" + en.email_entreprise + "',mat_fisc='" + en.matricule_fiscale + "', tel_ent='" + en.telephone_entreprise + "',fax_ent='" + en.fax_entreprise + "',nb_jour_mois=" + en.nbjoursmois + ",nb_heur_jour=" + en.nbheurjours + ",cnss=" + en.cnsss + ",date_creation='" + en.DCreat + "',codepostal=" + en.CodeCP + ",ville='" + en.Ville + "' where id_ent=" + en.id_entreprise + " ";
cnx.maj(rsql, out erreur);
}