Send (Pass) parameter to XML based API on ASP.Net Button Click using C# and VB.Net

Hello

i have fixed the error the only thing now stuck is how to change the value in xml date and airport code dynamically.

protected void Button1_Click(object sender, EventArgs e)
{
 
    string xml = "~/postxmls/XMLFile1.xml";
    string apiurl = " http://iata.api.mashery.com/athena/ndc192api";
    string message = postXMLData(apiurl,xml);
}
public string read_xml(string xmlpath)
{
    string transactxml = HttpContext.Current.Server.MapPath("~/postxmls/XMLFile1.xml");
    var xmlDoc = new XmlDocument();        
 
    xmlDoc.Load(transactxml);
    return xmlDoc.OuterXml;
}
public string postXMLData(string destinationUrl, string requestXml)
{
    string xmlpath = read_xml(requestXml);
 
    HttpWebRequest request = (HttpWebRequest)WebRequest.Create(destinationUrl);
    byte[] bytes;
    bytes = System.Text.Encoding.ASCII.GetBytes(xmlpath);
    request.ContentType = "application/xml";
    request.ContentLength = bytes.Length;
    request.Method = "POST";
    
    request.Headers.Add("Authorization-Key", "ptstg9gr5ajwcrve8n267hg9");
    Stream requestStream = request.GetRequestStream();
    requestStream.Write(bytes, 0, bytes.Length);
    requestStream.Close();
    HttpWebResponse response;
    response = (HttpWebResponse)request.GetResponse();
    if (response.StatusCode == HttpStatusCode.OK)
    {
        Stream responseStream = response.GetResponseStream();
        string responseStr = new StreamReader(responseStream).ReadToEnd();
        return responseStr;
    }
    return null;
}

Hi nauna,

Read the xml string and convert the date value to the required format.

Refer below example.

Namespaces

C#

using System.Globalization;
using System.Xml;

VB.Net

Imports System.Globalization
Imports System.Xml

Code

C#

protected void Page_Load(object sender, EventArgs e)
{
    string xml = "<note><Name>Jan</Name><Created_date>20-01-2021 16:25:12</Created_date></note>";
    XmlDocument doc = new XmlDocument();
    doc.LoadXml(xml);
    string xpath = "note/Created_date";
    var nodes = doc.SelectNodes(xpath);
    foreach (XmlNode node in nodes)
    {
        node.InnerText = DateTime.ParseExact(node.InnerText, "dd-MM-yyyy HH:mm:ss", CultureInfo.InvariantCulture).ToString("dd-MMM-yyyy");
    }
    ClientScript.RegisterClientScriptBlock(this.GetType(), "", "alert('" + doc.OuterXml + "')", true);
}

VB.Net

Protected Sub Page_Load(ByVal sender As Object, ByVal e As EventArgs) Handles Me.Load
    Dim xml As String = "<note><Name>Jan</Name><Created_date>20-01-2021 16:25:12</Created_date></note>"
    Dim doc As XmlDocument = New XmlDocument()
    doc.LoadXml(xml)
    Dim xpath As String = "note/Created_date"
    Dim nodes = doc.SelectNodes(xpath)
    For Each node As XmlNode In nodes
        node.InnerText = DateTime.ParseExact(node.InnerText, "dd-MM-yyyy HH:mm:ss", CultureInfo.InvariantCulture).ToString("dd-MMM-yyyy")
    Next
    ClientScript.RegisterClientScriptBlock(Me.GetType(), "", "alert('" & doc.OuterXml & "')", True)
End Sub

Screenshot