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