IDiseaseReportManager

Queries

HasPendingReport #

Check whether a disease requires a follow-up report.

Signature:

Public Function HasPendingReport(ByVal reportTable As ListObject, ByVal diseaseName As String, Optional ByVal expectedValue As String = "yes") As Boolean

Parameters:

  • reportTable: ListObject hosting the import report entries.
  • diseaseName: String disease identifier to search for.
  • expectedValue: Optional String value indicating a pending report (defaults to ""yes"").

Returns: Boolean True when the disease row exists and matches the expected flag.


Commands

ClearReportStatus #

Remove all report rows related to the disease from every table on the worksheet.

Signature:

Public Sub ClearReportStatus(ByVal reportSheet As Worksheet, ByVal diseaseName As String)

Parameters:

  • reportSheet: Worksheet hosting import report tables.
  • diseaseName: String disease identifier to purge.