public ProgramAttachment ProgramAttachmentSelectFile(DBGuid IDVal)
        {
            TraceCallEnterEvent.Raise();
              try
              {
            ProgramAttachment result = base.ProgramAttachmentSelect(IDVal);
            FileDataContext fileDataContext = new FileDataContext();

            string fileName = result.ID.Value.ToString() + Path.GetExtension(result.Path);
            result.FileData = fileDataContext.ProgramAttachmentSelect(result.ProgramRef, fileName);

            TraceCallReturnEvent.Raise();
            return result;
              }
              catch (Exception ex)
              {
            ExceptionManager.Publish(ex);
            TraceCallReturnEvent.Raise(false);
            throw;
              }
        }