public async Task <ActionResult> WebAcctSOASumm(AcctSOA _AcctSOA)
{
var accountSOA = (await AccountSOAOpService.GetAcctSOASummSelect(_AcctSOA.AcctNo)).acctSOASummary;
var AcctSOA = Mapper.Map <AcctSOA>(accountSOA);
return(Json(AcctSOA, JsonRequestBehavior.AllowGet));
}
public async Task <JsonResult> WebAcctSOATxnCategoryList(AcctSOA _AcctSOA, jQueryDataTableParamModel Params)
{
var _filtered = new List <AcctSOA>();
var acctSOA = await AccountSOAOpService.GetAcctSOATxnCategoryList(_AcctSOA.AcctNo, _AcctSOA.SelectedStmtDate);
var list = Mapper.Map <List <AcctSOA> >(acctSOA);
if (!string.IsNullOrEmpty(Params.sSearch))
{
Params.sSearch = Params.sSearch.ToLower();
}
if (!string.IsNullOrEmpty(Params.sSearch))
{
_filtered = list.Where(p => (!string.IsNullOrEmpty(p.TxnCode) ? p.TxnCode : string.Empty).ToLower().Contains(Params.sSearch) ||
(!string.IsNullOrEmpty(p.TxnEventCd) ? p.TxnEventCd : string.Empty).ToLower().Contains(Params.sSearch) ||
(!string.IsNullOrEmpty(p.TxnDesc) ? p.TxnDesc : string.Empty).ToLower().Contains(Params.sSearch) ||
(!string.IsNullOrEmpty(p.TotalCount) ? p.TotalCount : string.Empty).ToLower().Contains(Params.sSearch) ||
(!string.IsNullOrEmpty(p.TotalAmt) ? p.TotalAmt : string.Empty).ToLower().Contains(Params.sSearch) ||
(!string.IsNullOrEmpty(p.TotalItemQty) ? p.TotalItemQty : string.Empty).ToLower().Contains(Params.sSearch) ||
(!string.IsNullOrEmpty(p.TotalItemAmt) ? p.TotalItemAmt : string.Empty).ToLower().Contains(Params.sSearch) ||
(!string.IsNullOrEmpty(p.SelectedStmtDate) ? p.SelectedStmtDate : string.Empty).ToLower().Contains(Params.sSearch) ||
(!string.IsNullOrEmpty(p.CompanyName) ? p.CompanyName : string.Empty).ToLower().Contains(Params.sSearch) ||
(!string.IsNullOrEmpty(p.AcctNo) ? p.AcctNo : string.Empty).ToLower().Contains(Params.sSearch)).ToList();
_filtered = _filtered.Skip(Params.iDisplayStart).Take(Params.iDisplayLength).ToList();
}
else
{
_filtered = list.Skip(Params.iDisplayStart).Take(Params.iDisplayLength).ToList();
}
return(Json(new
{
sEcho = Params.sEcho,
iTotalRecords = list.Count(),
iTotalDisplayRecords = list.Count(),
aaData = _filtered.Select(x => new object[] {
x.TxnCode,
x.TxnEventCd,
x.TxnDesc,
x.TotalCount,
x.TotalAmt,
x.TotalItemQty,
x.TotalItemAmt,
x.SelectedStmtDate,
x.CompanyName,
x.AcctNo
})
}, JsonRequestBehavior.AllowGet));
}
/*
* public async Task<AcctSOA> WebAcctSOASummSelect(AcctSOA _AcctSOA)
* {
* var objDataEngine = new FleetDataEngine(AccessMode.CustomerService, DBType.Maint);
* try
* {
* await objDataEngine.InitiateConnectionAsync();
* SqlParameter[] Parameters = new SqlParameter[1];
* Parameters[0] = String.IsNullOrEmpty(_AcctSOA.AcctNo) ? new SqlParameter("@AcctNo", DBNull.Value) : new SqlParameter("@AcctNo", _AcctSOA.AcctNo);
*
* var Reader = await objDataEngine.ExecuteCommandAsync("WebAcctSOASummSelect", CommandType.StoredProcedure, Parameters);
*
* while (Reader.Read())
* {
*
* var _AcctSOASelect = new AcctSOA
* {
* CompanyID = Convert.ToString(Reader["Company Id"]),
* CompanyName = Convert.ToString(Reader["Company Name"]),
* BasicCard = Convert.ToString(Reader["Basic Card"]),
* SelectedStmtDate = Convert.ToString(Reader["Cycle Date"]),
* LastAgeCd = Convert.ToString(Reader["Last Age Code"]),
* CreditLimit = ConverterDecimal(Reader["Credit Limit"]),
* OpeningBal = ConverterDecimal(Reader["Opening Balance"]),
* MTDDebits = ConverterDecimal(Reader["MTD Debits"]),
* AvaiCredLimits = ConverterDecimal(Reader["Available Credit Limit"]),
* CurrBalance = ConverterDecimal(Reader["Current Balance"]),
* MTDCreds = ConverterDecimal(Reader["MTD Credits"]),
* TotMinimumPymt = Convert.ToString(Reader["Total Minimun Payment"]),
* CrrtDueMinimumOymt = ConverterDecimal(Reader["Current Due Minimun Payment"]),
* PastDueMinimumPymt = Convert.ToString(Reader["Past Due Minimun Payment"]),
* PymtDueDate = Convert.ToString(Reader["Payment DueDate"]),
* LastPymtDate = Convert.ToString(Reader["Last Payment Date"]),
* LastPymtAmt = ConverterDecimal(Reader["Last Payment Amount"])
* };
* return _AcctSOASelect;
* }
* return new AcctSOA();
* }
* finally
* {
* objDataEngine.CloseConnection();
*
* }
* }
*/
/*
* public async Task<List<AcctSOA>> WebAcctSOASummList(AcctSOA _AcctSOA)
* {
* var objDataEngine = new FleetDataEngine(AccessMode.CustomerService, DBType.Maint);
*
* try
* {
* objDataEngine.InitiateConnection();
* SqlParameter[] Parameters = new SqlParameter[1];
* Parameters[0] = String.IsNullOrEmpty(_AcctSOA.AcctNo) ? new SqlParameter("@AcctNo", DBNull.Value) : new SqlParameter("@AcctNo", _AcctSOA.AcctNo);
*
* var execResult = await objDataEngine.ExecuteCommandAsync("WebAcctSOASummList", CommandType.StoredProcedure, Parameters);
*
* var _SOAList = new List<AcctSOA>();
* while (execResult.Read())
* {
*
* _SOAList.Add(new AcctSOA
* {
* Month = Convert.ToString(execResult["Mth"]),
* SelectedStmtDate = Convert.ToString(execResult["Statement Date"]),
* ClseBalance = Convert.ToString(execResult["Closing Balance"]),
* MinimumPayment = Convert.ToString(execResult["Minimun Payment"]),
* Debits = Convert.ToString(execResult["Debits"]),
* Credits = Convert.ToString(execResult["Credits"]),
* Sales = Convert.ToString(execResult["Sales"]),
* DBAdjust = Convert.ToString(execResult["DB adjustment"]),
* Charges = Convert.ToString(execResult["Charges"]),
* Payment = Convert.ToString(execResult["Payment"]),
* CRAdjust = Convert.ToString(execResult["CR Adjustment"]),
* age = Convert.ToString(execResult["Age"]),
* Rchq = Convert.ToString(execResult["RChq"]),
* Lpay = Convert.ToString(execResult["Lpay"]),
* Rv = Convert.ToString(execResult["Rv"]),
* Dun = Convert.ToString(execResult["Dun"])
* });
* };
* return _SOAList;
* }
* finally
* {
* objDataEngine.CloseConnection();
* }
*
*
* }
*/
/*
* public async Task<List<AcctSOA>> WebAcctSOATxnCategoryList(AcctSOA _AcctSOA)
* {
* var objDataEngine = new FleetDataEngine(AccessMode.CustomerService, DBType.Maint);
*
* try
* {
* objDataEngine.InitiateConnection();
* SqlParameter[] Parameters = new SqlParameter[2];
* Parameters[0] = String.IsNullOrEmpty(_AcctSOA.AcctNo) ? new SqlParameter("@AcctNo", DBNull.Value) : new SqlParameter("@AcctNo", _AcctSOA.AcctNo);
* Parameters[1] = String.IsNullOrEmpty(_AcctSOA.SelectedStmtDate) ? new SqlParameter("@StmtDate", DBNull.Value) : new SqlParameter("@StmtDate", _AcctSOA.SelectedStmtDate);
*
* var execResult = await objDataEngine.ExecuteCommandAsync("WebAcctSOATxnCategoryList", CommandType.StoredProcedure, Parameters);
*
* var _SOATxnCategoryList = new List<AcctSOA>();
* while (execResult.Read())
* {
*
* _SOATxnCategoryList.Add(new AcctSOA
* {
* TxnCode = Convert.ToString(execResult["Transaction Code"]),
* TxnEventCd = Convert.ToString(execResult["Transaction Event Code"]),
* TxnDesc = Convert.ToString(execResult["Transaction Desc"]),
* TotalCount = Convert.ToString(execResult["Total Count"]),
* TotalAmt = ConverterDecimal(execResult["Total Amount"]),
* TotalItemQty =Convert.ToString(execResult["Total Item Quantity"]),
* TotalItemAmt = ConverterDecimal(execResult["Total Item Amount"]),
* SelectedStmtDate = Convert.ToString(execResult["Statement Date"]),
* CompanyName = Convert.ToString(execResult["Company Name"]),
* AcctNo = Convert.ToString(execResult["Account No"]),
* });
* };
* return _SOATxnCategoryList;
* }
* finally
* {
* objDataEngine.CloseConnection();
* }
* }
*/
public async Task <List <AcctSOA> > WebAcctSOATxnList(AcctSOA _AcctSOA)
{
var objDataEngine = new FleetDataEngine(AccessMode.CustomerService, DBType.Maint);
try
{
objDataEngine.InitiateConnection();
SqlParameter[] Parameters = new SqlParameter[3];
Parameters[0] = String.IsNullOrEmpty(_AcctSOA.AcctNo) ? new SqlParameter("@AcctNo", DBNull.Value) : new SqlParameter("@AcctNo", _AcctSOA.AcctNo);
Parameters[1] = String.IsNullOrEmpty(_AcctSOA.SelectedStmtDate) ? new SqlParameter("@StmtDate", DBNull.Value) : new SqlParameter("@StmtDate", _AcctSOA.SelectedStmtDate);
Parameters[2] = String.IsNullOrEmpty(_AcctSOA.TxnCode) ? new SqlParameter("@TxnCd", DBNull.Value) : new SqlParameter("@TxnCd", _AcctSOA.TxnCode);
var execResult = await objDataEngine.ExecuteCommandAsync("WebAcctSOATxnList", CommandType.StoredProcedure, Parameters);
var _SOATxnList = new List <AcctSOA>();
while (execResult.Read())
{
_SOATxnList.Add(new AcctSOA
{
//CompanyName = Convert.ToString(execResult["Company Name"]),
CardHolderNo = Convert.ToString(execResult["CardHolder No"]),
DriverCardNo = Convert.ToString(execResult["Driver Card No"]),
TxnDate = Convert.ToString(execResult["Transaction Date"]),
txnTime = Convert.ToString(execResult["Transaction Time"]),
PostDate = Convert.ToString(execResult["Post Date"]),
TxnCode = Convert.ToString(execResult["Txn Code"]),
Curr = Convert.ToString(execResult["Curr"]),
TxnAmt = ConverterDecimal(execResult["Transaction Amount"]),
Amt = ConverterDecimal(execResult["Amount"]),
ChqRefNo = Convert.ToString(execResult["Chq Ref No"]),
MerchantID = Convert.ToString(execResult["Merchant ID"]),
MerchantName = Convert.ToString(execResult["Merchant Name"]),
DBAName = Convert.ToString(execResult["Trading Name Description"]),
MCC = Convert.ToString(execResult["Mcc"]),
RRn = Convert.ToString(execResult["RRN"]),
});
}
;
return(_SOATxnList);
}
finally
{
objDataEngine.CloseConnection();
}
}
public async Task <JsonResult> WebAcctSOASummList(AcctSOA _AcctSOA, jQueryDataTableParamModel Params)
{
var _filtered = new List <AcctSOA>();
var list = Mapper.Map <List <AcctSOA> >((await AccountSOAOpService.GetAcctSOASummList(_AcctSOA.AcctNo)).AcctSOASummaryLst);
if (!string.IsNullOrEmpty(Params.sSearch))
{
Params.sSearch = Params.sSearch.ToLower();
}
if (!string.IsNullOrEmpty(Params.sSearch))
{
_filtered = list.Where(p => (!string.IsNullOrEmpty(p.Month) ? p.Month : string.Empty).ToLower().Contains(Params.sSearch) ||
(!string.IsNullOrEmpty(p.SelectedStmtDate) ? p.SelectedStmtDate : string.Empty).ToLower().Contains(Params.sSearch) ||
(!string.IsNullOrEmpty(p.ClseBalance) ? p.ClseBalance : string.Empty).ToLower().Contains(Params.sSearch) ||
(!string.IsNullOrEmpty(p.MinimumPayment) ? p.MinimumPayment : string.Empty).ToLower().Contains(Params.sSearch) ||
(!string.IsNullOrEmpty(p.Debits) ? p.Debits : string.Empty).ToLower().Contains(Params.sSearch) ||
(!string.IsNullOrEmpty(p.Credits) ? p.Credits : string.Empty).ToLower().Contains(Params.sSearch) ||
(!string.IsNullOrEmpty(p.Sales) ? p.Sales : string.Empty).ToLower().Contains(Params.sSearch) ||
(!string.IsNullOrEmpty(p.DBAdjust) ? p.DBAdjust : string.Empty).ToLower().Contains(Params.sSearch) ||
(!string.IsNullOrEmpty(p.Payment) ? p.Payment : string.Empty).ToLower().Contains(Params.sSearch) ||
(!string.IsNullOrEmpty(p.age) ? p.age : string.Empty).ToLower().Contains(Params.sSearch) ||
(!string.IsNullOrEmpty(p.Rchq) ? p.Rchq : string.Empty).ToLower().Contains(Params.sSearch) ||
(!string.IsNullOrEmpty(p.Lpay) ? p.Lpay : string.Empty).ToLower().Contains(Params.sSearch) ||
(!string.IsNullOrEmpty(p.Dun) ? p.Dun : string.Empty).ToLower().Contains(Params.sSearch) ||
(!string.IsNullOrEmpty(p.Rv) ? p.Rv : string.Empty).ToLower().Contains(Params.sSearch)).ToList();
_filtered = _filtered.Skip(Params.iDisplayStart).Take(Params.iDisplayLength).ToList();
}
else
{
_filtered = list.Skip(Params.iDisplayStart).Take(Params.iDisplayLength).ToList();
}
return(Json(new
{
sEcho = Params.sEcho,
iTotalRecords = list.Count(),
iTotalDisplayRecords = list.Count(),
aaData = _filtered.Select(x => new object[] { x.Month, x.SelectedStmtDate, x.ClseBalance, x.MinimumPayment, x.Debits, x.Credits, x.Sales, x.DBAdjust, x.Charges, x.Payment, x.CRAdjust, x.age, x.Rchq, x.Lpay, x.Rv, x.Dun })
}, JsonRequestBehavior.AllowGet));
}
public async Task <JsonResult> WebAcctSOATxnList(AcctSOA _AcctSOA, jQueryDataTableParamModel Params)
{
// await objAccountSOAOps.WebAcctSOATxnList(_AcctSOA);
var _filtered = new List <AcctSOA>();
var data = await AccountSOAOpService.GetAcctSOATxnList(_AcctSOA.AcctNo, _AcctSOA.SelectedStmtDate, _AcctSOA.TxnCode);
var list = Mapper.Map <List <AcctSOA> >(data);
if (!string.IsNullOrEmpty(Params.sSearch))
{
Params.sSearch = Params.sSearch.ToLower();
}
if (!string.IsNullOrEmpty(Params.sSearch))
{
_filtered = list.Where(p => (!string.IsNullOrEmpty(p.CardHolderNo) ? p.CardHolderNo : string.Empty).ToLower().Contains(Params.sSearch) ||
(!string.IsNullOrEmpty(p.DriverCardNo) ? p.DriverCardNo : string.Empty).ToLower().Contains(Params.sSearch) ||
(!string.IsNullOrEmpty(p.TxnDate) ? p.TxnDate : string.Empty).ToLower().Contains(Params.sSearch) ||
(!string.IsNullOrEmpty(p.txnTime) ? p.txnTime : string.Empty).ToLower().Contains(Params.sSearch) ||
(!string.IsNullOrEmpty(p.PostDate) ? p.PostDate : string.Empty).ToLower().Contains(Params.sSearch) ||
(!string.IsNullOrEmpty(p.TxnCode) ? p.TxnCode : string.Empty).ToLower().Contains(Params.sSearch) ||
(!string.IsNullOrEmpty(p.Curr) ? p.Curr : string.Empty).ToLower().Contains(Params.sSearch) ||
(!string.IsNullOrEmpty(p.TxnAmt) ? p.TxnAmt : string.Empty).ToLower().Contains(Params.sSearch) ||
(!string.IsNullOrEmpty(p.Amt) ? p.Amt : string.Empty).ToLower().Contains(Params.sSearch) ||
(!string.IsNullOrEmpty(p.MerchantName) ? p.MerchantName : string.Empty).ToLower().Contains(Params.sSearch) ||
(!string.IsNullOrEmpty(p.MCC) ? p.MCC : string.Empty).ToLower().Contains(Params.sSearch) ||
(!string.IsNullOrEmpty(p.ChqRefNo) ? p.ChqRefNo : string.Empty).ToLower().Contains(Params.sSearch)).ToList();
_filtered = _filtered.Skip(Params.iDisplayStart).Take(Params.iDisplayLength).ToList();
}
else
{
_filtered = list.Skip(Params.iDisplayStart).Take(Params.iDisplayLength).ToList();
}
return(Json(new
{
sEcho = Params.sEcho,
iTotalRecords = list.Count(),
iTotalDisplayRecords = list.Count(),
aaData = _filtered.Select(x => new object[] {
x.CardHolderNo,
x.MerchantID,
x.DriverCardNo,
x.MerchantName,
x.TxnDate,
x.txnTime,
x.PostDate,
x.DBAName,
x.TxnCode,
x.MCC,
x.Curr,
x.TxnAmt,
x.Amt,
x.RRn,
x.ChqRefNo,
//x.CompanyName,
})
}, JsonRequestBehavior.AllowGet));
}
