/// <summary> /// Maps a data reader to a product specification attribute /// </summary> /// <param name="dataReader">IDataReader</param> /// <returns>Product specification attribute</returns> private DBProductSpecificationAttribute GetProductSpecificationAttributeFromReader(IDataReader dataReader) { DBProductSpecificationAttribute productSpecificationAttribute = new DBProductSpecificationAttribute(); productSpecificationAttribute.ProductSpecificationAttributeID = NopSqlDataHelper.GetInt(dataReader, "ProductSpecificationAttributeID"); productSpecificationAttribute.ProductID = NopSqlDataHelper.GetInt(dataReader, "ProductID"); productSpecificationAttribute.SpecificationAttributeOptionID = NopSqlDataHelper.GetInt(dataReader, "SpecificationAttributeOptionID"); productSpecificationAttribute.AllowFiltering = NopSqlDataHelper.GetBoolean(dataReader, "AllowFiltering"); productSpecificationAttribute.ShowOnProductPage = NopSqlDataHelper.GetBoolean(dataReader, "ShowOnProductPage"); productSpecificationAttribute.DisplayOrder = NopSqlDataHelper.GetInt(dataReader, "DisplayOrder"); return productSpecificationAttribute; }
/// <summary> /// Gets a product specification attribute mapping /// </summary> /// <param name="ProductSpecificationAttributeID">Product specification attribute mapping identifier</param> /// <returns>Product specification attribute mapping</returns> public static ProductSpecificationAttribute GetProductSpecificationAttributeByID(int ProductSpecificationAttributeID) { if (ProductSpecificationAttributeID == 0) { return(null); } DBProductSpecificationAttribute dbItem = DBProviderManager <DBSpecificationAttributeProvider> .Provider.GetProductSpecificationAttributeByID(ProductSpecificationAttributeID); ProductSpecificationAttribute productSpecificationAttribute = DBMapping(dbItem); return(productSpecificationAttribute); }
/// <summary> /// Updates the product specification attribute mapping /// </summary> /// <param name="productSpecificationAttributeID">product specification attribute mapping identifier</param> /// <param name="productID">Product identifier</param> /// <param name="specificationAttributeOptionID">Specification attribute identifier</param> /// <param name="allowFiltering">Allow product filtering by this attribute</param> /// <param name="showOnProductPage">Show the attribute on the product page</param> /// <param name="displayOrder">The display order</param> /// <returns>Product specification attribute mapping</returns> public static ProductSpecificationAttribute UpdateProductSpecificationAttribute(int productSpecificationAttributeID, int productID, int specificationAttributeOptionID, bool allowFiltering, bool showOnProductPage, int displayOrder) { DBProductSpecificationAttribute dbItem = DBProviderManager <DBSpecificationAttributeProvider> .Provider.UpdateProductSpecificationAttribute(productSpecificationAttributeID, productID, specificationAttributeOptionID, allowFiltering, showOnProductPage, displayOrder); ProductSpecificationAttribute productSpecificationAttribute = DBMapping(dbItem); if (SpecificationAttributeManager.CacheEnabled) { NopCache.RemoveByPattern(SPECIFICATIONATTRIBUTEOPTION_PATTERN_KEY); NopCache.RemoveByPattern(SPECIFICATIONATTRIBUTEOPTION_PATTERN_KEY); NopCache.RemoveByPattern(PRODUCTSPECIFICATIONATTRIBUTE_PATTERN_KEY); } return(productSpecificationAttribute); }
/// <summary> /// Maps a DBProductSpecificationAttribute to a ProductSpecificationAttribute /// </summary> /// <param name="dbItem">DBProductSpecificationAttribute</param> /// <returns>ProductSpecificationAttribute</returns> private static ProductSpecificationAttribute DBMapping(DBProductSpecificationAttribute dbItem) { if (dbItem == null) { return(null); } ProductSpecificationAttribute item = new ProductSpecificationAttribute(); item.ProductSpecificationAttributeID = dbItem.ProductSpecificationAttributeID; item.ProductID = dbItem.ProductID; item.SpecificationAttributeOptionID = dbItem.SpecificationAttributeOptionID; item.AllowFiltering = dbItem.AllowFiltering; item.ShowOnProductPage = dbItem.ShowOnProductPage; item.DisplayOrder = dbItem.DisplayOrder; return(item); }