USP_DATAFORMTEMPLATE_EDIT_MAJORDONORLIFECYCLECRITERIA

The save procedure used by the edit dataform template "Major Donor Lifecycle 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.
@USEMAJORDONORSINGLEGIFT	bit	IN	Constituents with a single donation greater than or equal to a specific amount are 'Major donors'.
@MAJORDONORSINGLEGIFTAMOUNT	money	IN	Minimum donation amount
@USEMAJORDONORLIFETIMEGIVING	bit	IN	Constituents with lifetime giving greater than or equal to a specific amount are 'Major donors'.
@MAJORDONORLIFETIMEGIVINGAMOUNT	money	IN	Minimum lifetime giving amount
@INCLUDEMAJORDONORPROSPECTS	bit	IN	Constituents with a constituency of 'Major donor prospect' are 'Major donors' even if they have not yet donated.
@PLANNEDGIFTMUSTHAVEPAYMENTS	bit	IN	PLANNEDGIFTMUSTHAVEPAYMENTS

Definition

Copy



CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDIT_MAJORDONORLIFECYCLECRITERIA (
    @ID uniqueidentifier,
    @CHANGEAGENTID uniqueidentifier = null,
    @USEMAJORDONORSINGLEGIFT bit,
    @MAJORDONORSINGLEGIFTAMOUNT money,
    @USEMAJORDONORLIFETIMEGIVING bit,
    @MAJORDONORLIFETIMEGIVINGAMOUNT money,
    @INCLUDEMAJORDONORPROSPECTS bit,
    @PLANNEDGIFTMUSTHAVEPAYMENTS 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.REVENUELIFECYCLECRITERIA
        set
            USEMAJORDONORSINGLEGIFT = @USEMAJORDONORSINGLEGIFT,
            MAJORDONORSINGLEGIFTAMOUNT = @MAJORDONORSINGLEGIFTAMOUNT,
            USEMAJORDONORLIFETIMEGIVING = @USEMAJORDONORLIFETIMEGIVING,
            MAJORDONORLIFETIMEGIVINGAMOUNT = @MAJORDONORLIFETIMEGIVINGAMOUNT,
            INCLUDEMAJORDONORPROSPECTS = @INCLUDEMAJORDONORPROSPECTS,
            PLANNEDGIFTMUSTHAVEPAYMENTS = @PLANNEDGIFTMUSTHAVEPAYMENTS,
            CHANGEDBYID = @CHANGEAGENTID,
            DATECHANGED = @CURRENTDATE
        where 
            ID = @ID
    end try
    begin catch
        exec dbo.USP_RAISE_ERROR
        return 1
    end catch

return 0;