Story

As an admin, I would like the C# method provided below converted to SQL to make it easier to troubleshoot and maintain

Details

FK_OnAccountSale is on tbCustomerOnAccountBalanceEvent table

we are looking for "CustomerOnAccountBalanceEvents" in CashDaySummary.cs file -> GetCustomerSalePayment method

here is the method needs to be converted to sql:

~\inform\CFACustom\Mx.CFA.Data\Repositories\OnAccountSaleRepository.cs

// code placeholder
 public IList<OnAccountSale> GetOnAccountSaleByDateRanges(long entityId, DateRange businessDateRange, DateRange timeRange)
        {
            IList<OnAccountSale> result;            OnAccountSale oasAlias = null;
            TransactionSummary tsAlias = null;
            OnAccountSalePayment payAlias = null;
            TransactionControlInfo tciAlias = null;            using (var tx = Session.BeginTransaction(IsolationLevel.ReadUncommitted))
            {
                Session.Clear();                var trans = Session.QueryOver(() => oasAlias)
                    .Where(o => o.EntityId == entityId)
                    .And(o => o.ReversalFlag != true)
                    .JoinAlias(() => oasAlias.TransactionSummary, () => tsAlias, JoinType.InnerJoin)
                    .JoinAlias(() => oasAlias.Payments, () => payAlias, JoinType.LeftOuterJoin)
                    .JoinAlias(() => payAlias.TransactionControlInfo, () => tciAlias, JoinType.LeftOuterJoin)
                    .Where(() => (tsAlias.BusinessDay >= businessDateRange.Start &&
                                  tsAlias.BusinessDay <= businessDateRange.End) ||
                                 (oasAlias.UncollectibleTimestamp >= timeRange.Start &&
                                  oasAlias.UncollectibleTimestamp < timeRange.End) ||
                                 (tciAlias.BusinessDay >= businessDateRange.Start &&
                                  tciAlias.BusinessDay <= businessDateRange.End))
                    .List<OnAccountSale>().Distinct().ToList();                result = trans;
                tx.Commit();
            }            Session.Evict(result);
            return result;
        }