TR_PLANNEDGIFTADDITION_INSERTUPDATE_CURRENCY (Trigger)

          
                      CREATE trigger [dbo].[TR_PLANNEDGIFTADDITION_INSERTUPDATE_CURRENCY] on [dbo].[PLANNEDGIFTADDITION] 
                    after insert, update
                    not for replication
                    as
                    begin
                        set nocount on;
                          
                        declare @ORGANIZATIONCURRENCYID uniqueidentifier = dbo.UFN_CURRENCY_GETORGANIZATIONCURRENCY(); 

                        -- if we try to save an amount without explicitly setting an organization amount and an exchange rate, 

                        -- copy the amount to the organization amount.

                        if update(EXPECTEDGIFTAMOUNT) or update(RECOGNITIONAMOUNT)
                        begin
                            update
                                dbo.PLANNEDGIFTADDITION
                            set
                                PLANNEDGIFTADDITION.ORGANIZATIONEXPECTEDGIFTAMOUNT = PLANNEDGIFTADDITION.EXPECTEDGIFTAMOUNT,
                                PLANNEDGIFTADDITION.TRANSACTIONEXPECTEDGIFTAMOUNT = PLANNEDGIFTADDITION.EXPECTEDGIFTAMOUNT,

                                PLANNEDGIFTADDITION.ORGANIZATIONRECOGNITIONAMOUNT = PLANNEDGIFTADDITION.RECOGNITIONAMOUNT,
                                PLANNEDGIFTADDITION.TRANSACTIONRECOGNITIONAMOUNT = PLANNEDGIFTADDITION.RECOGNITIONAMOUNT,

                                PLANNEDGIFTADDITION.BASECURRENCYID = @ORGANIZATIONCURRENCYID,
                                PLANNEDGIFTADDITION.TRANSACTIONCURRENCYID = @ORGANIZATIONCURRENCYID,
                                PLANNEDGIFTADDITION.CHANGEDBYID = PLANNEDGIFTADDITION.CHANGEDBYID,
                                PLANNEDGIFTADDITION.DATECHANGED = PLANNEDGIFTADDITION.DATECHANGED
                            from
                                inserted
                            inner join
                                dbo.PLANNEDGIFTADDITION on inserted.ID = PLANNEDGIFTADDITION.ID
                            where
                                PLANNEDGIFTADDITION.ORGANIZATIONEXCHANGERATEID is null
                                and (PLANNEDGIFTADDITION.BASECURRENCYID is null or PLANNEDGIFTADDITION.BASECURRENCYID = @ORGANIZATIONCURRENCYID)
                                and PLANNEDGIFTADDITION.BASEEXCHANGERATEID is null
                                and (PLANNEDGIFTADDITION.TRANSACTIONCURRENCYID is null or PLANNEDGIFTADDITION.TRANSACTIONCURRENCYID = @ORGANIZATIONCURRENCYID)
                                and
                                (
                                    PLANNEDGIFTADDITION.ORGANIZATIONEXPECTEDGIFTAMOUNT <> PLANNEDGIFTADDITION.EXPECTEDGIFTAMOUNT
                                    or PLANNEDGIFTADDITION.TRANSACTIONEXPECTEDGIFTAMOUNT <> PLANNEDGIFTADDITION.EXPECTEDGIFTAMOUNT

                                    or PLANNEDGIFTADDITION.ORGANIZATIONRECOGNITIONAMOUNT <> PLANNEDGIFTADDITION.RECOGNITIONAMOUNT
                                    or PLANNEDGIFTADDITION.TRANSACTIONRECOGNITIONAMOUNT <> PLANNEDGIFTADDITION.RECOGNITIONAMOUNT
                                    
                                    or (
                                        PLANNEDGIFTADDITION.EXPECTEDGIFTAMOUNT = 0
                                        and PLANNEDGIFTADDITION.RECOGNITIONAMOUNT = 0
                                    )
                                );
                        end
                    end