Skip to content

PolicyQueryProvider

Query provider exposing 6 data-access operation(s) (GetBusiness, GetGroupAssociation, GetNonPolicyAccount, GetPayrollReportForReportId, GetPolicy, GetPolicyTeamFunction) against 7 distinct table(s); see sql/index.md for the full ORM operation catalog.

Purpose

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

Context

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

Public members

Member Signature Purpose
GetPolicy Policy GetPolicy(long policyNumber) Executes an ORM query (SQL-194) against POLICY.
GetNonPolicyAccount NonEmployerAccount GetNonPolicyAccount(long accountNumber) Executes an ORM query (SQL-195) against NON_EMPR_ACCT.
GetPolicyTeamFunction PolicyTeamFunction GetPolicyTeamFunction(long policyNumber, string teamFunctionCode) Executes an ORM query (SQL-196) against POLICY_TEAM_FUNCTION.
GetBusiness Business GetBusiness(long policyNumber) Executes an ORM query (SQL-197) against BUSINESS.
GetGroupAssociation PolicyPeriodGroupAssoc GetGroupAssociation(long policyNumber, DateTime effectiveDate) Executes an ORM query (SQL-198) against POLICY_PERIOD_GROUP_ASSOC, POLICY, Policy_Period.
GetPayrollReportForReportId PolicyPeriodPayrollAudit GetPayrollReportForReportId(long reportId) Executes an ORM query (SQL-199) against POLICY_PERIOD_PAYROLL_AUDIT.
PolicyQueryProvider(IRepositoryFactory factory, ILocationQueryProvider locationQueryProvider) PolicyQueryProvider(IRepositoryFactory factory, ILocationQueryProvider locationQueryProvider) 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/Policies/PolicyQueryProvider.cs