#region Namespaces

using System;

using System.Collections.Generic;

using System.Data;

using System.Data.SqlClient;

using System.IO;

using System.Linq;

using System.Net;

using System.Text;

using System.Web;

using System.Xml;

using System.Xml.Linq;

#endregion

​

​

namespace ST_cf00dad7b5884f678750e66a480775bf

{

    /// <summary>

    /// ScriptMain is the entry point class of the script.  Do not change the name, attributes,

    /// or parent of this class.

    /// </summary>

public partial class ScriptMain

    {

        public void Main(string test)

    {

          XmlDocument doc = new XmlDocument();

          doc.LoadXml(@"<soapenv:Envelope xmlns:soapenv='http://schemas.xmlsoap.org/soap/envelope/'>

          <soapenv:Header/>

   <soapenv:Body>

      <GetMessageReq>

         <MsgHeader>

            <!--Optional:-->

            <SourceSystem location='RICO_SageX3'></SourceSystem>

         </MsgHeader>

         <!--Optional:-->

         <MethodName>GetMsgRefListFromGivenRefID</MethodName>

         <!--Optional:-->

         <Parameters>

            <Parameter name='msgEventName'>Task</Parameter>

            <Parameter name='msgEventRef'>1</Parameter>

         </Parameters>

      </GetMessageReq>

   </soapenv:Body>

</soapenv:Envelope>");

        string SoapOutput = CallMyWebService(doc);

        Console.WriteLine(SoapOutput);  

    }

​

        #region Help:  Using Integration Services variables and parameters in a script

        /* To use a variable in this script, first ensure that the variable has been added to 

         * either the list contained in the ReadOnlyVariables property or the list contained in 

         * the ReadWriteVariables property of this script task, according to whether or not your

         * code needs to write to the variable.  To add the variable, save this script, close this instance of

         * Visual Studio, and update the ReadOnlyVariables and 

         * ReadWriteVariables properties in the Script Transformation Editor window.

         * To use a parameter in this script, follow the same steps. Parameters are always read-only.

         * 

         * Example of reading from a variable:

         *  DateTime startTime = (DateTime) Dts.Variables["System::StartTime"].Value;

         * 

         * Example of writing to a variable:

         *  Dts.Variables["User::myStringVariable"].Value = "new value";

         * 

         * Example of reading from a package parameter:

         *  int batchId = (int) Dts.Variables["$Package::batchId"].Value;

         *  

         * Example of reading from a project parameter:

         *  int batchId = (int) Dts.Variables["$Project::batchId"].Value;

         * 

         * Example of reading from a sensitive project parameter:

         *  int batchId = (int) Dts.Variables["$Project::batchId"].GetSensitiveValue();

         * */

​

        #endregion

​

        #region Help:  Firing Integration Services events from a script

        /* This script task can fire events for logging purposes.

         * 

         * Example of firing an error event:

         *  Dts.Events.FireError(18, "Process Values", "Bad value", "", 0);

         * 

         * Example of firing an information event:

         *  Dts.Events.FireInformation(3, "Process Values", "Processing has started", "", 0, ref fireAgain)

         * 

         * Example of firing a warning event:

         *  Dts.Events.FireWarning(14, "Process Values", "No values received for input", "", 0);

         * */

        #endregion

​

        #region Help:  Using Integration Services connection managers in a script

        /* Some types of connection managers can be used in this script task.  See the topic 

         * "Working with Connection Managers Programatically" for details.

         * 

         * Example of using an ADO.Net connection manager:

         *  object rawConnection = Dts.Connections["Sales DB"].AcquireConnection(Dts.Transaction);

         *  SqlConnection myADONETConnection = (SqlConnection)rawConnection;

         *  //Use the connection in some code here, then release the connection

         *  Dts.Connections["Sales DB"].ReleaseConnection(rawConnection);

         *

         * Example of using a File connection manager

         *  object rawConnection = Dts.Connections["Prices.zip"].AcquireConnection(Dts.Transaction);

         *  string filePath = (string)rawConnection;

         *  //Use the connection in some code here, then release the connection

         *  Dts.Connections["Prices.zip"].ReleaseConnection(rawConnection);

         * */

        #endregion

​

​

        /// <summary>

        /// This method is called when this script task executes in the control flow.

        /// Before returning from this method, set the value of Dts.TaskResult to indicate success or failure.

        /// To open Help, press F1.

        /// </summary>

​

        #region ScriptResults declaration

        /// <summary>

        /// This enum provides a convenient shorthand within the scope of this class for setting the

        /// result of the script.

        /// 

        /// This code was generated automatically.

        /// </summary>

​

        #endregion

         public XmlDocument LoadXml(string Envelope)

        {

            StringReader StrReader = new StringReader(Envelope);

            XmlDocument soapEnvelopeDocument = new XmlDocument();

            soapEnvelopeDocument.Load(StrReader);

            return soapEnvelopeDocument;

        }

​

        public string CallMyWebService(XmlDocument orderDoc)

        {

            string soapResult = null;

            ServicePointManager.Expect100Continue = true;

            ServicePointManager.SecurityProtocol = SecurityProtocolType.Tls12 | SecurityProtocolType.Ssl3 | SecurityProtocolType.Tls | SecurityProtocolType.Tls11;

            //ServicePointManager.SecurityProtocol = SecurityProtocolType.Ssl3 | SecurityProtocolType.Tls;

​

            var _url = "https://b2b-uat.gw.computacenter.com/?senderParty=MA_UK_RICOSX3_SYS&interface=SI_GetMessage_V2_SY_OB&interfaceNamespace=http://computacenter.com/global/Integration&zAdpt=soap&zI=nc2&zICC=true";

            var _action = "http://sap.com/xi/WebService/soap1.1";

            HttpWebRequest webRequest = CreateWebRequest(_url, _action);

            InsertSoapEnvelopeIntoWebRequest(orderDoc, webRequest);

​

            IAsyncResult asyncResult = webRequest.BeginGetResponse(null, null);

            asyncResult.AsyncWaitHandle.WaitOne();

​

            using (WebResponse webResponse = webRequest.EndGetResponse(asyncResult))

            {

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

                {

                    soapResult = rd.ReadToEnd();                                

                }

            }

​

            return soapResult;

​

            //return null;

        }

public string InsertData(string test)

{

    return "1";

}

​

        public void InsertSoapEnvelopeIntoWebRequest(XmlDocument soapEnvelopeXml, HttpWebRequest webRequest)

        {

            using (Stream stream = webRequest.GetRequestStream())

            {

                soapEnvelopeXml.Save(stream);

            }

        }

        public HttpWebRequest CreateWebRequest(string url, string action)

        {

            HttpWebRequest webRequest = (HttpWebRequest)WebRequest.Create(url);

            webRequest.Headers.Add("SOAPAction", action);

            webRequest.ContentType = "text/xml;charset=\"utf-8\"";

            webRequest.Accept = "text/xml";

            webRequest.Method = "POST";

            string authInfo = "MA_UK_RICOSX3_SYS-T:Umn0LTM5TyC5PCuHdUI0";

            authInfo = Convert.ToBase64String(Encoding.Default.GetBytes(authInfo));

            webRequest.Headers.Add("Authorization", "Basic " + authInfo);

            webRequest.Credentials = new NetworkCredential("MA_UK_RICOSX3_SYS-T", "Umn0LTM5TyC5PCuHdUI0");

            return webRequest;

        }

​

    }

    public class GetOutput

    {

        public int ID { get; set; }

        public DateTime Date { get; set; }

    }

}