USP_DATAFORMTEMPLATE_EDITLOAD_BBNCSIGNUPBATCHROW_2

The load procedure used by the edit dataform template "NetCommunity Signup Batch Row Edit Form 2"

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.
@LINKID	uniqueidentifier	INOUT	Linked Constituent
@NETCOMMUNITYTRANSACTIONPROCESSORID	uniqueidentifier	INOUT	Processor
@ISORGANIZATION	tinyint	INOUT	Constituent type
@BBNCID	int	INOUT	Blackbaud Internet Solutions ID
@BBNCTRANID	int	INOUT	Blackbaud Internet Solutions transaction ID
@BBNCCONSTITNAME	nvarchar(154)	INOUT	Blackbaud Internet Solutions Constituent name
@CONSTITUENTNAME	nvarchar(154)	INOUT	Constituent name
@ADDEDBY	nvarchar(255)	INOUT	Added by hidden
@ADDEDBYFORDISPLAY	nvarchar(255)	INOUT	Added by
@BBNCADDRESS	nvarchar(300)	INOUT	Blackbaud Internet Solutions address
@ADDRESS	nvarchar(300)	INOUT	Address
@BIOGRAPHICAL	xml	INOUT	Biographical
@PREFERREDADDRESS	xml	INOUT	Preferred address
@PREFERREDADDRESSUPDATE	bit	INOUT	Update the primary address with the downloaded information
@PREFERREDADDRESSADD	bit	INOUT	Add the downloaded information as a new address for this constituent
@PREFERREDADDRESSMAKEPRIMARY	bit	INOUT	Make this new address the primary address
@PREFERREDADDRESSTYPECODEID	uniqueidentifier	INOUT	Previous address type
@PHONETYPES	xml	INOUT	Phone type codes hidden
@CONSTITUENTATTRIBUTES	xml	INOUT	Constituent attributes
@SEQUENCE	int	INOUT	Sequence
@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.
@BBNCUSERID	int	INOUT	Blackbaud Internet Solutions user ID
@SIGNUPTRANSACTIONDATE	datetime	INOUT	Signup date
@LINKIDAUTOMATCH	nvarchar(255)	INOUT	Auto-match
@BIOGRAPHICALALLFIELDS	xml	INOUT	Biographical all fields
@PREFERREDADDRESSALLFIELDS	xml	INOUT	Preferred address all fields
@ORIGINALLINKID	uniqueidentifier	INOUT	Original link ID
@LINKEDCONSTITUENTSECURITYID	uniqueidentifier	INOUT	Linked constituent security group
@LINKEDCONSTITUENTSITEID	uniqueidentifier	INOUT	Linked constituent site
@ATTRIBUTECURRENCYID	uniqueidentifier	INOUT	Attribute currency

Definition

Copy



                    CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDITLOAD_BBNCSIGNUPBATCHROW_2
                    (
                            @ID uniqueidentifier,
                            @DATALOADED bit = 0 output,                            
                            @LINKID uniqueidentifier = null output,
                            @NETCOMMUNITYTRANSACTIONPROCESSORID uniqueidentifier = null output,
                            @ISORGANIZATION tinyint = null output,
                            @BBNCID int = null output,
                            @BBNCTRANID int = null output,
                            @BBNCCONSTITNAME nvarchar(154) = null output,
                            @CONSTITUENTNAME nvarchar(154) = null output,
                            @ADDEDBY nvarchar(255) = null output,
                            @ADDEDBYFORDISPLAY nvarchar(255) = null output,
                            @BBNCADDRESS nvarchar(300) = null output,
                            @ADDRESS nvarchar(300) = null output,
                            @BIOGRAPHICAL xml = null output,
                            @PREFERREDADDRESS xml = null output,
                            @PREFERREDADDRESSUPDATE bit = null output,
                            @PREFERREDADDRESSADD bit = null output,
                            @PREFERREDADDRESSMAKEPRIMARY bit = null output,
                            @PREFERREDADDRESSTYPECODEID uniqueidentifier = null output,
                            @PHONETYPES xml = null output,
                            @CONSTITUENTATTRIBUTES xml = null output,
                            @SEQUENCE int = null output,
                            @TSLONG bigint = 0 output,
                            @BBNCUSERID int = null output,
                            @SIGNUPTRANSACTIONDATE datetime = null output,
                            @LINKIDAUTOMATCH nvarchar(255) = null output,
                            @BIOGRAPHICALALLFIELDS xml = null output,
                            @PREFERREDADDRESSALLFIELDS xml = null output,
                            @ORIGINALLINKID uniqueidentifier = null output,
                            @LINKEDCONSTITUENTSECURITYID uniqueidentifier = null output,
                            @LINKEDCONSTITUENTSITEID uniqueidentifier = null output,
                            @ATTRIBUTECURRENCYID uniqueidentifier = null output
                        ) as
                            set nocount on;

                            set @DATALOADED = 0;
                            set @TSLONG = 0;

                            select
                                @DATALOADED = 1,
                                @LINKID = [LINKID],
                                @ORIGINALLINKID = [LINKID],
                                @NETCOMMUNITYTRANSACTIONPROCESSORID = [NETCOMMUNITYTRANSACTIONPROCESSORID],
                                @ISORGANIZATION = 0, --JamesWill CR272725-041307 2007/05/09 Signups will always be individuals

                                @BBNCID = [BBNCID],
                                @BBNCTRANID = [BBNCTRANID],
                                @BBNCCONSTITNAME = [BBNCCONSTITNAME],
                                @CONSTITUENTNAME =[BBNCCONSTITNAME],
                                @ADDEDBY = [ADDEDBY],
                                @ADDEDBYFORDISPLAY = [ADDEDBY],
                                @BBNCADDRESS = [BBNCADDRESS],
                                @ADDRESS = [BBNCADDRESS], --JamesWill 08/21/2007 CR280840-081307  Always display the address from the signup transaction

                                @BBNCUSERID = [BATCHBBNCSIGNUP].[BBNCUSERID],
                                @SIGNUPTRANSACTIONDATE = [BATCHBBNCSIGNUP].[SIGNUPTRANSACTIONDATE],
                                @BIOGRAPHICAL = [BIOGRAPHICAL],
                                @BIOGRAPHICALALLFIELDS = [BIOGRAPHICALALLFIELDS],
                                @PREFERREDADDRESS = [PREFERREDADDRESS],
                                @PREFERREDADDRESSALLFIELDS = [PREFERREDADDRESSALLFIELDS],
                                @PREFERREDADDRESSUPDATE = [PREFERREDADDRESSUPDATE],
                                @PREFERREDADDRESSADD = [PREFERREDADDRESSADD],
                                @PREFERREDADDRESSMAKEPRIMARY = [PREFERREDADDRESSMAKEPRIMARY],
                                @PREFERREDADDRESSTYPECODEID = [PREFERREDADDRESSTYPECODEID],
                                @PHONETYPES = [PHONETYPES],
                                @CONSTITUENTATTRIBUTES = [CONSTITUENTATTRIBUTES],
                                @LINKIDAUTOMATCH = [LINKIDAUTOMATCH],
                                @LINKEDCONSTITUENTSECURITYID = [LINKEDCONSTITUENTSECURITYID],
                                @LINKEDCONSTITUENTSITEID = [LINKEDCONSTITUENTSITEID],
                                @ATTRIBUTECURRENCYID = [ATTRIBUTECURRENCYID],
                                @SEQUENCE = [BATCHBBNCSIGNUP].[SEQUENCE],
                                @TSLONG = [BATCHBBNCSIGNUP].[TSLONG]
                            from
                                dbo.BATCHBBNCSIGNUP
                            where
                                BATCHBBNCSIGNUP.ID = @ID;                            

                            return 0;