spGet_DonorScrollerDonationsForSolicitor

            CREATE procedure [dbo].[spGet_DonorScrollerDonationsForSolicitor]
            (    
                @SolicitorID int,
                @Top int,
                @SortBy int             
            )
            as
            begin
                set nocount on

                select    top(@Top)

                        fd.[ID] DonationID,
                        fd.SolicitorID, 
                        fd.Amount,
                        fd.IsOffline,
                        fd.CurrencyType,
                        fd.IsAthon,
                        fd.InvoiceDate,
                        fd.InvoicePaid,
                        fd.PledgeID,
                        fd.GiftBackOfficeID,
                        dt.DonationTransactionsID, 
                        dt.XMLObjectData,
                        dt.DateAdded,
                        dt.processed_date DateProcessed,
                        dt.GiftPaymentMethod,
                        frs.AthonUnits
                from
                    dbo.Fundraiserdonations fd 
                    inner join dbo.FundraiserSolicitors frs on frs.id = fd.solicitorid
                    inner join dbo.DonationTransactions dt on dt.DonationTransactionsID = fd.DonationTransactionsID
                where
                    fd.SolicitorID = @SolicitorID and
                    (fd.IsAthon = 0 or fd.InvoicePaid = 0) and dt.IsDeleted = 0 and dt.Status = 1                    
                order by 
                    case
                        when @SortBy = 1 then case fd.IsAthon when 0 then fd.Amount else fd.Amount * frs.AthonUnits end 
                        when @SortBy = 3 then dt.DateAdded
                    end desc,
                    dt.LastName asc
            end