EbillQueryProvider¶

Query provider exposing 24 data-access operation(s) (GetBill, GetBillAssignmentRule, GetBillByClearinghouseAndControlNumber, GetBillCountByClearinghouseControlNumber, GetBillSetTypeCode, GetBillSetTypeCodeByCode and 18 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 24 public query/command method(s) consumed by higher application layers; see database-tables.md for the underlying schema.

Context¶

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

Public members¶

Member	Signature	Purpose
GetBill	`Ebill GetBill(long billId)`	Executes an ORM query (SQL-114) against EBILL.
GetBillByClearinghouseAndControlNumber	`Ebill GetBillByClearinghouseAndControlNumber(string clearinghouseControlNumber, EbillClearinghouse clearinghouse)`	Executes an ORM query (SQL-115) against EBILL, EBILL_BATCH, EBILL_CLEARINGHOUSE.
GetBillCountByClearinghouseControlNumber	`int GetBillCountByClearinghouseControlNumber(string clearinghouseControlNumber)`	Executes an ORM query (SQL-116) against EBILL.
GetBillsForResponseFileForClearinghouse	`IEnumerable<Ebill> GetBillsForResponseFileForClearinghouse(EbillClearinghouse clearinghouse)`	Executes an ORM query (SQL-117) against EBILL, CBP_BILL, EBILL_BATCH, EBILL_CLEARINGHOUSE, CBP_BILL_STATUS_CODE.
GetBillsByBatch	`IEnumerable<Ebill> GetBillsByBatch(long batchId)`	Executes an ORM query (SQL-118) against EBILL, EBILL_BATCH.
GetBillsByEob	`IEnumerable<Ebill> GetBillsByEob(long eobId)`	Executes an ORM query (SQL-119) against EBILL, EBILL_EOB.
GetBillsByReceivedMonth	`IEnumerable<Ebill> GetBillsByReceivedMonth(DateTime startDate, DateTime endDate)`	Executes an ORM query (SQL-120) against EBILL, EBILL_BATCH.
GetEbillResponseSet	`EbillResponseSet GetEbillResponseSet(int responseSetSequenceNumber)`	Executes an ORM query (SQL-121) against EBILL_RESPONSE_SET.
GetEbillSum	`decimal GetEbillSum(IEnumerable<Ebill> groupBills)`	Retrieves ebill sum.*
GetNonIndexedBills	`IEnumerable<Ebill> GetNonIndexedBills(long batchId)`	Executes an ORM query (SQL-122) against EBILL, EBILL_PATIENT, EBILL_PROVIDER, EBILL_BATCH, EBILL_STATUS_CODE.
GetNonAssignedBills	`IEnumerable<Ebill> GetNonAssignedBills(long batchId)`	Executes an ORM query (SQL-123) against EBILL, EBILL_PATIENT, EBILL_PROVIDER, EBILL_BATCH, EBILL_STATUS_CODE.
GetNonImagedBills	`IEnumerable<Ebill> GetNonImagedBills(long batchId)`	Executes an ORM query (SQL-124) against EBILL, EBILL_BATCH, EBILL_STATUS_CODE.
GetIndexedBills	`IEnumerable<long> GetIndexedBills(long batchId)`	Executes an ORM query (SQL-125) against EBILL, EBILL_PATIENT, EBILL_PROVIDER, EBILL_BATCH, EBILL_STATUS_CODE.
GetImagedBills	`IEnumerable<long> GetImagedBills(long batchId)`	Executes an ORM query (SQL-126) against EBILL, EBILL_PATIENT, EBILL_PROVIDER, EBILL_BATCH, EBILL_STATUS_CODE.
GetEbill	`Ebill GetEbill(long batchId)`	Executes an ORM query (SQL-127) against EBILL.
GetBillStatusCode	`EbillStatusCode GetBillStatusCode(string billStatusCode)`	Executes an ORM query (SQL-128) against EBILL_STATUS_CODE.
GetBillStatusAccepted	`EbillStatusCode GetBillStatusAccepted()`	Retrieves bill status accepted.*
GetBillStatusAssigned	`EbillStatusCode GetBillStatusAssigned()`	Retrieves bill status assigned.*
GetBillStatusCompleted	`EbillStatusCode GetBillStatusCompleted()`	Retrieves bill status completed.*
GetBillStatusDocumentLoad	`EbillStatusCode GetBillStatusDocumentLoad()`	Retrieves bill status document load.*
GetBillStatuseEobDistributed	`EbillStatusCode GetBillStatuseEobDistributed()`	Retrieves bill statuse eob distributed.*
GetBillStatuseEobRejected	`EbillStatusCode GetBillStatuseEobRejected()`	Retrieves bill statuse eob rejected.*
GetBillStatusImaged	`EbillStatusCode GetBillStatusImaged()`	Retrieves bill status imaged.*
GetBillStatusIndexed	`EbillStatusCode GetBillStatusIndexed()`	Retrieves bill status indexed.*
GetBillStatusNew	`EbillStatusCode GetBillStatusNew()`	Retrieves bill status new.*
GetBillStatusPended	`EbillStatusCode GetBillStatusPended()`	Retrieves bill status pended.*
GetBillStatusRejected	`EbillStatusCode GetBillStatusRejected()`	Retrieves bill status rejected.*
GetBillStatusCbpSetup	`EbillStatusCode GetBillStatusCbpSetup()`	Retrieves bill status cbp setup.*
GetBillStatusExtracted	`EbillStatusCode GetBillStatusExtracted()`	Retrieves bill status extracted.*
GetPendedProviderErrors	`IEnumerable<EbillErrorCondition> GetPendedProviderErrors(long providerId)`	Executes an ORM query (SQL-129) against EBILL_ERROR_CONDITION, EBILL_PROVIDER.
GetPendedPatientErrors	`IEnumerable<EbillErrorCondition> GetPendedPatientErrors(long patientId)`	Executes an ORM query (SQL-130) against EBILL_ERROR_CONDITION, EBILL_PATIENT.
GetPendedBillErrors	`IEnumerable<EbillErrorCondition> GetPendedBillErrors(long billId)`	Executes an ORM query (SQL-131) against EBILL_ERROR_CONDITION, EBILL.
GetPendedErrors	`IEnumerable<EbillErrorCondition> GetPendedErrors(Ebill bill)`	Executes an ORM query (SQL-132) against EBILL_ERROR_CONDITION, EBILL_PROVIDER, EBILL_PATIENT, EBILL.
GetBillAssignmentRule	`EbillAssignmentRule GetBillAssignmentRule(string ruleCode)`	Executes an ORM query (SQL-133) against EBILL_ASSIGNMENT_RULE.
GetConfidentialBillAssignment	`EbillAssignmentRule GetConfidentialBillAssignment()`	Retrieves confidential bill assignment.*
GetProviderErrorBillAssignment	`EbillAssignmentRule GetProviderErrorBillAssignment()`	Retrieves provider error bill assignment.*
GetClaimErrorBillAssignment	`EbillAssignmentRule GetClaimErrorBillAssignment()`	Retrieves claim error bill assignment.*
GetCleanBillAssignment	`EbillAssignmentRule GetCleanBillAssignment()`	Retrieves clean bill assignment.*
GetBillSetTypeCode	`EbillSetTypeCode GetBillSetTypeCode(string manualVersionNumber)`	Executes an ORM query (SQL-134) against EBILL_SET_TYPE_CODE.
GetBillSetTypeCodeByCode	`EbillSetTypeCode GetBillSetTypeCodeByCode(string code)`	Executes an ORM query (SQL-135) against EBILL_SET_TYPE_CODE.
GetEdiPlaceOfServiceCode	`EdiPlaceOfServiceCode GetEdiPlaceOfServiceCode(string ubBillTypeCode)`	Executes an ORM query (SQL-136) against EDI_PLACE_OF_SERVICE_CODE.
SetCompoundDrugForAllServiceLinesForTheBill	`void SetCompoundDrugForAllServiceLinesForTheBill(Ebill bill)`	Executes an ORM query (SQL-137) against EBILL_SERVICE, EBILL.
EbillQueryProvider(IRepositoryFactory factory)	`EbillQueryProvider(IRepositoryFactory factory)`	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/Ebilling/EbillQueryProvider.cs