Beispiel #1
0
        /// <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;
        }
Beispiel #2
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 ()
        }