UFN_SCHEDULINGEXCEPTION_VALIDATEALREADYREQUESTED

Validates that the student has not already requested the course within the given session.

Return

Return Type
bit

Parameters

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

Definition

Copy



CREATE function dbo.UFN_SCHEDULINGEXCEPTION_VALIDATEALREADYREQUESTED
(
    @STUDENTID uniqueidentifier,
    @COURSEID uniqueidentifier,
    @SESSIONID uniqueidentifier
)
returns bit
as 
begin
    declare @ALREADYREQUESTEDVALID bit = 1    

    if (select ALREADYREQUESTED from dbo.SCHEDULINGEXCEPTION) = 1
    begin
        declare @STARTDATE date
        declare @ENDDATE date
        select @STARTDATE = STARTDATE, @ENDDATE = ENDDATE from dbo.UFN_SESSION_GETDATES(@SESSIONID)

        if exists(select STUDENTCOURSE.ID 
                from dbo.STUDENTCOURSE 
                inner join dbo.STUDENTCOURSEREQUEST 
                    on STUDENTCOURSEREQUEST.ID = STUDENTCOURSE.ID
                where STUDENTID = @STUDENTID and COURSEID = @COURSEID
                    and ENDDATE = @ENDDATE and STARTDATE = @STARTDATE) 
            set @ALREADYREQUESTEDVALID = 0
    end
    return @ALREADYREQUESTEDVALID
end