/// <summary> /// Maps a data reader to a specification attribute option filter /// </summary> /// <param name="dataReader">IDataReader</param> /// <returns>Specification attribute option filter</returns> private DBSpecificationAttributeOptionFilter GetSpecificationAttributeOptionFilterFromReader(IDataReader dataReader) { var item = new DBSpecificationAttributeOptionFilter(); item.SpecificationAttributeId = NopSqlDataHelper.GetInt(dataReader, "SpecificationAttributeID"); item.SpecificationAttributeName = NopSqlDataHelper.GetString(dataReader, "SpecificationAttributeName"); item.DisplayOrder = NopSqlDataHelper.GetInt(dataReader, "DisplayOrder"); item.SpecificationAttributeOptionId = NopSqlDataHelper.GetInt(dataReader, "SpecificationAttributeOptionID"); item.SpecificationAttributeOptionName = NopSqlDataHelper.GetString(dataReader, "SpecificationAttributeOptionName"); return(item); }
/// <summary> /// Gets a specification attribute option filter mapping collection by category id /// </summary> /// <param name="CategoryID">Product category identifier</param> /// <returns>Specification attribute option filter mapping collection</returns> public override DBSpecificationAttributeOptionFilterCollection GetSpecificationAttributeOptionFilterByCategoryID(int CategoryID) { DBSpecificationAttributeOptionFilterCollection col = new DBSpecificationAttributeOptionFilterCollection(); Database db = NopSqlDataHelper.CreateConnection(_sqlConnectionString); DbCommand dbCommand = db.GetStoredProcCommand("Nop_SpecificationAttributeOptionFilter_LoadByFilter"); db.AddInParameter(dbCommand, "CategoryID", DbType.Int32, CategoryID); using (IDataReader dataReader = db.ExecuteReader(dbCommand)) { while (dataReader.Read()) { DBSpecificationAttributeOptionFilter item = GetSpecificationAttributeOptionFilterFromReader(dataReader); col.Add(item); } } return(col); }