USP_DATAFORM_EDITLOAD_ADDRESSPROCESSINGOPTION3

The load procedure used by the edit dataform template "Address Processing Option Edit Form 3"

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	IN	The input ID parameter used to load the fields defined on the form.
@DATALOADED	bit	INOUT	Output parameter indicating whether or not data was actually loaded.
@NAME	nvarchar(100)	INOUT	Name
@PURPOSE	nvarchar(500)	INOUT	Description
@INDUSECONSTITUENTPREFS	bit	INOUT	Use individual's mail preferences, if specified.
@INDALTADDRESS1TYPECODEID	uniqueidentifier	INOUT	1st choice
@INDALTADDRESS1ISPRIMARY	bit	INOUT
@INDALTADDRESS2TYPECODEID	uniqueidentifier	INOUT	2nd choice
@INDALTADDRESS2ISPRIMARY	bit	INOUT
@INDUSESEASONALADDRESS	bit	INOUT	Use seasonal address, if available.
@INDINCLUDEWITHNOADDRESS	bit	INOUT	If address is not found
@ORGUSECONSTITUENTPREFS	bit	INOUT	Use organization's mail preferences, if specified.
@ORGMAILINGPREFERENCE	tinyint	INOUT	Mailing preference
@ORGALTADDRESS1TYPECODEID	uniqueidentifier	INOUT	1st choice
@ORGALTADDRESS1ISPRIMARY	bit	INOUT
@ORGALTADDRESS2TYPECODEID	uniqueidentifier	INOUT	2nd choice
@ORGALTADDRESS2ISPRIMARY	bit	INOUT
@ORGINCLUDEWITHNOADDRESS	bit	INOUT	If address is not found
@ORGCONTACTTYPES	xml	INOUT
@ORGSENDTOALLCONTACTS	bit	INOUT	Mail to each contact found.
@ORGINCLUDEWITHNOCONTACT	bit	INOUT	If no contact is found
@ORGCONTACTALSOINDACTION	tinyint	INOUT	If contact is also an individual
@GROUPUSECONSTITUENTPREFS	bit	INOUT	Use group's mail preferences, if specified.
@GROUPALTADDRESS1TYPECODEID	uniqueidentifier	INOUT	1st choice
@GROUPALTADDRESS2TYPECODEID	uniqueidentifier	INOUT	2nd choice
@GROUPINCLUDEWITHNOADDRESS	tinyint	INOUT	If address is not found
@GROUPUSESEASONALADDRESS	bit	INOUT	Use seasonal address, if available.
@GROUPALTADDRESS1ISPRIMARY	bit	INOUT
@GROUPALTADDRESS2ISPRIMARY	bit	INOUT
@SITEID	uniqueidentifier	INOUT	Site
@TSLONG	bigint	INOUT	Output parameter indicating the TSLONG value of the record being edited. This is used to manage multi-user concurrency issues when multiple users access the same record.
@CURRENTAPPUSERID	uniqueidentifier	IN	Input parameter indicating the ID of the current user.
@SITEREQUIRED	bit	INOUT

Definition

Copy



                    CREATE procedure dbo.USP_DATAFORM_EDITLOAD_ADDRESSPROCESSINGOPTION3 (
                        @ID uniqueidentifier,
                        @DATALOADED bit = 0 output,
                        @NAME nvarchar(100) = null output,
                        @PURPOSE nvarchar(500) = null output,
                        @INDUSECONSTITUENTPREFS bit = null output,
                        @INDALTADDRESS1TYPECODEID uniqueidentifier = null output,
                        @INDALTADDRESS1ISPRIMARY bit = null output,
                        @INDALTADDRESS2TYPECODEID uniqueidentifier = null output,
                        @INDALTADDRESS2ISPRIMARY bit = null output,
                        @INDUSESEASONALADDRESS bit = null output,
                        @INDINCLUDEWITHNOADDRESS bit = null output,
                        @ORGUSECONSTITUENTPREFS bit = null output,
                        @ORGMAILINGPREFERENCE tinyint = null output,
                        @ORGALTADDRESS1TYPECODEID uniqueidentifier = null output,
                        @ORGALTADDRESS1ISPRIMARY bit = null output,
                        @ORGALTADDRESS2TYPECODEID uniqueidentifier = null output,
                        @ORGALTADDRESS2ISPRIMARY bit = null output,
                        @ORGINCLUDEWITHNOADDRESS bit = null output,
                        @ORGCONTACTTYPES xml = null output,
                        @ORGSENDTOALLCONTACTS bit = null output,
                        @ORGINCLUDEWITHNOCONTACT bit = null output,    
                        @ORGCONTACTALSOINDACTION tinyint = null output,
                        @GROUPUSECONSTITUENTPREFS bit = null output,
                        @GROUPALTADDRESS1TYPECODEID uniqueidentifier = null output,
                        @GROUPALTADDRESS2TYPECODEID uniqueidentifier = null output,
                        @GROUPINCLUDEWITHNOADDRESS tinyint = null output,
                        @GROUPUSESEASONALADDRESS bit = null output,
                        @GROUPALTADDRESS1ISPRIMARY bit = null output,
                        @GROUPALTADDRESS2ISPRIMARY bit = null output,
                        @SITEID uniqueidentifier = null output,
                        @TSLONG bigint = 0 output,
                        @CURRENTAPPUSERID uniqueidentifier = null,
                        @SITEREQUIRED bit = null output
                    )
                    as

                    set nocount on;

                    set @DATALOADED = 0
                    set @TSLONG = 0

                    set @SITEREQUIRED = dbo.UFN_SITEREQUIREDFORUSER(@CURRENTAPPUSERID);

                    select        
                        @DATALOADED=1,
                        @NAME = NAME,
                        @PURPOSE = PURPOSE,
                        @INDUSECONSTITUENTPREFS = INDUSECONSTITUENTPREFS,
                        @INDALTADDRESS1TYPECODEID = case INDALTADDRESS1ISPRIMARY when 1 then '00000000-0000-0000-0000-000000000001' else INDALTADDRESS1TYPECODEID end,
                        @INDALTADDRESS1ISPRIMARY = INDALTADDRESS1ISPRIMARY,
                        @INDALTADDRESS2TYPECODEID = case INDALTADDRESS2ISPRIMARY when 1 then '00000000-0000-0000-0000-000000000001' else INDALTADDRESS2TYPECODEID end,
                        @INDALTADDRESS2ISPRIMARY = INDALTADDRESS2ISPRIMARY,
                        @INDUSESEASONALADDRESS = INDUSESEASONALADDRESS,
                        @INDINCLUDEWITHNOADDRESS = INDINCLUDEWITHNOADDRESS,
                        @ORGUSECONSTITUENTPREFS = ORGUSECONSTITUENTPREFS,
                        @ORGMAILINGPREFERENCE = ORGMAILINGPREFERENCE,
                        @ORGALTADDRESS1TYPECODEID = case ORGALTADDRESS1ISPRIMARY when 1 then '00000000-0000-0000-0000-000000000001' else ORGALTADDRESS1TYPECODEID end,
                        @ORGALTADDRESS1ISPRIMARY = ORGALTADDRESS1ISPRIMARY,
                        @ORGALTADDRESS2TYPECODEID = case ORGALTADDRESS2ISPRIMARY when 1 then '00000000-0000-0000-0000-000000000001' else ORGALTADDRESS2TYPECODEID end,
                        @ORGALTADDRESS2ISPRIMARY = ORGALTADDRESS2ISPRIMARY,
                        @ORGINCLUDEWITHNOADDRESS = ORGINCLUDEWITHNOADDRESS,
                        @ORGSENDTOALLCONTACTS = ORGSENDTOALLCONTACTS,
                        @ORGINCLUDEWITHNOCONTACT = ORGINCLUDEWITHNOCONTACT,    
                        @ORGCONTACTALSOINDACTION = ORGCONTACTALSOINDACTION,
                        @ORGCONTACTTYPES = dbo.UFN_ADDRESSPROCESSINGOPTION_GETCONTACTTYPES_TOITEMLISTXML(@ID),
                        @GROUPUSECONSTITUENTPREFS = GROUPUSECONSTITUENTPREFS,
                        @GROUPALTADDRESS1TYPECODEID = case GROUPALTADDRESS1ISPRIMARY when 1 then '00000000-0000-0000-0000-000000000001' else GROUPALTADDRESS1TYPECODEID end,
                        @GROUPALTADDRESS2TYPECODEID = case GROUPALTADDRESS2ISPRIMARY when 1 then '00000000-0000-0000-0000-000000000001' else GROUPALTADDRESS2TYPECODEID end,
                        @GROUPINCLUDEWITHNOADDRESS = GROUPINCLUDEWITHNOADDRESS,
                        @GROUPUSESEASONALADDRESS = GROUPUSESEASONALADDRESS,
                        @GROUPALTADDRESS1ISPRIMARY = GROUPALTADDRESS1ISPRIMARY,
                        @GROUPALTADDRESS2ISPRIMARY = GROUPALTADDRESS2ISPRIMARY,
                        @SITEID = SITEID,
                        @TSLONG = TSLONG
                    from ADDRESSPROCESSINGOPTION
                    where ID=@ID

                    return 0;