SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

CREATE FUNCTION RegistrationHandler 
(
	@sysid varchar(50),
	@content_name varchar(50),
	@mobile_number varchar(20),
	@regval char(1)

)
RETURNS varchar(160)
AS
BEGIN
	DECLARE @rtval varchar(160)

	IF EXISTS(Select * from IsMobileRegistered(@content_name,@sysid,@mobile_number))
	   IF @regval = 'Y' --Already registered
		BEGIN
			SET @rtval=(Select * from GetErrorMessage('REGALREADY'))
		END
	ELSE
		IF @regval = 'N' -- Not registered
		BEGIN
				@rtval='Not Registered'
		END
	    ELSE
		--New user
	   IF @regval = 'Y' --register new user
	     BEGIN
				@rtval='New user registered'
	     END
	   ELSE
		   IF @regval = 'N'
		   BEGIN
			
				@rtval='New user not registered so cannot cancel'
		   END

    -- Return the result of the function
	RETURN @rtval

END
GO