USP_DATAFORMTEMPLATE_EDITLOAD_BBNCPROFILEBATCHROW

The load procedure used by the edit dataform template "NetCommunity Profile Update 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
@BBNCTRANID	int	INOUT	Blackbaud Internet Solutions transaction ID
@CONSTITUENTNAME	nvarchar(154)	INOUT	Constituent name
@ADDEDBY	nvarchar(255)	INOUT	Added by hidden
@ADDEDBYFORDISPLAY	nvarchar(255)	INOUT	Added by
@ADDRESS	nvarchar(300)	INOUT	Address
@PRIMARYBUSINESS	xml	INOUT	Primary business
@PRIMARYBUSINESSUPDATE	bit	INOUT	Primbiz update
@PRIMARYBUSINESSADD	bit	INOUT	Primbiz add
@PRIMARYBUSINESSMAKEPRIMARY	bit	INOUT	Primbiz make primary
@BIOGRAPHICAL	xml	INOUT	Biographical
@EDUCATION	xml	INOUT	Education
@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
@SPOUSE	xml	INOUT	Spouse
@SPOUSEREMOVE	bit	INOUT	Remove spouse
@SAMESPOUSE	bit	INOUT	Same spouse
@CONSTITUENTATTRIBUTES	xml	INOUT	Constituent attributes
@EDUCATIONATTRIBUTES	xml	INOUT	Education 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_BBNCPROFILEBATCHROW
                    (
                            @ID uniqueidentifier,
                            @DATALOADED bit = 0 output,                            
                            @LINKID uniqueidentifier  = null output,
                            @NETCOMMUNITYTRANSACTIONPROCESSORID uniqueidentifier = null output,
                            @BBNCTRANID int = null output,
                            @CONSTITUENTNAME nvarchar(154) = null output,
                            @ADDEDBY nvarchar(255) = null output,
                            @ADDEDBYFORDISPLAY nvarchar(255) = null output,
                            @ADDRESS nvarchar(300) = null output,
                            @PRIMARYBUSINESS xml = null output,
                            @PRIMARYBUSINESSUPDATE bit = null output,
                            @PRIMARYBUSINESSADD bit = null output,
                            @PRIMARYBUSINESSMAKEPRIMARY bit = null output,
                            @BIOGRAPHICAL xml = null output,
                            @EDUCATION 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,
                            @SPOUSE xml = null output,
                            @SPOUSEREMOVE bit = null output,
                            @SAMESPOUSE bit = null output,
                            @CONSTITUENTATTRIBUTES xml = null output,
                            @EDUCATIONATTRIBUTES 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],
                                @BBNCTRANID = [BBNCTRANID],
                                @CONSTITUENTNAME = dbo.UFN_CONSTITUENT_BUILDNAME([LINKID]),
                                @ADDEDBY = [ADDEDBY],
                                @ADDEDBYFORDISPLAY = [ADDEDBY],
                                @ADDRESS = dbo.UFN_BUILDFULLADDRESS(ADDRESS.ID, ADDRESS.ADDRESSBLOCK, ADDRESS.CITY, ADDRESS.STATEID, ADDRESS.POSTCODE, ADDRESS.COUNTRYID),
                                @PRIMARYBUSINESS = [PRIMARYBUSINESS],
                                @PRIMARYBUSINESSUPDATE = [PRIMARYBUSINESSUPDATE],
                                @PRIMARYBUSINESSADD = [PRIMARYBUSINESSADD],
                                @PRIMARYBUSINESSMAKEPRIMARY = [PRIMARYBUSINESSMAKEPRIMARY],
                                @BIOGRAPHICAL = [BIOGRAPHICAL],
                                @EDUCATION = [EDUCATION],
                                @PREFERREDADDRESS = [PREFERREDADDRESS],
                                @PREFERREDADDRESSUPDATE = [PREFERREDADDRESSUPDATE],
                                @PREFERREDADDRESSADD = [PREFERREDADDRESSADD],
                                @PREFERREDADDRESSMAKEPRIMARY = [PREFERREDADDRESSMAKEPRIMARY],
                                @PREFERREDADDRESSTYPECODEID = [PREFERREDADDRESSTYPECODEID],
                                @PHONETYPES = [PHONETYPES],
                                @SPOUSE = [SPOUSE],
                                @SPOUSEREMOVE = [SPOUSEREMOVE],
                                @SAMESPOUSE = [SAMESPOUSE],
                                @CONSTITUENTATTRIBUTES = [CONSTITUENTATTRIBUTES],
                                @EDUCATIONATTRIBUTES = [EDUCATIONATTRIBUTES],
                                @SEQUENCE = [BATCHBBNCPROFILE].[SEQUENCE],
                                @TSLONG = [BATCHBBNCPROFILE].[TSLONG]
                            from
                                dbo.BATCHBBNCPROFILE
                            inner join 
                                dbo.ADDRESS on BATCHBBNCPROFILE.LINKID = ADDRESS.CONSTITUENTID and ADDRESS.ISPRIMARY = 1
                            where
                                BATCHBBNCPROFILE.ID = @ID;                            

                            return 0;