USP_DATAFORMTEMPLATE_EDIT_REGISTRANT_EXTENSION_2

The save procedure used by the edit dataform template "Registrant Extension 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.
@REGISTRANTID	uniqueidentifier	IN	Registrant
@FUNDRAISINGGOAL	money	IN	Fundraisinggoal
@ADVOCACYACTIONGOAL	int	IN	Advocacyactiongoal
@MEMBERECRUITMENTGOAL	int	IN	Memberecruitmentgoal
@COMMUNICATIONGOAL	int	IN	Communicationgoal
@VOLUNTEERRECRUITMENTGOAL	int	IN	Volunteerrecruitmentgoal
@TARGETFUNDRAISINGGOAL	money	IN	TargetFundraisingGoal
@DONORRETENTIONGOAL	decimal(5, 2)	IN	DonorRetentionGoal
@OTHERUNITGOAL	int	IN	OtherUnitGoal
@ISPRIVATE	bit	IN	IsPrivate
@ALLOWADMINACCESSHQ	bit	IN	AllowAdminAccessHQ
@ISDASHBOARDHELPERVISIBLE	bit	IN	IsDashboardHelperVisible

Definition

Copy


CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDIT_REGISTRANT_EXTENSION_2
(
    @ID uniqueidentifier,
    @CHANGEAGENTID uniqueidentifier = null,
  @REGISTRANTID uniqueidentifier,
  @FUNDRAISINGGOAL money,
  @ADVOCACYACTIONGOAL int,
  @MEMBERECRUITMENTGOAL int,
  @COMMUNICATIONGOAL int,
  @VOLUNTEERRECRUITMENTGOAL int,
@TARGETFUNDRAISINGGOAL money,
    @DONORRETENTIONGOAL decimal(5,2),
    @OTHERUNITGOAL int,
    @ISPRIVATE bit,
  @ALLOWADMINACCESSHQ bit,
  @ISDASHBOARDHELPERVISIBLE bit
)
as

    set nocount on;

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

    begin try
        -- handle updating the data
        update dbo.REGISTRANTEXTENSION set
      REGISTRANTID = @REGISTRANTID,
      FUNDRAISINGGOAL = @FUNDRAISINGGOAL,
      ADVOCACYACTIONGOAL = @ADVOCACYACTIONGOAL,
      MEMBERECRUITMENTGOAL = @MEMBERECRUITMENTGOAL,
      COMMUNICATIONGOAL = @COMMUNICATIONGOAL,
      VOLUNTEERRECRUITMENTGOAL = @VOLUNTEERRECRUITMENTGOAL,
            TARGETFUNDRAISINGGOAL = @TARGETFUNDRAISINGGOAL,
            DONORRETENTIONGOAL = @DONORRETENTIONGOAL,
            OTHERUNITGOAL = @OTHERUNITGOAL,
            ISPRIVATE = @ISPRIVATE,
      ALLOWADMINACCESSHQ = @ALLOWADMINACCESSHQ,
      ISDASHBOARDHELPERVISIBLE = @ISDASHBOARDHELPERVISIBLE,
            CHANGEDBYID = @CHANGEAGENTID,
            DATECHANGED = getdate()
        where ID = @ID
    end try
    begin catch
        exec dbo.USP_RAISE_ERROR
        return 1
    end catch

return 0;