/// <summary> /// Gets all product attributes /// </summary> /// <returns>Product attribute collection</returns> public override DBProductAttributeCollection GetAllProductAttributes() { DBProductAttributeCollection productAttributes = new DBProductAttributeCollection(); Database db = NopSqlDataHelper.CreateConnection(_sqlConnectionString); DbCommand dbCommand = db.GetStoredProcCommand("Nop_ProductAttributeLoadAll"); using (IDataReader dataReader = db.ExecuteReader(dbCommand)) { while (dataReader.Read()) { DBProductAttribute productAttribute = GetProductAttributeFromReader(dataReader); productAttributes.Add(productAttribute); } } return(productAttributes); }
private static ProductAttributeCollection DBMapping(DBProductAttributeCollection dbCollection) { if (dbCollection == null) { return(null); } ProductAttributeCollection collection = new ProductAttributeCollection(); foreach (DBProductAttribute dbItem in dbCollection) { ProductAttribute item = DBMapping(dbItem); collection.Add(item); } return(collection); }
/// <summary> /// Gets all product attributes /// </summary> /// <param name="languageId">Language identifier</param> /// <returns>Product attribute collection</returns> public override DBProductAttributeCollection GetAllProductAttributes(int languageId) { var result = new DBProductAttributeCollection(); Database db = NopSqlDataHelper.CreateConnection(_sqlConnectionString); DbCommand dbCommand = db.GetStoredProcCommand("Nop_ProductAttributeLoadAll"); db.AddInParameter(dbCommand, "LanguageID", DbType.Int32, languageId); using (IDataReader dataReader = db.ExecuteReader(dbCommand)) { while (dataReader.Read()) { var item = GetProductAttributeFromReader(dataReader); result.Add(item); } } return(result); }
/// <summary> /// Gets all product attributes /// </summary> /// <returns>Product attribute collection</returns> public static ProductAttributeCollection GetAllProductAttributes() { string key = PRODUCTATTRIBUTES_ALL_KEY; object obj2 = NopCache.Get(key); if (ProductAttributeManager.CacheEnabled && (obj2 != null)) { return((ProductAttributeCollection)obj2); } DBProductAttributeCollection dbCollection = DBProviderManager <DBProductAttributeProvider> .Provider.GetAllProductAttributes(); ProductAttributeCollection productAttributes = DBMapping(dbCollection); if (ProductAttributeManager.CacheEnabled) { NopCache.Max(key, productAttributes); } return(productAttributes); }
/// <summary> /// Gets all product attributes /// </summary> /// <returns>Product attribute collection</returns> public override DBProductAttributeCollection GetAllProductAttributes() { DBProductAttributeCollection productAttributes = new DBProductAttributeCollection(); Database db = NopSqlDataHelper.CreateConnection(_sqlConnectionString); DbCommand dbCommand = db.GetStoredProcCommand("Nop_ProductAttributeLoadAll"); using (IDataReader dataReader = db.ExecuteReader(dbCommand)) { while (dataReader.Read()) { DBProductAttribute productAttribute = GetProductAttributeFromReader(dataReader); productAttributes.Add(productAttribute); } } return productAttributes; }