public UserAttachment UserAttachmentSelectFile(DBGuid IDVal) { TraceCallEnterEvent.Raise(); try { UserAttachment result = base.UserAttachmentSelect(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.UserAttachmentSelect(result.LoginNameRef, fileName); } TraceCallReturnEvent.Raise(); return result; } catch (Exception ex) { ExceptionManager.Publish(ex); TraceCallReturnEvent.Raise(false); throw; } }