USP_DATAFORMTEMPLATE_VIEW_STUDENT_SUMMARY

The load procedure used by the view dataform template "Student Summary View Form"

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	IN	The input ID parameter used to load the fields defined on the form.
@DATALOADED	bit	INOUT	Output parameter indicating whether or not data was actually loaded.
@PREVIOUSCLASS_TIME	nvarchar(100)	INOUT	PREVIOUSCLASS_TIME
@PREVIOUSCLASS_CLASSID	nvarchar(1000)	INOUT	Previous class
@PREVIOUSCLASS_FACULTY	nvarchar(1000)	INOUT	PREVIOUSCLASS_FACULTY
@CURRENTCLASS_TIME	nvarchar(100)	INOUT	CURRENTCLASS_TIME
@CURRENTCLASS_CLASSID	nvarchar(1000)	INOUT	Current class
@CURRENTCLASS_FACULTY	nvarchar(1000)	INOUT	CURRENTCLASS_FACULTY
@NEXTCLASS_TIME	nvarchar(100)	INOUT	NEXTCLASS_TIME
@NEXTCLASS_CLASSID	nvarchar(1000)	INOUT	Next class
@NEXTCLASS_FACULTY	nvarchar(1000)	INOUT	NEXTCLASS_FACULTY

Definition

Copy



CREATE procedure dbo.USP_DATAFORMTEMPLATE_VIEW_STUDENT_SUMMARY
(
    @ID uniqueidentifier,
    @DATALOADED bit = 0 output,

    @PREVIOUSCLASS_TIME nvarchar(100) = null output,
    @PREVIOUSCLASS_CLASSID nvarchar(1000) = null output,
    @PREVIOUSCLASS_FACULTY nvarchar(1000) = null output,

    @CURRENTCLASS_TIME nvarchar(100) = null output,
    @CURRENTCLASS_CLASSID nvarchar(1000) = null output,
    @CURRENTCLASS_FACULTY nvarchar(1000) = null output,

    @NEXTCLASS_TIME nvarchar(100) = null output,
    @NEXTCLASS_CLASSID nvarchar(1000) = null output,
    @NEXTCLASS_FACULTY nvarchar(1000) = null output
)
as
    set nocount on;

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

    set @DATALOADED = 1;

    declare @PREVIOUS_CLASSMEETINGID uniqueidentifier
    declare @CURRENT_CLASSMEETINGID uniqueidentifier
    declare @NEXT_CLASSMEETINGID uniqueidentifier

    select @PREVIOUS_CLASSMEETINGID = [PREVIOUS_CLASSMEETINGID],
           @CURRENT_CLASSMEETINGID = [CURRENT_CLASSMEETINGID],
           @NEXT_CLASSMEETINGID = [NEXT_CLASSMEETINGID]
    from dbo.UFN_STUDENT_GETCLASSMEETINGSTATUS(@ID, null)

    select @PREVIOUSCLASS_TIME = [TIME],
           @PREVIOUSCLASS_CLASSID = [CLASSID],
           @PREVIOUSCLASS_FACULTY = [FACULTY]
    from dbo.UFN_CLASSMEETING_GETSUMMARY(@PREVIOUS_CLASSMEETINGID)

    select @CURRENTCLASS_TIME = [TIME],
           @CURRENTCLASS_CLASSID = [CLASSID],
           @CURRENTCLASS_FACULTY = [FACULTY]
    from dbo.UFN_CLASSMEETING_GETSUMMARY(@CURRENT_CLASSMEETINGID)

    select @NEXTCLASS_TIME = [TIME],
           @NEXTCLASS_CLASSID = [CLASSID],
           @NEXTCLASS_FACULTY = [FACULTY]
    from dbo.UFN_CLASSMEETING_GETSUMMARY(@NEXT_CLASSMEETINGID)

    return 0;