USP_DATAFORMTEMPLATE_EDIT_CAMPAIGNHIERARCHYGOAL

The save procedure used by the edit dataform template "Campaign Hierarchy Goal Edit Form".
Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	IN	The input ID parameter indicating the ID of the record being edited.
@NAME	nvarchar(100)	IN	Name
@AMOUNT	money	IN	Amount
@STARTDATE	datetime	IN	Start date
@ENDDATE	datetime	IN	End date
@CHANGEAGENTID	uniqueidentifier	IN	Input parameter indicating the ID of the change agent invoking the procedure.
Definition

Copy


                    CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDIT_CAMPAIGNHIERARCHYGOAL (
                        @ID uniqueidentifier,
                        @NAME nvarchar(100),
                        @AMOUNT money,
                        @STARTDATE datetime,
                        @ENDDATE datetime,
                        @CHANGEAGENTID uniqueidentifier = null
                    ) as begin

                        set nocount on;

                        begin try

                            if @ID is null
                                set @ID = newid();

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

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

                            declare @BASECURRENCYID uniqueidentifier;
                            declare @DATEADDED datetime;
                            declare @CURRENCYEXCHANGERATEID uniqueidentifier;
                            declare @ORGANIZATIONAMOUNT money;
                            declare @ORGANIZATIONCURRENCYID uniqueidentifier;
                            set @ORGANIZATIONCURRENCYID = dbo.UFN_CURRENCY_GETORGANIZATIONCURRENCY();

                            select
                                @BASECURRENCYID = CAMPAIGN.BASECURRENCYID,
                                @DATEADDED = CAMPAIGNHIERARCHYGOAL.DATEADDED,
                                @CURRENCYEXCHANGERATEID = CAMPAIGNHIERARCHYGOAL.CURRENCYEXCHANGERATEID
                            from
                                dbo.CAMPAIGNHIERARCHYGOAL
                                left join dbo.CAMPAIGN on CAMPAIGNHIERARCHYGOAL.CAMPAIGNID = CAMPAIGN.ID
                            where
                                CAMPAIGNHIERARCHYGOAL.ID = @ID;

                            if (@ORGANIZATIONCURRENCYID = @BASECURRENCYID)
                            begin
                                set @ORGANIZATIONAMOUNT = @AMOUNT;
                            end
                            else
                            begin
                                if @CURRENCYEXCHANGERATEID is null
                                    set @CURRENCYEXCHANGERATEID = dbo.UFN_CURRENCYEXCHANGERATE_GETLATEST(@BASECURRENCYID, @ORGANIZATIONCURRENCYID, @DATEADDED, 0, null);

                                set @ORGANIZATIONAMOUNT = dbo.UFN_CURRENCY_CONVERT(@AMOUNT, @CURRENCYEXCHANGERATEID);
                            end

                            update 
                                dbo.CAMPAIGNHIERARCHYGOAL
                            set
                                NAME = @NAME,
                                AMOUNT = @AMOUNT,
                                STARTDATE = @STARTDATE,
                                ENDDATE = @ENDDATE,
                                ORGANIZATIONAMOUNT = @ORGANIZATIONAMOUNT,
                                CURRENCYEXCHANGERATEID = @CURRENCYEXCHANGERATEID,
                                CHANGEDBYID = @CHANGEAGENTID,
                                DATECHANGED = @CURRENTDATE
                            where
                                CAMPAIGNHIERARCHYGOAL.ID = @ID;

                        end try
                        begin catch
                            exec dbo.USP_RAISE_ERROR;
                            return 1;
                        end catch

                        return 0;

                    end