USP_STUDENT_CLASS_DROP_PROMPT

Provides the prompt for the "Student Class Drop" record operation.

Parameters

Parameter	Parameter Type	Mode	Description
@ID	nvarchar(73)	IN	Represents information to be displayed in the record operation prompt.
@PROMPTRESOURCEKEY	nvarchar(100)	INOUT
@PROMPT	nvarchar(100)	INOUT

Definition

Copy



                    create procedure dbo.USP_STUDENT_CLASS_DROP_PROMPT
                    (
                        @ID nvarchar(73),
                        @PROMPTRESOURCEKEY nvarchar(100) output,
                        @PROMPT nvarchar(100) = null output                        
                    )
                    as
                    set nocount on;

                    declare @CLASSID uniqueidentifier
                    declare @STUDENTID uniqueidentifier

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

                    if 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
                                and STUDENTMARKINGCOLUMNGRADE.GRADEISBLANK = 0
                        )
                        set @PROMPTRESOURCEKEY = 'REMOVESTUDENT_WITHGRADES'
                    else
                        set @PROMPTRESOURCEKEY = '$$are_you_sure_you_want_to_remove_this_student_from_the_class?'

                    return 0;