예제 #1
0
        private void pictureBox2_Click(object sender, EventArgs e)
        {
            this.Hide();
            GestionAssoc ga = new GestionAssoc();

            ga.Show();
        }
예제 #2
0
        private void button1_Click(object sender, EventArgs e)
        {
            SqlConnection  con = new SqlConnection(@"Data Source=(LocalDB)\MSSQLLocalDB;AttachDbFilename=F:\Folder\MiniProjet\Gestion_Association\MiniProjet\MiniProjet.mdf;Integrated Security=True;Connect Timeout=30");
            SqlDataAdapter sda = new SqlDataAdapter("Select count(*) from [ADMIN] where username='******' and password = '******'", con);
            DataTable      dt  = new DataTable();

            sda.Fill(dt);
            if (dt.Rows[0][0].ToString() == "1")
            {
                this.Hide();
                Form us1 = new GestionAssoc();
                us1.Show();
            }
            else
            {
                MessageBox.Show(this, "Nom d'utilisateur ou Mot de pass Incorrect", "Erreur", MessageBoxButtons.OK, MessageBoxIcon.Error);
            }
        }
예제 #3
0
        private void button1_Click(object sender, EventArgs e)
        {
            //TextBox tb = new TextBox();
            //if (tb != argentTB && string.IsNullOrEmpty(tb.Text))
            //{
            //    MessageBox.Show(this, "Certains champs n'ont pas était remplit", "Erreur", MessageBoxButtons.OK, MessageBoxIcon.Error);
            //    //button1.Enabled = false;
            //    return;
            //}


            string  nom          = nomTB.Text;
            string  prenom       = prenomTB.Text;
            string  cin          = cinTB.Text;
            string  ville        = villeTB.Text;
            string  code_postal  = cpTB.Text;
            char    sexe         = genderCBX.Text == "Masculin" ?'M' : 'F';
            string  email        = emailTB.Text;
            string  tele         = phoneTB.Text;
            string  date_naiss   = birthdayCAL.Value.ToShortDateString();
            string  lieu_naiss   = birthplaceTB.Text;
            string  statut       = statutCBX.Text;
            string  statut_civil = statutCivilCBX.Text;
            string  position     = positionCBX.Text;
            decimal somme_arg    = 0;

            if (argentTB.Text != "")
            {
                somme_arg = decimal.Parse(argentTB.Text);
            }
            string methode_pay = methodeCBX.Text;



            //string query = "insert into MEMBRE (nom,prenom,cin,ville,Code_Postal,sexe,email,num_tele,date_naissance,lieu_naissance,statut,statut_civil,position) values('"+ nom + "','"+ prenom + "','"+ cin + "','"+ ville + "','"+ code_postal + "','"+ sexe + "','"+ email + "','"+ tele + "','"+ date_naiss + "','"+ lieu_naiss + "','"+ statut + "','"+ statut_civil + "','"+ position+"')";
            string query = "insert into MEMBRE (nom,prenom,cin,ville,Code_Postal,sexe,email,num_tele,date_naissance,lieu_naissance,statut,statut_civil) values(@nom,@prenom,@cin,@ville,@code_postal,@sexe,@email,@tele,@date_naiss,@lieu_naiss,@statut,@statut_civil)";

            SqlConnection  con  = new SqlConnection(@"Data Source=(LocalDB)\MSSQLLocalDB;AttachDbFilename=F:\Folder\MiniProjet\Gestion_Association\MiniProjet\MiniProjet.mdf;Integrated Security=True;Connect Timeout=30");
            SqlDataAdapter sda  = new SqlDataAdapter();
            SqlDataAdapter sda1 = new SqlDataAdapter("Select count(*) from [Membre] where cin='" + cin + "'", con);
            DataTable      dt   = new DataTable();

            sda1.Fill(dt);
            if (dt.Rows[0][0].ToString() == "1")
            {
                MessageBox.Show(this, "Membre déja inscrit !", "Erreur", MessageBoxButtons.OK, MessageBoxIcon.Error);
            }
            else
            {
                sda.InsertCommand = new SqlCommand(query, con);
                sda.InsertCommand.Parameters.Add("@nom", SqlDbType.VarChar).Value          = nom;
                sda.InsertCommand.Parameters.Add("@prenom", SqlDbType.VarChar).Value       = prenom;
                sda.InsertCommand.Parameters.Add("@cin", SqlDbType.VarChar).Value          = cin;
                sda.InsertCommand.Parameters.Add("@ville", SqlDbType.VarChar).Value        = ville;
                sda.InsertCommand.Parameters.Add("@code_postal", SqlDbType.VarChar).Value  = code_postal;
                sda.InsertCommand.Parameters.Add("@sexe", SqlDbType.Char).Value            = sexe;
                sda.InsertCommand.Parameters.Add("@email", SqlDbType.VarChar).Value        = email;
                sda.InsertCommand.Parameters.Add("@tele", SqlDbType.VarChar).Value         = tele;
                sda.InsertCommand.Parameters.Add("@date_naiss", SqlDbType.Date).Value      = date_naiss;
                sda.InsertCommand.Parameters.Add("@lieu_naiss", SqlDbType.VarChar).Value   = lieu_naiss;
                sda.InsertCommand.Parameters.Add("@statut", SqlDbType.VarChar).Value       = statut;
                sda.InsertCommand.Parameters.Add("@statut_civil", SqlDbType.VarChar).Value = statut_civil;
                con.Open();
                try
                {
                    sda.InsertCommand.ExecuteNonQuery();
                    DataSet ds = new DataSet();
                    sda = new SqlDataAdapter("select MAX(id) from MEMBRE", con);
                    sda.Fill(ds, "member_id");
                    int membre_id = int.Parse(ds.Tables["member_id"].Rows[0][0].ToString());
                    query             = "insert into Adhesion(id_membre,position) values (@membre_id,@position)";
                    sda.InsertCommand = new SqlCommand(query, con);
                    sda.InsertCommand.Parameters.Add("@membre_id", SqlDbType.Int).Value    = membre_id;
                    sda.InsertCommand.Parameters.Add("@position", SqlDbType.VarChar).Value = position;
                    sda.InsertCommand.ExecuteNonQuery();
                    query             = "insert into Payement (membre_id,methode_payement,somme_argent) values (@membre_id,@methode_payement,@somme_argent)";
                    sda.InsertCommand = new SqlCommand(query, con);
                    sda.InsertCommand.Parameters.Add("@membre_id", SqlDbType.Int).Value            = membre_id;
                    sda.InsertCommand.Parameters.Add("@methode_payement", SqlDbType.VarChar).Value = methode_pay;
                    sda.InsertCommand.Parameters.Add("@somme_argent", SqlDbType.VarChar).Value     = somme_arg;

                    sda.InsertCommand.ExecuteNonQuery();
                    var mb = MessageBox.Show(this, "Membre Ajouté!", "Operation réussi", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
                    if (mb == DialogResult.OK)
                    {
                        this.Hide();
                        GestionAssoc ga = new GestionAssoc();
                        ga.Show();
                    }
                }catch (Exception ex)
                {
                    MessageBox.Show("Certains champs n'ont pas était remplis");
                }
            }
        }