USP_APPUSER_CLEANUPFORDELETE

Cleans up unnecessary references to this application user so that it can be deleted

Parameters

Parameter	Parameter Type	Mode	Description
@APPUSERID	uniqueidentifier	IN
@CHANGEAGENTID	uniqueidentifier	IN

Definition

Copy



            CREATE procedure dbo.USP_APPUSER_CLEANUPFORDELETE 
            (
                @APPUSERID uniqueidentifier, 
                @CHANGEAGENTID uniqueidentifier = null
            )
            as
            set nocount on;

            if @CHANGEAGENTID is null  
                exec dbo.USP_CHANGEAGENT_GETORCREATECHANGEAGENT @CHANGEAGENTID output;

            declare @CURRENTDATE datetime;
            set @CURRENTDATE=getdate();

            begin try
                update dbo.BATCH 
                    set APPUSERID = null,
                        CHANGEDBYID = @CHANGEAGENTID,
                        DATECHANGED = @CURRENTDATE 
                    where APPUSERID = @APPUSERID and STATUSCODE = 2

                update dbo.BATCHWORKFLOWSTATUS 
                    set APPUSERID = null,
                        CHANGEDBYID = @CHANGEAGENTID,
                        DATECHANGED = @CURRENTDATE  
                    where APPUSERID = @APPUSERID

                delete from dbo.SITEPERMISSION where SITEPERMISSION.APPUSERID = @APPUSERID;

                return 0;
            end try
            begin catch
                exec dbo.USP_RAISE_ERROR;
                return 1;
            end catch