.NET (Core and Framework)

I would like to create a wrap to call the API of the exchange btc-aplha as it implements the DCY currency which is the only one of an Italian project. My difficulty is understanding the rules for implementing key based authorization. The documentation is very sparse and I don't understand the examples which are in phyton or node.js

https://btc-alpha.github.io/api-docs/?javascript#authorization

Can anyone help me to implement the following methods I took from the node.js example

<pre>const hmacSha256 = require('crypto-js/hmac-sha256'); // sha256 hash. or use you favorite u like
const request = require('request'); // for http requests. or use you favorite u like

const BASE_URL = 'https://btc-alpha.com/api/v1';
const API_KEY = '0000-0000...';
const SECRET = 'Z%2........';

//Serialize for singing only. Can be used in request body if u like urlencoded form format instead of json
function serializePayload(payload) {
  return Object
    .keys(payload) // get keys of payload object
    .sort() // sort keys
    .map((key) => key + "=" + encodeURIComponent(payload[key])) // each value should be url encoded. the most sensitive part for sign checking
    .join('&'); // to sting, separate with ampersand
}

// Generates auth headers
function getAuthHeaders(payload) {
  // get SHA256 of <API_KEY><sorted urlencoded payload string><SECRET>
  const sign = hmacSha256(API_KEY + serializePayload(payload), SECRET).toString();

  return {
    'X-KEY': API_KEY,
    'X-SIGN': sign,
    'X-NONCE': Date.now()
  };
}

function getWallets(callback) {
  payload = {};

  const options = {
    method: 'get',
    url: `${BASE_URL}/wallets/`,
    headers: getAuthHeaders(payload)
  };

  request(options, callback);
}

function createOrder(order, callback) {
  const options = {
    method: 'post',
    url: `${BASE_URL}/order/`,
    headers: getAuthHeaders(order),
    form: order, // API accepts urlencoded form or json. Use appropriate headers!
  };

  request(options, callback);
}

// test
getWallets((error, response, body) => {
  console.log('error', error);
  console.log('body', body);
});

const order = {
  type: 'buy',
  pair: 'BTC_USD',
  amount: '0.0001',
  price: '0.1'
};

createOrder(order, (error, response, body) => {
  // get json, etc
  console.log('error', error);
  console.log('body', body);
});

Dear folks.

I am writing a program for connecting sql server database, and populating data from table using a stored procedure. it is working fine when I use the app.config file's data source as the server name, but when I use the server's ip address and port, it is not working. 

it is showing error, stored procedure not found.

My app config's connection string is as below.

<connectionStrings>  
      <clear />  
      <add name="CONNECTION_FLOR"
       providerName="Microsoft.Data.SqlClient"
       connectionString="Data Source=172.142.1.100,1433;User ID=redacted;Password=redacted;Initial Catalog=tempdb;Integrated Security=True;Connect Timeout=30;Encrypt=False;TrustServerCertificate=False;ApplicationIntent=ReadWrite;MultiSubnetFailover=False" />  
      </connectionStrings>

But when I use Data Source by name as Data Source=(localdb)\SubdivprojV13; it is working all good. The problem is with ip address and port. I checked the connection, connection is opening. But showing error as stored procedure not found.


please check my code snippet.

Public Class Form1
    Dim connection As New SqlConnection(ConfigurationManager.ConnectionStrings("CONNECTION_FLOR").ConnectionString)
    Private Sub BTN_DISPLAY_Click(sender As Object, e As EventArgs) Handles BTN_DISPLAY.Click
        Dim cmd As New SqlCommand With {
            .Connection = connection,
            .CommandType = CommandType.StoredProcedure,
            .CommandText = "SP_DISPLAY"
        }
        cmd.Connection.Open()
        lbl_CONN.Text = "Connected"
        lbl_CONN.ForeColor = Color.Green

        Dim dt As DataTable = New DataTable()
        dt.Load(cmd.ExecuteReader)
        DataGridView1.DataSource = dt
        DataGridView1.Update()

        If connection.State = ConnectionState.Open Then
            connection.Close()
            lbl_CONN.Text = "DisConnected"
            lbl_CONN.ForeColor = Color.Red
        End If
    End Sub
End Class

Any help is highly appreciated. Thanks in advance,.

using (SQLiteCommand cmd =      conn.CreateCommand())
         {
          try
         {
    
         cmd.CommandText = @"SELECT * FROM.  customer WHERE lastname = @setName";
    
        cmd.Parameters.AddWithValue("@setName", txt_name.Text);
    
        da_Customer = new SQLiteDataAdapter(cmd.CommandText, conn);
         dt_Customer = new DataTable();
        da_Customer.Fill(dt_Customer);
        dgv_customer.DataSource = dt_Customer;
        }
         catch (Exception ex)
       {
        MessageBox.Show(ex.Message);
         }
         }