void Start()
{
filterchoicememo = filterchoice;
if (Camera2 != null)
{
Camera2tex = new RenderTexture(Screen.width, Screen.height, 24);
Camera2.targetTexture = Camera2tex;
}
ChangeFilters();
SCShader = Shader.Find(ShaderName);
if (!SystemInfo.supportsImageEffects)
{
enabled = false;
return;
}
}
private static void AddFilter(filters filters, string value, string key, string valueKey)
{
if (filters.complex_filter == null)
{
filters.complex_filter = new complexFilter[0];
}
var temp = filters.complex_filter.ToList();
temp.Add(new complexFilter()
{
key = key, value = new associativeEntity()
{
key = valueKey, value = value
}
});
filters.complex_filter = temp.ToArray();
}
protected void related_sale(MagentoService mservice, string mlogin, string brand_sql, string search_family, string source_sku)
{
filters filter = new filters();
string storeview = "1";
if (search_family.Contains("OEM"))
{
storeview = "3";
}
filter = addFilter(filter, "brand", "eq", brand_sql);
filter = addFilter(filter, "status", "eq", "1");
var result = mservice.catalogProductList(mlogin, filter, storeview);
string[] sku_arr = new string[result.Length];
int i = 0;
//get result sku
foreach (catalogProductEntity product in result)
{
sku_arr[i] = product.sku;
i += 1;
}
//get stock level
var result2 = mservice.catalogInventoryStockItemList(mlogin, sku_arr);
foreach (catalogInventoryStockItemEntity product in result2)
{
string qty_sku = product.sku;
Double qty = double.Parse(product.qty);
if (qty > 0)
{
catalogProductLinkEntity assign = new catalogProductLinkEntity();
assign.position = "1";
// inject related listing
mservice.catalogProductLinkUpdate(mlogin, "related", source_sku, qty_sku, assign, "sku");
}
}
mservice.Dispose();
}
void SatControls()
{
GameObject[] satellites;
if (Input.GetKeyDown(KeyCode.Space)) // Pressing Space toggles between overlays, as a test.
{
if (activeFilter == filters.None)
{
activeFilter = filters.Work;
satellites = GameObject.FindGameObjectsWithTag("Satellite");
foreach (GameObject sat in satellites)
{
sat.GetComponent <Satellite>().ColorOverlay();
}
}
else
{
activeFilter = filters.None;
satellites = GameObject.FindGameObjectsWithTag("Satellite");
foreach (GameObject sat in satellites)
{
sat.GetComponent <Satellite>().ColorOverlay();
}
}
}
//go up or down in orbit
if (selectedSomething)
{
if (Input.GetKey(KeyCode.S))
{
satellite.AltitudeChange(0.3f);
}
else if (Input.GetKey(KeyCode.W))
{
satellite.AltitudeChange(-0.3f);
}
else
{
satellite.AltitudeChange(0.0f);
}
}
}
void Start()
{
filterchoicememo = filterchoice;
if (Camera2 != null)
{
DestroyImmediate(Camera2.targetTexture);
Camera2tex = new RenderTexture(Screen.width, Screen.height, 24);
Camera2.targetTexture = Camera2tex;
}
ChangeValue = BlendFX;
ChangeValue2 = SwitchCameraToCamera2;
ChangeFilters();
SCShader = Shader.Find(ShaderName);
if (!SystemInfo.supportsImageEffects)
{
enabled = false;
return;
}
}
public void SetupFieldType_CommonSwitchCaseConstantsConditionField_SetsFieldTypeDropdownListEnableToTrueAndSelectString(string switchCaseConstant)
{
// Arrange
var filter = new filters();
var fieldTypeDropDownList = CreateDropdownList(false);
ReflectionHelper.SetValue(filter, "ddlFieldType", fieldTypeDropDownList);
// Act
var parameters = new object[] { switchCaseConstant };
typeof(filters).CallMethod("SetupFieldType", parameters, filter);
// Assert
var fieldTypeDropdownList = ReflectionHelper.GetFieldInfoFromInstanceByName(filter, "ddlFieldType").GetValue(filter) as DropDownList;
fieldTypeDropdownList.ShouldNotBeNull();
fieldTypeDropdownList.Enabled.ShouldBeTrue();
fieldTypeDropDownList.SelectedIndex.ShouldBe(StringSelectedIndex);
}
public virtual async Task <GetOrdersResponse> GetOrdersAsync(DateTime modifiedFrom, DateTime modifiedTo, Mark mark = null)
{
var filters = new filters();
AddFilter(filters, modifiedFrom.ToSoapParameterString(), "updated_at", "from");
AddFilter(filters, modifiedTo.ToSoapParameterString(), "updated_at", "to");
if (!string.IsNullOrWhiteSpace(this.Store))
{
AddFilter(filters, this.Store, "store_id", "in");
}
return(await this.GetWithAsync(
res =>
{
//crutch for magento 1.7
res.result = res.result.Where(x => Extensions.ToDateTimeOrDefault(x.updated_at) >= modifiedFrom && Extensions.ToDateTimeOrDefault(x.updated_at) <= modifiedTo).ToArray();
return new GetOrdersResponse(res);
},
async ( client, session ) => await client.salesOrderListAsync( session, filters ).ConfigureAwait(false), 600000).ConfigureAwait(false));
}
public virtual async Task <SoapGetProductsResponse> GetProductsAsync()
{
try
{
var filters = new filters {
filter = new associativeEntity[0]
};
var store = string.IsNullOrWhiteSpace(this.Store) ? null : this.Store;
const int maxCheckCount = 2;
const int delayBeforeCheck = 1800000;
var res = new catalogProductListResponse();
var privateClient = this.CreateMagentoServiceClient(this.BaseMagentoUrl);
await ActionPolicies.GetAsync.Do(async() =>
{
var statusChecker = new StatusChecker(maxCheckCount);
TimerCallback tcb = statusChecker.CheckStatus;
if (privateClient.State != CommunicationState.Opened &&
privateClient.State != CommunicationState.Created &&
privateClient.State != CommunicationState.Opening)
{
privateClient = this.CreateMagentoServiceClient(this.BaseMagentoUrl);
}
var sessionId = await this.GetSessionId().ConfigureAwait(false);
using (var stateTimer = new Timer(tcb, privateClient, 1000, delayBeforeCheck))
res = await privateClient.catalogProductListAsync(sessionId.SessionId, filters, store).ConfigureAwait(false);
}).ConfigureAwait(false);
return(new SoapGetProductsResponse(res));
}
catch (Exception exc)
{
throw new MagentoSoapException(string.Format("An error occured during GetProductsAsync()"), exc);
}
}
void OnValidate()
{
if (filterchoice != filterchoicememo)
{
ChangeFilters();
SCShader = Shader.Find(ShaderName);
DestroyImmediate(SCMaterial);
if (SCMaterial == null)
{
SCMaterial = new Material(SCShader);
SCMaterial.hideFlags = HideFlags.HideAndDontSave;
}
}
filterchoicememo = filterchoice;
if (Camera2 != null)
{
Camera2tex = new RenderTexture(Screen.width, Screen.height, 24);
Camera2.targetTexture = Camera2tex;
}
}
static void identity_block(input_tensor, kernel_size, filters, stage, block) {
//KerasSharp.Backends.Current.Switch("KerasSharp.Backends.TensorFlowBackend");
//
var bn_axis = 3;
var filters1, filters2, filters3 = filters;
var conv_name_base = "res" + str(stage) + block + "_branch";
var bn_name_base = "bn" + str(stage) + block + "_branch";
var x = new Conv2D(filters1, (1,1), name:conv_name_base + "2a")(input_tensor);
x = x.add(new BatchNormalization(axis:bn_axis, name:bn_name_base + "2a")(x));
x = x.add(new activation: ReLU())(x));
x = x.add(new Conv2D(filters2, kernel_size, padding:"same", name:conv_name_base + "2b")(x));
x = x.add(new BatchNormalization(axis:bn_axis, name:bn_name_base + "2b")(x));
x = x.add(new activation: ReLU())(x));
x = x.add(new Conv2D(filters3, (1,1), name:conv_name_base + "2c")(x));
x = x.add(new BatchNormalization(axis:bn_axis, name:bn_name_base + "2c")(x));
x = x.add(activation: new ReLU())(x));
return x;
}
static void Main(string[] args)
{
Navision_CustomerListService.CustomerList nv_Customer = new Navision_CustomerListService.CustomerList();
Navision_CustomerListService.CustomerList_PortClient client = new Navision_CustomerListService.CustomerList_PortClient();
Navision_CustomerListService.CustomerList[] nv_CustomerLists;
client.ClientCredentials.UserName.UserName = "******";
client.ClientCredentials.UserName.Password = "******";
//client.ClientCredentials.Windows.ClientCredential.UserName = "******";
//client.ClientCredentials.Windows.ClientCredential.Password = "******";
//client.ClientCredentials.Windows.ClientCredential.Domain = "122.166.222.116";
nv_CustomerLists = client.ReadMultiple(null, null, 10000);
MagentoConnectService.PortTypeClient mage_client = new MagentoConnectService.PortTypeClient();
DBConnect db = new DBConnect();
int newCustomerCreateID = 0;
int createAddressID = 0;
string token_id = "";
filters myfilter = new filters();
token_id = mage_client.login("webserviceuser", "apikey");
Hashtable hsc = db.fetch_CustomerMapping();
for (int i = 0; i < nv_CustomerLists.Length; i++)
{
// Create Customer
customerCustomerEntityToCreate customerCreate = new customerCustomerEntityToCreate();
try
{
customerCreate.firstname = nv_CustomerLists[i].Name;
customerCreate.lastname = ".";
customerCreate.middlename = "";
customerCreate.password = "******";
customerCreate.store_id = 1;
customerCreate.store_idSpecified = true;
customerCreate.website_id = 1;
customerCreate.website_idSpecified = true;
customerCreate.group_id = 1;
customerCreate.group_idSpecified = true;
customerCreate.suffix = "P";
customerCreate.email = nv_CustomerLists[i].E_Mail;
customerCreate.gender = 1; //1-Male;2-Female
customerCreate.genderSpecified = true;
//customer address
customerAddressEntityCreate customerAddress = new customerAddressEntityCreate();
if (nv_CustomerLists[i].Location_Code == null)
{
customerAddress.city = "NA";
}
else
{
customerAddress.city = nv_CustomerLists[i].Location_Code;
}
customerAddress.region_id = 2; //CountryID
customerAddress.region_idSpecified = true;
if (nv_CustomerLists[i].Country_Region_Code == null)
{
customerAddress.country_id = "NA";
}
else
{
customerAddress.country_id = nv_CustomerLists[i].Country_Region_Code;
}
customerAddress.fax = nv_CustomerLists[i].Fax_No;
customerAddress.firstname = nv_CustomerLists[i].Name;
customerAddress.lastname = ".";
customerAddress.middlename = "";
string[] streettxt = { nv_CustomerLists[i].Address };
customerAddress.street = streettxt;
customerAddress.postcode = nv_CustomerLists[i].Post_Code;
customerAddress.prefix = "M";
customerAddress.suffix = "P";
// customerAddress.street = nv_CustomerLists[i].Address.ToString();
if (nv_CustomerLists[i].Phone_No == null)
{
customerAddress.telephone = "NA";
}
else
{
customerAddress.telephone = nv_CustomerLists[i].Phone_No;
}
//If you specify 'true' for is_default_billing and is_default_shipping. Then this address will be your default shipping and billing. Otherwise none.
customerAddress.is_default_billing = true;
customerAddress.is_default_shipping = true;
if (db.fetch_Customer(nv_CustomerLists[i].No.ToString()))
{
mage_client.customerCustomerUpdate(token_id, Convert.ToInt16(hsc[nv_CustomerLists[i].No]), customerCreate);
}
else
{
newCustomerCreateID = mage_client.customerCustomerCreate(token_id, customerCreate);
createAddressID = mage_client.customerAddressCreate(token_id, newCustomerCreateID, customerAddress);
db.InsertCustomerMapping(nv_CustomerLists[i].No, newCustomerCreateID.ToString(), nv_CustomerLists[i].E_Mail);
db.InsertLog("Customer", nv_CustomerLists[i].No, "Navision Customer Code", "SUCCESS");
}
}
catch (Exception ex)
{
MNC_Product_Sync.ErrorLog errLog = new MNC_Product_Sync.ErrorLog();
errLog.LogError("C:\\MNC_Logs", "Customer :" + ex.Message);
db.InsertLog("Customer", nv_CustomerLists[i].No, ex.Message, "FAILED");
}
finally
{
//mage_client.endSession(token_id);
}
}
mage_client.endSession(token_id);
}
protected override string GetSalesMonth(DateTime exportDate, string filename)
{
//access Magento store API
//Get the sales records for the requested month
DateTime fromDate = new DateTime(exportDate.Year, exportDate.Month, 1);
DateTime toDate = fromDate.AddMonths(1);
string result = "\n" + filename + ": ";
string tempDisplay = ProgressText;
ProgressText += result + "Exporting...";
StringBuilder data = new StringBuilder();
string h2 = "Product ID\tCustomer ID\tQuantity\tDate\r\n"; //sales file second header line
StringBuilder salesData = new StringBuilder(CommonHeader + h2);
Mage_Api_Model_Server_V2_HandlerPortTypeClient Mclient = new Mage_Api_Model_Server_V2_HandlerPortTypeClient();
string MsessionId = "";
//---------------------SALES MONTH EXPORT----------------------------
//errors caught by calling function
//login
MsessionId = Mclient.login(m_apiUserName, m_apiKey);
//create filter to get sales for this month only
filters monthFilter = new filters();
monthFilter.complex_filter = new complexFilter[2];
monthFilter.complex_filter[0] = new complexFilter();
monthFilter.complex_filter[0].key = "created_at";
monthFilter.complex_filter[0].value = new associativeEntity();
monthFilter.complex_filter[0].value.key = "from";
monthFilter.complex_filter[0].value.value = fromDate.ToString("yyyy-MM-dd HH:mm:ss");
monthFilter.complex_filter[1] = new complexFilter();
monthFilter.complex_filter[1].key = "created_at";
monthFilter.complex_filter[1].value = new associativeEntity();
monthFilter.complex_filter[1].value.key = "to";
monthFilter.complex_filter[1].value.value = toDate.ToString("yyyy-MM-dd HH:mm:ss");
//get list of sales orders
salesOrderEntity[] sorders = Mclient.salesOrderList(MsessionId, monthFilter);
if (sorders.Length > 0)
{
foreach (salesOrderEntity s in sorders)
{
string customerid = s.customer_id;
if (s.customer_is_guest.Equals("1"))
{
customerid = s.customer_email;
if (customerid == null || customerid.Length < 1)
customerid = s.increment_id;
}
string date = s.created_at;
//get list of items purchased on each sales order
salesOrderEntity sinfo = Mclient.salesOrderInfo(MsessionId, s.increment_id);
foreach (salesOrderItemEntity item in sinfo.items)
{
string productid = item.product_id;
//TODO: Need to get parent_item_id here if it exists
string quantity = item.qty_ordered;
int len = quantity.IndexOf(".");
if (len > 0)
quantity = quantity.Substring(0, len); //remove fractional part
//add line to sales data
salesData.Append(productid + "\t" + customerid + "\t" + quantity + "\t" + date + "\r\n");
}
}
}
//upload sales data
ProgressText = tempDisplay + result + "Uploading...";
result += m_boostService.WriteTable(m_alias, filename, data);
ProgressText = tempDisplay + result;
return result;
}
protected string ApiTest()
{
string result = "\n" + CatalogFilename + ": ";
string tempDisplay = ProgressText;
ProgressText += result + "Rows to export...";
StopWatch exportWatch = new StopWatch(true);
#if MAGENTO_API_AVAILABLE
#region Static Trevor
if (static_proxy && m_alias.Equals("Trevor"))
{
MagentoService Mclient = new MagentoService();
string MsessionId = "";
//---------------------CATALOG EXPORT----------------------------
try
{
MsessionId = Mclient.login(m_apiUserName, m_apiKey);
catalogProductEntity[] plist = Mclient.catalogProductList(MsessionId, null, "");
if (plist.Length < 1)
throw new Exception("No products available");
//TODO: create catalog file header
string type = "";
foreach (catalogProductEntity p in plist)
{
string pid = p.product_id;
if (p.type.Equals("simple")) //only export combined items or else simple items with no parents
{
bool isChild = false;
catalogProductLinkEntity[] plinks = Mclient.catalogProductLinkList(MsessionId, "grouped", pid, "id");
foreach (catalogProductLinkEntity pl in plinks)
if (pl.type.Equals("configurable"))
{
isChild = true;
break;
}
if (isChild) continue;
}
else
type += p.type + " ";
string pname = p.name;
string patt1 = "";
bool first = true;
foreach (string cid in p.category_ids)
{
if (first) first = false;
else patt1 += ",";
patt1 += cid;
}
catalogProductReturnEntity pinfo = Mclient.catalogProductInfo(MsessionId, pid, "", null, "id");
catalogProductReturnEntity pPriceInfo = Mclient.catalogProductGetSpecialPrice(MsessionId, pid, "", "id");
string patt2 = "";
string pprice = pPriceInfo.price; ;
if ((pPriceInfo.special_from_date != null) && (pinfo.special_to_date != null))
{
DateTime saleStart = DateTime.Parse(pPriceInfo.special_from_date);
DateTime saleEnd = DateTime.Parse(pPriceInfo.special_to_date);
DateTime now = DateTime.Now;
if (now >= saleStart && now <= saleEnd)
pprice = pPriceInfo.special_price;
}
string pfilter = "";
string plink = pinfo.url_key;
string pimage = "";
string psku = pinfo.sku;
catalogProductImageEntity pimageinfo = null;
try
{
pimageinfo = Mclient.catalogProductAttributeMediaInfo(MsessionId, pid, "", "", "id");
}
catch { }
if (pimageinfo != null)
{
pimage = pimageinfo.url;
}
}
}
catch { }
//---------------------SALES EXPORT----------------------------
try
{
//salesOrderEntity[] sorders = Mclient.salesOrderList(MsessionId, null);
salesOrderEntity[] sorders = Mclient.salesOrderList(MsessionId, null);
if (sorders.Length > 0)
{
//TODO: create header line for sales export
foreach (salesOrderEntity s in sorders)
{
string customerid = s.customer_id;
if (s.customer_is_guest.Equals("1"))
{
customerid = s.customer_email;
if (customerid == null || customerid.Length < 1)
customerid = s.increment_id;
}
string date = s.created_at;
salesOrderEntity sinfo = Mclient.salesOrderInfo(MsessionId, s.increment_id);
foreach (salesOrderItemEntity item in sinfo.items)
{
string productid = item.product_id;
string quantity = item.qty_ordered;
int len = quantity.IndexOf(".");
if (len > 0)
quantity = quantity.Substring(0, len); //remove fractional part
//TODO: add line to sales data here
}
}
//TODO: upload sales data
}
}
catch { }
}
#endregion
#endif
#region Static GoStore
Mage_Api_Model_Server_V2_HandlerPortTypeClient Mclient = new Mage_Api_Model_Server_V2_HandlerPortTypeClient();
string MsessionId = "";
//---------------------CATALOG EXPORT----------------------------
try
{
//login
//MsessionId = Mclient.login(m_apiUserName, m_apiKey);
MsessionId = Mclient.login("4Tell", "4tellsoftware"); //condomania
//Get API calls available
apiEntity[] resources = Mclient.resources(MsessionId);
//resultObj = proxy.CallMethod("resources", sessionID);
//Type t = resultObj.GetType();
//XmlSerializer xs = new XmlSerializer(t);
//XElement resources = xs.SerializeAsXElement(resultObj);
//TODO: check each CallMethod to make sure it is in this list...
//Set product attributes to fetch
catalogProductRequestAttributes prodAttributes = new catalogProductRequestAttributes();
string[] attributes = { "sku", "url_key", "price", "special_price", "special_from_date", "special_to_date", "parent_item_id" };
prodAttributes.attributes = attributes;
//filters prodFilters = new filters();
//associativeEntity[] filterList = new associativeEntity[1];
//filterList[0].key = "";
//filterList[0].value = "";
//loop through all products
StringBuilder data = new StringBuilder(CommonHeader + ProductRecord.Header());
catalogProductEntity[] plist;
Mclient.catalogProductList(out plist, MsessionId, null, "");
string type = "";
int maxCid = 0;
foreach (catalogProductEntity p in plist)
{
string pid = p.product_id;
if (p.type.Equals("simple")) //only export combined items or else simple items with no parents
{
//bool isChild = false;
//catalogProductLinkEntity[] plinks = Mclient.catalogProductLinkList(MsessionId, "grouped", pid, "id");
//foreach (catalogProductLinkEntity pl in plinks)
// if (pl.type.Equals("configurable"))
// {
// isChild = true;
// break;
// }
//if (isChild) continue;
}
else
type += p.type + " ";
string pname = p.name;
string patt1 = "";
bool first = true;
foreach (string cid in p.category_ids)
{
if (first) first = false;
else patt1 += ",";
patt1 += cid;
int id = Convert.ToInt32(cid);
if (id > maxCid) maxCid = id;
}
string patt2 = "";
catalogProductReturnEntity pinfo = Mclient.catalogProductInfo(MsessionId, pid, "", prodAttributes, "id");
string pprice = pinfo.price; ;
if ((pinfo.special_from_date != null) && (pinfo.special_to_date != null))
{
DateTime saleStart = DateTime.Parse(pinfo.special_from_date);
DateTime saleEnd = DateTime.Parse(pinfo.special_to_date);
DateTime now = DateTime.Now;
if (now >= saleStart && now <= saleEnd)
pprice = pinfo.special_price;
}
string pfilter = "";
string plink = pinfo.url_key;
string pimage = "";
string psku = pinfo.sku;
catalogProductImageEntity pimageinfo = null;
try
{
pimageinfo = Mclient.catalogProductAttributeMediaInfo(MsessionId, pid, "", "", "id");
}
catch
{
try
{
pimageinfo = Mclient.catalogProductAttributeMediaInfo(MsessionId, psku, "", "", "sku");
}
catch
{
}
}
if (pimageinfo != null)
{
pimage = pimageinfo.url;
}
data.Append(pid + "\t" + pname + "\t" + patt1 + "\t" + patt2 + "\t" + pprice + "\t" + pfilter + "\t" + plink + "\t" + pimage + "\t" + psku + "\r\n");
}
result += m_boostService.WriteTable(m_alias, CatalogFilename, data);
//get cat info
result += "\n" + Att1Filename + ": ";
ProgressText = tempDisplay + result + "Exporting...";
catalogCategoryInfo cinfo;
StringBuilder csb = new StringBuilder(CommonHeader + AttributeRecord.Header());
for (int cid = 1; cid <= maxCid; cid++)
{
try
{
cinfo = Mclient.catalogCategoryInfo(MsessionId, cid, "", null);
csb.Append(cid.ToString() + "\t" + cinfo.name + "\r\n");
}
catch
{
csb.Append(cid.ToString() + "\t" + cid.ToString() + "\r\n");
}
}
result += m_boostService.WriteTable(m_alias, Att1Filename, csb);
ProgressText = tempDisplay + result;
}
catch { }
//try
//{
// //catalogCategoryTree ctree = Mclient.catalogCategoryTree(MsessionId, "", "");
// catalogCategoryTree ctree = Mclient.catalogCategoryTree(MsessionId, "0", "");
//}
//catch { }
//try
//{
// //catalogCategoryEntityNoChildren[] clist = Mclient.catalogCategoryLevel(MsessionId, "", "", "");
// catalogCategoryEntityNoChildren[] clist = Mclient.catalogCategoryLevel(MsessionId, "", "", "");
//}
//catch { }
//try
//{
// //catalogCategoryEntityNoChildren[] clist = Mclient.catalogCategoryLevel(MsessionId, "", "", "");
// catalogCategoryEntityNoChildren[] clist = Mclient.catalogCategoryLevel(MsessionId, "", "", "");
//}
//catch { }
//try
//{
// //catalogCategoryInfo cinfo = Mclient.catalogCategoryInfo(MsessionId, 0, "CurrentView", null);
// catalogCategoryInfo cinfo = Mclient.catalogCategoryInfo(MsessionId, 4, "", null);
//}
//catch { }
//try
//{
// //catalogProductAttributeSetEntity[] pasList = Mclient.catalogProductAttributeSetList(MsessionId);
// //...this one works!
// catalogProductAttributeSetEntity[] pasList = Mclient.catalogProductAttributeSetList(MsessionId);
//}
//catch { }
//---------------------SALES EXPORT----------------------------
try
{
DateTime exportDate = DateTime.Now; //pass this date in
string salesFileName = string.Format(SalesFilenameFormat, exportDate.ToString("yyyy-MM"));
result += "\n" + salesFileName + ": ";
StringBuilder salesData = new StringBuilder(CommonHeader + SalesRecord.Header());
//create filter to get sales for this month only
string fromDate = string.Format("{0:0000}-{1:00}-01 00:00:00", exportDate.Year, exportDate.Month);
string toDate = string.Format("{0:0000}-{1:00}-01 00:00:00", exportDate.Year, exportDate.Month + 1);
filters monthFilter = new filters();
monthFilter.complex_filter = new complexFilter[2];
monthFilter.complex_filter[0] = new complexFilter();
monthFilter.complex_filter[0].key = "created_at";
monthFilter.complex_filter[0].value = new associativeEntity();
monthFilter.complex_filter[0].value.key = "from";
monthFilter.complex_filter[0].value.value = fromDate;
monthFilter.complex_filter[1] = new complexFilter();
monthFilter.complex_filter[1].key = "created_at";
monthFilter.complex_filter[1].value = new associativeEntity();
monthFilter.complex_filter[1].value.key = "to";
monthFilter.complex_filter[1].value.value = toDate;
//get list of sales orders
salesOrderEntity[] sorders = Mclient.salesOrderList(MsessionId, monthFilter);
if (sorders.Length > 0)
{
//TODO: create header line for sales export
foreach (salesOrderEntity s in sorders)
{
string customerid = s.customer_id;
if (s.customer_is_guest.Equals("1"))
{
customerid = s.customer_email;
if (customerid == null || customerid.Length < 1)
customerid = s.increment_id;
}
string date = s.created_at;
//get list of items purchased on each sales order
salesOrderEntity sinfo = Mclient.salesOrderInfo(MsessionId, s.increment_id);
foreach (salesOrderItemEntity item in sinfo.items)
{
string productid = item.product_id;
string quantity = item.qty_ordered;
int len = quantity.IndexOf(".");
if (len > 0)
quantity = quantity.Substring(0, len); //remove fractional part
//add line to sales data
salesData.Append(customerid + "\t" + productid + "\t" + quantity + "\t" + date + "\r\n");
}
}
//upload sales data
result += m_boostService.WriteTable(m_alias, salesFileName, salesData);
}
}
catch { }
#endregion
return result;
}
void Start()
{
filterchoicememo = filterchoice;
ChangeFilters ();
SCShader = Shader.Find(ShaderName);
if(!SystemInfo.supportsImageEffects)
{
enabled = false;
return;
}
}
public HttpResponseMessage AtualizarBanco()
{
try
{
var res = BinanceRestApi.GetExchangeInfo();
//var jsonObj = JsonConvert.DeserializeObject<ExchangeInfo>(content, new JsonSerializerSettings() { DefaultValueHandling = DefaultValueHandling.Ignore, NullValueHandling = NullValueHandling.Ignore });
if (res.IsSuccessStatusCode)
{
var content = res.Content.ReadAsStringAsync().Result;
var jsonObj = JsonConvert.DeserializeObject <ExchangeInfo>(content);
foreach (var item in jsonObj.symbols)
{
var dbsymbol = _ISymbolRepo.GetBySymbol(item.symbol.ToLower());
if (dbsymbol == null)
{
var symbol = new Symbol();
symbol.symbol = item.symbol.ToLower();
symbol.status = item.status;
symbol.baseAsset = item.baseAsset;
symbol.baseAssetPrecision = item.baseAssetPrecision;
symbol.quoteAsset = item.quoteAsset;
symbol.quotePrecision = item.quotePrecision;
symbol.orderTypes = item.orderTypes;
symbol.icebergAllowed = item.icebergAllowed;
symbol.ocoAllowed = item.ocoAllowed;
symbol.isSpotTradingAllowed = item.isSpotTradingAllowed;
symbol.isMarginTradingAllowed = item.isMarginTradingAllowed;
_ISymbolRepo.Add(symbol);
foreach (var filteritem in item.filters)
{
var filters = new filters();
filters.Symbol_Id = symbol.Id;
filters.filterType = filteritem.filterType;
//PRICE_FILTER
filters.minPrice = filteritem.minPrice;
filters.maxPrice = filteritem.maxPrice;
filters.tickSize = filteritem.tickSize;
//PERCENT_PRICE
filters.multiplierUp = filteritem.multiplierUp;
filters.multiplierDown = filteritem.multiplierDown;
//LOT_SIZE & MARKET_LOT_SIZE
filters.minQty = filteritem.minQty;
filters.maxQty = filteritem.maxQty;
filters.stepSize = filteritem.stepSize;
//MIN_NOTIONAL
filters.minNotional = filteritem.minNotional;
filters.applyToMarket = filteritem.applyToMarket;
//MIN_NOTIONAL & PERCENT_PRICE
filters.avgPriceMins = filteritem.avgPriceMins;
//ICEBERG_PARTS & MAX_NUM_ORDERS
filters.limit = filteritem.limit;
//MAX_NUM_ALGO_ORDERS
filters.maxNumAlgoOrders = filteritem.maxNumAlgoOrders;
//MAX_NUM_ICEBERG_ORDERS
filters.maxNumIcebergOrders = filteritem.maxNumIcebergOrders;
_IFiltersRepo.Add(filters);
}
}
else
{
var updatesymbol = dbsymbol;
updatesymbol.status = item.status;
updatesymbol.baseAsset = item.baseAsset;
updatesymbol.baseAssetPrecision = item.baseAssetPrecision;
updatesymbol.quoteAsset = item.quoteAsset;
updatesymbol.quotePrecision = item.quotePrecision;
updatesymbol.orderTypes = item.orderTypes;
updatesymbol.icebergAllowed = item.icebergAllowed;
updatesymbol.ocoAllowed = item.ocoAllowed;
updatesymbol.isSpotTradingAllowed = item.isSpotTradingAllowed;
updatesymbol.isMarginTradingAllowed = item.isMarginTradingAllowed;
if (updatesymbol != dbsymbol)
{
_ISymbolRepo.Update(dbsymbol);
}
foreach (var filteritem in item.filters)
{
var oldFilter = _IFiltersRepo.GetBySymbol_Type(filteritem.filterType, updatesymbol.Id);
var Updatefilters = (oldFilter != null) ? oldFilter : new filters();
Updatefilters.Symbol_Id = updatesymbol.Id;
Updatefilters.filterType = filteritem.filterType;
//PRICE_FILTER
Updatefilters.minPrice = filteritem.minPrice;
Updatefilters.maxPrice = filteritem.maxPrice;
Updatefilters.tickSize = filteritem.tickSize;
//PERCENT_PRICE
Updatefilters.multiplierUp = filteritem.multiplierUp;
Updatefilters.multiplierDown = filteritem.multiplierDown;
//LOT_SIZE & MARKET_LOT_SIZE
Updatefilters.minQty = filteritem.minQty;
Updatefilters.maxQty = filteritem.maxQty;
Updatefilters.stepSize = filteritem.stepSize;
//MIN_NOTIONAL
Updatefilters.minNotional = filteritem.minNotional;
Updatefilters.applyToMarket = filteritem.applyToMarket;
//MIN_NOTIONAL & PERCENT_PRICE
Updatefilters.avgPriceMins = filteritem.avgPriceMins;
//ICEBERG_PARTS & MAX_NUM_ORDERS
Updatefilters.limit = filteritem.limit;
//MAX_NUM_ALGO_ORDERS
Updatefilters.maxNumAlgoOrders = filteritem.maxNumAlgoOrders;
//MAX_NUM_ICEBERG_ORDE RS
Updatefilters.maxNumIcebergOrders = filteritem.maxNumIcebergOrders;
if (Updatefilters != oldFilter && oldFilter != null)
{
_IFiltersRepo.Update(Updatefilters);
}
else if (oldFilter == null)
{
_IFiltersRepo.Add(Updatefilters);
}
}
}
}
return(Request.CreateResponse(HttpStatusCode.OK, jsonObj.symbols.Count()));
}
else
{
var BinanceErrorObj = Helper.GetBinanceErrorObj(res);
return(Request.CreateResponse(HttpStatusCode.BadRequest, BinanceErrorObj));
}
}
catch (Exception ex)
{
return(Request.CreateResponse(HttpStatusCode.InternalServerError, ex.Message));
}
}
public List<ParcelItem> GetPendingOrders()
{
try
{
if (UserAccountCode != 0)
{
List<ParcelItem> items = new List<ParcelItem>();
DataModelEntities context = new DataModelEntities();
UserAccount userAccount = context.UserAccounts.First(u => u.User_Account_Code == UserAccountCode);
MagentoService service = new MagentoService();
service.Url = userAccount.Application_Name;
string sessionID = service.login(userAccount.Config_Value1, userAccount.Config_Value2);
List<associativeEntity> listAssociatedEntity = new List<associativeEntity>();
listAssociatedEntity.Add(new associativeEntity() { key = "status", value = "pending" });
filters filters = new filters();
filters.filter = listAssociatedEntity.ToArray();
salesOrderListEntity[] orders = service.salesOrderList(sessionID, filters);
List<ChargeCode> chargeCodes = context.ChargeCodes.Where(u => u.Is_Active == true && u.User_Code == UserCode).ToList();
foreach (salesOrderListEntity order in orders)
{
salesOrderEntity orderDetail = service.salesOrderInfo(sessionID, order.increment_id);
foreach (salesOrderItemEntity lineItem in orderDetail.items)
{
ParcelItem item = new ParcelItem();
item.Type = "MAGENTO";
item.AccountID = userAccount.User_Account_Code.ToString();
item.RecordNumber = orderDetail.order_id;
item.ItemID = lineItem.item_id;
item.TransactionID = orderDetail.increment_id;
item.ItemName = lineItem.name;
item.CustomLabel = lineItem.sku;
item.CustomLabelText = lineItem.sku;
string state = orderDetail.shipping_address.region;
string stateCode = orderDetail.shipping_address.region_id;
if (StateHelper.States.Where(s => s.Key == stateCode).Count() > 0)
item.State = StateHelper.States[stateCode];
else
item.State = state;
item.BuyerName = orderDetail.customer_firstname + " " + orderDetail.customer_lastname;
item.EmailAddress = orderDetail.customer_email;
item.BuyerID = orderDetail.customer_id;
item.Street2 = orderDetail.shipping_address.street;
item.Street3 = string.Empty;
item.City = orderDetail.shipping_address.city;
item.PostalCode = orderDetail.shipping_address.postcode;
item.Country = orderDetail.shipping_address.country_id;
item.Phone = orderDetail.shipping_address.telephone;
item.Quantity = lineItem.qty_ordered == string.Empty ? 0 : (int)decimal.Parse(lineItem.qty_ordered);
if (orderDetail.shipping_amount != string.Empty)
item.ShippingCost = double.Parse(orderDetail.shipping_amount);
item.SaleRecordId = orderDetail.increment_id;
// insurance details //
item.Currency = orderDetail.order_currency_code;
item.Price = double.Parse(lineItem.price);
item.ShippingMethod = orderDetail.shipping_description;
string shippingCode = orderDetail.shipping_description;
ChargeCode code = chargeCodes.FirstOrDefault(u => shippingCode.ToLower().Contains(u.Ebay_Code.ToLower()) == true);
if (code != null && code.Charge_Code_Name.ToLower() == "ignore")
{
continue; // ignore the item
}
bool IspostCodeOK = Common.VerifyPostCode(orderDetail.shipping_address.postcode, orderDetail.shipping_address.city);
if (IspostCodeOK)
item.PostCodeImageURL = Constant.tickURL;
else
item.PostCodeImageURL = Constant.crossURL;
items.Add(item);
}
}
return items;
}
else
{
return null;
}
}
catch (Exception ex)
{
return null;
}
}
public void globafun(filters par)
{
int[,] now = new int[3, 3];
if (par == filters.blur)
{
now = Kernel.blur;
}
else if (par == filters.sharp)
{
now = Kernel.sharp;
}
else if (par == filters.hor)
{
now = Kernel.hor;
}
else if (par == filters.ver)
{
now = Kernel.ver;
}
else if (par == filters.diag)
{
now = Kernel.diag;
}
else if (par == filters.all)
{
now = Kernel.all;
}
else if (par == filters.east)
{
now = Kernel.east;
}
else if (par == filters.south)
{
now = Kernel.south;
}
else if (par == filters.southeast)
{
now = Kernel.southeast;
}
//Color[,] alter = new Color[this.Height, this.Width];
byte[] temp = new byte[underlyingBytes.ByteArray.Length];
Array.Copy(underlyingBytes.ByteArray, temp, temp.Length);
for (int i = 0; i < this.Height - 2; ++i)
{
for (int j = 0; j < this.Width - 2; j++)
{
int[,] matRed = new int[3, 3];
int[,] matGreen = new int[3, 3];
int[,] matBlue = new int[3, 3];
for (int a = 0; a < 3; a++)
{
for (int b = 0; b < 3; b++)
{
Color color = GetPixelRowColumn(i + a, j + b);
matRed[a, b] = color.R;
matGreen[a, b] = color.G;
matBlue[a, b] = color.B;
}
}
byte newRed = (byte)Utility.Clamp(0, 255, multiplication(now, matRed));
byte newGreen = (byte)Utility.Clamp(0, 255, multiplication(now, matGreen));
byte newBlue = (byte)Utility.Clamp(0, 255, multiplication(now, matBlue));
SetPixelRowColumnOfArray(i + 1, j + 1, Color.FromArgb(newRed, newGreen, newBlue), temp);
//alter[i + 1, j + 1] = Color.FromArgb(newRed, newGreen, newBlue);
}
}
Array.Copy(temp, underlyingBytes.ByteArray, temp.Length);
//COPY ALTER TO THIS
//for (int i = 1; i < Height - 2; i++)
//{
// for (int j = 1; j < Width - 2; j++)
// {
// SetPixelRowColumn(i, j, alter[i, j]);
// }
//}
}
void Start()
{
filterchoicememo = filterchoice;
if (Camera2 !=null)
{
DestroyImmediate(Camera2.targetTexture);
Camera2tex=new RenderTexture(Screen.width,Screen.height, 24);
Camera2.targetTexture=Camera2tex;
}
ChangeValue = BlendFX;
ChangeValue2=SwitchCameraToCamera2;
ChangeFilters ();
SCShader = Shader.Find(ShaderName);
if(!SystemInfo.supportsImageEffects)
{
enabled = false;
return;
}
}
void OnValidate()
{
if (filterchoice != filterchoicememo)
{
ChangeFilters();
SCShader = Shader.Find(ShaderName);
DestroyImmediate(SCMaterial);
if(SCMaterial == null)
{
SCMaterial = new Material(SCShader);
SCMaterial.hideFlags = HideFlags.HideAndDontSave;
}
}
filterchoicememo = filterchoice;
if (Camera2 != null)
{
DestroyImmediate(Camera2.targetTexture);
Camera2tex=new RenderTexture(Screen.width,Screen.height, 24);
Camera2.targetTexture = Camera2tex;
}
ChangeValue=BlendFX;
ChangeValue2=SwitchCameraToCamera2;
}
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 virtual async Task <GetOrdersResponse> GetOrdersAsync(DateTime modifiedFrom, DateTime modifiedTo, Mark mark = null)
{
try
{
filters filters;
if (string.IsNullOrWhiteSpace(this.Store))
{
filters = new filters {
complex_filter = new complexFilter[2]
}
}
;
else
{
filters = new filters {
complex_filter = new complexFilter[3]
};
filters.complex_filter[2] = new complexFilter {
key = "store_id", value = new associativeEntity {
key = "in", value = this.Store
}
};
}
filters.complex_filter[1] = new complexFilter {
key = "updated_at", value = new associativeEntity {
key = "from", value = modifiedFrom.ToSoapParameterString()
}
};
filters.complex_filter[0] = new complexFilter {
key = "updated_at", value = new associativeEntity {
key = "to", value = modifiedTo.ToSoapParameterString()
}
};
const int maxCheckCount = 2;
const int delayBeforeCheck = 1800000;
var res = new salesOrderListResponse();
var privateClient = this._clientFactory.GetClient();
await ActionPolicies.GetAsync.Do(async() =>
{
var statusChecker = new StatusChecker(maxCheckCount);
TimerCallback tcb = statusChecker.CheckStatus;
privateClient = this._clientFactory.RefreshClient(privateClient);
var sessionId = await this.GetSessionId().ConfigureAwait(false);
using (var stateTimer = new Timer(tcb, privateClient, 1000, delayBeforeCheck))
res = await privateClient.salesOrderListAsync(sessionId.SessionId, filters).ConfigureAwait(false);
}).ConfigureAwait(false);
//crutch for magento 1.7
res.result = res.result.Where(x => Extensions.ToDateTimeOrDefault(x.updated_at) >= modifiedFrom && Extensions.ToDateTimeOrDefault(x.updated_at) <= modifiedTo).ToArray();
return(new GetOrdersResponse(res));
}
catch (Exception exc)
{
throw new MagentoSoapException(string.Format("An error occured during GetOrdersAsync(modifiedFrom:{0},modifiedTo{1})", modifiedFrom, modifiedTo), exc);
}
}
protected virtual async Task <SoapGetProductsResponse> GetProductsAsync(string productType, bool productTypeShouldBeExcluded, string productIdLike, DateTime?updatedFrom)
{
Func <bool, Task <catalogProductListResponse> > call = async(keepAlive) =>
{
var filtersTemp = new filters();
if (productType != null)
{
AddFilter(filtersTemp, productType, "type", productTypeShouldBeExcluded ? "neq" : "eq");
}
if (updatedFrom.HasValue)
{
AddFilter(filtersTemp, updatedFrom.Value.ToSoapParameterString(), "updated_at", "from");
}
if (!string.IsNullOrWhiteSpace(productIdLike))
{
AddFilter(filtersTemp, productIdLike, "product_id", "like");
}
var filters = filtersTemp;
//var filters = new MagentoSoapServiceReference_v_1_14_1_EE.filters { filter = new MagentoSoapServiceReference_v_1_14_1_EE.associativeEntity[1]{associativeEntity} };
var store = string.IsNullOrWhiteSpace(this.Store) ? null : this.Store;
var res = new catalogProductListResponse();
const int maxCheckCount = 2;
const int delayBeforeCheck = 1800000;
var privateClient = this._clientFactory.GetClient(keepAlive);
var statusChecker = new StatusChecker(maxCheckCount);
TimerCallback tcb = statusChecker.CheckStatus;
privateClient = this._clientFactory.RefreshClient(privateClient, keepAlive);
var sessionId = await this.GetSessionId().ConfigureAwait(false);
using (var stateTimer = new Timer(tcb, privateClient, 1000, delayBeforeCheck))
res = await privateClient.catalogProductListAsync(sessionId.SessionId, filters, store).ConfigureAwait(false);
return(res);
};
try
{
// keep alive is a crutch for 1 client, which has server that sloses connection after few minutes.
var keepAlive = false;
var res = new catalogProductListResponse();
await ActionPolicies.GetAsync.Do(async() =>
{
try
{
res = await call(keepAlive).ConfigureAwait(false);
return;
}
catch (CommunicationException)
{
keepAlive = !keepAlive;
}
res = await call(keepAlive).ConfigureAwait(false);
}).ConfigureAwait(false);
return(new SoapGetProductsResponse(res));
}
catch (Exception exc)
{
if (exc is CommunicationException) //crunch for fbeauty
{
var r = exc as CommunicationException;
if (r.InnerException.Message.Contains("403"))
{
if (productIdLike.Contains("00"))
{
return(null);
}
}
}
throw new MagentoSoapException(string.Format("An error occured during GetProductsAsync()"), exc);
}
}
public virtual async Task <GetOrdersResponse> GetOrdersAsync(IEnumerable <string> ordersIds)
{
var ordersIdsAgregated = string.Empty;
try
{
ordersIdsAgregated = string.Join(",", ordersIds);
filters filters;
if (string.IsNullOrWhiteSpace(this.Store))
{
filters = new filters {
complex_filter = new complexFilter[1]
}
}
;
else
{
filters = new filters {
complex_filter = new complexFilter[2]
};
filters.complex_filter[1] = new complexFilter {
key = "store_id", value = new associativeEntity {
key = "in", value = this.Store
}
};
}
filters.complex_filter[0] = new complexFilter {
key = "increment_id", value = new associativeEntity {
key = "in", value = ordersIdsAgregated
}
};
const int maxCheckCount = 2;
const int delayBeforeCheck = 1800000;
var res = new salesOrderListResponse();
var privateClient = this._clientFactory.GetClient();
await ActionPolicies.GetAsync.Do(async() =>
{
var statusChecker = new StatusChecker(maxCheckCount);
TimerCallback tcb = statusChecker.CheckStatus;
privateClient = this._clientFactory.RefreshClient(privateClient);
var sessionId = await this.GetSessionId().ConfigureAwait(false);
using (var stateTimer = new Timer(tcb, privateClient, 1000, delayBeforeCheck))
res = await privateClient.salesOrderListAsync(sessionId.SessionId, filters).ConfigureAwait(false);
}).ConfigureAwait(false);
return(new GetOrdersResponse(res));
}
catch (Exception exc)
{
throw new MagentoSoapException(string.Format("An error occured during GetOrdersAsync({0})", ordersIdsAgregated), exc);
}
}
private void bbDownload_Click(object sender, EventArgs e)
{
if (cbLoja.SelectedItem == null)
{
MessageBox.Show("Obrigatório selecionar loja.", "Mensagem", MessageBoxButtons.OK, MessageBoxIcon.Information);
cbLoja.Focus();
return;
}
if (string.IsNullOrEmpty((cbLoja.SelectedItem as TRegistro_LojaVirtual).UserName))
{
MessageBox.Show("Não existe USERNAME cadastrado para loja.", "Mensagem", MessageBoxButtons.OK, MessageBoxIcon.Information);
return;
}
if (string.IsNullOrEmpty((cbLoja.SelectedItem as TRegistro_LojaVirtual).ApiKey))
{
MessageBox.Show("Não existe APIKEY cadastrado para loja.", "Mensagem", MessageBoxButtons.OK, MessageBoxIcon.Information);
return;
}
MagentoService api = new MagentoService();
string sessao = string.Empty;
try
{
sessao = api.login((cbLoja.SelectedItem as TRegistro_LojaVirtual).UserName, (cbLoja.SelectedItem as TRegistro_LojaVirtual).ApiKey);
filters mf = new filters();
complexFilter[] cpf = new complexFilter[0];
if (cbStatus.SelectedIndex > 0)
{
complexFilter mcpf = new complexFilter();
mcpf.key = "status";
associativeEntity mas = new associativeEntity();
mas.key = "=";
mas.value = cbStatus.SelectedValue.ToString();
mcpf.value = mas;
Array.Resize(ref cpf, cpf.Length + 1);
cpf[cpf.Length - 1] = mcpf;
}
if (!string.IsNullOrEmpty(dt_ini.Text.SoNumero()))
{
complexFilter mcpf = new complexFilter();
mcpf.key = "created_at";
associativeEntity mas = new associativeEntity();
mas.key = "from";
mas.value = DateTime.Parse(dt_ini.Text).ToString("yyyy-MM-dd") + " 00:00:00";
mcpf.value = mas;
Array.Resize(ref cpf, cpf.Length + 1);
cpf[cpf.Length - 1] = mcpf;
}
mf.complex_filter = cpf;
salesOrderListEntity[] lista = api.salesOrderList(sessao, mf);
if (lista.Length > 0)
{
TList_Pedido lPedido = new TList_Pedido();
lista.ToList().ForEach(p =>
{
object obj = new TCD_Pedido().BuscarEscalar(
new TpBusca[]
{
new TpBusca()
{
vNM_Campo = "a.Nr_PedidoOrigem",
vOperador = "=",
vVL_Busca = "'" + p.increment_id.Trim() + "'"
}
}, "a.nr_pedido");
lPedido.Add(new TRegistro_Pedido()
{
Nr_PedidoOrigem = p.increment_id,
Vl_totalpedido = decimal.Divide(int.Parse(p.grand_total.SoNumero()), 10000),
StatusMagento = p.status,
NM_Clifor = p.firstname.Trim() + " " + p.lastname.Trim(),
Nr_pedido = obj == null ? 0 : decimal.Parse(obj.ToString()),
DT_Pedido = DateTime.Parse(p.created_at)
});
});
bsPedLoja.DataSource = lPedido;
}
}
catch (Exception ex)
{ MessageBox.Show(ex.Message.Trim(), "Erro", MessageBoxButtons.OK, MessageBoxIcon.Error); }
finally
{
if (!string.IsNullOrWhiteSpace(sessao))
{
api.endSession(sessao);
}
}
}
