here is code for login, but am not sure if i got it right, also how do i fetch record using username after login with email
- ALTER PROCEDURE [dbo].[Validate_User]
- @Id int,
- @UserName NVARCHAR(200),
- @Email NVARCHAR(200),
- @Password NVARCHAR(20)
- AS
- BEGIN
- SET NOCOUNT ON;
- DECLARE @UserId INT, @LastLoginDate DATETIME
- SELECT @UserId = UserId, @LastLoginDate = LastLogin
- FROM User3 WHERE UserName = @Email AND [Password] = @PassWord
- IF @UserId IS NOT NULL
- BEGIN
- IF NOT EXISTS(SELECT UserId FROM UserActivation WHERE UserId = @UserId)
- BEGIN
- UPDATE User3
- SET LastLogin = GETDATE()
- WHERE UserId = @UserId
- SELECT @UserId [UserId] -- User Valid
- END
- ELSE
- BEGIN
- SELECT -2 -- User not activated.
- END
- END
- ELSE
- BEGIN
- SELECT -1 -- User invalid.
- END
- END
Manas MohapatraPosted Aug 12, 2016, 8:51 AM