USP_DATAFORMTEMPLATE_EDIT_BBNCMEMBERSHIPBATCHROW

The save procedure used by the edit dataform template "NetCommunity Membership Batch Row Edit Form".

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	IN	The input ID parameter indicating the ID of the record being edited.
@CHANGEAGENTID	uniqueidentifier	IN	Input parameter indicating the ID of the change agent invoking the procedure.
@NETCOMMUNITYTRANSACTIONPROCESSORID	uniqueidentifier	IN	Processor
@BBNCID	int	IN	Blackbaud Internet Solutions ID
@BBNCTRANID	int	IN	Blackbaud Internet Solutions transaction ID
@ORIGINPAGE	nvarchar(1000)	IN	Origin page
@ORIGINPAGEID	int	IN	Origin page ID
@EMAILSUBJECT	nvarchar(4000)	IN	Email subject
@EMAILID	int	IN	Email ID
@ADDEDBY	nvarchar(255)	IN	Added by hidden
@SEQUENCE	int	IN	Sequence
@MEMBERSHIPID	uniqueidentifier	IN	Membership
@MEMBERSHIPLEVELID	uniqueidentifier	IN	Membership level
@MEMBERSHIPLEVELTERMID	uniqueidentifier	IN	Membership level term
@MEMBERSHIPLEVELTYPECODEID	uniqueidentifier	IN	Membership level type
@MEMBERSHIPPROGRAMID	uniqueidentifier	IN	Membership program
@MEMBERSHIPPROGRAMINFO	xml	IN	Membership program info
@PAYMENTINFO	xml	IN	Payment info
@MEMBERSINFO	xml	IN	Members info
@MEMBERSECURITYID	uniqueidentifier	IN	Member constituent security group

Definition

Copy



                    CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDIT_BBNCMEMBERSHIPBATCHROW
                    (
                        @ID uniqueidentifier,
                        @CHANGEAGENTID uniqueidentifier,


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

                        @MEMBERSHIPID uniqueidentifier,

                        @MEMBERSHIPLEVELID uniqueidentifier,

                        @MEMBERSHIPLEVELTERMID uniqueidentifier,

                        @MEMBERSHIPLEVELTYPECODEID uniqueidentifier,

                        @MEMBERSHIPPROGRAMID uniqueidentifier,
                        @MEMBERSHIPPROGRAMINFO xml,

                        @PAYMENTINFO xml,
                        @MEMBERSINFO xml,

                        @MEMBERSECURITYID uniqueidentifier
                    )
                    as
                    set nocount on;

                    begin try
                        if @CHANGEAGENTID is null
                            exec dbo.USP_CHANGEAGENT_GETORCREATECHANGEAGENT @CHANGEAGENTID output;

                        declare @CHANGEDATE datetime;
                        set @CHANGEDATE = getdate();

                        update dbo.BATCHBBNCMEMBERSHIP
                            set NETCOMMUNITYTRANSACTIONPROCESSORID = @NETCOMMUNITYTRANSACTIONPROCESSORID,
                                BBNCID = @BBNCID,
                                BBNCTRANID = @BBNCTRANID,
                                ORIGINPAGE = @ORIGINPAGE,
                                ORIGINPAGEID = @ORIGINPAGEID,
                                EMAILSUBJECT = @EMAILSUBJECT,
                                EMAILID = @EMAILID,
                                ADDEDBY = @ADDEDBY,
                                SEQUENCE = @SEQUENCE,

                                MEMBERSHIPID = @MEMBERSHIPID,
                                MEMBERSHIPLEVELID = @MEMBERSHIPLEVELID,

                                MEMBERSHIPLEVELTERMID = @MEMBERSHIPLEVELTERMID,

                                MEMBERSHIPLEVELTYPECODEID = @MEMBERSHIPLEVELTYPECODEID,

                                MEMBERSHIPPROGRAMID = @MEMBERSHIPPROGRAMID,
                                MEMBERSHIPPROGRAMINFO = @MEMBERSHIPPROGRAMINFO,

                                PAYMENTINFO = @PAYMENTINFO,

                                MEMBERSECURITYID = @MEMBERSECURITYID,

                                CHANGEDBYID = @CHANGEAGENTID,
                                DATECHANGED = @CHANGEDATE

                        where ID = @ID;

                        declare @CONTEXTCACHE varbinary(128);
                        set @CONTEXTCACHE = CONTEXT_INFO();
                        set CONTEXT_INFO @CHANGEAGENTID;

                        delete from dbo.BATCHBBNCMEMBERSHIPMEMBER where BATCHBBNCMEMBERSHIPID = @ID;

                        if not @CONTEXTCACHE is null
                            set CONTEXT_INFO @CONTEXTCACHE;

                        insert into dbo.BATCHBBNCMEMBERSHIPMEMBER(ID, BATCHBBNCMEMBERSHIPID, SEQUENCE, MEMBERID, MEMBERCONSTITUENTID, MEMBERISPRIMARY, MEMBERUPDATEADDRESS, MEMBERADDADDRESS, MEMBERMAKEADDRESSPRIMARY, MEMBERADDRESSTYPECODEID,
                                                                  MEMBERBIOINFO, MEMBERBIOINFOALL, MEMBERPHONETYPES,
                                                                  MEMBERADDRESSINFO, MEMBERADDRESSINFOALL,
                                                                  ADDEDBYID, CHANGEDBYID, DATEADDED, DATECHANGED)
                            select 
                                coalesce(ID, newid()), @ID, SEQUENCE, 
                                MEMBERID, MEMBERCONSTITUENTID,
                                MEMBERISPRIMARY, MEMBERUPDATEADDRESS, MEMBERADDADDRESS, MEMBERMAKEADDRESSPRIMARY, MEMBERADDRESSTYPECODEID,
                                MEMBERBIOINFO, MEMBERBIOINFOALL, MEMBERPHONETYPES,
                                MEMBERADDRESSINFO, MEMBERADDRESSINFOALL,
                                @CHANGEAGENTID, @CHANGEAGENTID, @CHANGEDATE, @CHANGEDATE
                            from dbo.UFN_BATCHBBNCMEMBERSHIP_GETMEMBERS_FROMITEMLISTXML(@MEMBERSINFO);

                    end try
                    begin catch
                        exec dbo.USP_RAISE_ERROR;
                        return 1;
                    end catch

                    return 0;