LegalQueryProvider¶

Query provider exposing 15 data-access operation(s) (GetActiveLegalCases, GetAdpEmployeeName, GetAppealAssignedAttorney, GetAttorneyProfile, GetCaseCost, GetClaimIdForCase and 9 more) against 13 distinct table(s); see sql/index.md for the full ORM operation catalog.

Purpose¶

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

Context¶

Namespace: SAIF.Data.Queries.Legal
Assembly/package: SAIF.Data

Public members¶

Member	Signature	Purpose
GetLegalCase	`LegalCase GetLegalCase(long id)`	Executes an ORM query (SQL-152) against LEGAL_CASE.
GetLegalCases	`IEnumerable<LegalCase> GetLegalCases(long claimId)`	Executes an ORM query (SQL-153) against LEGAL_CASE.
GetClaimIdForCase	`long GetClaimIdForCase(string claimNumOrCaseNumber)`	Executes an ORM query (SQL-154) against LEGAL_CASE.
GetCaseCost	`IEnumerable<CaseCost> GetCaseCost(long caseId)`	Executes an ORM query (SQL-155) against CASE_COST, LEGAL_CASE.
GetLegalBills	`IEnumerable<LegalBill> GetLegalBills(long caseId)`	Executes an ORM query (SQL-156) against LEGAL_BILL, LEGAL_CASE.
GetSubpoenas	`IEnumerable<Subpoena> GetSubpoenas(long caseId)`	Executes an ORM query (SQL-157) against SUBPOENA, LEGAL_CASE.
GetAppealAssignedAttorney	`String GetAppealAssignedAttorney(long caseId)`	Executes an ORM query (SQL-158) against APPEAL, LEGAL_CASE.
GetAdpEmployeeName	`String GetAdpEmployeeName(string emplId)`	Executes an ORM query (SQL-159) against `Employee` (SAIF.Framework mapping; table unknown**).
GetActiveLegalCases	`IEnumerable<LegalCase> GetActiveLegalCases(long claimId)`	Executes an ORM query (SQL-160) against LEGAL_CASE, CASE_STATUS_CODE.
GetAttorneyProfile	`AttorneyProfile GetAttorneyProfile(string attorneyEmployeeId)`	Executes an ORM query (SQL-161) against ATTORNEY_PROFILE.
GetOtherFirm	`OtherFirm GetOtherFirm(long id)`	Executes an ORM query (SQL-162) against OTHER_FIRM.
GetLegalPerson	`LegalPerson GetLegalPerson(long id)`	Executes an ORM query (SQL-163) against LEGAL_PERSON.
GetLegalPersonAddress	`LegalPersonAddress GetLegalPersonAddress(long id, string addressTypeCode)`	Executes an ORM query (SQL-164) against LEGAL_PERSON_ADDRESS, LEGAL_PERSON, ADDRESS_TYPE_CODE.
IsPrimaryCase	`bool IsPrimaryCase(long caseId)`	Executes an ORM query (SQL-165) against CONSOLIDATED_CASE, LEGAL_CASE.
IsImageAlertNeeded	`bool IsImageAlertNeeded(long claimId)`	Executes an ORM query (SQL-166) against LEGAL_CASE.
GetFinancialTransaction	`FinancialTransaction GetFinancialTransaction(long claimId, string invoiceNumber)`	Retrieves financial transaction.*
GetLegalBillFinancialTransaction	`FinancialTransaction GetLegalBillFinancialTransaction(long billId, long claimId)`	Retrieves legal bill financial transaction.*
GetSubpoenaFinancialTransaction	`FinancialTransaction GetSubpoenaFinancialTransaction(long subpoenaId, long recipientId, long claimId)`	Retrieves subpoena financial transaction.*
LegalQueryProvider(IRepositoryFactory factory, ICCClaimApiService ccclaimApiService, IClaimDataApiClient gwclaimDataApiClient)	`LegalQueryProvider(IRepositoryFactory factory, ICCClaimApiService ccclaimApiService, IClaimDataApiClient gwclaimDataApiClient)`	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/Legal/LegalQueryProvider.cs