USP_DATALIST_CONSTITUENTPROFILEDASHBOARDEVENTS

                    CREATE procedure dbo.USP_DATALIST_CONSTITUENTPROFILEDASHBOARDEVENTS
                    (
                        @CONSTITUENTID uniqueidentifier,
                        @ISVISIBLE bit = 1,
                        @SELECTEDCURRENCYID uniqueidentifier = null
                    )
                    as
                        set nocount on;

                        if @ISVISIBLE = 1
                        begin
                            select
                                EVENT.NAME,
                                EVENT.[STARTDATE],
                                coalesce((select sum(dbo.UFN_REGISTRANTREGISTRATION_GETAMOUNTINCURRENCY(REGISTRANTREGISTRATION.ID, @SELECTEDCURRENCYID)) from dbo.REGISTRANTREGISTRATION where REGISTRANTREGISTRATION.REGISTRANTID = REGISTRANT.ID), 0) as AMOUNT,
                                coalesce((select sum(dbo.UFN_REVENUESPLIT_GETAMOUNTINCURRENCY(REVENUESPLIT.ID, @SELECTEDCURRENCYID)) from dbo.REVENUESPLIT inner join dbo.EVENTREGISTRANTPAYMENT on REVENUESPLIT.ID = EVENTREGISTRANTPAYMENT.PAYMENTID where EVENTREGISTRANTPAYMENT.REGISTRANTID = REGISTRANT.ID), 0) as AMOUNTPAID
                            from dbo.REGISTRANT
                            inner join dbo.EVENT on REGISTRANT.EVENTID = EVENT.ID
                            where REGISTRANT.CONSTITUENTID = @CONSTITUENTID;                                
                        end