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