protected void upsell_sale(MagentoService mservice, string mlogin, string brand_sql, string search_family, string source_sku)
{
string storeview = "1";
if (search_family.Contains("OEM"))
{
storeview = "3";
}
string sku_family = search_family;
if (sku_family.Contains("DK"))
{
search_family = "DK";
}
else if (sku_family.Contains("LP"))
{
search_family = "LP";
}
filters filter = new filters();
filter = addFilter(filter, "sku_family", "like", "%" + search_family + "%");
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, "up_sell", source_sku, qty_sku, assign, "sku");
}
}
mservice.Dispose();
}
//login to magento with soap_api
protected void get_magento_detail()
{
MagentoService mservice = new MagentoService();
String mlogin = mservice.login("admin", "Interconnection123");
//retriving list of product from storeview
//para @sessionid = login info
//@ filter = searchfilter @store id = see below
//store id : 1 = Main Website Store, 2= Low Income Store, 3 = Retail Store
var result = mservice.catalogProductInfo(mlogin, "ICL1296", "1", null, null);
mservice.Dispose();
}
protected void export_Click(object sender, EventArgs e)
{
MagentoService mservice = new MagentoService();
String mlogin = mservice.login("admin", "Interconnection123");
string[] arr1 = new string[] { "1218" };
string product = "1";
catalogInventoryStockItemUpdateEntity update_item = new catalogInventoryStockItemUpdateEntity();
update_item.qty = "1";
update_item.is_in_stock = 1;
var update = mservice.catalogInventoryStockItemUpdate(mlogin, product, update_item);
var item = mservice.catalogInventoryStockItemList(mlogin, arr1);
//working up_sell function
//catalogProductLinkEntity assign = new catalogProductLinkEntity();
//assign.position = "1";
//mservice.catalogProductLinkUpdate(mlogin, "related", "1030", "1029", assign, "product_id");
catalogProductCreateEntity create = new catalogProductCreateEntity();
var inv = new catalogProductTierPriceEntity();
create.name = name.Text;
create.price = price_control.Text;
create.description = des.Text;
create.short_description = short_des.Text;
create.tax_class_id = "2";
create.meta_title = meta_info.Text;
create.visibility = "4";
create.weight = "0";
create.status = "2";
create.meta_description = meta_description.Text;
inv.qty = 0;
associativeEntity[] attributes = new associativeEntity[18];
attributes[0] = new associativeEntity();
attributes[0].key = "asset_tag";
attributes[0].value = asset_tag.Text;
attributes[1] = new associativeEntity();
attributes[1].key = "sku_family";
attributes[1].value = sku_family.Text;
attributes[2] = new associativeEntity();
attributes[2].key = "cpu";
attributes[2].value = cpu.Text;
attributes[3] = new associativeEntity();
attributes[3].key = "software_description";
attributes[3].value = soft_des.Text;
attributes[4] = new associativeEntity();
attributes[4].key = "ram";
attributes[4].value = ram.Text + " RAM";
attributes[5] = new associativeEntity();
attributes[5].key = "hdd";
attributes[5].value = hdd.Text + " HDD";
attributes[6] = new associativeEntity();
attributes[6].key = "os";
attributes[6].value = software.Text;
attributes[7] = new associativeEntity();
attributes[7].key = "creation_date";
attributes[7].value = create_date.Text;
attributes[8] = new associativeEntity();
attributes[8].key = "wireless";
attributes[8].value = wireless.SelectedItem.ToString();
attributes[9] = new associativeEntity();
attributes[9].key = "incl";
attributes[9].value = includes.Text;
attributes[10] = new associativeEntity();
attributes[10].key = "brand";
attributes[10].value = brand.Text;
attributes[11] = new associativeEntity();
attributes[11].key = "grade";
attributes[11].value = grade.SelectedItem.Value;
attributes[12] = new associativeEntity();
attributes[12].key = "wcoa";
attributes[12].value = wcoa.Text;
attributes[13] = new associativeEntity();
attributes[13].key = "ocoa";
attributes[13].value = ocoa.Text;
attributes[14] = new associativeEntity();
attributes[14].key = "video";
attributes[14].value = video_card.Text;
attributes[15] = new associativeEntity();
attributes[15].key = "display";
attributes[15].value = screen.Text;
attributes[16] = new associativeEntity();
attributes[16].key = "computer";
attributes[16].value = is_computer.SelectedValue;
attributes[17] = new associativeEntity();
attributes[17].key = "optical";
attributes[17].value = optical.Text;
catalogProductAdditionalAttributesEntity additionalAttributes = new catalogProductAdditionalAttributesEntity();
additionalAttributes.single_data = attributes;
create.additional_attributes = additionalAttributes;
mservice.catalogProductCreate(
mlogin, "simple", "4", sku.Text, create, "1");
mservice.Dispose();
//update inventory
catalogInventoryStockItemUpdateEntity qty_update = new catalogInventoryStockItemUpdateEntity();
qty_update.qty = qty.Text;
qty_update.is_in_stock = int.Parse(stock_Availability.SelectedValue);
mservice.catalogInventoryStockItemUpdate(
mlogin, sku.Text, qty_update);
get_magento_list(sku.Text);
ClearTextBoxes(Page);
//string content = "admin,,Default,simple,,,0,"+status.SelectedItem.ToString()+ ",No,\"Catalog, Search\",Yes,"+tax_class.SelectedItem.ToString()+ ",No,No,Yes,No,No,\"" + name.Text+ "\",,," + software.Text+ ","+cpu.Text+","+hdd.Text+",,"+ram.Text+ ",Use config,Use config,\"" + meta_info.Text+ "\",\"" + meta_description.Text+ "\",,,,,No layout updates,Block after Info Column,No,,,,,,"+brand.Text+ ",\"" + includes.Text+ "\"," + grade.SelectedItem.ToString()+",,,,,,,,,,,,,,,,,,"+wireless.SelectedItem.ToString()+ ",,,,,,,,,,,,,," + des.Text + ",\"" + short_des.Text+ "\",,,\"" + soft_des.Text+ "\",,,,,,,,,,,1,0,1,0,0,1,1,1,0,1,0,,,1,0,1,0,1,0,1,0,0,0,1,\"" + name.Text+ "\",0,simple,,,,,,,,,,," + asset_tag.Text+","+sku_family.Text+","+create_date.Text+"";
}
