public Intervenant(int id, Dossier dossier, string nom, string prenom, string adresse, string ville, string codePostal, string telephone, string mail, bool statut, bool presence, string qualite, string typeLieu, string utilite, string etat, string etage, string remarque, string numeroContrat, string numeroSinistre, Representant representant, Compagnie compagnie, Assureur assureur, Expert expert, int idDossier)
{
this._id = id;
this._nom = nom;
this._prenom = prenom;
this._adresse = adresse;
this._ville = ville;
this._codePostal = codePostal;
this._telephone = telephone;
this._mail = mail;
this._statut = statut;
this._presence = presence;
this._qualite = qualite;
this._typeLieu = typeLieu;
this._utilite = utilite;
this._etat = etat;
this._etage = etage;
this._remarque = remarque;
this._numeroContrat = numeroContrat;
this._numeroSinistre = numeroSinistre;
this._representant = representant;
this._compagnie = compagnie;
this._assureur = assureur;
this._expert = expert;
this._idDossier = idDossier;
}
public Intervenant()
{
this._id = 0;
this._nom = "";
this._prenom = "";
this._adresse = "";
this._ville = "";
this._codePostal = "";
this._telephone = "";
this._mail = "";
this._statut = true;
this._presence = true;
this._qualite = "";
this._typeLieu = "";
this._utilite = "";
this._etat = "";
this._etage = "";
this._remarque = "";
this._numeroContrat = "";
this._numeroSinistre = "";
this._representant = new Representant();
this._compagnie = new Compagnie();
this._assureur = new Assureur();
this._expert = new Expert();
// this._idDossier = 0;
}
public Expert RechercherExpertParId(int id)
{
Expert expert;
_connexion.Open();
_requete = new MySqlCommand("SELECT * FROM Expert WHERE id=@id", _connexion);
_requete.Parameters.Add(new MySqlParameter("@id", id));
MySqlDataReader dr = _requete.ExecuteReader();
dr.Read();
expert = new Expert(Convert.ToInt32(dr["id"]), dr["nom"].ToString(), dr["prenom"].ToString(), dr["adresse"].ToString(), dr["ville"].ToString(), dr["codePostal"].ToString(), dr["telephone"].ToString(), dr["mail"].ToString(), dr["numeroDossier"].ToString());
_connexion.Close();
return(expert);
}
public void MettreAJourExpert(Expert expert)
{
_connexion.Open();
_requete = new MySqlCommand("UPDATE Expert SET nom=@nom, prenom=@prenom, adresse=@adresse, ville=@ville, codePostal=@codePostal, telephone=@telephone, mail=@mail, numeroDossier=@numeroDossier WHERE id=@id ", _connexion);
_requete.Parameters.Add(new MySqlParameter("@nom", expert.Nom));
_requete.Parameters.Add(new MySqlParameter("@prenom", expert.Prenom));
_requete.Parameters.Add(new MySqlParameter("@adresse", expert.Adresse));
_requete.Parameters.Add(new MySqlParameter("@ville", expert.Ville));
_requete.Parameters.Add(new MySqlParameter("@codePostal", expert.CodePostal));
_requete.Parameters.Add(new MySqlParameter("@telephone", expert.Telephone));
_requete.Parameters.Add(new MySqlParameter("@mail", expert.Mail));
_requete.Parameters.Add(new MySqlParameter("@numeroDossier", expert.NumeroDossier));
_requete.Parameters.Add(new MySqlParameter("@id", expert.Id));
_requete.ExecuteNonQuery();
_connexion.Close();
}
