USP_DATAFORMTEMPLATE_EDIT_PLANNEDGIFTVEHICLEOPTIONS

The save procedure used by the edit dataform template "Planned Gift Vehicle Options Edit Data 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.
@AUTOCALCULATEREALIZEDAMOUNT	bit	IN	Auto-calculate realized amount

Definition

Copy



          CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDIT_PLANNEDGIFTVEHICLEOPTIONS
          (
            @ID uniqueidentifier,
            @CHANGEAGENTID uniqueidentifier = null,
            @AUTOCALCULATEREALIZEDAMOUNT bit
          )
          as
            set nocount on;

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

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

            begin try
              update dbo.PLANNEDGIFTVEHICLEOPTIONS 
              set
                AUTOCALCULATEREALIZEDAMOUNT = @AUTOCALCULATEREALIZEDAMOUNT,
                CHANGEDBYID = @CHANGEAGENTID,
                DATECHANGED = @CURRENTDATE
              where ID = @ID;
            end try
            begin catch
              exec dbo.USP_RAISE_ERROR;
              return 1;
            end catch

            return 0;