private static ProductPictureCollection DBMapping(DBProductPictureCollection dbCollection) { if (dbCollection == null) return null; ProductPictureCollection collection = new ProductPictureCollection(); foreach (DBProductPicture dbItem in dbCollection) { ProductPicture item = DBMapping(dbItem); collection.Add(item); } return collection; }
/// <summary> /// Gets all product picture mappings by product identifier /// </summary> /// <param name="ProductID">Product identifier</param> /// <returns>Product picture mapping collection</returns> public override DBProductPictureCollection GetProductPicturesByProductID(int ProductID) { DBProductPictureCollection productPictureCollection = new DBProductPictureCollection(); Database db = NopSqlDataHelper.CreateConnection(_sqlConnectionString); DbCommand dbCommand = db.GetStoredProcCommand("Nop_ProductPictureLoadAllByProductID"); db.AddInParameter(dbCommand, "ProductID", DbType.Int32, ProductID); using (IDataReader dataReader = db.ExecuteReader(dbCommand)) { while (dataReader.Read()) { DBProductPicture productPicture = GetProductPictureFromReader(dataReader); productPictureCollection.Add(productPicture); } } return productPictureCollection; }