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