public Boolean Update(int id, stage_isetna.Business.Entreprise en)
{
try
{
cn.Open();
SqlCommand cmd = new SqlCommand("UPDATE Entreprise set nomEntreprise='" + en.getnomEntreprise() + "'," + "telephone='" + en.getTelephone() + "',adresse='" + en.getAdresse() + "' where id=" + id, cn);
SqlDataReader Reader = cmd.ExecuteReader();
cn.Close();
return(true);
}
catch (Exception ex)
{
String er = ex.Message;
return(false);
}
}
public Boolean Insert(stage_isetna.Business.Entreprise e)
{
try
{
cn.Open();
string strQuery = "INSERT INTO Entreprise VALUES (@id, @nomEntreprise,@tel,@adresse)";
SqlCommand cmd = new SqlCommand(strQuery, cn);
cmd.Parameters.AddWithValue("@id", e.getId());
cmd.Parameters.AddWithValue("@nomEntreprise", e.getnomEntreprise());
cmd.Parameters.AddWithValue("@tel", e.getTelephone());
cmd.Parameters.AddWithValue("@adresse", e.getAdresse());
cmd.Connection = cn;
cmd.ExecuteNonQuery();
cn.Close();
return(true);
}
catch (Exception ex)
{
String er = ex.Message;
return(false);
}
}
