Skip to content

AuditQueryProvider

Query provider exposing 9 data-access operation(s) (GetAdjustmentType, GetAudit, GetAuditForBill, GetNationalDrugCode, GetNonDuplicateServiceCount, GetOriginalBills and 3 more) against 8 distinct table(s); see sql/index.md for the full ORM operation catalog.

Purpose

  • Provides read/write access to 8 table(s) via NHibernate IQueryable<T>/GetRepository<T>() calls documented in sql/index.md.
  • Exposes 9 public query/command method(s) consumed by higher application layers; see database-tables.md for the underlying schema.

Context

  • Namespace: SAIF.Data.Queries.Claims
  • Assembly/package: SAIF.Data

Public members

Member Signature Purpose
BillId long BillId { get; set; } Foreign-key identifier referencing the related bill record.*
OriginalBillId long? OriginalBillId { get; set; } Foreign-key identifier referencing the related original bill record.*
GetAudit CbpAudit GetAudit(long auditId) Executes an ORM query (SQL-013) against CBP_AUDIT, CBP_BILL.
GetAuditForBill CbpAudit GetAuditForBill(long billId) Executes an ORM query (SQL-014) against CBP_AUDIT, CBP_BILL.
GetNationalDrugCode CbpNationalDrug GetNationalDrugCode(string code) Executes an ORM query (SQL-015) against CBP_NATIONAL_DRUG.
IsNurseReviewRequired bool IsNurseReviewRequired(long billId) Executes an ORM query (SQL-016) against CBP_SERVICE_CODE.
GetNonDuplicateServiceCount int GetNonDuplicateServiceCount(long billId) Executes an ORM query (SQL-018) against CBP_AUDITED_SERVICE, CBP_AUDIT, CBP_BILL, CBP_ORIGINAL_BILL_CODE.
GetServices IEnumerable<CbpAuditedService> GetServices(long claimId, long billIdToExclude, DateTime fromDate, DateTime thruDate) Executes an ORM query (SQL-019) against CBP_AUDITED_SERVICE, CBP_AUDIT, CBP_BILL.
GetOriginalBills IEnumerable<long> GetOriginalBills(long billId) Executes an ORM query (SQL-020) against CBP_AUDITED_SERVICE, CBP_AUDIT, CBP_BILL.
GetPhysicalMedicineCount int GetPhysicalMedicineCount(long claimId) Executes an ORM query (SQL-021) against CBP_AUDITED_SERVICE, CBP_BILL.
GetAdjustmentType CbpAuditAdjustmentType GetAdjustmentType(string code) Executes an ORM query (SQL-023) against CBP_AUDIT_ADJUSTMENT_TYPE.
AuditQueryProvider(IRepositoryFactory factory, IProviderQueryProvider providerQueryProvider, IServiceCodeQueryProvider serviceCodeQueryProvider, IAuditNoteQueryProvider auditNoteQueryProvider, IClaimPaymentQueryProvider claimPaymentQueryProvider) AuditQueryProvider(IRepositoryFactory factory, IProviderQueryProvider providerQueryProvider, IServiceCodeQueryProvider serviceCodeQueryProvider, IAuditNoteQueryProvider auditNoteQueryProvider, IClaimPaymentQueryProvider claimPaymentQueryProvider) Initializes a new instance, wiring the repository factory used by this provider's query methods.*

Behavioral notes

  • Query methods build LINQ expressions over IQueryable<T> obtained via Factory.GetRepository<T>() and execute them against the underlying NHibernate session.*

Constraints and usage notes

  • Instances are constructed with an IRepositoryFactory and are expected to be resolved through dependency injection rather than instantiated directly.*

Note: Statements marked with * were inferred from code structure, naming conventions, or contextual evidence where direct confirmation was not available in source artifacts. Statements marked with ** could not be confirmed; treat as unknown until verified.

Sources

  • Data/SAIF.Data/Queries/AuditQueryProvider.cs