private void cmbSports_SelectedIndexChanged(object sender, EventArgs e)
{
// clear des zones d'affichage
txtId.Clear();
txtNom.Clear();
txtPrenom.Clear();
txtMail.Clear();
// On ne charge la liste des adhérents que si la liste sports est entièrement chargée
if (this.listeSportChargee)
{
Bdd bdd = Bdd.getInstance();
bdd.Ouvrir();
cmbAdherents.Enabled = true;
DataTable dt = new DataTable();
dt.Load(bdd.GetAdherentBySport((int)cmbSports.SelectedValue));
this.sportChange = true;
cmbAdherents.DataSource = dt;
cmbAdherents.ValueMember = "id";
cmbAdherents.DisplayMember = "idNom";
cmbAdherents.Text = "-- sélectionnez --";
pnlAdherent.Enabled = false;
bdd.Fermer();
this.sportChange = false;
}
}
private void cmbAdherents_SelectedIndexChanged(object sender, EventArgs e)
{
if (!this.sportChange)
{
pnlAdherent.Enabled = true;
Bdd bdd = Bdd.getInstance();
bdd.Ouvrir();
MySqlDataReader reader = bdd.GetAdherentById((int)cmbAdherents.SelectedValue);
if (reader.HasRows)
{
reader.Read();
txtId.Text = reader.GetInt32("id").ToString();
txtNom.Text = reader.GetString("nom");
txtPrenom.Text = reader.GetString("prenom");
txtMail.Text = reader.GetString("mail");
lblModifMail.Visible = false;
btnModifMail.Enabled = false;
}
bdd.Fermer();
}
}
private void FrmSport_Load(object sender, EventArgs e)
{
Bdd bdd = Bdd.getInstance();
bdd.Ouvrir();
MySqlDataReader reader = bdd.GetSports();
DataTable dt = new DataTable();
dt.Load(reader);
cmbSports.DataSource = dt;
cmbSports.ValueMember = "id";
cmbSports.DisplayMember = "libelle";
bdd.Fermer();
cmbSports.Text = "-- sélectionnez --";
this.listeSportChargee = true;
pnlAdherent.Enabled = false;
String emailPattern = @"^[\w!#$%&'*+\-/=?\^_`{|}~]+(\.[\w!#$%&'*+\-/=?\^_`{|}~]+)*"
+ "@"
+ @"((([\-\w]+\.)+[a-zA-Z]{2,4})|(([0-9]{1,3}\.){3}[0-9]{1,3}))\z";
this.regxMail = new Regex(emailPattern);
}
private void btnModifMail_Click(object sender, EventArgs e)
{
Bdd bdd = Bdd.getInstance();
try
{
bdd.Ouvrir();
bdd.UpdateMail(Convert.ToInt32(txtId.Text), txtMail.Text);
lblModifMail.Text = "Mise à jour effectuée";
lblModifMail.ForeColor = Color.Green;
}
catch (Exception ex)
{
lblModifMail.Text = ex.Message;
lblModifMail.ForeColor = Color.Red;
}
finally
{
lblModifMail.Visible = true;
btnModifMail.Enabled = false;
bdd.Fermer();
}
}
