USP_DATAFORMTEMPLATE_EDITLOAD_BBNCMEMBERSHIPBATCHROW_2

The load procedure used by the edit dataform template "NetCommunity Membership 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.
@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.
@NETCOMMUNITYTRANSACTIONPROCESSORID	uniqueidentifier	INOUT	Processor
@BBNCID	int	INOUT	Blackbaud Internet Solutions ID
@BBNCTRANID	int	INOUT	Blackbaud Internet Solutions transaction ID
@ORIGINPAGE	nvarchar(1000)	INOUT	Origin page
@ORIGINPAGEID	int	INOUT	Origin page ID
@EMAILSUBJECT	nvarchar(4000)	INOUT	Email subject
@EMAILID	int	INOUT	Email ID
@ADDEDBY	nvarchar(255)	INOUT	Added by hidden
@ADDEDBYFORDISPLAY	nvarchar(255)	INOUT	Added by
@SEQUENCE	int	INOUT	Sequence
@MEMBERSHIPID	uniqueidentifier	INOUT	Membership
@MEMBERSHIPLEVELID	uniqueidentifier	INOUT	Membership level
@MEMBERSHIPLEVELTERMID	uniqueidentifier	INOUT	Membership level term
@MEMBERSHIPLEVELTYPECODEID	uniqueidentifier	INOUT	Membership level type
@MEMBERSHIPPROGRAMID	uniqueidentifier	INOUT	Membership program
@MEMBERSHIPPROGRAMINFO	xml	INOUT	Membership program info
@PAYMENTINFO	xml	INOUT	Payment info
@MEMBERSINFO	xml	INOUT	Members info
@MEMBERSECURITYID	uniqueidentifier	INOUT	Member constituent security group
@MEMBERSITEID	uniqueidentifier	INOUT	Guest site
@PDACCOUNTSYSTEMID	uniqueidentifier	INOUT	Account system

Definition

Copy



                    CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDITLOAD_BBNCMEMBERSHIPBATCHROW_2
                    (
                        @ID uniqueidentifier,
                        @DATALOADED bit = 0 output,
                        @TSLONG bigint = 0 output,

                        @NETCOMMUNITYTRANSACTIONPROCESSORID uniqueidentifier = null output,
                        @BBNCID int = null output,
                        @BBNCTRANID int = null output,
                        @ORIGINPAGE nvarchar(1000) = null output,
                        @ORIGINPAGEID int = null output,
                        @EMAILSUBJECT nvarchar(4000) = null output,
                        @EMAILID int = null output,
                        @ADDEDBY nvarchar(255) = null output,
                        @ADDEDBYFORDISPLAY nvarchar(255) = null output,
                        @SEQUENCE int = null output,

                        @MEMBERSHIPID uniqueidentifier = null output,

                        @MEMBERSHIPLEVELID uniqueidentifier = null output,

                        @MEMBERSHIPLEVELTERMID uniqueidentifier = null output,

                        @MEMBERSHIPLEVELTYPECODEID uniqueidentifier = null output,

                        @MEMBERSHIPPROGRAMID uniqueidentifier = null output,
                        @MEMBERSHIPPROGRAMINFO xml = null output,

                        @PAYMENTINFO xml = null output,
                        @MEMBERSINFO xml = null output,

                        @MEMBERSECURITYID uniqueidentifier = null output,
                        @MEMBERSITEID uniqueidentifier = null output,
            @PDACCOUNTSYSTEMID uniqueidentifier = null output
                    )
                    as
                    set nocount on;

                    set @DATALOADED = 0;

                    select
                        @DATALOADED = 1,
                        @TSLONG = TSLONG,
                        @NETCOMMUNITYTRANSACTIONPROCESSORID = NETCOMMUNITYTRANSACTIONPROCESSORID,
                        @BBNCID = BBNCID,
                        @BBNCTRANID = BBNCTRANID,
                        @ORIGINPAGE = ORIGINPAGE,
                        @ORIGINPAGEID = ORIGINPAGEID,
                        @EMAILSUBJECT = EMAILSUBJECT,
                        @EMAILID = EMAILID,
                        @ADDEDBY = ADDEDBY,
                        @ADDEDBYFORDISPLAY = ADDEDBY,
                        @SEQUENCE = SEQUENCE,

                        @MEMBERSHIPID = MEMBERSHIPID,
                        @MEMBERSHIPLEVELID = MEMBERSHIPLEVELID,

                        @MEMBERSHIPLEVELTERMID = MEMBERSHIPLEVELTERMID,

                        @MEMBERSHIPLEVELTYPECODEID = MEMBERSHIPLEVELTYPECODEID,

                        @MEMBERSHIPPROGRAMID = MEMBERSHIPPROGRAMID,
                        @MEMBERSHIPPROGRAMINFO = MEMBERSHIPPROGRAMINFO,

                        @PAYMENTINFO = PAYMENTINFO,

                        @MEMBERSECURITYID = MEMBERSECURITYID,
                        @MEMBERSITEID = MEMBERSITEID,

                        @MEMBERSINFO = dbo.UFN_BATCHBBNCMEMBERSHIP_GETMEMBERS_TOITEMLISTXML(@ID),
            @PDACCOUNTSYSTEMID = PDACCOUNTSYSTEMID
                    from dbo.BATCHBBNCMEMBERSHIP
                    where ID = @ID;