Exemple #1
0
        protected void send_Click(object sender, EventArgs e)
        {
            if (InscriptionNom.Text != "" && InscriptionName.Text != "" && InscriptionAge.Text != "" && InscriptionMail.Text != "" && InscriptionID.Text != "" && InscriptionMDP.Text != "" && InscriptionMDPC.Text != "")
            {
                string connetionString;
                connetionString = @"Data Source=mysql-cinemaneverland.alwaysdata.net;Database=cinemaneverland_bdd ;User ID=219115_wb;Password=wasefbelhocine01*";
                //connetionString = @"Server=tcp:myservertuto.database.windows.net,1433;Initial Catalog=mydbtuto;Persist Security Info=False;User ID=myadmin;Password=Admin123;MultipleActiveResultSets=False;Encrypt=True;TrustServerCertificate=False;Connection Timeout=30;";

                MySqlConnection cnn = new MySqlConnection(connetionString);

                cnn.Open();
                MySqlCommand          cmd = new MySqlCommand("select count(*) from user where login_user='******' ", cnn);
                MySqlDataAdapter      sda = new MySqlDataAdapter(cmd);
                System.Data.DataTable dt  = new System.Data.DataTable();
                sda.Fill(dt);
                cmd.ExecuteNonQuery();
                MySqlCommand          com    = new MySqlCommand("select count(*) from user where mail_user='******' ", cnn);
                MySqlDataAdapter      sd     = new MySqlDataAdapter(com);
                System.Data.DataTable datatb = new System.Data.DataTable();
                sd.Fill(datatb);
                com.ExecuteNonQuery();
                if (dt.Rows[0][0].ToString() == "1")
                {
                    ErrorMessage.Text = InscriptionID.Text + " ce login est déjà pris";
                }
                else if (datatb.Rows[0][0].ToString() == "1")
                {
                    ErrorMessage.Text = InscriptionMail.Text + " ce mail est déjà pris";
                }
                else if (InscriptionMDP.Text != InscriptionMDPC.Text)
                {
                    ErrorMessage.Text = "Les deux mot de passe ne coresspondent pas";
                }
                else
                {
                    connetionString = @"Data Source=mysql-cinemaneverland.alwaysdata.net;Database=cinemaneverland_bdd ;User ID=219115_wb;Password=wasefbelhocine01*";
                    cnn             = new MySqlConnection(connetionString);
                    cnn.Open();

                    MySqlCommand     command;
                    MySqlDataAdapter adapter = new MySqlDataAdapter();

                    String sql = "INSERT INTO `user`(id_user,nom_user,prenom_user,age_user,mail_user,login_user,mdp_user) VALUES('', @_Nom , @_Name , @_Age ,@_Mail, @_ID , @_Password )";

                    command = new MySqlCommand(sql, cnn);

                    adapter.InsertCommand = command;

                    InscriptionMDP.Text = Hasher.HashString(InscriptionMDP.Text.Trim());//hachage du mdp en sha1
                    command.Parameters.AddWithValue("@_Nom", InscriptionNom.Text);
                    command.Parameters.AddWithValue("@_Name", InscriptionName.Text);
                    command.Parameters.AddWithValue("@_Age", InscriptionAge.Text);
                    command.Parameters.AddWithValue("@_Mail", InscriptionMail.Text);
                    command.Parameters.AddWithValue("@_ID", InscriptionID.Text);
                    command.Parameters.AddWithValue("@_Password", InscriptionMDP.Text);

                    adapter.InsertCommand.ExecuteNonQuery();
                    command.Dispose();
                    ErrorMessage.Text = "Inscription Réussie ";
                    cnn.Close();
                }
            }
            else
            {
                ErrorMessage.Text = "Veuillez remplir tout les champs ";
            }
        }