USP_DATAFORMTEMPLATE_VIEW_COURSEPROFILE

The load procedure used by the view dataform template "Course Profile 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.
@NAME	nvarchar(60)	INOUT	Name
@ISINACTIVE	bit	INOUT	ISINACTIVE
@HASCLASSWITHBLOCK	bit	INOUT	HASCLASSWITHBLOCK

Definition

Copy



CREATE procedure dbo.USP_DATAFORMTEMPLATE_VIEW_COURSEPROFILE 
(
    @ID uniqueidentifier,
    @DATALOADED bit = 0 output,
    @NAME nvarchar(60) = null output,
    @ISINACTIVE bit = null output,
    @HASCLASSWITHBLOCK bit = null output
)
as
set nocount on;

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

    set @DATALOADED = 0;

    declare @CURRENTDATE date = getdate()

    select @DATALOADED = 1,
        @NAME = dbo.COURSE.NAME,
        @ISINACTIVE = dbo.COURSE.ISINACTIVE,
        @HASCLASSWITHBLOCK =
            case when exists(
                    select 1
                    from dbo.CLASSMEETINGGROUP
                        inner join dbo.CLASS on CLASSMEETINGGROUP.CLASSID = CLASS.ID
                    where COURSEID = @ID and CLASSMEETINGGROUP.PATTERNBLOCKID is not null)
                then 1
                else 0
            end
    from dbo.COURSE
        left join dbo.SESSION on dbo.UFN_SESSION_GET_FORSCHOOL_BYDATE(COURSE.SCHOOLID, @CURRENTDATE, @CURRENTDATE) = SESSION.ID
        left join dbo.ACADEMICYEAR on SESSION.ACADEMICYEARID = ACADEMICYEAR.ID
    where dbo.COURSE.ID = @ID

return 0;