USP_DATAFORMTEMPLATE_EDIT_BBNCPROFILEBATCHROW

The save 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 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
@BBNCTRANID	int	IN	Blackbaud Internet Solutions transaction ID
@ADDEDBY	nvarchar(255)	IN	Added by hidden
@PRIMARYBUSINESS	xml	IN	Primary business
@PRIMARYBUSINESSUPDATE	bit	IN	Primbiz update
@PRIMARYBUSINESSADD	bit	IN	Primbiz add
@PRIMARYBUSINESSMAKEPRIMARY	bit	IN	Primbiz make primary
@BIOGRAPHICAL	xml	IN	Biographical
@EDUCATION	xml	IN	Education
@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
@SPOUSE	xml	IN	Spouse
@SPOUSEREMOVE	bit	IN	Remove spouse
@SAMESPOUSE	bit	IN	Same spouse
@CONSTITUENTATTRIBUTES	xml	IN	Constituent attributes
@EDUCATIONATTRIBUTES	xml	IN	Education attributes
@SEQUENCE	int	IN	Sequence

Definition

Copy



                        CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDIT_BBNCPROFILEBATCHROW
                        (
                            @ID uniqueidentifier,
                            @CHANGEAGENTID uniqueidentifier,
                            @LINKID uniqueidentifier,
                            @NETCOMMUNITYTRANSACTIONPROCESSORID uniqueidentifier,
                            @BBNCTRANID int,
                            @ADDEDBY nvarchar(255),
                            @PRIMARYBUSINESS xml,
                            @PRIMARYBUSINESSUPDATE bit,
                            @PRIMARYBUSINESSADD bit,
                            @PRIMARYBUSINESSMAKEPRIMARY bit,
                            @BIOGRAPHICAL xml,
                            @EDUCATION xml,
                            @PREFERREDADDRESS xml,
                            @PREFERREDADDRESSUPDATE bit,
                            @PREFERREDADDRESSADD bit,
                            @PREFERREDADDRESSMAKEPRIMARY bit,
                            @PREFERREDADDRESSTYPECODEID uniqueidentifier,
                            @PHONETYPES xml,
                            @SPOUSE xml,
                            @SPOUSEREMOVE bit,
                            @SAMESPOUSE bit,
                            @CONSTITUENTATTRIBUTES xml,
                            @EDUCATIONATTRIBUTES xml,
                            @SEQUENCE int
                        ) 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.BATCHBBNCPROFILE 
                                set
                                    [LINKID] = @LINKID,
                                    [NETCOMMUNITYTRANSACTIONPROCESSORID] = @NETCOMMUNITYTRANSACTIONPROCESSORID,
                                    [BBNCTRANID] = @BBNCTRANID,
                                    [ADDEDBY] = @ADDEDBY,
                                    [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] = @SEQUENCE,
                                    [CHANGEDBYID] = @CHANGEAGENTID,
                                    [DATECHANGED] = @CURRENTDATE
                                where ID = @ID;

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

                            return 0;