USP_DATAFORMTEMPLATE_VIEW_EDITSTUDENTSCHEDULE_STUDENTCLASS

The load procedure used by the view dataform template "Edit Student Schedule, Student Class View"

Parameters

Parameter	Parameter Type	Mode	Description
@ID	nvarchar(73)	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.
@HASGRADES	bit	INOUT	HASGRADES

Definition

Copy



create procedure dbo.USP_DATAFORMTEMPLATE_VIEW_EDITSTUDENTSCHEDULE_STUDENTCLASS
(
    @ID nvarchar(73),
    @DATALOADED bit = 0 output,
    @HASGRADES bit = null output
)
as
    set nocount on;

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

    set @DATALOADED = 1;

    declare @CLASSID uniqueidentifier
    declare @STUDENTID uniqueidentifier

    select
        @CLASSID = cast(substring(@ID,1,36) as uniqueidentifier),
        @STUDENTID = cast(substring(@ID,38,36) as uniqueidentifier)

    select @HASGRADES = case when exists(
            select 1
            from dbo.STUDENTCOURSE
                inner join dbo.STUDENTCLASSMEETINGGROUP on STUDENTCOURSE.ID = STUDENTCLASSMEETINGGROUP.STUDENTCOURSEID
                inner join dbo.STUDENTMARKINGCOLUMNGRADE on STUDENTCLASSMEETINGGROUP.ID = STUDENTMARKINGCOLUMNGRADE.STUDENTCLASSMEETINGGROUPID
                inner join dbo.CLASSMEETINGGROUP on STUDENTCLASSMEETINGGROUP.CLASSMEETINGGROUPID = CLASSMEETINGGROUP.ID
            where STUDENTCOURSE.STUDENTID = @STUDENTID
                and CLASSMEETINGGROUP.CLASSID = @CLASSID
        ) then 1 else 0 end

    return 0;