/// <summary> /// Gets a filtered product specification attribute mapping collection by category id /// </summary> /// <param name="categoryID">Product category identifier</param> /// <returns>Product specification attribute mapping collection</returns> public static SpecificationAttributeOptionFilterCollection GetSpecificationAttributeOptionFilter(int CategoryID) { DBSpecificationAttributeOptionFilterCollection dbCol = DBProviderManager <DBSpecificationAttributeProvider> .Provider.GetSpecificationAttributeOptionFilterByCategoryID(CategoryID); SpecificationAttributeOptionFilterCollection col = DBMapping(dbCol); return(col); }
/// <summary> /// Maps a DBSpecificationAttributeOptionFilterCollection to a SpecificationAttributeOptionFilterCollection /// </summary> /// <param name="dbCol">DBSpecificationAttributeOptionFilterCollection</param> /// <returns>SpecificationAttributeOptionFilterCollection</returns> private static SpecificationAttributeOptionFilterCollection DBMapping(DBSpecificationAttributeOptionFilterCollection dbCol) { if (dbCol == null) { return(null); } SpecificationAttributeOptionFilterCollection col = new SpecificationAttributeOptionFilterCollection(); foreach (DBSpecificationAttributeOptionFilter dbItem in dbCol) { SpecificationAttributeOptionFilter item = DBMapping(dbItem); col.Add(item); } return(col); }
/// <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; }