USP_DATAFORMTEMPLATE_EDIT_PEOPLEFINDERSUBMITPROCESS

The save procedure used by the edit dataform template "PeopleFinder Submit Process Edit Data Form".

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	IN	The input ID parameter indicating the ID of the record being edited.
@CHANGEAGENTID	uniqueidentifier	IN	Input parameter indicating the ID of the change agent invoking the procedure.
@IDSETREGISTERID	uniqueidentifier	IN	Selected
@ADDRESSINCLUDECODE	tinyint	IN	Address types
@ADDRESSTYPECODEID	uniqueidentifier	IN	Specific type
@CREATEOUTPUTIDSET	bit	IN	Create selection from results
@OUTPUTIDSETNAME	nvarchar(100)	IN	Selection name
@OVERWRITEOUTPUTIDSET	bit	IN	Overwrite existing selection
@INCLUDEINACTIVE	bit	IN	Include inactive constituents
@INCLUDEINCOMPLETEADDRESSES	bit	IN	Include incomplete addresses

Definition

Copy



CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDIT_PEOPLEFINDERSUBMITPROCESS
(
    @ID uniqueidentifier,
    @CHANGEAGENTID uniqueidentifier = null,
    @IDSETREGISTERID uniqueidentifier,
    @ADDRESSINCLUDECODE tinyint,
    @ADDRESSTYPECODEID uniqueidentifier,
    @CREATEOUTPUTIDSET bit,
    @OUTPUTIDSETNAME nvarchar(100),
    @OVERWRITEOUTPUTIDSET bit,
    @INCLUDEINACTIVE bit,
    @INCLUDEINCOMPLETEADDRESSES bit
)
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.PEOPLEFINDERSUBMITPROCESS
        set
            IDSETREGISTERID = @IDSETREGISTERID,
            ADDRESSINCLUDECODE = @ADDRESSINCLUDECODE,
            ADDRESSTYPECODEID = @ADDRESSTYPECODEID,
            CREATEOUTPUTIDSET = @CREATEOUTPUTIDSET,
            OUTPUTIDSETNAME = @OUTPUTIDSETNAME,
            OVERWRITEOUTPUTIDSET = @OVERWRITEOUTPUTIDSET,
            INCLUDEINACTIVE = @INCLUDEINACTIVE,
            INCLUDEINCOMPLETEADDRESSES = @INCLUDEINCOMPLETEADDRESSES,
            CHANGEDBYID = @CHANGEAGENTID,
            DATECHANGED = @CURRENTDATE
        where
            ID = @ID
    end try
    begin catch
        exec dbo.USP_RAISE_ERROR
        return 1
    end catch

return 0;