USP_DATAFORMTEMPLATE_ADD_STUDENT_CLASS_PRELOAD

The load procedure used by the edit dataform template "Student Class Add Form"

Parameters

Parameter	Parameter Type	Mode	Description
@CLASSID	uniqueidentifier	IN	Input parameter indicating the context ID for the record being added.
@SESSIONID	uniqueidentifier	INOUT
@SCHOOLID	uniqueidentifier	INOUT

Definition

Copy



CREATE procedure dbo.USP_DATAFORMTEMPLATE_ADD_STUDENT_CLASS_PRELOAD
(
    @CLASSID uniqueidentifier,
    @SESSIONID uniqueidentifier = null output,
    @SCHOOLID uniqueidentifier = null output
)
as
    set nocount on;

    select
        @SCHOOLID = dbo.COURSE.SCHOOLID,
        @SESSIONID = dbo.UFN_SESSION_GET_FORSCHOOL_BYDATE(COURSE.SCHOOLID, CLASS.STARTDATE, CLASS.ENDDATE)
    from dbo.CLASS
        inner join dbo.COURSE on CLASS.COURSEID = COURSE.ID
    where dbo.CLASS.ID = @CLASSID

    return 0;