public void MettreAJourIntervenant(Intervenant intervenant)
{
_connexion.Open();
_requete = new MySqlCommand("UPDATE Intervenant SET nom=@nom, prenom=@prenom, adresse=@adresse, ville=@ville, codePostal=@codePostal, telephone=@telephone, mail=@mail, statut=@statut, presence=@presence, qualite=@qualite, typeLieu=@typeLieu, utilite=@utilite, etat=@etat, etage=@etage, remarque=@remarque, numeroContrat=@numeroContrat, numeroSinistre=@numeroSinistre, idRepresentant=@idRepresentant, idCompagnie=@idCompagnie, idAssureur=@idAssureur, idExpert=@idExpert, idDossier=@idDossier WHERE id=@id ", _connexion);
_requete.Parameters.Add(new MySqlParameter("@nom", intervenant.Nom));
_requete.Parameters.Add(new MySqlParameter("@prenom", intervenant.Prenom));
_requete.Parameters.Add(new MySqlParameter("@adresse", intervenant.Adresse));
_requete.Parameters.Add(new MySqlParameter("@ville", intervenant.Ville));
_requete.Parameters.Add(new MySqlParameter("@codePostal", intervenant.CodePostal));
_requete.Parameters.Add(new MySqlParameter("@telephone", intervenant.Telephone));
_requete.Parameters.Add(new MySqlParameter("@mail", intervenant.Mail));
_requete.Parameters.Add(new MySqlParameter("@statut", intervenant.Statut));
_requete.Parameters.Add(new MySqlParameter("@presence", intervenant.Presence));
_requete.Parameters.Add(new MySqlParameter("@qualite", intervenant.Qualite));
_requete.Parameters.Add(new MySqlParameter("@typeLieu", intervenant.TypeLieu));
_requete.Parameters.Add(new MySqlParameter("@utilite", intervenant.Utilite));
_requete.Parameters.Add(new MySqlParameter("@etat", intervenant.Etat));
_requete.Parameters.Add(new MySqlParameter("@etage", intervenant.Etage));
_requete.Parameters.Add(new MySqlParameter("@remarque", intervenant.Remarque));
_requete.Parameters.Add(new MySqlParameter("@numeroContrat", intervenant.NumeroContrat));
_requete.Parameters.Add(new MySqlParameter("@numeroSinistre", intervenant.NumeroSinistre));
_requete.Parameters.Add(new MySqlParameter("@idRepresentant", intervenant.Representant.Id));
_requete.Parameters.Add(new MySqlParameter("@idCompagnie", intervenant.Compagnie.Id));
_requete.Parameters.Add(new MySqlParameter("@idAssureur", intervenant.Assureur.Id));
_requete.Parameters.Add(new MySqlParameter("@idExpert", intervenant.Expert.Id));
_requete.Parameters.Add(new MySqlParameter("@idDossier", intervenant.IdDossier));
_requete.Parameters.Add(new MySqlParameter("@id", intervenant.Id));
_requete.ExecuteNonQuery();
_connexion.Close();
}
public void CreerIntervenant(Intervenant intervenant)
{
//
string[] listeTablesAInsert = new string[] { "Intervenant", "Compagnie", "Expert", "Representant", "Assureur", "Representant" };
int[] idsRetourneesParLesRequetes = new int[listeTablesAInsert.Length];
for (int k = 0; k < listeTablesAInsert.Length; k++)
{
_connexion.Open();
_requete = new MySqlCommand("INSERT INTO " + listeTablesAInsert[k] + "() VALUES()", _connexion);
_requete.ExecuteNonQuery();
_connexion.Close();
idsRetourneesParLesRequetes[k] = SelectMaxId(listeTablesAInsert[k]);
}
intervenant.Id = idsRetourneesParLesRequetes[0];
intervenant.Compagnie.Id = idsRetourneesParLesRequetes[1];
intervenant.Expert.Id = idsRetourneesParLesRequetes[2];
intervenant.Representant.Id = idsRetourneesParLesRequetes[3];
intervenant.Assureur.Id = idsRetourneesParLesRequetes[4];
intervenant.Assureur.Representant.Id = idsRetourneesParLesRequetes[5];
MettreAJourIntervenant(intervenant);
MettreAJourAssureur(intervenant.Assureur);
}