/// <summary> /// Gets all product variant attribute combinations /// </summary> /// <param name="productVariantId">Product variant identifier</param> /// <returns>Product variant attribute combination collection</returns> public override DBProductVariantAttributeCombinationCollection GetAllProductVariantAttributeCombinations(int productVariantId) { var result = new DBProductVariantAttributeCombinationCollection(); Database db = NopSqlDataHelper.CreateConnection(_sqlConnectionString); DbCommand dbCommand = db.GetStoredProcCommand("Nop_ProductVariantAttributeCombinationLoadAll"); db.AddInParameter(dbCommand, "ProductVariantID", DbType.Int32, productVariantId); using (IDataReader dataReader = db.ExecuteReader(dbCommand)) { while (dataReader.Read()) { var item = GetProductVariantAttributeCombinationFromReader(dataReader); result.Add(item); } } return(result); }
private static ProductVariantAttributeCombinationCollection DBMapping(DBProductVariantAttributeCombinationCollection dbCollection) { if (dbCollection == null) { return(null); } var collection = new ProductVariantAttributeCombinationCollection(); foreach (var dbItem in dbCollection) { var item = DBMapping(dbItem); collection.Add(item); } return(collection); }