USP_DATAFORMTEMPLATE_EDIT_UPDATEMULTIPLECONSTITUENTSFROMMFO_BATCHROW

The save procedure used by the edit dataform template "Update Constituents From MatchFinder Online 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.
@ORGANIZATIONID	uniqueidentifier	IN	Linked constituent
@MATCHFINDERRECORDID	int	IN	MatchFinder record id
@UPDATEORGNAME	bit	IN
@MFORGNAME	nvarchar(100)	IN	MF org name
@UPDATEALIAS	bit	IN
@MFALIAS	nvarchar(100)	IN	MF alias
@UPDATEINDUSTRY	bit	IN
@MFINDUSTRY	nvarchar(100)	IN	MF industry
@UPDATEADDRESS	bit	IN
@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
@MFPHONE	nvarchar(100)	IN	MF phone number
@UPDATEFAX	bit	IN
@MFFAX	nvarchar(100)	IN	MF fax number
@UPDATEWEBADDRESS	bit	IN
@MFWEBADDRESS	nvarchar(2047)	IN	MF web address
@CREATENEWCONTACT	bit	IN
@UPDATECONTACT	bit	IN
@CONTACTLINKID	uniqueidentifier	IN
@UPDATECONTACTNAME	bit	IN
@MFCONTACTNAME	nvarchar(150)	IN
@MFCONTACTFIRSTNAME	nvarchar(150)	IN
@MFCONTACTLASTNAME	nvarchar(150)	IN
@UPDATECONTACTEMAIL	bit	IN
@MFCONTACTEMAIL	nvarchar(100)	IN
@UPDATEMATCHINGFACTOR	bit	IN
@MFMATCHINGFACTOR	decimal(5, 2)	IN	MF matching factor
@UPDATEMINMATCHPERGIFT	bit	IN
@MFMINMATCHPERGIFT	money	IN	MF min match per gift
@UPDATEMAXMATCHPERGIFT	bit	IN
@MFMAXMATCHPERGIFT	money	IN	MF max match per gift
@UPDATEMAXMATCHANNUAL	bit	IN
@MFMAXMATCHANNUAL	money	IN	MF max match per year
@UPDATEMAXMATCHTOTAL	bit	IN
@MFMAXMATCHTOTAL	money	IN	MF max match total
@UPDATEMATCHNOTES	bit	IN
@MFMATCHNOTES	nvarchar(max)	IN	MF match notes
@SEQUENCE	int	IN	Sequence

Definition

Copy


                    CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDIT_UPDATEMULTIPLECONSTITUENTSFROMMFO_BATCHROW
                    (
                        @ID uniqueidentifier,
                        @CHANGEAGENTID uniqueidentifier,
                        @ORGANIZATIONID uniqueidentifier,
                        @MATCHFINDERRECORDID int,

                        @UPDATEORGNAME bit,
                        @MFORGNAME nvarchar(100),

                        @UPDATEALIAS bit,
                        @MFALIAS nvarchar(100),

                        @UPDATEINDUSTRY bit,
                        @MFINDUSTRY nvarchar(100),

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

                        @UPDATEPHONE bit,
                        @MFPHONE nvarchar(100),

                        @UPDATEFAX bit,
                        @MFFAX nvarchar(100),

                        @UPDATEWEBADDRESS bit,
                        @MFWEBADDRESS nvarchar(2047),

                        @CREATENEWCONTACT bit,
                        @UPDATECONTACT bit,
                        @CONTACTLINKID uniqueidentifier,

                        @UPDATECONTACTNAME bit,
                        @MFCONTACTNAME nvarchar(150),
                        @MFCONTACTFIRSTNAME nvarchar(150),
                        @MFCONTACTLASTNAME nvarchar(150),

                        @UPDATECONTACTEMAIL bit,
                        @MFCONTACTEMAIL nvarchar(100),

                        @UPDATEMATCHINGFACTOR bit,
                        @MFMATCHINGFACTOR decimal(5,2),

                        @UPDATEMINMATCHPERGIFT bit,
                        @MFMINMATCHPERGIFT money,

                        @UPDATEMAXMATCHPERGIFT bit,
                        @MFMAXMATCHPERGIFT money,

                        @UPDATEMAXMATCHANNUAL bit,
                        @MFMAXMATCHANNUAL money,

                        @UPDATEMAXMATCHTOTAL bit,
                        @MFMAXMATCHTOTAL money,

                        @UPDATEMATCHNOTES bit,
                        @MFMATCHNOTES nvarchar(max),
                        @SEQUENCE int
                    )
                    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.UPDATEMULTIPLECONSTITUENTSFROMMFOBATCH
                            set CONSTITUENTID = @ORGANIZATIONID,
                                UPDATEORGNAME = @UPDATEORGNAME,
                                UPDATEALIAS = @UPDATEALIAS,
                                UPDATEINDUSTRY = @UPDATEINDUSTRY,
                                UPDATEADDRESS = @UPDATEADDRESS,
                                UPDATEPHONE = @UPDATEPHONE,
                                UPDATEWEBADDRESS = @UPDATEWEBADDRESS,
                                UPDATEFAX = @UPDATEFAX,
                                UPDATEMATCHINGFACTOR = @UPDATEMATCHINGFACTOR,
                                UPDATEMINMATCHPERGIFT = @UPDATEMINMATCHPERGIFT,
                                UPDATEMAXMATCHPERGIFT = @UPDATEMAXMATCHPERGIFT,
                                UPDATEMAXMATCHANNUAL = @UPDATEMAXMATCHANNUAL,
                                UPDATEMAXMATCHTOTAL = @UPDATEMAXMATCHTOTAL,
                                UPDATEMATCHNOTES = @UPDATEMATCHNOTES,
                                CREATENEWCONTACT = @CREATENEWCONTACT,
                                UPDATECONTACT = @UPDATECONTACT,
                                CONTACTLINKID = @CONTACTLINKID,
                                UPDATECONTACTNAME = @UPDATECONTACTNAME,
                                UPDATECONTACTEMAIL = @UPDATECONTACTEMAIL,
                                SEQUENCE = @SEQUENCE,
                                CHANGEDBYID = @CHANGEAGENTID,
                                DATECHANGED  = @CHANGEDATE
                        where ID = @ID;
                    end try
                    begin catch
                        exec dbo.USP_RAISE_ERROR
                        return 1;
                    end catch

                    return 0;