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