fnValidateSupervisor

Return

Return Type
int

Parameters

Parameter	Parameter Type	Mode
@ClientsID	int	IN
@UserName	nvarchar(255)	IN
@Password	nvarchar(255)	IN

Definition

Copy



            create function dbo.fnValidateSupervisor(@ClientsID int, @UserName nvarchar(255), @Password nvarchar(255))
            returns int
            begin
                if exists (select 1 from dbo.ClientUsers where ClientsID = @ClientsID and UserName = @UserName and Password = @Password and (IsSupervisor = 1 or InternalUser = 1))
                    return 1;
                return -1;
            end