/// <summary> /// Updates the product variant attribute mapping /// </summary> /// <param name="productVariantAttribute">The product variant attribute mapping</param> public void UpdateProductVariantAttribute(ProductVariantAttribute productVariantAttribute) { if (productVariantAttribute == null) { throw new ArgumentNullException("productVariantAttribute"); } productVariantAttribute.TextPrompt = CommonHelper.EnsureNotNull(productVariantAttribute.TextPrompt); productVariantAttribute.TextPrompt = CommonHelper.EnsureMaximumLength(productVariantAttribute.TextPrompt, 200); if (!_context.IsAttached(productVariantAttribute)) { _context.ProductVariantAttributes.Attach(productVariantAttribute); } _context.SaveChanges(); if (this.CacheEnabled) { _cacheManager.RemoveByPattern(PRODUCTATTRIBUTES_PATTERN_KEY); _cacheManager.RemoveByPattern(PRODUCTVARIANTATTRIBUTES_PATTERN_KEY); _cacheManager.RemoveByPattern(PRODUCTVARIANTATTRIBUTEVALUES_PATTERN_KEY); } }
/// <summary> /// Gets a product variant attribute mapping /// </summary> /// <param name="ProductVariantAttributeID">Product variant attribute mapping identifier</param> /// <returns>Product variant attribute mapping</returns> public static ProductVariantAttribute GetProductVariantAttributeByID(int ProductVariantAttributeID) { if (ProductVariantAttributeID == 0) { return(null); } string key = string.Format(PRODUCTVARIANTATTRIBUTES_BY_ID_KEY, ProductVariantAttributeID); object obj2 = NopCache.Get(key); if (ProductAttributeManager.CacheEnabled && (obj2 != null)) { return((ProductVariantAttribute)obj2); } DBProductVariantAttribute dbItem = DBProviderManager <DBProductAttributeProvider> .Provider.GetProductVariantAttributeByID(ProductVariantAttributeID); ProductVariantAttribute productVariantAttribute = DBMapping(dbItem); if (ProductAttributeManager.CacheEnabled) { NopCache.Max(key, productVariantAttribute); } return(productVariantAttribute); }
/// <summary> /// Adds an attribute /// </summary> /// <param name="Attributes">Attributes</param> /// <param name="pva">Product variant attribute</param> /// <param name="value">Value</param> /// <returns>Attributes</returns> public static string AddAttribute(string Attributes, ProductVariantAttribute pva, string value) { string result = string.Empty; try { XmlDocument xmlDoc = new XmlDocument(); if (String.IsNullOrEmpty(Attributes)) { XmlElement _element1 = xmlDoc.CreateElement("Attributes"); xmlDoc.AppendChild(_element1); } else { xmlDoc.LoadXml(Attributes); } XmlElement rootElement = (XmlElement)xmlDoc.SelectSingleNode(@"//Attributes"); XmlElement pvaElement = null; //find existing XmlNodeList nodeList1 = xmlDoc.SelectNodes(@"//Attributes/ProductVariantAttribute"); foreach (XmlNode node1 in nodeList1) { if (node1.Attributes != null && node1.Attributes["ID"] != null) { int id = Convert.ToInt32(node1.Attributes["ID"].InnerText.Trim()); if (id == pva.ProductVariantAttributeID) { pvaElement = (XmlElement)node1; break; } } } //create new one if not found if (pvaElement == null) { pvaElement = xmlDoc.CreateElement("ProductVariantAttribute"); pvaElement.SetAttribute("ID", pva.ProductVariantAttributeID.ToString()); rootElement.AppendChild(pvaElement); } XmlElement pvavElement = xmlDoc.CreateElement("ProductVariantAttributeValue"); pvaElement.AppendChild(pvavElement); XmlElement pvavVElement = xmlDoc.CreateElement("Value"); pvavVElement.InnerText = value; pvavElement.AppendChild(pvavVElement); result = xmlDoc.OuterXml; } catch (Exception exc) { Debug.Write(exc.ToString()); } return(result); }
/// <summary> /// Gets selected product variant attributes /// </summary> /// <param name="Attributes">Attributes</param> /// <returns>Selected product variant attributes</returns> public static ProductVariantAttributeCollection ParseProductVariantAttributes(string Attributes) { ProductVariantAttributeCollection pvaCollection = new ProductVariantAttributeCollection(); List <int> IDs = ParseProductVariantAttributeIDs(Attributes); foreach (int id in IDs) { ProductVariantAttribute pva = ProductAttributeManager.GetProductVariantAttributeByID(id); if (pva != null) { pvaCollection.Add(pva); } } return(pvaCollection); }
private static ProductVariantAttributeCollection DBMapping(DBProductVariantAttributeCollection dbCollection) { if (dbCollection == null) { return(null); } ProductVariantAttributeCollection collection = new ProductVariantAttributeCollection(); foreach (DBProductVariantAttribute dbItem in dbCollection) { ProductVariantAttribute item = DBMapping(dbItem); collection.Add(item); } return(collection); }
/// <summary> /// Updates the product variant attribute mapping /// </summary> /// <param name="ProductVariantAttributeID">The product variant attribute mapping identifier</param> /// <param name="ProductVariantID">The product variant identifier</param> /// <param name="ProductAttributeID">The product attribute identifier</param> /// <param name="TextPrompt">The text prompt</param> /// <param name="IsRequired">The value indicating whether the entity is required</param> /// <param name="AttributeControlType">The attribute control type</param> /// <param name="DisplayOrder">The display order</param> /// <returns>Product variant attribute mapping</returns> public static ProductVariantAttribute UpdateProductVariantAttribute(int ProductVariantAttributeID, int ProductVariantID, int ProductAttributeID, string TextPrompt, bool IsRequired, AttributeControlTypeEnum AttributeControlType, int DisplayOrder) { DBProductVariantAttribute dbItem = DBProviderManager <DBProductAttributeProvider> .Provider.UpdateProductVariantAttribute(ProductVariantAttributeID, ProductVariantID, ProductAttributeID, TextPrompt, IsRequired, (int)AttributeControlType, DisplayOrder); ProductVariantAttribute productVariantAttribute = DBMapping(dbItem); if (ProductAttributeManager.CacheEnabled) { NopCache.RemoveByPattern(PRODUCTATTRIBUTES_PATTERN_KEY); NopCache.RemoveByPattern(PRODUCTVARIANTATTRIBUTES_PATTERN_KEY); NopCache.RemoveByPattern(PRODUCTVARIANTATTRIBUTEVALUES_PATTERN_KEY); } return(productVariantAttribute); }
private static ProductVariantAttribute DBMapping(DBProductVariantAttribute dbItem) { if (dbItem == null) { return(null); } ProductVariantAttribute item = new ProductVariantAttribute(); item.ProductVariantAttributeID = dbItem.ProductVariantAttributeID; item.ProductVariantID = dbItem.ProductVariantID; item.ProductAttributeID = dbItem.ProductAttributeID; item.TextPrompt = dbItem.TextPrompt; item.IsRequired = dbItem.IsRequired; item.AttributeControlTypeID = dbItem.AttributeControlTypeID; item.DisplayOrder = dbItem.DisplayOrder; return(item); }
/// <summary> /// Creates a copy of product with all depended data /// </summary> /// <param name="productId">The product identifier</param> /// <param name="name">The name of product duplicate</param> /// <param name="isPublished">A value indicating whether the product duplicate should be published</param> /// <param name="copyImages">A value indicating whether the product images should be copied</param> /// <returns>Product entity</returns> public Product DuplicateProduct(int productId, string name, bool isPublished, bool copyImages) { var product = GetProductById(productId); if (product == null) return null; Product productCopy = null; //uncomment this line to support transactions //using (var scope = new System.Transactions.TransactionScope()) { // product productCopy = new Product() { Name = name, ShortDescription = product.ShortDescription, FullDescription = product.FullDescription, AdminComment = product.AdminComment, TemplateId = product.TemplateId, ShowOnHomePage = product.ShowOnHomePage, MetaKeywords = product.MetaKeywords, MetaDescription = product.MetaDescription, MetaTitle = product.MetaTitle, SEName = product.SEName, AllowCustomerReviews = product.AllowCustomerReviews, AllowCustomerRatings = product.AllowCustomerRatings, Published = isPublished, Deleted = product.Deleted, CreatedOn = DateTime.UtcNow, UpdatedOn = DateTime.UtcNow }; InsertProduct(productCopy); if (productCopy == null) return null; var languages = IoC.Resolve<ILanguageService>().GetAllLanguages(true); //localization foreach (var lang in languages) { var productLocalized = GetProductLocalizedByProductIdAndLanguageId(product.ProductId, lang.LanguageId); if (productLocalized != null) { var productLocalizedCopy = new ProductLocalized() { ProductId = productCopy.ProductId, LanguageId = productLocalized.LanguageId, Name = productLocalized.Name, ShortDescription = productLocalized.ShortDescription, FullDescription = productLocalized.FullDescription, MetaKeywords = productLocalized.MetaKeywords, MetaDescription = productLocalized.MetaDescription, MetaTitle = productLocalized.MetaTitle, SEName = productLocalized.SEName }; InsertProductLocalized(productLocalizedCopy); } } // product pictures if (copyImages) { foreach (var productPicture in product.ProductPictures) { var picture = productPicture.Picture; var pictureCopy = IoC.Resolve<IPictureService>().InsertPicture(picture.PictureBinary, picture.MimeType, picture.IsNew); InsertProductPicture(new ProductPicture() { ProductId = productCopy.ProductId, PictureId = pictureCopy.PictureId, DisplayOrder = productPicture.DisplayOrder }); } } // product <-> categories mappings foreach (var productCategory in product.ProductCategories) { var productCategoryCopy = new ProductCategory() { ProductId = productCopy.ProductId, CategoryId = productCategory.CategoryId, IsFeaturedProduct = productCategory.IsFeaturedProduct, DisplayOrder = productCategory.DisplayOrder }; IoC.Resolve<ICategoryService>().InsertProductCategory(productCategoryCopy); } // product <-> manufacturers mappings foreach (var productManufacturers in product.ProductManufacturers) { var productManufacturerCopy = new ProductManufacturer() { ProductId = productCopy.ProductId, ManufacturerId = productManufacturers.ManufacturerId, IsFeaturedProduct = productManufacturers.IsFeaturedProduct, DisplayOrder = productManufacturers.DisplayOrder }; IoC.Resolve<IManufacturerService>().InsertProductManufacturer(productManufacturerCopy); } // product <-> releated products mappings foreach (var relatedProduct in product.RelatedProducts) { InsertRelatedProduct( new RelatedProduct() { ProductId1 = productCopy.ProductId, ProductId2 = relatedProduct.ProductId2, DisplayOrder = relatedProduct.DisplayOrder }); } // product specifications foreach (var productSpecificationAttribute in IoC.Resolve<ISpecificationAttributeService>().GetProductSpecificationAttributesByProductId(product.ProductId)) { var psaCopy = new ProductSpecificationAttribute() { ProductId = productCopy.ProductId, SpecificationAttributeOptionId = productSpecificationAttribute.SpecificationAttributeOptionId, AllowFiltering = productSpecificationAttribute.AllowFiltering, ShowOnProductPage = productSpecificationAttribute.ShowOnProductPage, DisplayOrder = productSpecificationAttribute.DisplayOrder }; IoC.Resolve<ISpecificationAttributeService>().InsertProductSpecificationAttribute(psaCopy); } // product variants var productVariants = GetProductVariantsByProductId(product.ProductId, true); foreach (var productVariant in productVariants) { // product variant picture int pictureId = 0; if (copyImages) { var picture = productVariant.Picture; if (picture != null) { var pictureCopy = IoC.Resolve<IPictureService>().InsertPicture(picture.PictureBinary, picture.MimeType, picture.IsNew); pictureId = pictureCopy.PictureId; } } // product variant download & sample download int downloadId = productVariant.DownloadId; int sampleDownloadId = productVariant.SampleDownloadId; if (productVariant.IsDownload) { var download = productVariant.Download; if (download != null) { var downloadCopy = new Download() { UseDownloadUrl = download.UseDownloadUrl, DownloadUrl = download.DownloadUrl, DownloadBinary = download.DownloadBinary, ContentType = download.ContentType, Filename = download.Filename, Extension = download.Extension, IsNew = download.IsNew }; IoC.Resolve<IDownloadService>().InsertDownload(downloadCopy); downloadId = downloadCopy.DownloadId; } if (productVariant.HasSampleDownload) { var sampleDownload = productVariant.SampleDownload; if (sampleDownload != null) { var sampleDownloadCopy = new Download() { UseDownloadUrl = sampleDownload.UseDownloadUrl, DownloadUrl = sampleDownload.DownloadUrl, DownloadBinary = sampleDownload.DownloadBinary, ContentType = sampleDownload.ContentType, Filename = sampleDownload.Filename, Extension = sampleDownload.Extension, IsNew = sampleDownload.IsNew }; IoC.Resolve<IDownloadService>().InsertDownload(sampleDownloadCopy); sampleDownloadId = sampleDownloadCopy.DownloadId; } } } // product variant var productVariantCopy = new ProductVariant() { ProductId = productCopy.ProductId, Name = productVariant.Name, SKU = productVariant.SKU, Description = productVariant.Description, AdminComment = productVariant.AdminComment, ManufacturerPartNumber = productVariant.ManufacturerPartNumber, IsGiftCard = productVariant.IsGiftCard, GiftCardType = productVariant.GiftCardType, IsDownload = productVariant.IsDownload, DownloadId = downloadId, UnlimitedDownloads = productVariant.UnlimitedDownloads, MaxNumberOfDownloads = productVariant.MaxNumberOfDownloads, DownloadExpirationDays = productVariant.DownloadExpirationDays, DownloadActivationType = productVariant.DownloadActivationType, HasSampleDownload = productVariant.HasSampleDownload, SampleDownloadId = sampleDownloadId, HasUserAgreement = productVariant.HasUserAgreement, UserAgreementText = productVariant.UserAgreementText, IsRecurring = productVariant.IsRecurring, CycleLength = productVariant.CycleLength, CyclePeriod = productVariant.CyclePeriod, TotalCycles = productVariant.TotalCycles, IsShipEnabled = productVariant.IsShipEnabled, IsFreeShipping = productVariant.IsFreeShipping, AdditionalShippingCharge = productVariant.AdditionalShippingCharge, IsTaxExempt = productVariant.IsTaxExempt, TaxCategoryId = productVariant.TaxCategoryId, ManageInventory = productVariant.ManageInventory, StockQuantity = productVariant.StockQuantity, DisplayStockAvailability = productVariant.DisplayStockAvailability, DisplayStockQuantity = productVariant.DisplayStockQuantity, MinStockQuantity = productVariant.MinStockQuantity, LowStockActivityId = productVariant.LowStockActivityId, NotifyAdminForQuantityBelow = productVariant.NotifyAdminForQuantityBelow, Backorders = productVariant.Backorders, OrderMinimumQuantity = productVariant.OrderMinimumQuantity, OrderMaximumQuantity = productVariant.OrderMaximumQuantity, WarehouseId = productVariant.WarehouseId, DisableBuyButton = productVariant.DisableBuyButton, CallForPrice = productVariant.CallForPrice, Price = productVariant.Price, OldPrice = productVariant.OldPrice, ProductCost = productVariant.ProductCost, CustomerEntersPrice = productVariant.CustomerEntersPrice, MinimumCustomerEnteredPrice = productVariant.MinimumCustomerEnteredPrice, MaximumCustomerEnteredPrice = productVariant.MaximumCustomerEnteredPrice, Weight = productVariant.Weight, Length = productVariant.Length, Width = productVariant.Width, Height = productVariant.Height, PictureId = pictureId, AvailableStartDateTime = productVariant.AvailableStartDateTime, AvailableEndDateTime = productVariant.AvailableEndDateTime, Published = productVariant.Published, Deleted = productVariant.Deleted, DisplayOrder = productVariant.DisplayOrder, CreatedOn = DateTime.UtcNow, UpdatedOn = DateTime.UtcNow }; InsertProductVariant(productVariantCopy); //localization foreach (var lang in languages) { var productVariantLocalized = GetProductVariantLocalizedByProductVariantIdAndLanguageId(productVariant.ProductVariantId, lang.LanguageId); if (productVariantLocalized != null) { var productVariantLocalizedCopy = new ProductVariantLocalized() { ProductVariantId = productVariantCopy.ProductVariantId, LanguageId = productVariantLocalized.LanguageId, Name = productVariantLocalized.Name, Description = productVariantLocalized.Description }; InsertProductVariantLocalized(productVariantLocalizedCopy); } } // product variant <-> attributes mappings foreach (var productVariantAttribute in IoC.Resolve<IProductAttributeService>().GetProductVariantAttributesByProductVariantId(productVariant.ProductVariantId)) { var productVariantAttributeCopy = new ProductVariantAttribute() { ProductVariantId = productVariantCopy.ProductVariantId, ProductAttributeId = productVariantAttribute.ProductAttributeId, TextPrompt = productVariantAttribute.TextPrompt, IsRequired = productVariantAttribute.IsRequired, AttributeControlTypeId = productVariantAttribute.AttributeControlTypeId, DisplayOrder = productVariantAttribute.DisplayOrder }; IoC.Resolve<IProductAttributeService>().InsertProductVariantAttribute(productVariantAttributeCopy); // product variant attribute values var productVariantAttributeValues = IoC.Resolve<IProductAttributeService>().GetProductVariantAttributeValues(productVariantAttribute.ProductVariantAttributeId); foreach (var productVariantAttributeValue in productVariantAttributeValues) { var pvavCopy = new ProductVariantAttributeValue() { ProductVariantAttributeId = productVariantAttributeCopy.ProductVariantAttributeId, Name = productVariantAttributeValue.Name, PriceAdjustment = productVariantAttributeValue.PriceAdjustment, WeightAdjustment = productVariantAttributeValue.WeightAdjustment, IsPreSelected = productVariantAttributeValue.IsPreSelected, DisplayOrder = productVariantAttributeValue.DisplayOrder }; IoC.Resolve<IProductAttributeService>().InsertProductVariantAttributeValue(pvavCopy); //localization foreach (var lang in languages) { var pvavLocalized = IoC.Resolve<IProductAttributeService>().GetProductVariantAttributeValueLocalizedByProductVariantAttributeValueIdAndLanguageId(productVariantAttributeValue.ProductVariantAttributeValueId, lang.LanguageId); if (pvavLocalized != null) { var pvavLocalizedCopy = new ProductVariantAttributeValueLocalized() { ProductVariantAttributeValueId = pvavCopy.ProductVariantAttributeValueId, LanguageId = pvavLocalized.LanguageId, Name = pvavLocalized.Name }; IoC.Resolve<IProductAttributeService>().InsertProductVariantAttributeValueLocalized(pvavLocalizedCopy); } } } } foreach (var combination in IoC.Resolve<IProductAttributeService>().GetAllProductVariantAttributeCombinations(productVariant.ProductVariantId)) { var combinationCopy = new ProductVariantAttributeCombination() { ProductVariantId = productVariantCopy.ProductVariantId, AttributesXml = combination.AttributesXml, StockQuantity = combination.StockQuantity, AllowOutOfStockOrders = combination.AllowOutOfStockOrders }; IoC.Resolve<IProductAttributeService>().InsertProductVariantAttributeCombination(combinationCopy); } // product variant tier prices foreach (var tierPrice in productVariant.TierPrices) { InsertTierPrice( new TierPrice() { ProductVariantId = productVariantCopy.ProductVariantId, Quantity = tierPrice.Quantity, Price = tierPrice.Price }); } // product variant <-> discounts mapping foreach (var discount in productVariant.AllDiscounts) { IoC.Resolve<IDiscountService>().AddDiscountToProductVariant(productVariantCopy.ProductVariantId, discount.DiscountId); } // prices by customer role foreach (var crpp in productVariant.CustomerRoleProductPrices) { this.InsertCustomerRoleProductPrice( new CustomerRoleProductPrice() { CustomerRoleId = crpp.CustomerRoleId, ProductVariantId = productVariantCopy.ProductVariantId, Price = crpp.Price } ); } } //uncomment this line to support transactions //scope.Complete(); } return productCopy; }
/// <summary> /// Adds an attribute /// </summary> /// <param name="attributes">Attributes</param> /// <param name="pva">Product variant attribute</param> /// <param name="value">Value</param> /// <returns>Attributes</returns> public static string AddProductAttribute(string attributes, ProductVariantAttribute pva, string value) { string result = string.Empty; try { XmlDocument xmlDoc = new XmlDocument(); if (String.IsNullOrEmpty(attributes)) { XmlElement _element1 = xmlDoc.CreateElement("Attributes"); xmlDoc.AppendChild(_element1); } else { xmlDoc.LoadXml(attributes); } XmlElement rootElement = (XmlElement)xmlDoc.SelectSingleNode(@"//Attributes"); XmlElement pvaElement = null; //find existing XmlNodeList nodeList1 = xmlDoc.SelectNodes(@"//Attributes/ProductVariantAttribute"); foreach (XmlNode node1 in nodeList1) { if (node1.Attributes != null && node1.Attributes["ID"] != null) { int id = Convert.ToInt32(node1.Attributes["ID"].InnerText.Trim()); if (id == pva.ProductVariantAttributeId) { pvaElement = (XmlElement)node1; break; } } } //create new one if not found if (pvaElement == null) { pvaElement = xmlDoc.CreateElement("ProductVariantAttribute"); pvaElement.SetAttribute("ID", pva.ProductVariantAttributeId.ToString()); rootElement.AppendChild(pvaElement); } XmlElement pvavElement = xmlDoc.CreateElement("ProductVariantAttributeValue"); pvaElement.AppendChild(pvavElement); XmlElement pvavVElement = xmlDoc.CreateElement("Value"); pvavVElement.InnerText = value; pvavElement.AppendChild(pvavVElement); result = xmlDoc.OuterXml; } catch (Exception exc) { Debug.Write(exc.ToString()); } return result; }
/// <summary> /// Updates the product variant attribute mapping /// </summary> /// <param name="productVariantAttribute">The product variant attribute mapping</param> public void UpdateProductVariantAttribute(ProductVariantAttribute productVariantAttribute) { if (productVariantAttribute == null) throw new ArgumentNullException("productVariantAttribute"); productVariantAttribute.TextPrompt = CommonHelper.EnsureNotNull(productVariantAttribute.TextPrompt); productVariantAttribute.TextPrompt = CommonHelper.EnsureMaximumLength(productVariantAttribute.TextPrompt, 200); if (!_context.IsAttached(productVariantAttribute)) _context.ProductVariantAttributes.Attach(productVariantAttribute); _context.SaveChanges(); if (this.CacheEnabled) { _cacheManager.RemoveByPattern(PRODUCTATTRIBUTES_PATTERN_KEY); _cacheManager.RemoveByPattern(PRODUCTVARIANTATTRIBUTES_PATTERN_KEY); _cacheManager.RemoveByPattern(PRODUCTVARIANTATTRIBUTEVALUES_PATTERN_KEY); } }
protected void btnNewProductVariantAttribute_Click(object sender, EventArgs e) { try { if (this.ProductVariant != null) { if (ddlNewProductAttributes.SelectedItem == null) return; int productAttributeId = int.Parse(ddlNewProductAttributes.SelectedItem.Value); AttributeControlTypeEnum attributeControlType = (AttributeControlTypeEnum)Enum.ToObject(typeof(AttributeControlTypeEnum), int.Parse(this.ddlAttributeControlType.SelectedItem.Value)); var productVariantAttribute = new ProductVariantAttribute() { ProductVariantId = this.ProductVariant.ProductVariantId, ProductAttributeId = productAttributeId, TextPrompt = txtNewTextPrompt.Text, IsRequired = cbNewProductVariantAttributeIsRequired.Checked, AttributeControlTypeId = (int)attributeControlType, DisplayOrder = txtNewProductVariantAttributeDisplayOrder.Value }; this.ProductAttributeService.InsertProductVariantAttribute(productVariantAttribute); BindAttributes(); BindCombinations(); RefreshSelectCombinationControl(); txtNewProductVariantAttributeDisplayOrder.Value = 1; } } catch (Exception exc) { processAjaxError(exc); } }