USP_DATAFORMTEMPLATE_EDIT_FUNDRAISINGGOALBASECURRENCY

The save procedure used by the edit dataform template "Fundraising Goal Base Currency 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.
@BASECURRENCYID	uniqueidentifier	IN	Base currency

Definition

Copy



create procedure dbo.USP_DATAFORMTEMPLATE_EDIT_FUNDRAISINGGOALBASECURRENCY
(
  @ID uniqueidentifier,
  @CHANGEAGENTID uniqueidentifier = null,
  @BASECURRENCYID uniqueidentifier
)
as

    set nocount on;

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

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

    begin try
        declare @OLDBASECURRENCYID uniqueidentifier;
        select 
            @OLDBASECURRENCYID = GROUPGOAL.BASECURRENCYID
        from 
            dbo.GROUPGOAL
        where
            GROUPGOAL.ID = @ID;

        update dbo.GROUPGOAL set
            GROUPGOAL.BASECURRENCYID = @BASECURRENCYID,
            GROUPGOAL.CHANGEDBYID = @CHANGEAGENTID,
            GROUPGOAL.DATECHANGED = @CURRENTDATE
        where
            GROUPGOAL.ID = @ID;

        --If the user saves without changing the base currency, don't update org amounts.

        if @OLDBASECURRENCYID <> @BASECURRENCYID
        begin
            declare @ORGANIZATIONCURRENCYID uniqueidentifier = dbo.UFN_CURRENCY_GETORGANIZATIONCURRENCY()
            declare @DATEADDED datetime;
            select @DATEADDED = GROUPGOAL.DATEADDED from dbo.GROUPGOAL where GROUPGOAL.ID = @ID;

            --If the new base currency is the org currency, org amount equals amount, so don't bother getting

            --  an exchange rate or doing a conversion.

            if @BASECURRENCYID = @ORGANIZATIONCURRENCYID
                update 
                    dbo.GROUPGOAL
                set
                    GROUPGOAL.ORGANIZATIONAMOUNT = GROUPGOAL.AMOUNT,
                    GROUPGOAL.ORGANIZATIONEXCHANGERATEID = null,
                    GROUPGOAL.CHANGEDBYID = @CHANGEAGENTID,
                    GROUPGOAL.DATECHANGED = @CURRENTDATE
                where
                    GROUPGOAL.ID = @ID;
            else --Base currency has changed and isn't the org currency

            begin
                declare @CURRENCYEXCHANGERATEID uniqueidentifier = dbo.UFN_CURRENCYEXCHANGERATE_GETLATEST(@BASECURRENCYID, @ORGANIZATIONCURRENCYID, @DATEADDED, 0, null);

                update dbo.GROUPGOAL
                set
                    GROUPGOAL.ORGANIZATIONAMOUNT = dbo.UFN_CURRENCY_CONVERT(GROUPGOAL.AMOUNT, @CURRENCYEXCHANGERATEID),
                    GROUPGOAL.ORGANIZATIONEXCHANGERATEID = @CURRENCYEXCHANGERATEID,
                    GROUPGOAL.CHANGEDBYID = @CHANGEAGENTID,
                    GROUPGOAL.DATECHANGED = @CURRENTDATE
                where
                    GROUPGOAL.ID = @ID;
            end
        end
    end try
    begin catch
        exec dbo.USP_RAISE_ERROR
        return 1
    end catch

    return 0;