USP_DATAFORMTEMPLATE_ADD_ENROLLGROUPINCLASS_PRELOAD

The load procedure used by the edit dataform template "Enroll group in a class"

Parameters

Parameter	Parameter Type	Mode	Description
@CLASSID	uniqueidentifier	IN	Input parameter indicating the context ID for the record being added.
@HEADER	nvarchar(200)	INOUT
@STUDENTRECORDTYPEID	uniqueidentifier	INOUT
@SEATSAVAILABLE	int	INOUT	Seats available

Definition

Copy



CREATE procedure dbo.USP_DATAFORMTEMPLATE_ADD_ENROLLGROUPINCLASS_PRELOAD
(
    @CLASSID uniqueidentifier,
    @HEADER nvarchar(200) = null output,
    @STUDENTRECORDTYPEID uniqueidentifier = null output,
    @SEATSAVAILABLE int = null output
)
as
    set nocount on;

    select @HEADER = COURSE.[COURSEID] + ' - ' + CLASS.[SECTION]
    from dbo.CLASS
        inner join dbo.COURSE on dbo.CLASS.COURSEID = dbo.COURSE.ID
    where dbo.CLASS.ID = @CLASSID

    select @STUDENTRECORDTYPEID = ID from dbo.RECORDTYPE where upper(NAME) = 'STUDENT';

    declare @NUMENROLLED int = dbo.UFN_CLASS_GETNUMBERENROLLED(@CLASSID)
  select @SEATSAVAILABLE = 
        case when CLASS.CLASSSIZETARGET <= @NUMENROLLED
            then 0
            else CLASS.CLASSSIZETARGET - @NUMENROLLED
        end
    from dbo.CLASS
    where CLASS.ID = @CLASSID 
    group by CLASS.CLASSSIZETARGET

    return 0;