USP_TOGGLEINCLUDEGRANTS_UPDATE

Executes the "Toggle Include Grants: Update" record operation.

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	IN	Input parameter indicating the ID of the record being updated.
@CHANGEAGENTID	uniqueidentifier	IN	Input parameter indicating the ID of the change agent invoking the update.

Definition

Copy



                    CREATE procedure dbo.USP_TOGGLEINCLUDEGRANTS_UPDATE
                    (
                        @ID uniqueidentifier,
                        @CHANGEAGENTID uniqueidentifier = null
                    )
                    as begin
                        declare @CURRENTDATE datetime = getdate();

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


                        if exists (select ID from MAJORGIVINGCONFIGURATION)
                        begin 
                            update dbo.MAJORGIVINGCONFIGURATION
                            set INCLUDEGRANTS = 
                                case
                                    when (dbo.UFN_GETINCLUDEGRANTS() = 0) then 1
                                    else 0
                                end,
                                CHANGEDBYID = @CHANGEAGENTID,
                                DATECHANGED = @CURRENTDATE;
                        end
                        else
                        begin
                            insert into dbo.MAJORGIVINGCONFIGURATION
                                (INCLUDEGRANTS, ADDEDBYID, CHANGEDBYID, DATEADDED, DATECHANGED)
                            values
                                (1, @CHANGEAGENTID, @CHANGEAGENTID, @CURRENTDATE, @CURRENTDATE)
                        end

                    end