/// <summary> /// envoie les champs modifier dans la base de donnée /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void ConfirmeAD_Click(object sender, EventArgs e) { DBConnectTest db = new DBConnectTest(); string upNom = textNomAD.Text; string upPrenom = textPrenomAD.Text; DateTime upDate = dateTimePicker1.Value; string upSexe = textSexeAD.Text; string upVille = textVilleAD.Text; string upAdresse = textAdresseAD.Text; int upNumLicence = Convert.ToInt32(textNumLicence.Text); int upCP = Convert.ToInt32(textCPAD.Text); int upCotisation = Convert.ToInt32(textCotisationAD.Text); db.UpdateAD(upNom, upPrenom, upVille, upAdresse, upSexe, upCP, upCotisation, upDate, upNumLicence, ID); actuAD(); textBoxClearAD(); ConfirmeAD.Hide(); ModifierAD.Show(); ID = 0; }
/// <summary> /// permet de recuperer les données de la base de donnée et les metre dans les champs et ainsi les modifier /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void ModifierAD_Click(object sender, EventArgs e) { int x = ListeAD.SelectedIndex; DBConnectTest db = new DBConnectTest(); textNomAD.Text = bb[x].GetNom(); textPrenomAD.Text = bb[x].GetPrenom(); dateTimePicker1.Text = Convert.ToString(bb[x].GetDateNaissance()); textSexeAD.Text = bb[x].GetSexe(); textVilleAD.Text = bb[x].GetVille(); textAdresseAD.Text = bb[x].GetAdresse(); textNumLicence.Text = Convert.ToString(bb[x].GetNumLicence()); textCPAD.Text = Convert.ToString(bb[x].GetCP()); textCotisationAD.Text = Convert.ToString(bb[x].GetCotisation()); ID = bb[x].GetID(); ConfirmeAD.Show(); ModifierAD.Hide(); // if () }