public List <Order> GetListFromSAP(string customerNumber, string documentDate, string documentDateTo, string salesOrg)
{
List <Order> orderList = new List <Order>();
try
{
// Get Status Info Collection
CustDataCollection customerDataCollection = GetList(customerNumber, documentDate, documentDateTo, salesOrg);
foreach (var orederHeader in customerDataCollection.d.results)
{
var date = DateTime.ParseExact(orederHeader.DocumentDate,
"yyyyMMdd",
CultureInfo.InvariantCulture);
foreach (var orderItem in orederHeader.Cust2SalesNav.results)
{
}
}
// TODO : Map Get List to Order List
}
catch (Exception)
{
throw;
}
return(orderList);
}
private CustDataCollection GetList(string customerNumber, string documentDate, string documentDateTo, string salesOrg)
{
// Get List as per below inputs
// {0} Customer Number
// {1} Document Date
// {2} Document DateTo
// {3} Material Number
// {4} Sales Org
//string requestURL = "https://gq1.sap.sca.se:443/sap/opu/odata/sap/ZBAPI_SALESORDER_GETLIST_SRV/CustDataSet?$format=json&$expand=Cust2SalesNav&$filter=CustomerNumber eq '0000008542' and DocumentDate eq '20160606' and DocumentDateTo eq '20161206' and SalesOrganization eq 'BE68'&sap-client=006&sap-language=EN";
//string requestURL = "https://gq1.sap.sca.se:443/sap/opu/odata/sap/ZBAPI_SALESORDER_GETLIST_SRV/CustDataSet?$format=json&$expand=Cust2SalesNav&$filter=CustomerNumber eq '11324' and DocumentDate eq '20160501' and DocumentDateTo eq '20160731' and SalesOrganization eq 'NL68'&sap-client=006&sap-language=EN";
string requestURL = string.Format(sapGetListURL, customerNumber, documentDate, documentDateTo, salesOrg);
HttpWebRequest req = (HttpWebRequest)WebRequest.Create(requestURL);
HttpWebResponse resp; // No Use
req.Credentials = new NetworkCredential(sapUserName, sapPassword);
req.Method = "GET";
req.Headers.Add("X-CSRF-Token", "Fetch");
req.Proxy.Credentials = System.Net.CredentialCache.DefaultCredentials;
cookieJar = new CookieContainer();
req.CookieContainer = cookieJar;
CustDataCollection collection = null;
using (HttpWebResponse response = (HttpWebResponse)req.GetResponse())
{
if (response.StatusCode == HttpStatusCode.OK)
{
var rawJson = new StreamReader(response.GetResponseStream()).ReadToEnd();
collection = JsonConvert.DeserializeObject <CustDataCollection>(rawJson);
var dat1 = collection.d.results[0].Cust2SalesNav.results;
string a = "";
string b = null;
dat1 = dat1.Where(q => q.ReqSegment.Equals(a)).ToList();
dat1 = dat1.Where(q => q.SalesOrg.Equals(b)).ToList();
csrfToken = response.Headers.GetValues("X-CSRF-TOKEN").FirstOrDefault();
setCookie = response.Headers.Get("Set-Cookie");
cookiestopass = response.Cookies;
}
}
return(collection);
}
