USP_DATALIST_CLIENTUSERCURRENTORPREVIOUSEVENT

CREATE procedure dbo.USP_DATALIST_CLIENTUSERCURRENTORPREVIOUSEVENT
(
   @EVENTID uniqueidentifier,
   @USERNAME nvarchar(50),
   @CLIENTSID int,
   @CLIENTUSERID int = 0,
   @ISUSERNAME bit = 1
)
as
    set nocount on;
  begin
      -- current event user

     if exists(select top 1 CU.ID from dbo.CLIENTUSERS CU INNER JOIN dbo.REGISTRANT R ON R.CONSTITUENTID = dbo.UFN_CONSTITUENT_GET_BY_CLIENTUSERID(CU.ID) where R.EVENTID = @EVENTID and ((@ISUSERNAME = 1 and CU.UserName = @USERNAME) or (@ISUSERNAME = 0 and CU.ID = @CLIENTUSERID)) and cu.ClientsID = @CLIENTSID)
        select 0 as CLIENTUSERTYPE
     -- previous event user

     else if exists(select top 1 CU.ID from dbo.CLIENTUSERS CU INNER JOIN dbo.REGISTRANT R ON R.CONSTITUENTID = dbo.UFN_CONSTITUENT_GET_BY_CLIENTUSERID(CU.ID) where R.EVENTID <> @EVENTID and ((@ISUSERNAME = 1 and CU.UserName = @USERNAME) or (@ISUSERNAME = 0 and CU.ID = @CLIENTUSERID)) and cu.ClientsID = @CLIENTSID)
        select 1 as CLIENTUSERTYPE
     -- cms user

     else if exists(select top 1 ID from dbo.CLIENTUSERS CU where ((@ISUSERNAME = 1 and CU.UserName = @USERNAME) or (@ISUSERNAME = 0 and CU.ID = @CLIENTUSERID)) and CU.ClientsID = @CLIENTSID)  
        select 2 as CLIENTUSERTYPE
     else 
     -- no user

        select -1 as CLIENTUSERTYPE
  end