public JobFindAttachment JobFindAttachmentSelectFile(DBGuid IDVal) { TraceCallEnterEvent.Raise(); try { JobFindAttachment result = base.JobFindAttachmentSelect(IDVal); if (result != null && !result.Path.IsNull) { FileDataContext fileDataContext = new FileDataContext(); string ext = Path.GetExtension(result.Path).ToLower(); string fileName = result.ID.ToString() + ext; result.FileData = fileDataContext.JobFindAttachmentSelect(result.JobFindRef, fileName); } TraceCallReturnEvent.Raise(); return result; } catch (Exception ex) { ExceptionManager.Publish(ex); TraceCallReturnEvent.Raise(false); throw; } }