USP_DATAFORMTEMPLATE_EDIT_SOLICITORCREDITRULES_2

Parameters

Parameter	Parameter Type	Mode
@CHANGEAGENTID	uniqueidentifier	IN
@PRIMARYMANAGERPERCENT	decimal(5, 2)	IN
@SECONDARYMANAGERPERCENT	decimal(5, 2)	IN
@SECONDARYSOLICITORPERCENT	decimal(5, 2)	IN
@APPLYTOPLEDGES	bit	IN
@APPLYTODONATIONS	bit	IN
@APPLYTOPLANNEDGIFTS	bit	IN
@APPLYTOGRANTAWARDS	bit	IN
@APPLYTOMATCHINGGIFTCLAIMS	bit	IN
Definition

Copy


create procedure dbo.USP_DATAFORMTEMPLATE_EDIT_SOLICITORCREDITRULES_2 (
    @CHANGEAGENTID uniqueidentifier,
    @PRIMARYMANAGERPERCENT decimal(5,2),
    @SECONDARYMANAGERPERCENT decimal(5,2),
    @SECONDARYSOLICITORPERCENT decimal(5,2),
    @APPLYTOPLEDGES bit,
    @APPLYTODONATIONS bit,
    @APPLYTOPLANNEDGIFTS bit,
    @APPLYTOGRANTAWARDS bit,
    @APPLYTOMATCHINGGIFTCLAIMS bit
)
as

    set nocount on;

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

    declare @CURRENTDATE datetime
    set @CURRENTDATE = getdate()
    declare @NUMROWS int

    begin try
        select @NUMROWS = COUNT(*) from dbo.SOLICITORCREDITRULES
        if @NUMROWS >= 1
            update dbo.SOLICITORCREDITRULES set
                PRIMARYMANAGERPERCENT = @PRIMARYMANAGERPERCENT,
                SECONDARYMANAGERPERCENT = @SECONDARYMANAGERPERCENT,
                SECONDARYSOLICITORPERCENT = @SECONDARYSOLICITORPERCENT,
                APPLYTOPLEDGES = @APPLYTOPLEDGES,
                APPLYTODONATIONS = @APPLYTODONATIONS,
                APPLYTOPLANNEDGIFTS = @APPLYTOPLANNEDGIFTS,
                APPLYTOGRANTAWARDS = @APPLYTOGRANTAWARDS,
                APPLYTOMATCHINGGIFTCLAIMS = @APPLYTOMATCHINGGIFTCLAIMS,
                CHANGEDBYID = @CHANGEAGENTID,
                DATECHANGED = @CURRENTDATE
        else
            insert into dbo.SOLICITORCREDITRULES
                (
                    PRIMARYMANAGERPERCENT,
                    SECONDARYMANAGERPERCENT,
                    SECONDARYSOLICITORPERCENT,
                    APPLYTOPLEDGES,
                    APPLYTODONATIONS,
                    APPLYTOPLANNEDGIFTS,
                    APPLYTOGRANTAWARDS,
                    APPLYTOMATCHINGGIFTCLAIMS,
                    ADDEDBYID,
                    CHANGEDBYID,
                    DATEADDED,
                    DATECHANGED
                )
                values
                (
                    @PRIMARYMANAGERPERCENT,
                    @SECONDARYMANAGERPERCENT,
                    @SECONDARYSOLICITORPERCENT,
                    @APPLYTOPLEDGES,
                    @APPLYTODONATIONS,
                    @APPLYTOPLANNEDGIFTS,
                    @APPLYTOGRANTAWARDS,
                    @APPLYTOMATCHINGGIFTCLAIMS,
                    @CHANGEAGENTID,
                    @CHANGEAGENTID,
                    @CURRENTDATE,
                    @CURRENTDATE
                )
    end try
    begin catch
        exec dbo.USP_RAISE_ERROR
        return 1
    end catch

return 0;