USP_DATAFORMTEMPLATE_VIEW_STUDENTGRADE

The load procedure used by the view dataform template "Enter grade by student view"

Parameters

Parameter	Parameter Type	Mode	Description
@CURRENTAPPUSERID	uniqueidentifier	IN	Input parameter indicating the ID of the current user.
@DATALOADED	bit	INOUT	Output parameter indicating whether or not data was actually loaded.
@CURRENTSESSIONLABEL	nvarchar(300)	INOUT	CURRENTSESSIONLABEL
@SCHOOLID	uniqueidentifier	INOUT	SCHOOLID
@SESSIONID	uniqueidentifier	INOUT	SESSIONID
@STUDENTID	uniqueidentifier	INOUT	Student

Definition

Copy



CREATE procedure dbo.USP_DATAFORMTEMPLATE_VIEW_STUDENTGRADE
(
    @CURRENTAPPUSERID uniqueidentifier,
    @DATALOADED bit = 0 output,
    @CURRENTSESSIONLABEL nvarchar(300) = null output,
    @SCHOOLID uniqueidentifier = null output,
    @SESSIONID uniqueidentifier = null output,
    @STUDENTID uniqueidentifier = null output
)
as
    set nocount on;

    -- be sure to set this, in case the select returns no rows

    set @DATALOADED = 0;

    -- populate the output parameters, which correspond to fields on the form.  Note that

    -- we set @DATALOADED = 1 to indicate that the load was successful.  Otherwise, the system

    -- will display a "no data loaded" message.

    select @DATALOADED = 1

    select 
        @CURRENTSESSIONLABEL = case dbo.UFN_SCHOOL_ISSINGLESCHOOL() when 1 then '' else dbo.UFN_SCHOOL_GETNAME(ACADEMICYEAR.SCHOOLID) + ', ' end + ACADEMICYEARNAMECODE.DESCRIPTION + ', ' + SESSIONNAMECODE.DESCRIPTION, 
        @SCHOOLID = ACADEMICYEAR.SCHOOLID,
        @SESSIONID = SESSION.ID
    from dbo.GRADINGAPPUSERSESSION
    inner join dbo.SESSION on GRADINGAPPUSERSESSION.SESSIONID = SESSION.ID
    inner join dbo.SESSIONNAMECODE on SESSION.SESSIONNAMECODEID = SESSIONNAMECODE.ID
    inner join dbo.ACADEMICYEAR on SESSION.ACADEMICYEARID = ACADEMICYEAR.ID
    inner join dbo.ACADEMICYEARNAMECODE on ACADEMICYEAR.ACADEMICYEARNAMECODEID = ACADEMICYEARNAMECODE.ID
    where GRADINGAPPUSERSESSION.ID = @CURRENTAPPUSERID

    return 0;