USP_DATAFORMTEMPLATE_EDIT_BBNCFUNDRAISERBATCHROW

The save procedure used by the edit dataform template "NetCommunity Fundraiser 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.
@NETCOMMUNITYTRANSACTIONPROCESSORID	uniqueidentifier	IN	Processor
@BBNCTRANID	int	IN	Blackbaud Internet Solutions transaction ID
@BBNCAPPEALID	int	IN	Blackbaud Internet Solutions appeal ID
@APPEALID	uniqueidentifier	IN	Appeal hidden
@NEWTEAMS	int	IN	New teams hidden
@NEWTEAMFUNDRAISERS	int	IN	New team fundraisers hidden
@CHANGEDTEAMS	int	IN	Changed teams hidden
@CHANGEDTEAMFUNDRAISERS	int	IN	Changed team fundraisers hidden
@TEAMS	xml	IN	Teams hidden
@TEAMFUNDRAISERS	xml	IN	Team fundraisers hidden
@SEQUENCE	int	IN	Sequence

Definition

Copy



                    CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDIT_BBNCFUNDRAISERBATCHROW
                    (
                        @ID uniqueidentifier,
                        @CHANGEAGENTID uniqueidentifier,
                        @NETCOMMUNITYTRANSACTIONPROCESSORID uniqueidentifier,
                        @BBNCTRANID int,
                        @BBNCAPPEALID int,
                        @APPEALID uniqueidentifier,
                        @NEWTEAMS int,
                        @NEWTEAMFUNDRAISERS int,
                        @CHANGEDTEAMS int,
                        @CHANGEDTEAMFUNDRAISERS int,
                        @TEAMS xml,
                        @TEAMFUNDRAISERS 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.BATCHBBNCFUNDRAISER
                            set
                                [NETCOMMUNITYTRANSACTIONPROCESSORID] = @NETCOMMUNITYTRANSACTIONPROCESSORID,
                                [BBNCTRANID] = @BBNCTRANID,
                                [BBNCAPPEALID] = @BBNCAPPEALID,
                                [APPEALID] = @APPEALID,
                                [NEWTEAMS] = @NEWTEAMS,
                                [NEWTEAMFUNDRAISERS] = @NEWTEAMFUNDRAISERS,
                                [CHANGEDTEAMS] = @CHANGEDTEAMS,
                                [CHANGEDTEAMFUNDRAISERS] = @CHANGEDTEAMFUNDRAISERS,
                                [TEAMS] = @TEAMS,
                                [TEAMFUNDRAISERS] = @TEAMFUNDRAISERS,
                                [SEQUENCE] = @SEQUENCE,
                                [CHANGEDBYID] = @CHANGEAGENTID,
                                [DATECHANGED] = @CURRENTDATE
                            where ID = @ID;

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

                        return 0;