USP_DATAFORMTEMPLATE_ADD_BATCHEMAILFINDERBATCHROW

The save procedure used by the add dataform template "EmailFinder Batch Row Add Form".

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	INOUT	The output parameter indicating the ID of the record added.
@BATCHID	uniqueidentifier	IN	Input parameter indicating the context ID for the record being added.
@CHANGEAGENTID	uniqueidentifier	IN	Input parameter indicating the ID of the change agent invoking the procedure.
@SEQUENCE	int	IN	Sequence
@EMAILFINDERID	uniqueidentifier	IN
@CONSTITUENTID	uniqueidentifier	IN	Constituent
@ADDRESSID	uniqueidentifier	IN
@EMAILADDRESS	UDT_EMAILADDRESS	IN	Email address
@OPTOUT	bit	IN	Opt out

Definition

Copy



CREATE procedure dbo.USP_DATAFORMTEMPLATE_ADD_BATCHEMAILFINDERBATCHROW(
    @ID uniqueidentifier = null output,
    @BATCHID uniqueidentifier,
    @CHANGEAGENTID uniqueidentifier,
    @SEQUENCE int,
    @EMAILFINDERID uniqueidentifier,
    @CONSTITUENTID uniqueidentifier = null,
    @ADDRESSID uniqueidentifier = null,
    @EMAILADDRESS dbo.UDT_EMAILADDRESS = null,
    @OPTOUT bit = null
) 
as

    set nocount on;

    declare @CURRENTDATE datetime;

    if @ID is null
        set @ID = newid();

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

    set @CURRENTDATE = getdate();

    begin try
        insert into dbo.BATCHEMAILFINDER
        (
            ID,
            BATCHID,
            SEQUENCE,
            ADDEDBYID,
            CHANGEDBYID,
            DATEADDED,
            DATECHANGED,
            EMAILFINDERID,
            CONSTITUENTID,
            ADDRESSID,
            EMAILADDRESS,
            OPTOUT
        ) 
        values 
        (
            @ID,
            @BATCHID,
            @SEQUENCE,
            @CHANGEAGENTID,
            @CHANGEAGENTID,
            @CURRENTDATE,
            @CURRENTDATE,
            @EMAILFINDERID,
            @CONSTITUENTID,
            @ADDRESSID,
            @EMAILADDRESS,
            @OPTOUT
        );
    end try
    begin catch
        exec.dbo.USP_RAISE_ERROR;
        return 1;
    end catch

    return 0;