USP_DATAFORMTEMPLATE_ADD_NAMEFORMATPARAMETER

The save procedure used by the add dataform template "Name Format Parameter Add Data Form".

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	INOUT	The output parameter indicating the ID of the record added.
@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
@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
@SITEID	uniqueidentifier	IN	Site
@CURRENTAPPUSERID	uniqueidentifier	IN	Input parameter indicating the ID of the current user.

Definition

Copy


                    CREATE procedure dbo.USP_DATAFORMTEMPLATE_ADD_NAMEFORMATPARAMETER
                    (
                        @ID uniqueidentifier = null output,
                        @CHANGEAGENTID uniqueidentifier = null,
                        @NAME nvarchar(100),
                        @DESCRIPTION nvarchar(255) = '',
                        @INDIVIDUALADDRESSEES xml = null,
                        @ADDRESSEEFUNCTIONID uniqueidentifier = null,
                        @INDIVIDUALSALUTATIONS xml = null,
                        @SALUTATIONFUNCTIONID uniqueidentifier = null,
                        @ORGANIZATIONADDRESSEES xml = null,
                        @CONTACTADDRESSEEFUNCTIONID uniqueidentifier = null,
                        @ORGANIZATIONSALUTATIONS xml = null,
                        @ORGSALUTATIONCODE tinyint = 0,
                        @CONTACTSALUTATIONFUNCTIONID uniqueidentifier = null,
                        @CONTACTSALUTATIONOPTIONCODE tinyint,
                        @CUSTOMNAME nvarchar(100) = '',
                        @GROUPADDRESSEES xml = null,
                        @GROUPADDRESSEEFUNCTIONID uniqueidentifier = null,
                        @GROUPSALUTATIONCODE tinyint = 0,
                        @GROUPSALUTATIONS xml = null,
                        @GROUPSALUTATIONFUNCTIONID uniqueidentifier = null,
                        @GROUPNOCONTACTOPTIONCODE tinyint,
                        @GROUPNOCONTACTCUSTOMNAME nvarchar(100) = '',
                        @JOINTRULETYPECODE tinyint = 1,
                        @JOINTSELECTIONID uniqueidentifier = null,
                        @JOINTSELECTIONBOTHRULETYPECODE tinyint = 1,
                        @JOINTSELECTIONNEITHERRULETYPECODE tinyint = 1,
                        @JOINTEXCLUDESPOUSE bit = 0,
                        @JOINTSPOUSESMAILEDSEPARATELY bit = 0,
                        @SITEID uniqueidentifier = null,
                        @CURRENTAPPUSERID uniqueidentifier = 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()

                        declare @ISDEFAULT bit;
                        set @ISDEFAULT = 0;
                        select @ISDEFAULT = 1 where
                            not exists(select ID from dbo.NAMEFORMATPARAMETER where ISDEFAULT = 1);

                        begin try

                            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;

                            insert into    dbo.NAMEFORMATPARAMETER
                                (ID,
                                NAME,
                                DESCRIPTION,
                                ADDRESSEEFUNCTIONID,
                                SALUTATIONFUNCTIONID,
                                CONTACTADDRESSEEFUNCTIONID,
                                ORGSALUTATIONCODE,
                                CONTACTSALUTATIONFUNCTIONID,
                                CONTACTSALUTATIONOPTIONCODE,
                                CUSTOMNAME,
                                GROUPADDRESSEEFUNCTIONID,
                                GROUPSALUTATIONCODE,
                                GROUPSALUTATIONFUNCTIONID,
                                GROUPNOCONTACTOPTIONCODE,
                                GROUPNOCONTACTCUSTOMNAME,
                                JOINTRULETYPECODE,
                                JOINTSELECTIONID,
                                JOINTSELECTIONBOTHRULETYPECODE,
                                JOINTSELECTIONNEITHERRULETYPECODE,
                                JOINTEXCLUDESPOUSE,
                                JOINTSPOUSESMAILEDSEPARATELY,
                                ISDEFAULT,
                                SITEID,
                                ADDEDBYID,CHANGEDBYID,DATEADDED,DATECHANGED)
                            values(@ID,
                                @NAME,
                                @DESCRIPTION,
                                @ADDRESSEEFUNCTIONID,
                                @SALUTATIONFUNCTIONID,
                                @CONTACTADDRESSEEFUNCTIONID,
                                @ORGSALUTATIONCODE,
                                @CONTACTSALUTATIONFUNCTIONID,
                                @CONTACTSALUTATIONOPTIONCODE,
                                @CUSTOMNAME,
                                @GROUPADDRESSEEFUNCTIONID,
                                @GROUPSALUTATIONCODE,
                                @GROUPSALUTATIONFUNCTIONID,
                                @GROUPNOCONTACTOPTIONCODE,
                                @GROUPNOCONTACTCUSTOMNAME,
                                @JOINTRULETYPECODE,
                                @JOINTSELECTIONID,
                                @JOINTSELECTIONBOTHRULETYPECODE,
                                @JOINTSELECTIONNEITHERRULETYPECODE,
                                @JOINTEXCLUDESPOUSE,
                                @JOINTSPOUSESMAILEDSEPARATELY,
                                @ISDEFAULT,
                                @SITEID,
                                @CHANGEAGENTID,@CHANGEAGENTID,@CURRENTDATE,@CURRENTDATE);

                            exec dbo.USP_NAMEFORMATPARAMETER_GETINDADDRESSEES_ADDFROMXML @ID, @INDIVIDUALADDRESSEES, @CHANGEAGENTID;
                            exec dbo.USP_NAMEFORMATPARAMETER_GETINDSALUTATIONS_ADDFROMXML @ID, @INDIVIDUALSALUTATIONS, @CHANGEAGENTID;

                            exec dbo.USP_NAMEFORMATPARAMETER_GETORGADDRESSEES_ADDFROMXML @ID, @ORGANIZATIONADDRESSEES, @CHANGEAGENTID;
                            exec dbo.USP_NAMEFORMATPARAMETER_GETORGSALUTATIONS_ADDFROMXML @ID, @ORGANIZATIONSALUTATIONS, @CHANGEAGENTID;

                            exec dbo.USP_NAMEFORMATPARAMETER_GETGRPADDRESSEES_ADDFROMXML @ID, @GROUPADDRESSEES, @CHANGEAGENTID;
                            exec dbo.USP_NAMEFORMATPARAMETER_GETGRPSALUTATIONS_ADDFROMXML @ID, @GROUPSALUTATIONS, @CHANGEAGENTID;

                        end try

                        begin catch
                            exec dbo.USP_RAISE_ERROR
                            return 1
                        end catch

                        return 0