public Int32 getPaymentCount(DailyTransactionRange range) { var result = _databaseConnection.Query <Int32>(@"SELECT count(*) FROM TRANSACTIONS T WHERE T.TYPE NOT IN ('S','C','D') and amount <> 0 and t.status <> 'D' and TRAN_NUM >= :startTran and TRAN_NUM <= :EndTran", new { StartTran = range.FromTxn, EndTran = range.ToTxn }); return(result.DefaultIfEmpty(0).FirstOrDefault <Int32>()); }
public List <Int32> getRefundTransactionIds(DailyTransactionRange range) { var result = _databaseConnection.Query <Int32>(@" SELECT T.TRAN_NUM FROM TRANSACTIONS T WHERE T.TYPE = 'D' and T.adjustment_type is not null and T.impacts = 'C' and amount <> 0 and t.status <> 'D' and TRAN_NUM >= :startTran and TRAN_NUM <= :EndTran ", new { StartTran = range.FromTxn, EndTran = range.ToTxn }); return(result.ToList <Int32>()); }
public List <Int32> getPaymentTransactionIds(DailyTransactionRange range) { var result = _databaseConnection.Query <Int32>(@" SELECT T.TRAN_NUM FROM TRANSACTIONS T WHERE T.TYPE NOT IN ('S','C','D','F') and amount <> 0 and t.status <> 'D' and tran_num >= :StartTran and tran_num <= :EndTran ", new { StartTran = range.FromTxn, EndTran = range.ToTxn }); return(result.ToList <Int32>()); }