Skip to content

AuditNoteQueryProvider

Query provider exposing 9 data-access operation(s) (GetAllAuditNotes, GetAuditNote, GetAuditNotesForBill, GetAuditNotesForClaim, GetNoteCategories, GetNoteTypeCode and 3 more) against 4 distinct table(s); see sql/index.md for the full ORM operation catalog.

Purpose

  • Provides read/write access to 4 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
GetAuditNote CbpNote GetAuditNote(long noteId) Executes an ORM query (SQL-004) against CBP_NOTE.
GetAuditNotesForClaim IEnumerable<CbpNote> GetAuditNotesForClaim(long claimId, bool includeInactive = false) Executes an ORM query (SQL-005) against CBP_NOTE.
GetAuditNotesForBill IEnumerable<CbpNote> GetAuditNotesForBill(long billId, bool includeInactive = false) Executes an ORM query (SQL-006) against CBP_NOTE, CBP_BILL.
GetAllAuditNotes IEnumerable<CbpNote> GetAllAuditNotes(long billId, long claimId, bool includeInactive = false) Executes an ORM query (SQL-007) against CBP_NOTE, CBP_BILL.
GetNoteTypeCode CbpNoteTypeCode GetNoteTypeCode(string typeCode, string categoryCode) Executes an ORM query (SQL-008) against CBP_NOTE_TYPE_CODE, CBP_NOTE_CATEGORY_CODE.
GetNoteCategories IEnumerable<CbpNoteCategoryCode> GetNoteCategories() Executes an ORM query (SQL-009) against CBP_NOTE_CATEGORY_CODE.
GetNoteTypes IEnumerable<CbpNoteTypeCode> GetNoteTypes() Executes an ORM query (SQL-010) against CBP_NOTE_TYPE_CODE.
GetNoteTypesForCategory IEnumerable<CbpNoteTypeCode> GetNoteTypesForCategory(string category) Executes an ORM query (SQL-011) against CBP_NOTE_TYPE_CODE, CBP_NOTE_CATEGORY_CODE.
IsAuditNoteNoContention bool IsAuditNoteNoContention(long noteId, int updateNumber) Executes an ORM query (SQL-012) against CBP_NOTE.
AuditNoteQueryProvider(IRepositoryFactory factory) AuditNoteQueryProvider(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/AuditNoteQueryProvider.cs