USP_BATCHCONSTITUENTUPDATE_DELETE

Executes the "Constituent Update Batch Row: Delete" record operation.

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	IN	Input parameter indicating the ID of the record being deleted.
@CHANGEAGENTID	uniqueidentifier	IN	Input parameter indicating the ID of the change agent invoking the delete.

Definition

Copy



    CREATE procedure dbo.USP_BATCHCONSTITUENTUPDATE_DELETE
    (
        @ID uniqueidentifier,
        @CHANGEAGENTID uniqueidentifier
    ) as
        set nocount on;

     --remove BBIS transaction info if batch row was created by BBIS signup transaction.

      declare @BBNCTRANID int = 0;
            select @BBNCTRANID = (select top 1 BBNCTRANID
            from dbo.BATCHCONSTITUENTUPDATEBBNCINFO
            where ID in
                      (select BCUB.ID from dbo.BATCHCONSTITUENTUPDATEBBNCINFO BCUB
                      inner join dbo.BATCHCONSTITUENTUPDATE CUB on CUB.ID = BCUB.BATCHCONSTITUENTUPDATEID
                      where CUB.ID = @ID));

     delete
     from dbo.BATCHCONSTITUENTUPDATEBBNCINFO 
     where ID in
           (select BCUB.ID from dbo.BATCHCONSTITUENTUPDATEBBNCINFO BCUB
           inner join dbo.BATCHCONSTITUENTUPDATE CUB on CUB.ID = BCUB.BATCHCONSTITUENTUPDATEID
           where CUB.ID = @ID);

     if @BBNCTRANID > 0
      exec [dbo].[spTransactions_DeleteSignup] @BBNCTRANID

        -- Remove Constituent Solicit Codes

        delete    BSC
        from    dbo.BATCHCONSTITUENTUPDATESOLICITCODE BSC
        join    BATCHCONSTITUENTUPDATE on BATCHCONSTITUENTUPDATE.ID = BSC.BATCHCONSTITUENTUPDATEID
        where   BATCHCONSTITUENTUPDATE.ID = @ID;

        exec USP_BATCHCONSTITUENTUPDATE_DELETEBYID_WITHCHANGEAGENTID @ID, @CHANGEAGENTID

        return 0;