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);
     }
 }