public IEnumerable <Overtech.DataModels.Warehouse.GatheringPalletPhoto> ListPalletPhoto(long storeOrderId, long?gatheringPalletId) { using (IDAL dal = this.DAL) { List <Overtech.DataModels.Warehouse.GatheringPalletPhoto> palletPhotos = this.listPalletPhotoByStoreId(dal, storeOrderId, gatheringPalletId); var documentOp = new DocumentOperations(dal, _resolver); for (int i = 0; i < palletPhotos.Count; i++) { IUniParameter prmDocumentId = dal.CreateParameter("DocumentId", palletPhotos[i].Photo); var tmpDocument = dal.Read <Overtech.DataModels.Document.Document>("DOC_SEL_DOCUMENT_SP", prmDocumentId); palletPhotos[i].PhotoContent = System.Text.Encoding.ASCII.GetString(documentOp.GetDocumentBody(tmpDocument)); } return(palletPhotos); } }