USP_DATAFORMTEMPLATE_EDIT_BBNCPROFILEBATCHROW_4

The save procedure used by the edit dataform template "NetCommunity Profile Update Batch Row Edit Form 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
@BBNCID	int	IN	Blackbaud Internet Solutions ID
@BBNCTRANID	int	IN	Blackbaud Internet Solutions transaction ID
@ADDEDBY	nvarchar(255)	IN	Added by hidden
@PRIMARYBUSINESS	xml	IN	Primary business
@PRIMARYBUSINESSUPDATE	bit	IN	Update the business address with the downloaded information
@PRIMARYBUSINESSADD	bit	IN	Add the downloaded information as the new business address for this constituent
@PRIMARYBUSINESSMAKEPRIMARY	bit	IN	Make the this new business address primary (deprecated)
@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	Change this constituent's current spouse relationship into a former spouse relationship
@SAMESPOUSE	bit	IN	Update the existing spouse with the downloaded information
@CONSTITUENTATTRIBUTES	xml	IN	Constituent attributes
@EDUCATIONATTRIBUTES	xml	IN	Education attributes
@SEQUENCE	int	IN	Sequence
@PREFERREDADDRESSALLFIELDS	xml	IN	Preferred address all fields
@PRIMARYBUSINESSADDRESSTYPECODEID	uniqueidentifier	IN	Previous business address type
@PRIMARYBUSINESSALLFIELDS	xml	IN	Primary business all fields
@PRIMARYBUSINESSORGANIZATIONLINKID	uniqueidentifier	IN	Primary business organization
@SPOUSELINKID	uniqueidentifier	IN	Spouse
@SPOUSEOLDNAME	nvarchar(200)	IN	Previous spouse
@PRIMARYBUSINESSAUTOMATCH	nvarchar(255)	IN	Primary business auto-match
@SPOUSESECURITYID	uniqueidentifier	IN	Spouse constituent security group
@PRIMARYBUSINESSSECURITYID	uniqueidentifier	IN	Primary business constituent security group
@ISORGANIZATIONUPDATE	bit	IN	Is organization update
@SPOUSESITEID	uniqueidentifier	IN	Spouse site
@PRIMARYBUSINESSSITEID	uniqueidentifier	IN	Primary business site
@ADDITIONALADDRESSES	xml	IN	Additional addresses
@EMPLOYMENTHISTORY	xml	IN	Employment
@EDUCATIONALHISTORY	xml	IN	Educational history
@EDUCATIONALINVOLVEMENTS	xml	IN	Educational involvements
@ATTRIBUTECURRENCYID	uniqueidentifier	IN	Attribute currency
@PHONENUMBERS	xml	IN	Phone numbers
@EMAILADDRESSES	xml	IN	Email addresses
@ORGRELATIONSHIPS	xml	IN	Employment
@NAMEFORMATS	xml	IN	Name formats

Definition

Copy



                        create procedure dbo.USP_DATAFORMTEMPLATE_EDIT_BBNCPROFILEBATCHROW_4
                        (
                            @ID uniqueidentifier,
                            @CHANGEAGENTID uniqueidentifier,
                            @LINKID uniqueidentifier,
                            @NETCOMMUNITYTRANSACTIONPROCESSORID uniqueidentifier,
                            @BBNCID int,
                            @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,
                            @PREFERREDADDRESSALLFIELDS xml,
                            @PRIMARYBUSINESSADDRESSTYPECODEID uniqueidentifier,
                            @PRIMARYBUSINESSALLFIELDS xml,
                            @PRIMARYBUSINESSORGANIZATIONLINKID uniqueidentifier,
                            @SPOUSELINKID uniqueidentifier,
                            @SPOUSEOLDNAME nvarchar(200),
                            @PRIMARYBUSINESSAUTOMATCH nvarchar(255),
                            @SPOUSESECURITYID uniqueidentifier,
                            @PRIMARYBUSINESSSECURITYID uniqueidentifier,
                            @ISORGANIZATIONUPDATE bit,
                            @SPOUSESITEID uniqueidentifier,
                            @PRIMARYBUSINESSSITEID uniqueidentifier,
                            @ADDITIONALADDRESSES xml,
                            @EMPLOYMENTHISTORY xml,
                            @EDUCATIONALHISTORY xml,
                            @EDUCATIONALINVOLVEMENTS xml,
                            @ATTRIBUTECURRENCYID uniqueidentifier,
                            @PHONENUMBERS xml,
              @EMAILADDRESSES xml,
              @ORGRELATIONSHIPS xml,
              @NAMEFORMATS xml
                        ) 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,
                                    [BBNCID] = @BBNCID,
                                    [BBNCTRANID] = @BBNCTRANID,
                                    [ADDEDBY] = @ADDEDBY,
                                    [PRIMARYBUSINESS] = @PRIMARYBUSINESS,
                                    [PRIMARYBUSINESSALLFIELDS] = @PRIMARYBUSINESSALLFIELDS,
                                    [PRIMARYBUSINESSUPDATE] = @PRIMARYBUSINESSUPDATE,
                                    [PRIMARYBUSINESSADD] = @PRIMARYBUSINESSADD,
                                    [PRIMARYBUSINESSMAKEPRIMARY] = @PRIMARYBUSINESSMAKEPRIMARY,
                                    [PRIMARYBUSINESSADDRESSTYPECODEID] = @PRIMARYBUSINESSADDRESSTYPECODEID,
                                    [BIOGRAPHICAL] = @BIOGRAPHICAL,
                                    [EDUCATION] = @EDUCATION,
                                    [PREFERREDADDRESS] = @PREFERREDADDRESS,
                                    [PREFERREDADDRESSALLFIELDS] = @PREFERREDADDRESSALLFIELDS,
                                    [PRIMARYBUSINESSORGANIZATIONLINKID] = @PRIMARYBUSINESSORGANIZATIONLINKID,
                                    [PREFERREDADDRESSUPDATE] = @PREFERREDADDRESSUPDATE,
                                    [PREFERREDADDRESSADD] = @PREFERREDADDRESSADD,
                                    [PREFERREDADDRESSMAKEPRIMARY] = @PREFERREDADDRESSMAKEPRIMARY,
                                    [PREFERREDADDRESSTYPECODEID] = @PREFERREDADDRESSTYPECODEID,
                                    [PHONETYPES] = @PHONETYPES,
                                    [SPOUSE] = @SPOUSE,
                                    [SPOUSEREMOVE] = @SPOUSEREMOVE,
                                    [SAMESPOUSE] = @SAMESPOUSE,
                                    [SPOUSELINKID] = @SPOUSELINKID,
                                    [SPOUSEOLDNAME] = @SPOUSEOLDNAME,
                                    [CONSTITUENTATTRIBUTES] = @CONSTITUENTATTRIBUTES,
                                    [EDUCATIONATTRIBUTES] = @EDUCATIONATTRIBUTES,
                                    [PRIMARYBUSINESSAUTOMATCH] = @PRIMARYBUSINESSAUTOMATCH,
                                    [SPOUSESECURITYID] = @SPOUSESECURITYID,
                                    [PRIMARYBUSINESSSECURITYID] = @PRIMARYBUSINESSSECURITYID,
                                    [ISORGANIZATIONUPDATE] = @ISORGANIZATIONUPDATE,
                                    [SPOUSESITEID] = @SPOUSESITEID,
                                    [PRIMARYBUSINESSSITEID] = @PRIMARYBUSINESSSITEID,
                                    [ADDITIONALADDRESSES] = @ADDITIONALADDRESSES,
                                    [EMPLOYMENTHISTORY] = @EMPLOYMENTHISTORY,
                                    [EDUCATIONALHISTORY] = @EDUCATIONALHISTORY,
                                    [EDUCATIONALINVOLVEMENTS] = @EDUCATIONALINVOLVEMENTS,
                                    [ATTRIBUTECURRENCYID] = @ATTRIBUTECURRENCYID,
                                    [PHONENUMBERS] = @PHONENUMBERS,
                  [EMAILADDRESSES] = @EMAILADDRESSES,
                  [ORGRELATIONSHIPS] = @ORGRELATIONSHIPS,
                  [NAMEFORMATS] = @NAMEFORMATS,
                                    [SEQUENCE] = @SEQUENCE,
                                    [CHANGEDBYID] = @CHANGEAGENTID,
                                    [DATECHANGED] = @CURRENTDATE                  
                                where ID = @ID;

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

                            return 0;