spUndelete_ClientUsers

Parameters

Parameter	Parameter Type	Mode
@ClientUsersID	int	IN
@SignupGenerated	bit	IN
@CleanupBackOffice	bit	IN
Definition

Copy



CREATE PROCEDURE [dbo].[spUndelete_ClientUsers]
        (
                @ClientUsersID    int,
                @SignupGenerated bit,
                @CleanupBackOffice bit
        )
        AS
        BEGIN

        set nocount on

        begin transaction
            if @SignupGenerated=1
            begin
                UPDATE ClientUsers
                SET Deleted = 0, IsProvisional = 1
                WHERE ID = @ClientUsersID

            end
            else
            begin
            UPDATE ClientUsers
            SET Deleted = 0, IsProvisional = 0
            WHERE ID = @ClientUsersID
            end

            if @CleanupBackOffice=1
                delete from BackOfficeSystemUsers
                where BackOfficeSystemUsers.clientusersid = @ClientUsersID
                and exists 
                (select *
                from backofficesystempeople p
                where 
                p.id = BackOfficeSystemUsers.BackOfficePeopleID 
                and p.BackOfficeSystemID = 0
                )

        commit
        END