USP_DATAFORMTEMPLATE_EDIT_CONSTITUENCYCRITERIAMAJORDONOR

Parameters

Parameter	Parameter Type	Mode
@CHANGEAGENTID	uniqueidentifier	IN
@MAJORDONORCONSTITUENCYDEFLIFETIMEAMOUNT	money	IN
@MAJORDONORCONSTITUENCYDEFLARGESTGIFTAMOUNT	money	IN

Definition

Copy


create procedure dbo.USP_DATAFORMTEMPLATE_EDIT_CONSTITUENCYCRITERIAMAJORDONOR 
(
    @CHANGEAGENTID uniqueidentifier = null,
    @MAJORDONORCONSTITUENCYDEFLIFETIMEAMOUNT money,
    @MAJORDONORCONSTITUENCYDEFLARGESTGIFTAMOUNT money
)
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.CONSTITUENCYCRITERIASPOUSE set
        MAJORDONORCONSTITUENCYDEFLIFETIMEAMOUNT = @MAJORDONORCONSTITUENCYDEFLIFETIMEAMOUNT,
        MAJORDONORCONSTITUENCYDEFLARGESTGIFTAMOUNT = @MAJORDONORCONSTITUENCYDEFLARGESTGIFTAMOUNT,
        CHANGEDBYID = @CHANGEAGENTID,
        DATECHANGED = @CURRENTDATE
end try
begin catch
    exec dbo.USP_RAISE_ERROR
    return 1
end catch

return 0;