using System;

using System.IO;

using System.Xml;   

using System.Net;

using System.Threading;

​

public class Program

{

    int successiveFailedCalls = 0;

    public static void Main()

    {

        SysTransactionV1Query();

    }

    private static dynamic SysTransactionV1Query()

    {

        XmlDocument xmlDocument = new XmlDocument();

        XmlDocument soapEnvelopeXmlResponse = new XmlDocument();

        var body = generateSysTransactionV1QueryBody();

        var request = createPostWebRequest(body);

        //Console.WriteLine(request);

        dynamic res = "";

        try

        {

            using (WebResponse response = request.GetResponse())

            {

                 successiveFailedCalls = 0;

​

                 using (StreamReader rd = new StreamReader(response.GetResponseStream()))

                 {

                     soapEnvelopeXmlResponse.Load(rd);

​

                     string results = soapEnvelopeXmlResponse.SelectSingleNode("descendant::Results").InnerText;

​

                     using (TextReader sr = new StringReader(results))

                     {

                         xmlDocument = new XmlDocument();

                         xmlDocument.Load(sr);

                         res = xmlDocument["margintransactions"];

                         Console.WriteLine("res: " + res);

                     }

                 }

             }

        }

        catch (Exception e)

        {

            Console.WriteLine(e);

            WebException we = e as WebException;

​

            successiveFailedCalls++;

​

            if (successiveFailedCalls < 15)

            {

                Thread.Sleep(3000);

                return SysTransactionV1Query();

            }

        }

        return res;

    }

    private static HttpWebRequest createPostWebRequest(XmlDocument body)

    {

        HttpWebRequest webRequest = (HttpWebRequest)WebRequest.Create("https://api.astutepayroll.com/webservice/");

        webRequest.ContentType = "text/xml;charset=\"ISO-8859-1\"";

        webRequest.Method = "POST";

​

        // HttpClient webRequest = new HttpClient();

        // string url = "https://api.astutepayroll.com/webservice/";

        // webRequest.DefaultRequestHeaders.Accept.Add(new MediaTypeWithQualityHeaderValue("text/xml;charset=\"ISO-8859-1\""));

        // webRequest.BaseAddress = new Uri(url);

​

        using (Stream stream = webRequest.GetRequestStream())

            // using (Stream stream = webRequest.GetStreamAsync(url))

        {

            body.Save(stream);

        }

​

        return webRequest;

    }

    private static XmlDocument generateSysTransactionV1QueryBody(

        string ApiKey = "agrilabour",

        string ApiUsername = "pt20.api",

        string ApiPassword = "fUK47G*oj$8A",

        string Query = "transaction_date >= '2019-07-01 00:00:00'")

    {

        XmlDocument xml = new XmlDocument();

​

        string format =

            @"<x:Envelope

                    xmlns:x=""http://schemas.xmlsoap.org/soap/envelope/""

                    xmlns:urn96=""urn:SysTransactionV1Query""

                    xmlns:urn=""urn:tsoIntegrator"">

                    <x:Header/>

                    <x:Body>

                        <urn96:SysTransactionV1Query>

                            <urn96:parms_in>

                                <urn:api_key>{0}</urn:api_key>

                                <urn:api_username>{1}</urn:api_username>

                                <urn:api_password>{2}</urn:api_password>

                                <urn:query>{3}</urn:query>

                            </urn96:parms_in>

                        </urn96:SysTransactionV1Query>

                    </x:Body>

                </x:Envelope>";

​

        xml.LoadXml(string.Format(

            format, 

            ApiKey, 

            ApiUsername, 

            ApiPassword, 

            Query));

​

        return xml;

    }

}