Beispiel #1
0
        private void btnRegister_Click(object sender, RoutedEventArgs e)
        {
            try
            {
                using (DataBaseConnection db = new DataBaseConnection(this.ConnectionString))
                {
                    IList<String> parameterNames = new List<String>();
                    parameterNames.Add("uname");
                    parameterNames.Add("d_name");
                    parameterNames.Add("passwd_hash");

                    IList<OleDbType> parameterTypes = new List<OleDbType>();
                    parameterTypes.Add(OleDbType.VarChar);
                    parameterTypes.Add(OleDbType.VarChar);
                    parameterTypes.Add(OleDbType.VarChar);

                    IList<ParameterDirection> parameterDirections = new List<ParameterDirection>();
                    parameterDirections.Add(ParameterDirection.Input);
                    parameterDirections.Add(ParameterDirection.Input);
                    parameterDirections.Add(ParameterDirection.Input);

                    IList<Object> parameterValues = new List<Object>();
                    parameterValues.Add(txtUser.Text);
                    parameterValues.Add("Dorf von " + txtUser.Text);

                    String pw_hashed = MD5hash.GetHashString(txtPassowrd.Password);

                    parameterValues.Add(pw_hashed);

                    db.ExecuteSqlProcedure("CREATE_NEW_USER", parameterNames, parameterTypes, parameterDirections, parameterValues);
                    lblStatus.Content = "Neuer Nutzer registriert";
                }
            }
            catch (Exception ex)
            {
                MessageBox.Show("Error: " + ex.Message);
            }
        }