Exemplo n.º 1
0
        private void Add_Click(object sender, RoutedEventArgs e)
        {
            using (var command = new SqlCommand("AddNewUser", Connect.Conn)
            {
                CommandType = CommandType.StoredProcedure
            })
            {
                command.Parameters.Add(new SqlParameter("@login", TextBoxLogin.Text));
                command.Parameters.Add(new SqlParameter("@email", TextBoxEmail.Text));
                command.Parameters.Add(new SqlParameter("@password", Convert.ToBase64String(SHA256.Create().ComputeHash(Encoding.UTF8.GetBytes(TextBoxPassword.Text)))));

                using (var rsa = new RSACryptoServiceProvider(1024))
                {
                    try
                    {
                        byte[] pub  = rsa.ExportCspBlob(false);
                        byte[] priv = rsa.ExportCspBlob(true);
                        string rsaBlock;

                        rsaBlock = Convert.ToBase64String(pub);
                        command.Parameters.Add(new SqlParameter("@key", rsaBlock));
                    }
                    finally
                    {
                        rsa.PersistKeyInCsp = false;
                    }
                }

                command.ExecuteNonQuery();

                AddUserCorrWindow AdUsC = new AddUserCorrWindow();
                TextBoxLogin.Text    = "";
                TextBoxEmail.Text    = "";
                TextBoxPassword.Text = "";

                AdUsC.ShowDialog();
            }
        }
        private void Add_Click(object sender, RoutedEventArgs e)
        {
            using (var command = new SqlCommand("AddNewRoom", Connect.Conn)
            {
                CommandType = CommandType.StoredProcedure
            })
            {
                command.Parameters.Add(new SqlParameter("@name_room", TextBoxName.Text));
                command.Parameters.Add(new SqlParameter("@limit", TextBoxLimit.Text));

                byte[] key = new byte[16];
                RandomNumberGenerator rand = RandomNumberGenerator.Create();
                rand.GetBytes(key);
                command.Parameters.Add(new SqlParameter("@key", Convert.ToBase64String(key)));

                command.ExecuteNonQuery();

                AddUserCorrWindow AdUsC = new AddUserCorrWindow();
                TextBoxName.Text  = "";
                TextBoxLimit.Text = "";

                AdUsC.ShowDialog();
            }
        }