/// <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",""); ; }