USP_EMAILFINDER_DELETE

Executes the "EmailFinder: 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.
@CURRENTAPPUSERID	uniqueidentifier	IN	Input parameter indicating the ID of the current user.

Definition

Copy



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

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

    declare @SUBMITID uniqueidentifier;
    declare @RESUBMITID uniqueidentifier;
    declare @GETID uniqueidentifier;

    select 
        @SUBMITID = SUBMIT.ID,
        @RESUBMITID = RESUBMIT.ID,
        @GETID = GET.ID
    from 
        dbo.EMAILFINDER
    inner join 
        dbo.EMAILFINDERSUBMITPROCESS SUBMIT on EMAILFINDER.ID = SUBMIT.EMAILFINDERID
    inner join
        dbo.EMAILFINDERRESUBMITPROCESS RESUBMIT on EMAILFINDER.ID = RESUBMIT.EMAILFINDERID
    inner join
        dbo.EMAILFINDERGETPROCESS GET on GET.EMAILFINDERID = EMAILFINDER.ID
    where 
        EMAILFINDER.ID = @ID;

    exec dbo.USP_BUSINESSPROCESS_PARAMETERSETCANBEDELETED 'EMAILFINDERSUBMITPROCESSSTATUS', @SUBMITID;
    exec dbo.USP_BUSINESSPROCESS_PARAMETERSETCANBEDELETED 'EMAILFINDERRESUBMITPROCESSSTATUS', @RESUBMITID;
    exec dbo.USP_BUSINESSPROCESS_PARAMETERSETCANBEDELETED 'EMAILFINDERGETPROCESSSTATUS', @GETID;

    exec dbo.USP_BUSINESSPROCESSINSTANCE_DELETE '2be9f4ad-5f54-444c-9176-1807e7a895d9', @SUBMITID, @CHANGEAGENTID;
    exec dbo.USP_BUSINESSPROCESSINSTANCE_DELETE 'b8dbebaf-16d7-4024-adf1-efe0b3872806', @RESUBMITID, @CHANGEAGENTID;
    exec dbo.USP_BUSINESSPROCESSINSTANCE_DELETE 'f4911109-3b6a-4c99-ad34-9a69cbc28545', @GETID, @CHANGEAGENTID;

    exec dbo.USP_EMAILFINDER_DELETEBYID_WITHCHANGEAGENTID @ID, @CHANGEAGENTID;

    return 0;