UFN_SCHEDULINGEXCEPTION_VALIDATEALREADYTAKEN

Validates that the student has not already taken the requested course.

Return

Return Type
bit

Parameters

Parameter	Parameter Type	Mode	Description
@STUDENTID	uniqueidentifier	IN
@COURSEID	uniqueidentifier	IN

Definition

Copy



CREATE function dbo.UFN_SCHEDULINGEXCEPTION_VALIDATEALREADYTAKEN
(
    @STUDENTID uniqueidentifier,
    @COURSEID uniqueidentifier
)
returns bit
as 
begin
    declare @ALREADYTAKENVALID bit = 1    

    if (select ALREADYTAKEN from dbo.SCHEDULINGEXCEPTION) = 1
    begin
        if exists(select STUDENTCLASSMEETINGGROUP.ID 
                from dbo.STUDENTCLASSMEETINGGROUP
                inner join dbo.STUDENTCOURSE 
                    on STUDENTCLASSMEETINGGROUP.STUDENTCOURSEID = STUDENTCOURSE.ID
                where STUDENTID = @STUDENTID and COURSEID = @COURSEID
                    and STUDENTCLASSMEETINGGROUP.STATUSCODE = 0) --only validate against enrolled

            set @ALREADYTAKENVALID = 0
    end
    return @ALREADYTAKENVALID
end