BillQueryProvider¶

Query provider exposing 26 data-access operation(s) (BillExists, GetBill, GetBillAmounts, GetBillIdsForClaim, GetBillServiceCode, GetBillServiceCodeStateless and 20 more) against 15 distinct table(s); see sql/index.md for the full ORM operation catalog.

Purpose¶

Provides read/write access to 15 table(s) via NHibernate IQueryable<T>/GetRepository<T>() calls documented in sql/index.md.
Exposes 26 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
BillExists	`bool BillExists(long billId)`	Executes an ORM query (SQL-024) against CBP_BILL.
GetBill	`CbpBill GetBill(long billId)`	Executes an ORM query (SQL-025) against CBP_BILL.
GetBillsForClaim	`IEnumerable<CbpBill> GetBillsForClaim(long claimId)`	Executes an ORM query (SQL-026) against CBP_BILL.
GetBillIdsForClaim	`IEnumerable<long> GetBillIdsForClaim(long claimId)`	Executes an ORM query (SQL-027) against CBP_BILL.
GetBillTypes	`IEnumerable<CbpBillTypeCode> GetBillTypes()`	Executes an ORM query (SQL-028) against CBP_BILL_TYPE_CODE.
GetBillStatusCode	`CbpBillStatusCode GetBillStatusCode(string status)`	Executes an ORM query (SQL-029) against CBP_BILL_STATUS_CODE.
GetBillStatusHistory	`IEnumerable<CbpBillStatus> GetBillStatusHistory(long billId)`	Executes an ORM query (SQL-030) against CBP_BILL_STATUS, CBP_BILL.
GetRegeneratedBillEntrySourceCode	`CbpBillEntrySourceCode GetRegeneratedBillEntrySourceCode()`	Executes an ORM query (SQL-031) against CBP_BILL_ENTRY_SOURCE_CODE.
GetBillAmounts	`decimal GetBillAmounts(long claimId, string paymentCategory, IList<string> billTypes)`	Executes an ORM query (SQL-032) against CBP_BILL.
GetStrippedCbpDiagnosis	`string GetStrippedCbpDiagnosis(string diagnosisInformation, string icdVersion)`	Executes an ORM query (SQL-034) against CBP_DIAGNOSIS.
GetCbpDiagnosis	`CbpDiagnosis GetCbpDiagnosis(string diagnosisInformation, string icdVersion)`	Executes an ORM query (SQL-035) against CBP_DIAGNOSIS.
GetCbpDiagnosisTypeCode	`CbpDiagnosisTypeCode GetCbpDiagnosisTypeCode(EbillHealthInformation diagnosis)`	Executes an ORM query (SQL-036) against CBP_DIAGNOSIS_TYPE_CODE.
GetEbillEntrySourceCode	`CbpBillEntrySourceCode GetEbillEntrySourceCode()`	Executes an ORM query (SQL-037) against CBP_BILL_ENTRY_SOURCE_CODE.
GetCbpBillTypeCode	`CbpBillTypeCode GetCbpBillTypeCode(string billtype)`	Executes an ORM query (SQL-038) against CBP_BILL_TYPE_CODE.
GetCbpServiceCodeNotExpired	`CbpServiceCode GetCbpServiceCodeNotExpired(string serviceCode)`	Executes an ORM query (SQL-039) against CBP_SERVICE_CODE.
GetCbpServiceCodeExpired	`CbpServiceCode GetCbpServiceCodeExpired(string serviceCode)`	Executes an ORM query (SQL-040) against CBP_SERVICE_CODE.
GetCbpServiceZCode	`CbpServiceCode GetCbpServiceZCode(string serviceCode)`	Executes an ORM query (SQL-041) against CBP_SERVICE_CODE, CBP_SERVICE_TYPE_CODE.
GetCbpServiceZDecDescription	`CbpServiceDescription GetCbpServiceZDecDescription(string serviceCode)`	Executes an ORM query (SQL-042) against CBP_SERVICE_DESCRIPTION, CBP_SERVICE_CODE, CBP_SERVICE_TYPE_CODE.
GetCbpServiceZDecDescriptionStateless	`CbpServiceDescriptionStateless GetCbpServiceZDecDescriptionStateless(string serviceCode)`	Executes an ORM query (SQL-043) against CBP_SERVICE_DESCRIPTION.
GetBillServiceTypeCode	`CbpServiceTypeCode GetBillServiceTypeCode(string serviceTypeCode)`	Executes an ORM query (SQL-044) against CBP_SERVICE_TYPE_CODE.
GetBillServiceCode	`CbpServiceCode GetBillServiceCode(string serviceCode, string serviceTypeCode)`	Executes an ORM query (SQL-045) against CBP_SERVICE_CODE, CBP_SERVICE_TYPE_CODE.
GetBillServiceCodeStateless	`CbpServiceCodeStateless GetBillServiceCodeStateless(string serviceCode, string serviceTypeCode)`	Executes an ORM query (SQL-046) against CBP_SERVICE_CODE.
GetNationalDrug	`CbpNationalDrug GetNationalDrug(string nationalDrugCode)`	Executes an ORM query (SQL-047) against CBP_NATIONAL_DRUG.
GetDispenseAsWritten	`PharmacyDispenseAsWrittenCode GetDispenseAsWritten(string dispenseAsWritten)`	Executes an ORM query (SQL-048) against CL_PHARMACY_DAW_CODE.
GetCbpProcedureCode	`CbpProcedureCode GetCbpProcedureCode(string code, string icdVersion)`	Executes an ORM query (SQL-049) against CBP_PROCEDURE_CODE.
GetIcdVersion	`IcdVersionCode GetIcdVersion(string icdVersion)`	Executes an ORM query (SQL-050) against `IcdVersionCode` (map file not compiled; table unknown**).
BillQueryProvider(IRepositoryFactory factory, IServiceCodeQueryProvider serviceCodeQueryProvider, IAuditNoteQueryProvider auditNoteQueryProvider, IProviderQueryProvider providerQueryProvider, IAuditQueryProvider auditQueryProvider)	`BillQueryProvider(IRepositoryFactory factory, IServiceCodeQueryProvider serviceCodeQueryProvider, IAuditNoteQueryProvider auditNoteQueryProvider, IProviderQueryProvider providerQueryProvider, IAuditQueryProvider auditQueryProvider)`	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/Claims/BillQueryProvider.cs