void SaveAdresse()
{
Adresse ad = new Adresse();
ad.Id = idAdresse;
ad.Pays = paysTxt.Text;
ad.Ville = villeTxt.Text;
ad.Commune = comTxt.Text;
ad.Quartier = quartierTxt.Text;
ad.Enregistrer(ad);
}
public void ActionBtn()
{
try
{
switch (btnSave.Text)
{
case "Enregistrer":
if (fx.Question(1) == true)
{
adr.Id = id;
adr.Pays = fx.ValidateName(pays.Text);
adr.Province = fx.ValidateName(Province.Text);
adr.Ville = fx.ValidateName(ville.Text);
adr.Commune = fx.ValidateName(commune.Text);
adr.Quartier = fx.ValidateName(quartier.Text);
adr.Avenue = fx.ValidateName(avenue.Text);
adr.Numero = numero.Text;
if (adr.Enregistrer() == true)
{
fx.Message(1);
Actualiser();
}
}
break;
case "Modifier":
if (fx.Question(2) == true)
{
adr.Id = id;
adr.Pays = fx.ValidateName(pays.Text);
adr.Province = fx.ValidateName(Province.Text);
adr.Ville = fx.ValidateName(ville.Text);
adr.Commune = fx.ValidateName(commune.Text);
adr.Quartier = fx.ValidateName(quartier.Text);
adr.Avenue = fx.ValidateName(avenue.Text);
adr.Numero = numero.Text;
if (adr.Enregistrer() == true)
{
fx.Message(2);
Actualiser();
}
}
break;
}
}
catch (InvalidOperationException ex)
{
MessageBox.Show("Error when loading datas, " + ex.Message, "Loading datas", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
}
catch (System.Data.SqlClient.SqlException ex)
{
MessageBox.Show("Error when loading datas, " + ex.Message, "Loading datas", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
}
catch (MySql.Data.MySqlClient.MySqlException ex)
{
MessageBox.Show("Error when loading datas, " + ex.Message, "Loading datas", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
}
finally
{
if (ImplementeConnexion.Instance.Conn != null)
{
if (ImplementeConnexion.Instance.Conn.State == System.Data.ConnectionState.Open)
{
ImplementeConnexion.Instance.Conn.Close();
}
}
}
}
