/// <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); }
/// <summary> /// Gets all specification attribute option filter mapping collection by category id /// </summary> /// <param name="categoryId">Product category identifier</param> /// <param name="languageId">Language identifier</param> /// <returns>Specification attribute option filter mapping collection</returns> public override DBSpecificationAttributeOptionFilterCollection GetSpecificationAttributeOptionFilterByCategoryId(int categoryId, int languageId) { var result = new DBSpecificationAttributeOptionFilterCollection(); Database db = NopSqlDataHelper.CreateConnection(_sqlConnectionString); DbCommand dbCommand = db.GetStoredProcCommand("Nop_SpecificationAttributeOptionFilter_LoadByFilter"); db.AddInParameter(dbCommand, "CategoryID", DbType.Int32, categoryId); db.AddInParameter(dbCommand, "LanguageID", DbType.Int32, languageId); using (IDataReader dataReader = db.ExecuteReader(dbCommand)) { while (dataReader.Read()) { var item = GetSpecificationAttributeOptionFilterFromReader(dataReader); result.Add(item); } } return(result); }
/// <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; }