USP_DATAFORMTEMPLATE_EDIT_CONSTITUENTNAMEFORMATS

The save procedure used by the edit dataform template "Constituent Name Formats Edit 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.
@FORMATS	xml	IN

Definition

Copy



                CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDIT_CONSTITUENTNAMEFORMATS
                (
                    @ID uniqueidentifier,
                    @CHANGEAGENTID uniqueidentifier = null,
                    @FORMATS xml
                )
                as
                    set nocount on;

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

                        if (select count(ID) from dbo.UFN_CONSTITUENT_GETNAMEFORMATS_FROMITEMLISTXML(@FORMATS) where PRIMARYADDRESSEE = 1) > 0
                            update 
                                dbo.NAMEFORMAT 
                            set 
                                PRIMARYADDRESSEE = 0, 
                                DATECHANGED = getdate(), 
                                CHANGEDBYID = @CHANGEAGENTID 
                            where 
                                CONSTITUENTID = @ID and 
                                PRIMARYADDRESSEE = 1;

                        if (select count(ID) from dbo.UFN_CONSTITUENT_GETNAMEFORMATS_FROMITEMLISTXML(@FORMATS) where PRIMARYSALUTATION = 1) > 0
                            update 
                                dbo.NAMEFORMAT 
                            set 
                                PRIMARYSALUTATION = 0, 
                                DATECHANGED = getdate(), 
                                CHANGEDBYID = @CHANGEAGENTID                                
                            where 
                                CONSTITUENTID = @ID and PRIMARYSALUTATION = 1;

                        exec dbo.USP_CONSTITUENT_GETNAMEFORMATS_UPDATEFROMXML @ID, @FORMATS, @CHANGEAGENTID;
                    end try
                    begin catch
                        EXEC dbo.USP_RAISE_ERROR;
                        return 1;
                    end catch

                    return 0;