public Dossier(int id, Mission mission, Contrat contrat, Sinistre sinistre, Risque risque, bool estModifiable) { this._id = id; this._estModifiable = estModifiable; this._mission = mission; this._contrat = contrat; this._sinistre = sinistre; this._risque = risque; }
public Dossier() { this._id = 0; this._estModifiable = true; this._mission = new Mission(); this._contrat = new Contrat(); this._sinistre = new Sinistre(); this._risque = new Risque(); this._listeIntervenants = new List <Intervenant>(); }
public void MettreAJourSinistre(Sinistre sinistre) { _connexion.Open(); _requete = new MySqlCommand("UPDATE Sinistre SET type=@type, adresse=@adresse, ville=@ville, codePostal=@codePostal, dateSurvenance=@dateSurvenance, causesEtCirconstances=@causesEtCirconstances, origine=@origine, rdf=@rdf, origineSinistre=@origineSinistre, idEntrepriseRdf=@idEntrepriseRdf WHERE id=@id ", _connexion); _requete.Parameters.Add(new MySqlParameter("@type", sinistre.Type)); _requete.Parameters.Add(new MySqlParameter("@adresse", sinistre.Adresse)); _requete.Parameters.Add(new MySqlParameter("@ville", sinistre.Ville)); _requete.Parameters.Add(new MySqlParameter("@codePostal", sinistre.CodePostal)); _requete.Parameters.Add(new MySqlParameter("@dateSurvenance", sinistre.DateSurvenance)); _requete.Parameters.Add(new MySqlParameter("@causesEtCirconstances", sinistre.CausesEtCirconstances)); _requete.Parameters.Add(new MySqlParameter("@origine", sinistre.Origine)); _requete.Parameters.Add(new MySqlParameter("@rdf", sinistre.Rdf)); _requete.Parameters.Add(new MySqlParameter("@origineSinistre", sinistre.OrigineSinistre)); _requete.Parameters.Add(new MySqlParameter("@idEntrepriseRdf", sinistre.EntrepriseRdf.Id)); _requete.Parameters.Add(new MySqlParameter("@id", sinistre.Id)); _requete.ExecuteNonQuery(); _connexion.Close(); }