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)); }