USP_DATAFORMTEMPLATE_EDIT_NAMEFORMATPARAMETER2_2

The save procedure used by the edit dataform template "Name Format Parameter Edit Form 2".

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.
@NAME	nvarchar(100)	IN	Name
@DESCRIPTION	nvarchar(255)	IN	Description
@INDIVIDUALADDRESSEES	xml	IN	Use format defined on individual's record
@ADDRESSEEFUNCTIONID	uniqueidentifier	IN	Otherwise, use this format
@INDIVIDUALSALUTATIONS	xml	IN	Use format defined on individual's record
@SALUTATIONFUNCTIONID	uniqueidentifier	IN	Otherwise, use this format
@ORGANIZATIONADDRESSEES	xml	IN	Use format defined on contact's record
@CONTACTADDRESSEEFUNCTIONID	uniqueidentifier	IN	Otherwise, use this format
@ORGANIZATIONSALUTATIONS	xml	IN	Use format defined on contact's record
@ORGSALUTATIONCODE	tinyint	IN	ORGSALUTATIONCODE
@CONTACTSALUTATIONFUNCTIONID	uniqueidentifier	IN	Otherwise, use this format
@CONTACTSALUTATIONOPTIONCODE	tinyint	IN	If contact is not available, use
@CUSTOMNAME	nvarchar(100)	IN	Custom name
@GROUPADDRESSEES	xml	IN	Use format defined on primary member's record
@GROUPADDRESSEEFUNCTIONID	uniqueidentifier	IN	Otherwise, use this format
@GROUPSALUTATIONCODE	tinyint	IN	GROUPSALUTATIONCODE
@GROUPSALUTATIONS	xml	IN	Use format defined on primary member's record
@GROUPSALUTATIONFUNCTIONID	uniqueidentifier	IN	Otherwise, use this format
@GROUPNOCONTACTOPTIONCODE	tinyint	IN	If member is not available, use
@GROUPNOCONTACTCUSTOMNAME	nvarchar(100)	IN	Custom name
@JOINTRULETYPECODE	tinyint	IN	JOINTRULETYPECODE
@JOINTSELECTIONID	uniqueidentifier	IN	Joint selection criteria
@JOINTSELECTIONBOTHRULETYPECODE	tinyint	IN	If both constituents are found in the selection, use the following
@JOINTSELECTIONNEITHERRULETYPECODE	tinyint	IN	If neither constituents are found in the selection, use the following
@SITEID	uniqueidentifier	IN	Site
@CURRENTAPPUSERID	uniqueidentifier	IN	Input parameter indicating the ID of the current user.
@JOINTEXCLUDESPOUSE	bit	IN	The spouse does not qualify or is excluded from the process
@JOINTSPOUSESMAILEDSEPARATELY	bit	IN	Both spouses will be mailed separately within the process

Definition

Copy


                    CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDIT_NAMEFORMATPARAMETER2_2
                    (
                        @ID uniqueidentifier,
                        @CHANGEAGENTID uniqueidentifier = null,
                        @NAME nvarchar(100),
                        @DESCRIPTION nvarchar(255),
                        @INDIVIDUALADDRESSEES xml,
                        @ADDRESSEEFUNCTIONID uniqueidentifier,
                        @INDIVIDUALSALUTATIONS xml,
                        @SALUTATIONFUNCTIONID uniqueidentifier,
                        @ORGANIZATIONADDRESSEES xml,
                        @CONTACTADDRESSEEFUNCTIONID uniqueidentifier,
                        @ORGANIZATIONSALUTATIONS xml,
                        @ORGSALUTATIONCODE tinyint,
                        @CONTACTSALUTATIONFUNCTIONID uniqueidentifier,
                        @CONTACTSALUTATIONOPTIONCODE tinyint,
                        @CUSTOMNAME nvarchar(100),
                        @GROUPADDRESSEES xml,
                        @GROUPADDRESSEEFUNCTIONID uniqueidentifier,
                        @GROUPSALUTATIONCODE tinyint,
                        @GROUPSALUTATIONS xml,
                        @GROUPSALUTATIONFUNCTIONID uniqueidentifier,
                        @GROUPNOCONTACTOPTIONCODE tinyint,
                        @GROUPNOCONTACTCUSTOMNAME nvarchar(100),
                        @JOINTRULETYPECODE tinyint,
                        @JOINTSELECTIONID uniqueidentifier,
                        @JOINTSELECTIONBOTHRULETYPECODE tinyint,
                        @JOINTSELECTIONNEITHERRULETYPECODE tinyint,
                        @SITEID uniqueidentifier,
                        @CURRENTAPPUSERID uniqueidentifier = null,
                        @JOINTEXCLUDESPOUSE bit,
                        @JOINTSPOUSESMAILEDSEPARATELY bit
                    )
                    as
                        set nocount on;

                        declare @CURRENTDATE datetime;

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

                            set @CURRENTDATE = GetDate();

                            if dbo.UFN_SITEREQUIREDFORUSER(@CURRENTAPPUSERID) = 1 and @SITEID is null
                            begin
                                raiserror ('ERR_SITE_MUSTHAVESITE',13,1);
                                return 1;
                            end

                            if @JOINTSELECTIONID is not null
                                set @JOINTRULETYPECODE = 5;

                            update 
                                dbo.NAMEFORMATPARAMETER
                            set
                                NAME = @NAME,
                                DESCRIPTION = @DESCRIPTION,
                                ADDRESSEEFUNCTIONID  = @ADDRESSEEFUNCTIONID,
                                SALUTATIONFUNCTIONID  = @SALUTATIONFUNCTIONID,
                                CONTACTADDRESSEEFUNCTIONID  = @CONTACTADDRESSEEFUNCTIONID,
                                ORGSALUTATIONCODE = @ORGSALUTATIONCODE,
                                CONTACTSALUTATIONFUNCTIONID  = @CONTACTSALUTATIONFUNCTIONID,
                                CONTACTSALUTATIONOPTIONCODE  = @CONTACTSALUTATIONOPTIONCODE,
                                CUSTOMNAME = @CUSTOMNAME,
                                GROUPADDRESSEEFUNCTIONID  = @GROUPADDRESSEEFUNCTIONID,
                                GROUPSALUTATIONCODE = @GROUPSALUTATIONCODE,
                                GROUPSALUTATIONFUNCTIONID  = @GROUPSALUTATIONFUNCTIONID,
                                GROUPNOCONTACTOPTIONCODE  = @GROUPNOCONTACTOPTIONCODE,
                                GROUPNOCONTACTCUSTOMNAME = @GROUPNOCONTACTCUSTOMNAME,
                                JOINTRULETYPECODE = @JOINTRULETYPECODE,
                                JOINTSELECTIONID = @JOINTSELECTIONID,
                                JOINTSELECTIONBOTHRULETYPECODE = @JOINTSELECTIONBOTHRULETYPECODE,
                                JOINTSELECTIONNEITHERRULETYPECODE = @JOINTSELECTIONNEITHERRULETYPECODE,
                                JOINTEXCLUDESPOUSE = @JOINTEXCLUDESPOUSE,
                                JOINTSPOUSESMAILEDSEPARATELY = @JOINTSPOUSESMAILEDSEPARATELY,
                                SITEID = @SITEID,
                                CHANGEDBYID = @CHANGEAGENTID,
                                DATECHANGED = @CURRENTDATE
                            where 
                                 NAMEFORMATPARAMETER.ID = @ID;

                            exec dbo.USP_NAMEFORMATPARAMETER_GETINDADDRESSEES_UPDATEFROMXML @ID, @INDIVIDUALADDRESSEES, @CHANGEAGENTID;
                            exec dbo.USP_NAMEFORMATPARAMETER_GETINDSALUTATIONS_UPDATEFROMXML @ID, @INDIVIDUALSALUTATIONS, @CHANGEAGENTID;

                            exec dbo.USP_NAMEFORMATPARAMETER_GETORGADDRESSEES_UPDATEFROMXML @ID, @ORGANIZATIONADDRESSEES, @CHANGEAGENTID;
                            exec dbo.USP_NAMEFORMATPARAMETER_GETORGSALUTATIONS_UPDATEFROMXML @ID, @ORGANIZATIONSALUTATIONS, @CHANGEAGENTID;

                            exec dbo.USP_NAMEFORMATPARAMETER_GETGRPADDRESSEES_UPDATEFROMXML @ID, @GROUPADDRESSEES, @CHANGEAGENTID;
                            exec dbo.USP_NAMEFORMATPARAMETER_GETGRPSALUTATIONS_UPDATEFROMXML @ID, @GROUPSALUTATIONS, @CHANGEAGENTID;

                        end try

                        begin catch
                            exec dbo.USP_RAISE_ERROR;
                            return 1;
                        end catch

                        return 0;