UFN_SCHEDULINGEXCEPTION_VALIDATEGENDER

Validates that the student gender matches that of the requested course in a single gender school.

Return

Return Type
bit

Parameters

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

Definition

Copy



CREATE function dbo.UFN_SCHEDULINGEXCEPTION_VALIDATEGENDER
(
    @STUDENTID uniqueidentifier,
    @COURSEID uniqueidentifier
)
returns bit
as 
begin
    declare @GENDERVALID bit = 1    
    declare @GENDERSCHOOL bit = 0

    if (select DIFFERENTGENDER from dbo.SCHEDULINGEXCEPTION) = 1
    begin

        if  (select COURSE.GENDERCODE 
                from dbo.COURSE 
                where COURSE.ID = @COURSEID) <> 0 and 
            ((select COURSE.GENDERCODE 
                from dbo.COURSE 
                where COURSE.ID = @COURSEID) <> 
             (select GENDERCODE 
                from dbo.CONSTITUENT 
                where CONSTITUENT.ID = @STUDENTID))
            set @GENDERVALID = 0
    end
    return @GENDERVALID
end