SOAP mysql
contact Apply via Freelancers.net
date posted 16/12/2010
Hi i need some help getting data from a remote server.
I have been given a sample code in C# and password but i am unable to get the data.
I need this urgently and am willing to pay for the service.
letter and sample code below
######################
Hello,
I am sending sample of code presenting how to use our web service.
To use it you'd have to give your credentials plus the usercode, which is XXXXXXX for you.
Direct address to registration number lookup service is http://www.1stchoice.co.uk/1stChoiceServices/SupplierPub.asmx?op=RegnoLookup
If you have any troubles with the usage, please let me know.
Kind regards,
Maj
using System;
using System.Collections.Generic;
using System.Text;
using System.Xml;
namespace SupplierPubUsageExample
{
class Program
{
static private string sUsername = "username";
static string sPassword = "password";
static int iLastRefNum = 0;
//static string wsUrl = "http://localhost:3906/1stChoiceServices/SupplierPub.asmx";
static string wsUrl = "http://www.1stchoice.co.uk/1stChoiceServices/SupplierPub.asmx";
static void Main(string[] args)
{
//GetOrders(sUsername, sPassword, iLastRefNum);
MakeQuote(sUsername, sPassword);
}
static void GetOrders(string Username, string Password, int LastRefNum)
{
string ReturnString = "";
wsSupplier.SupplierPub ws = new wsSupplier.SupplierPub();
ws.Url = wsUrl;
ReturnString = ws.GetOrders(Username, Password, LastRefNum);
List lOrders = ParseGetOrdersResult(ReturnString);
}
private class PartDetails
{
public string pid;
public string pdsc;
public string pcmt;
public PartDetails(string pid, string pdsc, string pcmt)
{
this.pid = pid;
this.pdsc = pdsc;
this.pcmt = pcmt;
}
}
private class OrderDetails
{
public string rfno;
public string date;
public string cdes;
public string cmak;
public string cran;
public string cyer;
public string cbdy;
public string cbdt;
public string cgbx;
public string cfue;
public string cvin;
public string cenn;
public string cccs;
public string cclr;
public string creg;
public string unam;
public string uloc;
public string upos;
public string uphn;
public string umob;
public string ueml;
public List lParts = new List();
}
static List ParseGetOrdersResult(string ReturnString)
{
List lRet = new List();
XmlDocument document = new XmlDocument();
try
{
ReturnString = ReturnString.Replace("&", "&");
document.LoadXml(ReturnString);
XmlNode root = document.DocumentElement;
XmlNodeList xmlOrders = root.SelectNodes("descendant::rq");
foreach (XmlNode order in xmlOrders)
{
lRet.Add(ParseOrderXML(order));
}
}
catch (Exception ex)
{
string str = ex.Message;
//return error
}
return lRet;
}
static OrderDetails ParseOrderXML(XmlNode xmlOrder)
{
OrderDetails oRet = new OrderDetails();
XmlNode xmlOrDet01 = xmlOrder.SelectSingleNode("descendant::rfno");
oRet.rfno = xmlOrDet01.InnerText;
XmlNode xmlOrDet02 = xmlOrder.SelectSingleNode("descendant::date");
oRet.date = xmlOrDet02.InnerText;
XmlNode xmlOrDet03 = xmlOrder.SelectSingleNode("descendant::cdes");
oRet.cdes = xmlOrDet03.InnerText;
XmlNode xmlOrDet04 = xmlOrder.SelectSingleNode("descendant::cmak");
oRet.cmak = xmlOrDet04.InnerText;
XmlNode xmlOrDet05 = xmlOrder.SelectSingleNode("descendant::cran");
oRet.cran = xmlOrDet05.InnerText;
XmlNode xmlOrDet06 = xmlOrder.SelectSingleNode("descendant::cyer");
oRet.cyer = xmlOrDet06.InnerText;
XmlNode xmlOrDet07 = xmlOrder.SelectSingleNode("descendant::cbdy");
oRet.cbdy = xmlOrDet07.InnerText;
XmlNode xmlOrDet08 = xmlOrder.SelectSingleNode("descendant::cbdt");
oRet.cbdt = xmlOrDet08.InnerText;
XmlNode xmlOrDet09 = xmlOrder.SelectSingleNode("descendant::cgbx");
oRet.cgbx = xmlOrDet09.InnerText;
XmlNode xmlOrDet10 = xmlOrder.SelectSingleNode("descendant::cfue");
oRet.cfue = xmlOrDet10.InnerText;
XmlNode xmlOrDet11 = xmlOrder.SelectSingleNode("descendant::cvin");
oRet.cvin = xmlOrDet11.InnerText;
XmlNode xmlOrDet12 = xmlOrder.SelectSingleNode("descendant::cenn");
oRet.cenn = xmlOrDet12.InnerText;
XmlNode xmlOrDet13 = xmlOrder.SelectSingleNode("descendant::cccs");
oRet.cccs = xmlOrDet13.InnerText;
XmlNode xmlOrDet14 = xmlOrder.SelectSingleNode("descendant::cclr");
oRet.cclr = xmlOrDet14.InnerText;
XmlNode xmlOrDet15 = xmlOrder.SelectSingleNode("descendant::creg");
oRet.creg = xmlOrDet15.InnerText;
XmlNode xmlOrDet16 = xmlOrder.SelectSingleNode("descendant::unam");
oRet.unam = xmlOrDet16.InnerText;
XmlNode xmlOrDet17 = xmlOrder.SelectSingleNode("descendant::uloc");
oRet.uloc = xmlOrDet17.InnerText;
XmlNode xmlOrDet18 = xmlOrder.SelectSingleNode("descendant::upos");
oRet.upos = xmlOrDet18.InnerText;
XmlNode xmlOrDet19 = xmlOrder.SelectSingleNode("descendant::uphn");
oRet.uphn = xmlOrDet19.InnerText;
XmlNode xmlOrDet20 = xmlOrder.SelectSingleNode("descendant::umob");
oRet.umob = xmlOrDet20.InnerText;
XmlNode xmlOrDet21 = xmlOrder.SelectSingleNode("descendant::ueml");
oRet.ueml = xmlOrDet21.InnerText;
XmlNodeList xmlParts = xmlOrder.SelectNodes("descendant::part");
foreach (XmlNode xmlPart in xmlParts)
{
XmlNode xmlOrDet22 = xmlOrder.SelectSingleNode("descendant::pid");
XmlNode xmlOrDet23 = xmlOrder.SelectSingleNode("descendant::pdsc");
XmlNode xmlOrDet24 = xmlOrder.SelectSingleNode("descendant::pcmt");
oRet.lParts.Add(new PartDetails(xmlOrDet22.InnerText, xmlOrDet23.InnerText, xmlOrDet24.InnerText));
}
return oRet;
}
static void MakeQuote(string Username, string Password)
{
string request = "";
string ReturnString = "";
wsSupplier.SupplierPub ws = new wsSupplier.SupplierPub();
ws.Url = wsUrl; ;
ReturnString = ws.MakeQuote(Username, Password, request);
}
}
}
|
A project is typically a fixed-price piece of work, based on specific results, and often completed offsite using the freelancer's own tools.
Click here to post a project.
- Ongoing Web Development Project
- posted on 20/1/2011
- Freelance Developer required
- posted on 20/1/2011
- Flash Grid
- posted on 20/1/2011
- Finish phase 1 of a Bureau de Change app
- posted on 19/1/2011
- Website Builder
- posted on 19/1/2011
- iPhone / Android Developer
- posted on 18/1/2011
- Developer/Designer Required
- posted on 18/1/2011
- Lead PHP Developer
- posted on 17/1/2011
- Copywriter / Editor familar with "American English"
- posted on 17/1/2011
- Freelance symfony PHP developer required
- posted on 17/1/2011
- Web design + SEO Project
- posted on 15/1/2011
- Web Page Developer
- posted on 14/1/2011
- Conversion from PSD to HTML
- posted on 14/1/2011
- PHP Developer required for Simple CMS Website
- posted on 13/1/2011
- 3D artist
- posted on 13/1/2011
- Presentations freelancers needed
- posted on 13/1/2011
- Facebook app developer urgently required
- posted on 13/1/2011
- Facebook app developer urgently required
- posted on 13/1/2011
- Freelance CSS Developer Required
- posted on 12/1/2011
- Full Time Web Developer required
- posted on 11/1/2011
- Data Matching and Capture Operatives
- posted on 11/1/2011
- Adult Web Designer Required
- posted on 10/1/2011
- Senior Drupal Developer Wanted
- posted on 10/1/2011
- PPT slide graphics - urgent
- posted on 10/1/2011
- UK Telemarketer required
- posted on 9/1/2011
- Typo3 Expert
- posted on 7/1/2011
- PHP / Email Guru Required for ongoing work
- posted on 6/1/2011
- Design a website with 3d animation
- posted on 6/1/2011
- Developer SQL Server and Reporting Services
- posted on 5/1/2011
- Copywriter for articles
- posted on 5/1/2011
|
