/// <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 void InsertDefaultSKU(TList<SKUEntity> SKUList)
{
string ConnectionString = System.Configuration.ConfigurationManager.ConnectionStrings["ZNodeECommerceDB"].ConnectionString;
ZNode.Libraries.DataAccess.Service.SKUService ProductSKUServ = new SKUService();
foreach (SKUEntity entity in SKUList)
{
SKU _sku = new SKU();
int Productid = GetProductID(entity.ProductNum, ConnectionString);
int SkuId = GetSkuID(entity.SKU, ConnectionString);
if (Productid == 0)
{
break;
}
//Set Properties
_sku.QuantityOnHand = entity.QuantityOnHand;
_sku.ProductID = Productid;
if (entity.RetailPriceOverride.HasValue)
{
_sku.RetailPriceOverride = entity.RetailPriceOverride.Value;
}
_sku.SKU = entity.SKU;
if (SkuId > 0)
{
_sku.UpdateDte = System.DateTime.Now;
ProductSKUServ.Update(_sku);
}
else
{
ProductSKUServ.Insert(_sku);
}
}
}