USP_DATAFORMTEMPLATE_EDITLOAD_BBNCSIGNUPBATCHROW

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

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
@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.

Definition

Copy



                    CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDITLOAD_BBNCSIGNUPBATCHROW
                    (
                            @ID uniqueidentifier,
                            @DATALOADED bit = 0 output,                            
                            @LINKID uniqueidentifier = null output,
                            @NETCOMMUNITYTRANSACTIONPROCESSORID uniqueidentifier = null output,
                            @ISORGANIZATION tinyint = 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
                        ) as
                            set nocount on;

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

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

                                @BBNCTRANID = [BBNCTRANID],
                                @BBNCCONSTITNAME = [BBNCCONSTITNAME],
                                @CONSTITUENTNAME = case when [LINKID] is null then [BBNCCONSTITNAME] else dbo.UFN_CONSTITUENT_BUILDNAME([LINKID]) end,
                                @ADDEDBY = [ADDEDBY],
                                @ADDEDBYFORDISPLAY = [ADDEDBY],
                                @BBNCADDRESS = [BBNCADDRESS],
                                @ADDRESS = case when [LINKID] is null then [BBNCADDRESS] else dbo.UFN_BUILDFULLADDRESS(ADDRESS.ID, ADDRESS.ADDRESSBLOCK, ADDRESS.CITY, ADDRESS.STATEID, ADDRESS.POSTCODE, ADDRESS.COUNTRYID) end,
                                @BIOGRAPHICAL = [BIOGRAPHICAL],
                                @PREFERREDADDRESS = [PREFERREDADDRESS],
                                @PREFERREDADDRESSUPDATE = [PREFERREDADDRESSUPDATE],
                                @PREFERREDADDRESSADD = [PREFERREDADDRESSADD],
                                @PREFERREDADDRESSMAKEPRIMARY = [PREFERREDADDRESSMAKEPRIMARY],
                                @PREFERREDADDRESSTYPECODEID = [PREFERREDADDRESSTYPECODEID],
                                @PHONETYPES = [PHONETYPES],
                                @CONSTITUENTATTRIBUTES = [CONSTITUENTATTRIBUTES],
                                @SEQUENCE = [BATCHBBNCSIGNUP].[SEQUENCE],
                                @TSLONG = [BATCHBBNCSIGNUP].[TSLONG]
                            from
                                dbo.BATCHBBNCSIGNUP
                            left join 
                                dbo.ADDRESS on BATCHBBNCSIGNUP.LINKID = ADDRESS.CONSTITUENTID and ADDRESS.ISPRIMARY = 1
                            where
                                BATCHBBNCSIGNUP.ID = @ID;                            

                            return 0;