SQL-MVC-003: Retrieve single context value by session and name¶

Looks up a single context value by session ID and context name. Used by clsContext.GetPID, which is invoked from clsControllerBase.CheckContextViewID() to resolve the "page ID" (SAIFPID_NAME) context value for the current session.

Classification¶

Field	Value
SQL ID	SQL-MVC-003
Operation type	Read
Execution method	Inline SQL (`SqlCommand` + `SqlDataAdapter.Fill`)
Database	SQL Server (catalog `NETFRAMEWORK`)
Schema	`[unqualified]**`
Command type	Text
Business object	N/A (Application layer)
Criteria property	N/A (Application layer)
Lifecycle method	N/A (Application layer)
Application class	`clsContext.clsContextRepository.Retrieve(inSessionID, inContextValue)` — called from `clsContext.GetPID`

Parameters¶

Parameter	Direction	Type	Max length	Description
`@SessionID`	Input	`SqlDbType.VarChar`	50	Session identifier to match; bound from `inSessionID`.
`@ContextName`	Input	`SqlDbType.VarChar`	50	Context variable name to look up (the `SqlParameter` is named `@ContextName` while the calling method's argument is named `inContextValue` — a source-level naming inconsistency, not a functional issue); used by `clsContext.GetPID` to fetch a single named context value (e.g., `SAIFPID_NAME`).

Tables¶

Table	Access	Columns used
Context	SELECT	`ContextValue`

Sample SQL¶

-- Retrieve a single named context value for the given session (e.g., SAIFPID_NAME)
Select ContextValue
FROM Context
Where SessionID = @SessionID
  AND ContextName = @ContextName

Operations and processes¶

Page/control lifecycle initialization

Business rules¶

No business rule directly governs this statement — it is a simple existence check (If dt.Rows.Count = 1) with no error/contention handling; the caller returns "" when no row is found.

Note: Statements marked with ** could not be confirmed; treat as unknown until verified.

Sources¶

SAIF.Presentation.Web.MVC\clsContext.vb
SAIF.Presentation.Web.MVC\clsControllerBase.vb