USP_SIMPLEDATALIST_CLASS

Class List

Parameters

Parameter	Parameter Type	Mode	Description
@CURRENTAPPUSERID	uniqueidentifier	IN	Input parameter indicating the ID of the current user.
@COURSEID	uniqueidentifier	IN
@CHECKCOURSEGRADING	bit	IN
@CHECKCOURSERESTRICTION	bit	IN

Definition

Copy



                CREATE procedure dbo.USP_SIMPLEDATALIST_CLASS
                (
                    @CURRENTAPPUSERID uniqueidentifier,
                    @COURSEID uniqueidentifier = null,
                    @CHECKCOURSEGRADING bit = 0,
                    @CHECKCOURSERESTRICTION bit = 0
                )
                as
                    set nocount on;

                    select
                        CLASS.ID as VALUE,
                        COURSE.COURSEID + ' - ' + CLASS.[SECTION] as LABEL
                    from dbo.CLASS
                        inner join dbo.COURSE on dbo.CLASS.COURSEID = dbo.COURSE.ID
                        left join dbo.GRADINGAPPUSERSESSION on GRADINGAPPUSERSESSION.SESSIONID = dbo.UFN_SESSION_GET_FORSCHOOL_BYDATE(COURSE.SCHOOLID, CLASS.STARTDATE, CLASS.ENDDATE)
                        left join dbo.APPUSERSESSION on APPUSERSESSION.SESSIONID = dbo.UFN_SESSION_GET_FORSCHOOL_BYDATE(COURSE.SCHOOLID, CLASS.STARTDATE, CLASS.ENDDATE)
                    where CLASS.[COURSEID] = @COURSEID
                        and (@CHECKCOURSEGRADING = 0 or GRADINGAPPUSERSESSION.ID = @CURRENTAPPUSERID)
                        and (@CHECKCOURSERESTRICTION = 0 or APPUSERSESSION.ID = @CURRENTAPPUSERID)
                    order by LABEL asc