public static void Shop_GetOrderCount(string StoreName, string APIKey, string Password)
{
ShopifyClient sp = new ShopifyClient(StoreName, APIKey, Password);
SqlPipe p = SqlContext.Pipe;
// Create the record and specify the metadata for the columns.
SqlDataRecord record = new SqlDataRecord(new SqlMetaData("OrderCount", SqlDbType.Int));
// Mark the begining of the result-set.
SqlContext.Pipe.SendResultsStart(record);
record.SetInt32(0,sp.GetOrderCount());
// Send the row back to the client.
SqlContext.Pipe.SendResultsRow(record);
// Mark the end of the result-set.
SqlContext.Pipe.SendResultsEnd();
}
private void GetOrderCount()
{
sp = new ShopifyClient(_storename, _apikey, _password);
txtRawData_Copy.Clear();
txtRawData_Copy.Text = "Total Order Count: " + sp.GetOrderCount().ToString();
}