USP_DATAFORMTEMPLATE_EDIT_INDIVIDUALDISPLAYNAMEFORMAT

The save procedure used by the edit dataform template "Individual Display Name Format Edit Data Form".

Parameters

Parameter	Parameter Type	Mode	Description
@CHANGEAGENTID	uniqueidentifier	IN	Input parameter indicating the ID of the change agent invoking the procedure.
@NAMEFORMATFUNCTIONID	uniqueidentifier	IN	Name format text

Definition

Copy



CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDIT_INDIVIDUALDISPLAYNAMEFORMAT (
    @CHANGEAGENTID uniqueidentifier = null,
    @NAMEFORMATFUNCTIONID uniqueidentifier
)
as

    set nocount on;

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

    declare @CURRENTDATE datetime
    set @CURRENTDATE = getdate()

    begin try
        if @NAMEFORMATFUNCTIONID is null or @NAMEFORMATFUNCTIONID = '00000000-0000-0000-0000-000000000000'
        begin
            delete from dbo.CONSTITUENTDISPLAYNAMEFORMAT
        end
        else
        begin
            if exists(select 1 from dbo.CONSTITUENTDISPLAYNAMEFORMAT)
            begin
                -- handle updating the data

                update dbo.CONSTITUENTDISPLAYNAMEFORMAT set
                    INDIVIDUALNAMEFORMATFUNCTIONID = @NAMEFORMATFUNCTIONID,
                    CHANGEDBYID = @CHANGEAGENTID,
                    DATECHANGED = @CURRENTDATE
                where INDIVIDUALNAMEFORMATFUNCTIONID != @NAMEFORMATFUNCTIONID
            end
            else
            begin
                insert into dbo.CONSTITUENTDISPLAYNAMEFORMAT
                (
                    ID,
                    INDIVIDUALNAMEFORMATFUNCTIONID,
                    ADDEDBYID,
                    CHANGEDBYID,
                    DATEADDED,
                    DATECHANGED
                )
                values
                (
                    newid(),
                    @NAMEFORMATFUNCTIONID,
                    @CHANGEAGENTID,
                    @CHANGEAGENTID,
                    @CURRENTDATE,
                    @CURRENTDATE
                )
            end
        end

        exec dbo.USP_CREATEORUPDATE_CONSTITUENTDISPLAYNAME @CHANGEAGENTID;
    end try
    begin catch
        exec dbo.USP_RAISE_ERROR
        return 1
    end catch

return 0;