public OrganisationAttachment OrganisationAttachmentsSelectFile(DBGuid IDVal) { TraceCallEnterEvent.Raise(); try { OrganisationAttachment result = base.OrganisationAttachmentSelect(IDVal); if (!result.Path.IsNull) { FileDataContext fileDataContext = new FileDataContext(); string ext = Path.GetExtension(result.Path).ToLower(); string fileName = result.ID.ToString() + ext; result.DownloadData = fileDataContext.OrganisationAttachmentSelect(result.OrganisationRef, fileName); } TraceCallReturnEvent.Raise(); return result; } catch (Exception ex) { ExceptionManager.Publish(ex); TraceCallReturnEvent.Raise(false); throw; } }