USP_CLIENTUSERS_UPDATELOGIN

Parameters

Parameter	Parameter Type	Mode
@CLIENTSID	int	IN
@USERNAME	nvarchar(50)	IN
@VALIDPASSWORD	bit	IN
@CLIENTUSERSID	int	INOUT
@LASTSUCCESS	datetime	INOUT
@NUMFAILS	int	INOUT
@MEMBERSHIPREFRESHEDON	datetime	INOUT

Definition

Copy



create procedure dbo.USP_CLIENTUSERS_UPDATELOGIN
(
    @CLIENTSID int,
    @USERNAME nvarchar(50),
    @VALIDPASSWORD bit,
    @CLIENTUSERSID int OUTPUT,
    @LASTSUCCESS datetime OUTPUT,
    @NUMFAILS int OUTPUT,    
    @MEMBERSHIPREFRESHEDON datetime OUTPUT
)
AS
begin
set nocount on;
SELECT top 1 @USERNAME = Username, @CLIENTUSERSID = ID,@LASTSUCCESS=DateLastLogin,@NUMFAILS=NumFailedAttempts, @MEMBERSHIPREFRESHEDON=MembershipRefreshedOn
FROM dbo.ClientUsers 
WHERE ([Username] = @USERNAME) AND (ClientsID = @CLIENTSID) And Deleted = 0
if (COALESCE(@CLIENTUSERSID,0)>0) 
  begin
    if @VALIDPASSWORD > 0
      begin
        UPDATE ClientUsers SET DateLastLogin=getutcdate(), NumFailedAttempts=0 WHERE ID=@ClientUsersID
      end
    else
      begin
        UPDATE ClientUsers SET NumFailedAttempts=COALESCE(@NumFails,0)+1 WHERE ID=@CLIENTUSERSID
        select @USERNAME=NULL,@CLIENTUSERSID=NULL,@LASTSUCCESS=NULL,@NUMFAILS=0,@MEMBERSHIPREFRESHEDON=NULL
      end
    end 
end