USP_DATAFORMTEMPLATE_EDIT_BBNCSIGNUPBATCHROW_1_3

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

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

Definition

Copy



                        CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDIT_BBNCSIGNUPBATCHROW_1_3
                        (
                            @ID uniqueidentifier,
                            @CHANGEAGENTID uniqueidentifier,
                            @LINKID uniqueidentifier,
                            @NETCOMMUNITYTRANSACTIONPROCESSORID uniqueidentifier,
                            @ISORGANIZATION tinyint,
                            @BBNCID int,
                            @BBNCTRANID int,
                            @BBNCCONSTITNAME nvarchar(154),
                            @ADDEDBY nvarchar(255),
                            @BBNCADDRESS nvarchar(300),
                            @BIOGRAPHICAL xml,
                            @PREFERREDADDRESS xml,
                            @PREFERREDADDRESSUPDATE bit,
                            @PREFERREDADDRESSADD bit,
                            @PREFERREDADDRESSMAKEPRIMARY bit,
                            @PREFERREDADDRESSTYPECODEID uniqueidentifier,
                            @PHONETYPES xml,
                            @CONSTITUENTATTRIBUTES xml,
                            @SEQUENCE int,
                            @BBNCUSERID int,
                            @SIGNUPTRANSACTIONDATE datetime,
                            @LINKIDAUTOMATCH nvarchar(255),
                            @BIOGRAPHICALALLFIELDS xml,
                            @PREFERREDADDRESSALLFIELDS xml,
                            @ORIGINALLINKID uniqueidentifier,
                            @LINKEDCONSTITUENTSECURITYID uniqueidentifier
                        ) as
                            set nocount on;

                            declare @CURRENTDATE datetime;

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

                            set @CURRENTDATE = getdate();

                            begin try                                
                                update
                                    dbo.BATCHBBNCSIGNUP 
                                set
                                    [LINKID] = @LINKID,
                                    [NETCOMMUNITYTRANSACTIONPROCESSORID] = @NETCOMMUNITYTRANSACTIONPROCESSORID,
                                    [ISORGANIZATION] = 0, --JamesWill CR272725-041307 2007/05/09 Signups will always be individuals

                                    [BBNCID] = @BBNCID,
                                    [BBNCTRANID] = @BBNCTRANID,
                                    [BBNCCONSTITNAME] = @BBNCCONSTITNAME,
                                    [ADDEDBY] = @ADDEDBY,
                                    [BBNCADDRESS] = @BBNCADDRESS,
                                    [BBNCUSERID] = @BBNCUSERID,
                                    [SIGNUPTRANSACTIONDATE] = @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,
                                    [SEQUENCE] = @SEQUENCE,
                                    [CHANGEDBYID] = @CHANGEAGENTID,
                                    [DATECHANGED] = @CURRENTDATE
                                where ID = @ID;

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

                            return 0;