fnUserIDByNameAndEmail

Return

Return Type
int

Parameters

Parameter	Parameter Type	Mode
@ClientsID	int	IN
@FirstName	nvarchar(50)	IN
@LastName	nvarchar(50)	IN
@Email	nchar	IN

Definition

Copy



            create function [dbo].[fnUserIDByNameAndEmail]
            (
                @ClientsID int,
                @FirstName nvarchar(50),
                @LastName nvarchar(50),
                @Email nchar(100)
            )
            RETURNS int
            AS
                BEGIN
                    declare @UserID int

                    SELECT @UserID = ID FROM dbo.ClientUsers 
                    WHERE ClientsID=@ClientsID 
                        and FirstName=@FirstName
                        and LastName=@LastName
                        and Email=@Email
                        and deleted=0

                    if @@ROWCOUNT = 0 
                        SELECT @UserID = 0

                    RETURN @UserID
                END