Get xml data

-
   private KDLModel.RateShop Rate(RateShopLoadML rateShop)
        {

            KDLModel.RateShop rate = new KDLModel.RateShop();
            Uri InitUrl = new Uri("https://webservices.averittexpress.com/LTLRateQuoteService");
            System.Xml.XmlNodeList xmlList = null;
            RateShop.RateShopBAL rateShopBAL = new RateShop.RateShopBAL();
            try
            {
                CarrierUserML carrierUser = new RateShop.RateShopBAL().GetIndividualUserByCarrier(rateShop.CarrierId, rateShop.userCarriers); // Carrier Markup

                #region Authentication
                CarrierUserML cUser = new CarrierUserML();
                CarriersDAL cDal = new CarriersDAL();
                cUser = cDal.GetCarrierCredentials(rateShop.CreatedBy.Value, rateShop.CarrierId);
                System.Net.NetworkCredential myCred = new System.Net.NetworkCredential();
                myCred.UserName = cUser.UserName;
                myCred.Password = cUser.Password;
                #endregion

                // Set up the HTTP Request
                HttpWebRequest wReq = (HttpWebRequest)WebRequest.Create(InitUrl);
                byte[] bytes;
                bytes = System.Text.Encoding.ASCII.GetBytes(returnUrl(rateShop));
                wReq.ContentType = "text/xml; encoding='utf-8'";
                wReq.Method = "POST";
                wReq.Timeout = 10000;
                wReq.KeepAlive = false;

                // NetworkCredential myCred = new NetworkCredential("Progressp", "Edward42");

                CredentialCache myCache = new CredentialCache();
                myCache.Add(InitUrl, "Basic", myCred);
                wReq.Credentials = myCache;
                wReq.PreAuthenticate = true;

                Stream requestStream = wReq.GetRequestStream();
                requestStream.Write(bytes, 0, bytes.Length);
                requestStream.Close();

                HttpWebResponse response = (HttpWebResponse)wReq.GetResponse();
                Stream responseStream = response.GetResponseStream();
                StreamReader reader = new StreamReader(responseStream);
                System.Xml.XmlDocument document = new System.Xml.XmlDocument();
                string responseFromServer = reader.ReadToEnd();
                document.LoadXml(responseFromServer);
                xmlList = document.GetElementsByTagName("return");
                foreach (XmlNode item in xmlList)
                {
                    string RateQuoteNumber = item["ns2:RateQuoteNumber"].InnerText;
                    string NetTotal = item["ns2:NetTotal"].InnerText.Replace("$", "");
                    string EstimatedServiceDays = item["ns2:EstimatedServiceDays"].InnerText;
                    string ShipmentDate = item["ns2:ShipmentDate"].InnerText;

                    rate.EstTransit = EstimatedServiceDays;
                    rate.Rate = NetTotal;
                    rate.QuoteNumber = RateQuoteNumber;
                    rate.EstDelivery = Convert.ToDateTime(ShipmentDate).AddDays(Convert.ToInt64(EstimatedServiceDays)).ToShortDateString();
                    rate.Direct = "D";
                    rate.Mode = "LTL";
                    rate.ServiceLevel = "Standard";
                    rate = rateShopBAL.AdditionalMarkupCalculation(rateShop, carrierUser, rate);   //for Carrier Markup
                }


            }
            catch (Exception ex)
            {
                if (xmlList != null)
                {
                    if (xmlList.Count > 0)
                    {
                        foreach (XmlNode item in xmlList)
                        {

                            rate.ErrorMessage = item["ns2:Error"].InnerText;
                        }
                    }
                }
                else
                {
                    rate.ErrorMessage = ex.Message;
                }

            }
            return rate;
        }

Comments

  1. adesh January 4, 2016 at 9:20 AM

    var markers = [];
    var map = '';
    function ShowTrack(address) {
    markers = [];
    debugger;
    var lst = address.split('~');
    GetMarkers(address);
    {
    if (lst.length > 1) {
    var mapOptions = {
    center: new google.maps.LatLng(markers[0].lat, markers[0].lng),
    zoom: 10,
    mapTypeId: google.maps.MapTypeId.ROADMAP
    };
    map = new google.maps.Map(document.getElementById("dvMap"), mapOptions);


    var lat_lng = new Array();
    var latlngbounds = new google.maps.LatLngBounds();
    for (i = 0; i < markers.length; i++) {
    var data = markers[i]
    var myLatlng = new google.maps.LatLng(data.lat, data.lng);
    lat_lng.push(myLatlng);


    var marker = new google.maps.Marker({
    position: myLatlng,
    map: map,
    title: data.title
    });
    latlngbounds.extend(marker.position);

    }
    google.maps.event.addListenerOnce(map, 'idle', function () {

    google.maps.event.trigger(map, 'resize');
    // map.setCenter(latlngbounds.getCenter());
    var center = new google.maps.LatLng(50, 3, 10.9);
    map.setCenter(center);
    map.fitBounds(latlngbounds);
    });
    map.setCenter(latlngbounds.getCenter());
    map.fitBounds(latlngbounds);

    //***********ROUTING****************//
    //Initialize the Path Array
    var path = new google.maps.MVCArray();
    //Initialize the Direction Service
    var service = new google.maps.DirectionsService();
    //Set the Path Stroke Color
    var poly = new google.maps.Polyline({ map: map, strokeColor: '#4986E7' });

    //Loop and Draw Path Route between the Points on MAP
    for (var i = 0; i < lat_lng.length; i++) {
    if ((i + 1) < lat_lng.length) {
    var src = lat_lng[i];
    var des = lat_lng[i + 1];
    path.push(src);
    poly.setPath(path);
    service.route({
    origin: src,
    destination: des,
    travelMode: google.maps.DirectionsTravelMode.DRIVING
    }, function (result, status) {
    if (status == google.maps.DirectionsStatus.OK) {
    for (var i = 0, len = result.routes[0].overview_path.length; i < len; i++) {
    path.push(result.routes[0].overview_path[i]);
    }
    }
    });
    }
    }
    }
    }
    }

    ReplyDelete

Post a Comment

Popular posts from this blog

Querying a Data Table Using Select Method and Lambda Expressions in Dot Net

-
Image
.Net Questions and Ans.. Q. 1 Querying a Data Table Using Select Method and Lambda Expressions in Dot Net Suppose we have a DataTable object having four fields: SSN, NAME, ADDRESS and AGE. We could create a data table and add columns in the following way: DataTable  dt =  new   DataTable (); dt.Columns.Add( "SSN" ,  typeof ( string )); dt.Columns.Add( "NAME" ,  typeof ( string )); dt.Columns.Add( "ADDR" ,  typeof ( string )); dt.Columns.Add( "AGE" ,  typeof ( int )); // Showing how to set Primary Key(s) in a Data table (Although it's not compulsory to have one) DataColumn [] keys =  new   DataColumn [1]; keys[0] = dt.Columns[0]; dt.PrimaryKey = keys; Now we store some data in our data table "dt" to show how we can perform several queries on the DataTable object like filtering some data, finding a person's record...
Read more

StringToTable

-
ALTER FUNCTION [dbo].[udf_StringToTable] (       @list NVARCHAR(MAX) ,       @delimiter NCHAR(1) = ',' --Defaults to CSV ) RETURNS @tableList TABLE ( value nvarchar(MAX) ) AS BEGIN     DECLARE @value NVARCHAR(MAX)     DECLARE @position INT     SET @list = LTRIM(RTRIM(@list))+ ','     SET @position = CHARINDEX(@delimiter, @list, 1)     IF REPLACE(@list, @delimiter, '') <> ''     BEGIN         WHILE @position > 0         BEGIN             SET @value = LTRIM(RTRIM(LEFT(@list, @position - 1)))             IF @value <> ''             BEGIN                 INSERT INTO @tableList (value)   ...
Read more

GetPhoneSSNFormat

-
ALTER FUNCTION [dbo].[udf_GetPhoneSSNFormat] (     -- Add the parameters for the function here     @TypeId        INT,     @DataValue    NVARCHAR(MAX) ) RETURNS NVARCHAR(MAX) AS BEGIN     DECLARE @FormattedValue    NVARCHAR(MAX)     SET @FormattedValue = ''     -- Will Remove all white spaces, brackets, hyphens     DECLARE @OriginalValue    NVARCHAR(MAX)     SET @OriginalValue = ISNULL(REPLACE(REPLACE(REPLACE(REPLACE(@DataValue,'(',''),')',''),'-',''),' ',''),'')         -- Type Id : 1 For Phone #     -- Type Id : 2 For SSN #     IF @TypeId = 1         BEGIN             SELECT @FormattedValue =              ...
Read more