USP_CLIENTUSERSCIPHER_INSERTORUPDATE_CIPHER

      CREATE procedure dbo.USP_CLIENTUSERSCIPHER_INSERTORUPDATE_CIPHER
      (  
         @CLIENTUSERSID int,
         @CIPHER varchar(255)
      )
      as
      begin
        set nocount on;

          declare @CHANGEAGENTID    uniqueidentifier;
        declare @SALTEDPASSWORD nvarchar(255);
        exec dbo.[USP_CHANGEAGENT_GETORCREATECHANGEAGENT] @CHANGEAGENTID output;
        --Generate hash bytes based on user's password


        exec @SALTEDPASSWORD =  UFN_HASHBYTES_GET  @CIPHER

        --Case: Existing users


        if exists(select CLIENTUSERSID from dbo.CLIENTUSERSCIPHER where CLIENTUSERSID = @CLIENTUSERSID) 
        begin
         update dbo.CLIENTUSERSCIPHER set CIPHER = @SALTEDPASSWORD, CHANGEDBYID = @CHANGEAGENTID where CLIENTUSERSID = @CLIENTUSERSID;
        end
        --Case: New users

        else
        begin
          insert into dbo.CLIENTUSERSCIPHER(CLIENTUSERSID, CIPHER, ADDEDBYID, CHANGEDBYID) 
          values (@CLIENTUSERSID, @SALTEDPASSWORD, @CHANGEAGENTID, @CHANGEAGENTID);
        end   
      end