GO
/****** Object: StoredProcedure [dbo].[spEX_LoginUser]
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER PROCEDURE [dbo].[spEX_LoginUser]
(
@loginname varchar(50),
@password varchar(50)
)
AS
BEGIN
IF EXISTS(SELECT LoginName, [Password] FROM EX_Candidate WHERE LoginName=@loginname AND [Password]=@password AND Appeared=0)
BEGIN
SELECT 1 AS Status,@loginname as LoginName,'Login Successful' AS ReturnMessage
END
else
BEGIN
SELECT 0 AS Status,@loginname as LoginName,'User doesnot exists' as ReturnMessage
END
END