public static void MainOrders(string[] args)
{
MNC_Product_Sync.Navision_SalesOrder_Service.SalesOrder_PortClient client = new MNC_Product_Sync.Navision_SalesOrder_Service.SalesOrder_PortClient();
client.ClientCredentials.Windows.ClientCredential.UserName = "******";
client.ClientCredentials.Windows.ClientCredential.Password = "******";
client.ClientCredentials.Windows.ClientCredential.Domain = "122.166.222.116";
DBConnect db = new DBConnect();
MNC_Product_Sync.MagentoConnectService.PortTypeClient mage_client = new MNC_Product_Sync.MagentoConnectService.PortTypeClient();
string token_id = null;
try
{
ServicePointManager.ServerCertificateValidationCallback = ((sender, certificate, chain, sslPolicyErrors) => true);
token_id = mage_client.login("webserviceuser", "apikey");
_stateCodes = mage_client.directoryRegionList(token_id, "US");
filters filtres = new filters();
filtres.complex_filter = new complexFilter[]
{
new complexFilter()
{
//key = "created_at",
//value = new associativeEntity
//{
// key = "gt",
// value = "2015-07-28 08:00:00"
//}
key = "status",
value = new associativeEntity
{
key = "eq",
value = "pending"
}
}
};
salesOrderListEntity[] salesOrders = mage_client.salesOrderList(token_id, filtres);
Hashtable hsc = db.fetch_Customer1Mapping();
foreach (salesOrderListEntity orderHeader in salesOrders)
{
if (!db.fetch_Order(orderHeader.increment_id.ToString(), "1"))
{
MNC_Product_Sync.Navision_SalesOrder_Service.SalesOrder so = new MNC_Product_Sync.Navision_SalesOrder_Service.SalesOrder();
MNC_Product_Sync.Navision_SalesOrder_Service.Sales_Order_Line[] sls = new MNC_Product_Sync.Navision_SalesOrder_Service.Sales_Order_Line[50];
salesOrderEntity orderDetail = mage_client.salesOrderInfo(token_id, orderHeader.increment_id);
salesOrderAddressEntity billToAddress = orderDetail.billing_address;
salesOrderAddressEntity shipToAddress = orderDetail.shipping_address;
so.Bill_to_Address = billToAddress.street + " " + billToAddress.region + " " + billToAddress.postcode;
so.Ship_to_Address = billToAddress.street + " " + billToAddress.region + " " + billToAddress.postcode;
so.Bill_to_Name = billToAddress.firstname + " " + billToAddress.lastname + " ";
so.Ship_to_Name = shipToAddress.firstname + " " + shipToAddress.lastname;
so.Bill_to_Contact = billToAddress.telephone;
so.Sell_to_Customer_No = hsc[orderDetail.customer_id].ToString();
so.Ship_to_Contact = billToAddress.telephone;
so.External_Document_No = orderHeader.increment_id;
so.Bill_to_Customer_No = hsc[orderDetail.customer_id].ToString();
so.Sell_to_Customer_Name = orderHeader.customer_firstname + " " + orderHeader.customer_lastname;
so.Order_Date = DateTime.Parse(orderHeader.created_at);
so.VAT_Bus_Posting_Group = "FOREIGN";
int i = 0;
foreach (salesOrderItemEntity li in orderDetail.items)
{
if (!db.fetch_Order(orderHeader.increment_id.ToString(), (i + 1).ToString()))
{
MNC_Product_Sync.Navision_SalesOrder_Service.Sales_Order_Line sl = new MNC_Product_Sync.Navision_SalesOrder_Service.Sales_Order_Line();
sl.Quantity = decimal.Parse(li.qty_ordered);
sl.VAT_Prod_Posting_Group = "DOMESTIC";
sl.No = li.sku;
sl.Description = li.name;
sl.Unit_Price = decimal.Parse(li.base_price);
sl.Line_Amount = decimal.Parse(li.base_row_total);
sl.TypeSpecified = true;
sl.Sales_Header_Repl = decimal.Parse(li.base_price).ToString();
sl.QuantitySpecified = true;
sl.Type = MNC_Product_Sync.Navision_SalesOrder_Service.Type.Item;
sl.Line_No = i + 1;
sls[i] = sl;
i = i + 1;
db.InsertOrderMapping(so.No, sl.Line_No.ToString(), orderHeader.increment_id, sl.Line_No.ToString(), orderHeader.customer_id);
}
}
if (!db.fetch_Order(orderHeader.increment_id.ToString(), (i + 1).ToString()))
{
try {
so.SalesLines = sls;
client.Create(ref so);
if (so.No != null)
{
db.UpdateOrder(orderHeader.increment_id, so.No);
db.InsertLog("Order", so.No, "Navision Order Number", "SUCCESS");
}
}
catch (Exception ex)
{
db.deleteOrder(orderHeader.increment_id);
db.InsertLog("Order", orderHeader.increment_id, ex.Message, "FAILED");
}
}
}
}
}
catch (Exception ex)
{
db.InsertLog("Order", "", ex.Message.ToString(), "FAILED");
MNC_Product_Sync.ErrorLog errLog = new MNC_Product_Sync.ErrorLog();
errLog.LogError("C:\\MNC_Logs", "Order : " + ex.Message);
}
finally
{
mage_client.endSession(token_id);
}
}
public static void Main(string [] args)
{
mIgnoreInvalidCertificates = new System.Net.Security.RemoteCertificateValidationCallback(delegate { return(true); });
MagentoService mageService = new MagentoService();
string mageSession = null;
if (args.Length < 3)
{
Console.WriteLine("Usage; ListOrders apiUser apiKey status [processing|complete|pending]");
return;
}
try {
_apiUser = args[0];
_apiKey = args[1];
_status = args[2];
Console.WriteLine("Connecting to " + mageService.Url);
if (_beSecure) //require secure communications
{
System.Net.ServicePointManager.ServerCertificateValidationCallback -= mIgnoreInvalidCertificates;
Console.WriteLine("Requiring Valid Certificates from Remote Sites");
}
else /// Allow connections to SSL sites that have unsafe certificates.
{
System.Net.ServicePointManager.ServerCertificateValidationCallback += mIgnoreInvalidCertificates;
Console.WriteLine("Ignoring Invalid Certificates from Remote Sites");
}
mageSession = mageService.login(_apiUser, _apiKey);
}
catch (Exception ex) {
Console.WriteLine("Login failed: \"" + ex.Message + "\"\n");
return;
}
try {
_stateCodes = mageService.directoryRegionList(mageSession, "US");
salesOrderListEntity[] salesOrders = mageService.salesOrderList(mageSession, tanMageFilter("status", "eq", _status, "10"));
if (_wantXml)
{
System.Xml.Serialization.XmlSerializer xml = new System.Xml.Serialization.XmlSerializer(salesOrders.GetType());
xml.Serialize(Console.Out, salesOrders);
Console.WriteLine();
}
foreach (salesOrderListEntity orderHeader in salesOrders)
{
salesOrderEntity orderDetail = mageService.salesOrderInfo(mageSession, orderHeader.increment_id);
mageService.salesOrderAddComment(mageSession, orderHeader.increment_id, orderHeader.status, "Examined by remote API II", "0");
if (_wantXml)
{
System.Xml.Serialization.XmlSerializer xmlDetail = new System.Xml.Serialization.XmlSerializer(orderDetail.GetType());
xmlDetail.Serialize(Console.Out, orderDetail);
Console.WriteLine();
}
if (_wantHumanReadable)
{
Console.WriteLine(
"OrderID " + orderHeader.increment_id + "\n"
+ "OrderDate " + orderHeader.created_at + "\n"
+ "Status " + orderHeader.status + "\n"
+ "SoldTo " + orderHeader.billing_firstname + " " + orderHeader.billing_lastname + "\n"
+ "Total " + orderHeader.grand_total
);
salesOrderAddressEntity billToAddress = orderDetail.billing_address;
Console.WriteLine(
"BillTo\n"
+ "\t" + orderHeader.billing_firstname + " " + orderHeader.billing_lastname + "\n"
+ "\t" + billToAddress.street + "\n"
+ "\t" + billToAddress.city + ", " + getStateAbbreviation(billToAddress.region_id) + " " + billToAddress.postcode
);
salesOrderAddressEntity shipToAddress = orderDetail.shipping_address;
Console.WriteLine(
"ShipTo\n"
+ "\t" + orderHeader.shipping_firstname + " " + orderHeader.shipping_lastname + "\n"
+ "\t" + shipToAddress.street + "\n"
+ "\t" + shipToAddress.city + ", " + getStateAbbreviation(shipToAddress.region_id) + " " + shipToAddress.postcode
);
foreach (salesOrderItemEntity li in orderDetail.items)
{
Console.WriteLine(li.sku + " " + li.name);
phpDeserializer(li.product_options);
}
Console.WriteLine(sep);
}
}
mageService.endSession(mageSession);
}
catch (Exception ex) {
Console.WriteLine("I was hoping for better than this. Error: \"" + ex.Message + "\"\n");
}
}
public BillingAddress(salesOrderAddressEntity resultBillingAddress)
{
Mapper.Map <TsZoey_v_1_9_0_1_CE.salesOrderAddressEntity, BillingAddress>(resultBillingAddress, this);
}
