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