USP_DATAFORMTEMPLATE_ADD_UPDATEMULTIPLECONSTITUENTSFROMMFO_COMMIT

The save procedure used by the add dataform template "Update Constituents From MatchFinder Online Batch Commit Add Form".

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	INOUT	The output parameter indicating the ID of the record added.
@CURRENTAPPUSERID	uniqueidentifier	IN	Input parameter indicating the ID of the current user.
@VALIDATEONLY	bit	IN	Validate only
@BATCHNUMBER	nvarchar(100)	IN
@CHANGEAGENTID	uniqueidentifier	IN	Input parameter indicating the ID of the change agent invoking the procedure.
@ORGANIZATIONID	uniqueidentifier	IN	Linked constituent
@MATCHFINDERRECORDID	int	IN	MatchFinder record
@UPDATEORGNAME	bit	IN	Update org name
@MFORGNAME	nvarchar(100)	IN	MF org name
@UPDATEALIAS	bit	IN	Update alias
@MFALIAS	nvarchar(100)	IN	MF alias
@UPDATEINDUSTRY	bit	IN	Update industry
@MFINDUSTRY	nvarchar(100)	IN	MF industry
@UPDATEADDRESS	bit	IN	Update address
@MFADDRESSBLOCK	nvarchar(150)	IN	MF address block
@MFCITY	nvarchar(50)	IN	MF city
@MFSTATE	nvarchar(100)	IN	MF state
@MFSTATEID	uniqueidentifier	IN	MF state ID
@MFCOUNTRY	nvarchar(100)	IN	MF country
@MFCOUNTRYID	uniqueidentifier	IN	MF country ID
@MFPOSTCODE	nvarchar(12)	IN	MF postcode
@UPDATEPHONE	bit	IN	Update phone number
@MFPHONE	nvarchar(100)	IN	MF phone number
@UPDATEFAX	bit	IN	Update fax number
@MFFAX	nvarchar(100)	IN	MF fax number
@UPDATEWEBADDRESS	bit	IN	Update web address
@MFWEBADDRESS	nvarchar(2047)	IN	MF web address
@CREATENEWCONTACT	bit	IN
@UPDATECONTACT	bit	IN
@CONTACTLINKID	uniqueidentifier	IN
@UPDATECONTACTNAME	bit	IN
@MFCONTACTFIRSTNAME	nvarchar(100)	IN
@MFCONTACTLASTNAME	nvarchar(100)	IN
@UPDATECONTACTEMAIL	bit	IN
@MFCONTACTEMAIL	nvarchar(100)	IN
@UPDATEMATCHINGFACTOR	bit	IN	Update matching factor
@MFMATCHINGFACTOR	decimal(5, 2)	IN	MF matching factor
@UPDATEMINMATCHPERGIFT	bit	IN	Update min match per gift
@MFMINMATCHPERGIFT	money	IN	MF min match per gift
@UPDATEMAXMATCHPERGIFT	bit	IN	Update max match per gift
@MFMAXMATCHPERGIFT	money	IN	MF max match per gift
@UPDATEMAXMATCHANNUAL	bit	IN	Update max match per year
@MFMAXMATCHANNUAL	money	IN	MF max match per year
@UPDATEMAXMATCHTOTAL	bit	IN	Update max match total
@MFMAXMATCHTOTAL	money	IN	MF max match total
@UPDATEMATCHNOTES	bit	IN	Update match notes
@MFMATCHNOTES	nvarchar(max)	IN	MF match notes

Definition

Copy


                    CREATE procedure dbo.USP_DATAFORMTEMPLATE_ADD_UPDATEMULTIPLECONSTITUENTSFROMMFO_COMMIT
                    (
                        @ID uniqueidentifier = null output,
                        @CURRENTAPPUSERID uniqueidentifier,
                        @VALIDATEONLY bit,
                        @BATCHNUMBER nvarchar(100),
                        @CHANGEAGENTID uniqueidentifier,
                        @ORGANIZATIONID uniqueidentifier,
                        @MATCHFINDERRECORDID int,

                        @UPDATEORGNAME bit = 0,
                        @MFORGNAME nvarchar(100) = '',

                        @UPDATEALIAS bit = 0,
                        @MFALIAS nvarchar(100) = '',

                        @UPDATEINDUSTRY bit = 0,
                        @MFINDUSTRY nvarchar(100) = '',

                        @UPDATEADDRESS bit = 0,
                        @MFADDRESSBLOCK nvarchar(150) = '',
                        @MFCITY nvarchar(50) = '',
                        @MFSTATE nvarchar(100) = '',
                        @MFSTATEID uniqueidentifier = null,
                        @MFCOUNTRY nvarchar(100) = '',
                        @MFCOUNTRYID uniqueidentifier = null,
                        @MFPOSTCODE nvarchar(12) = '',

                        @UPDATEPHONE bit = 0,
                        @MFPHONE nvarchar(100) = '',

                        @UPDATEFAX bit = 0,
                        @MFFAX nvarchar(100) = '',

                        @UPDATEWEBADDRESS bit = 0,
                        @MFWEBADDRESS nvarchar(2047) = '',

                        @CREATENEWCONTACT bit = 0,
                        @UPDATECONTACT bit = 0,
                        @CONTACTLINKID uniqueidentifier = null,

                        @UPDATECONTACTNAME bit = 0,
                        @MFCONTACTFIRSTNAME nvarchar(100) = '',
                        @MFCONTACTLASTNAME nvarchar(100) = '',

                        @UPDATECONTACTEMAIL bit = 0,
                        @MFCONTACTEMAIL nvarchar(100) = '',

                        @UPDATEMATCHINGFACTOR bit = 0,
                        @MFMATCHINGFACTOR decimal(5,2) = 0.0,

                        @UPDATEMINMATCHPERGIFT bit = 0,
                        @MFMINMATCHPERGIFT money = 0,

                        @UPDATEMAXMATCHPERGIFT bit = 0,
                        @MFMAXMATCHPERGIFT money = 0,

                        @UPDATEMAXMATCHANNUAL bit = 0,
                        @MFMAXMATCHANNUAL money = 0,

                        @UPDATEMAXMATCHTOTAL bit = 0,
                        @MFMAXMATCHTOTAL money = 0,

                        @UPDATEMATCHNOTES bit = 0,
                        @MFMATCHNOTES nvarchar(max) = ''
                    )
                    as
                    set nocount on;

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

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

                    begin try
                        if @VALIDATEONLY = 0
                        begin

                            exec dbo.USP_MATCHFINDER_LINKCONSTITUENTTOMATCHFINDER
                                @CONSTITUENTID = @ORGANIZATIONID,
                                @MATCHFINDERRECORDID = @MATCHFINDERRECORDID,
                                @CHANGEAGENTID = @CHANGEAGENTID,
                                @CHANGEDATE = @CHANGEDATE;

                            exec dbo.USP_MATCHFINDER_UPDATECONSTITUENT
                                @APPUSERID = @CURRENTAPPUSERID,
                                @CONSTITUENTID = @ORGANIZATIONID,
                                @UPDATEORGNAME = @UPDATEORGNAME,
                                @NEWORGNAME = @MFORGNAME,
                                @UPDATEADDRESS = @UPDATEADDRESS,
                                @NEWADDRESSBLOCK = @MFADDRESSBLOCK,
                                @NEWCITY = @MFCITY,
                                @NEWSTATEID = @MFSTATEID,
                                @NEWCOUNTRYID = @MFCOUNTRYID,
                                @NEWPOSTCODE = @MFPOSTCODE,
                                @UPDATEPHONE = @UPDATEPHONE,
                                @NEWPHONE = @MFPHONE,
                                @UPDATEFAX = @UPDATEFAX,
                                @NEWFAX = @MFFAX,
                                @UPDATEWEBADDRESS = @UPDATEWEBADDRESS,
                                @NEWWEBADDRESS = @MFWEBADDRESS,
                                @UPDATEALIAS = @UPDATEALIAS,
                                @NEWALIAS = @MFALIAS,
                                @UPDATEINDUSTRY = @UPDATEINDUSTRY,
                                @NEWINDUSTRY = @MFINDUSTRY,
                                @UPDATEMATCHINGFACTOR = @UPDATEMATCHINGFACTOR,
                                @NEWMATCHINGFACTOR = @MFMATCHINGFACTOR,
                                @UPDATEMINMATCHPERGIFT = @UPDATEMINMATCHPERGIFT,
                                @NEWMINMATCHPERGIFT = @MFMINMATCHPERGIFT,
                                @UPDATEMAXMATCHPERGIFT = @UPDATEMAXMATCHPERGIFT,
                                @NEWMAXMATCHPERGIFT = @MFMAXMATCHPERGIFT,
                                @UPDATEMAXMATCHTOTAL = @UPDATEMAXMATCHTOTAL,
                                @NEWMAXMATCHTOTAL = @MFMAXMATCHTOTAL,
                                @UPDATEMAXMATCHANNUAL = @UPDATEMAXMATCHANNUAL,
                                @NEWMAXMATCHANNUAL = @MFMAXMATCHANNUAL,
                                @UPDATEMATCHNOTES = @UPDATEMATCHNOTES,
                                @NEWMATCHNOTES = @MFMATCHNOTES,

                                @CREATENEWCONTACT = @CREATENEWCONTACT,
                                @UPDATECONTACT = @UPDATECONTACT,
                                @CONTACTLINKID = @CONTACTLINKID,
                                @UPDATECONTACTNAME = @UPDATECONTACTNAME,
                                @CONTACTFIRSTNAME = @MFCONTACTFIRSTNAME,
                                @CONTACTMIDDLENAME = N'',
                                @CONTACTKEYNAME = @MFCONTACTLASTNAME,
                                @UPDATECONTACTEMAIL = @UPDATECONTACTEMAIL,
                                @NEWCONTACTEMAIL = @MFCONTACTEMAIL,

                                @CHANGEAGENTID = @CHANGEAGENTID,
                                @CHANGEDATE = @CHANGEDATE;

                                set @ID = @ORGANIZATIONID;
                        end
                    end try
                    begin catch
                        exec dbo.USP_RAISE_ERROR;
                        return 1;
                    end catch

                    return 0;