/// <summary>
///
/// </summary>
/// <param name="ds"></param>
/// <param name="appSettings"></param>
/// <param name="connString"></param>
private void UploadProductRetailPrice(ZNode.Libraries.Framework.Business.ZNodeGenericCollection<ProductSKUEntity> ProdSKUList, string connString)
{
#region Local Variable Declaration
SqlConnection conn = new SqlConnection(connString);
ZNode.Libraries.DataAccess.Service.ProductService ProductServ = new ProductService();
ZNode.Libraries.DataAccess.Service.SKUService ProductSKUServ = new SKUService();
ZNode.Libraries.DataAccess.Service.AddOnValueService ProductAddOnValueServ = new AddOnValueService();
#endregion
foreach (ProductSKUEntity entity in ProdSKUList)
{
SKU _sku = new SKU();
//Update Prodcut table
int ProductID = GetProductBySKU(entity.SKU, connString);
if (ProductID > 0)
{
Product _productObject = ProductServ.GetByProductID(ProductID);
_productObject.RetailPrice = entity.RetailPrice;
_productObject.SalePrice = entity.SalePrice;
_productObject.WholesalePrice = entity.WholesalePrice;
_productObject.UpdateDte = System.DateTime.Now;
ProductServ.Update(_productObject);
}
//Update SKU table
int SkuId = GetSkuID(entity.SKU, connString);
if (SkuId > 0)
{
_sku = ProductSKUServ.GetBySKUID(SkuId);
//Set Quantity available value
_sku.RetailPriceOverride = entity.RetailPrice;
_sku.SalePriceOverride = entity.SalePrice;
_sku.WholesalePriceOverride = entity.WholesalePrice;
_sku.UpdateDte = System.DateTime.Now;
//Upate SKU
ProductSKUServ.Update(_sku);
}
//Update Add-On table
AddOnValue _addOnvalue = new AddOnValue();
int AddOnValueId = GetSkuIDByAddOnValueSKU(entity.SKU, connString);
if (AddOnValueId > 0)
{
_addOnvalue = ProductAddOnValueServ.GetByAddOnValueID(AddOnValueId);
_addOnvalue.RetailPrice = entity.RetailPrice;
_addOnvalue.SalePrice = entity.SalePrice;
_addOnvalue.WholesalePrice = entity.WholesalePrice;
_addOnvalue.UpdateDte = System.DateTime.Now;
ProductAddOnValueServ.Update(_addOnvalue);
}
}
}
/// <summary>
///
/// </summary>
/// <param name="ProductList"></param>
private System.Xml.XmlDocument InsertProduct(ZNode.Libraries.Framework.Business.ZNodeGenericCollection<ProductEntity> ProductList)
{
ZNode.Libraries.DataAccess.Service.ProductService ProductServ = new ProductService();
string ConnectionString = System.Configuration.ConfigurationManager.ConnectionStrings["ZNodeECommerceDB"].ConnectionString;
int RowsAffected = 0;
try
{
//Loop through the no.of items in the Product List object
foreach (ProductEntity Entity in ProductList)
{
Product _product = new Product();
int ProductId = GetProductID(Entity.ProductNum, ConnectionString);
if (ProductId > 0)
{
_product = ProductServ.GetByProductID(ProductId);
}
//Set Properties
_product.Name = Entity.Name;
_product.Description = Entity.Description;
_product.FeaturesDesc = Entity.FeaturesDesc;
_product.DisplayOrder = Entity.DisplayOrder;
//General settings
_product.PortalID = Entity.PortalID;
_product.ProductNum = Entity.ProductNum;
_product.ActiveInd = Entity.IsActive;
_product.ImageFile = Entity.ImageFile;
_product.RetailPrice = Entity.RetailPrice;
_product.SalePrice = Entity.SalePrice;
_product.WholesalePrice = Entity.WholesalePrice;
//Display Settings
_product.CallForPricing = Entity.CallForPricing;
_product.HomepageSpecial = Entity.HomepageSpecial;
_product.CategorySpecial = Entity.CategorySpecial;
_product.Keywords = Entity.Keywords;
//inventory Settings
_product.BackOrderMsg = Entity.BackOrderMsg;
_product.OutOfStockMsg = Entity.OutOfStockMsg;
_product.InStockMsg = Entity.InStockMsg;
// Product Type Section
int ProductTypeId = ZnodeProductTypeInsert(Entity.PortalID, Entity.ProductTypeName, ConnectionString);
if (ProductTypeId == 0)
{
ProductTypeId = ZnodeProductTypeInsert(Entity.PortalID, Entity.ProductTypeName, ConnectionString);
}
//If product type is "Default" ,then SKU and Quantity on Hand values are updated into Product Table
// Otherwise it will update the values into SKU table
if (Entity.ProductTypeName.Equals("Default"))
{
_product.QuantityOnHand = Entity.QuantityOnHand;
_product.SKU = Entity.SKU;
//remove Existing Skus for this product
ZNode.Libraries.Admin.SKUAdmin _skuAdmin = new ZNode.Libraries.Admin.SKUAdmin();
_skuAdmin.DeleteByProductId(ProductId);
}
else
{
//Reset Default product Inventory settings
_product.QuantityOnHand = 0;
_product.SKU = Entity.SKU;
}
_product.ProductTypeID = ProductTypeId; // Set product type id
int ManufacturerId = GetManufacturerID(Entity.ManufacturerName, ConnectionString);
if (ManufacturerId == 0)
{
_product.ManufacturerID = null; //If not exists ,then insert null to Manufacturerid
}
bool status = false;
if (ProductId > 0)
{
_product.UpdateDte = System.DateTime.Now;
status = ProductServ.Update(_product);
}
else
{
status = ProductServ.Insert(_product);
}
if (status)
{
RowsAffected++;
}
}
}
catch (Exception ex)
{ return CreateSOAPResponse("", "-2", ex.Message); }
return CreateSOAPResponse(RowsAffected.ToString(),"0",""); ;
}
