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(); }