public ActionResult DelTxnAdj(NonFleetTxn _NonFleetTxn, CardnAccNo _CardnAcctNo) { _NonFleetTxn._CardnAccNo = _CardnAcctNo; var _deleteTxnAdj = objNonFleetTxnOps.DelNonFleetTxn(_NonFleetTxn); return(Json(new { resultCd = _deleteTxnAdj }, JsonRequestBehavior.AllowGet)); }
public async Task <ActionResult> SaveChangedStatus(ChangeStatus ChangeSts, CardnAccNo _CardNAcct) { ChangeSts._CardnAccNo = _CardNAcct; var _SaveChangedStatus = await CardHolderService.StatusSave(ChangeSts, GetUserId); return(Json(new { resultCd = _SaveChangedStatus }, JsonRequestBehavior.AllowGet)); }
public async Task <ActionResult> ftSKDSDetail(SKDS _SKDS, CardnAccNo _CardNAcctNo) { _SKDS._CardnAccNo = _CardNAcctNo; var data = (await CardAcctSignUpService.GetSKDSDetail(_SKDS._CardnAccNo.AccNo, _SKDS.ApplId, _SKDS.TxnId)).skds; return(Json(new { subs = data }, JsonRequestBehavior.AllowGet)); }
public async Task <ActionResult> SaveSKDS(SKDS _SKDS, CardnAccNo _CardnAcctNo) { _SKDS._CardnAccNo = _CardnAcctNo; _SKDS.UserId = GetUserId; var _SaveSkds = await CardAcctSignUpService.SaveSKDS(_SKDS); return(Json(new { result = _SaveSkds }, JsonRequestBehavior.AllowGet)); }
public async Task <ActionResult> SaveLocationAccept(LocationAcceptListModel _LocationAcceptList, CardnAccNo _CardnAcct) { _LocationAcceptList._CardnAccNo = _CardnAcct; var _saveLocationAccept = await CardHolderService.SaveLocationAccept(_LocationAcceptList, _CardnAcct.AccNo, _CardnAcct.CardNo, GetUserId); return(Json(new { resultCd = _saveLocationAccept }, JsonRequestBehavior.AllowGet)); }
public async Task <ActionResult> ftLocationList(jQueryDataTableParamModel Params, string AcctNo, CardnAccNo _CardnAccNo) { var _filtered = new List <LocationAcceptListModel>(); var list = (await CardHolderService.GetLocationAcceptances(AcctNo, _CardnAccNo.CardNo)).locationAccepts; if (!string.IsNullOrEmpty(Params.sSearch)) { Params.sSearch = Params.sSearch.ToLower(); } if (!string.IsNullOrEmpty(Params.sSearch)) { _filtered = list.Where(p => (!string.IsNullOrEmpty(p._CardnAccNo.CardNo) ? p._CardnAccNo.CardNo : string.Empty).ToLower().Contains(Params.sSearch) || (!string.IsNullOrEmpty(p.DBAName) ? p.DBAName : string.Empty).Contains(Params.sSearch) || (!string.IsNullOrEmpty(p.s_state) ? p.s_state : string.Empty).Contains(Params.sSearch) || (!string.IsNullOrEmpty(p.UserId) ? p.UserId : string.Empty).Contains(Params.sSearch) || (!string.IsNullOrEmpty(p.CreationDate) ? p.CreationDate : string.Empty).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._CardnAccNo.CardNo, x.DBAName, x.s_state, x.UserId, x.CreationDate }) }, JsonRequestBehavior.AllowGet)); }
public ActionResult SaveLocationAccept(LocationAcceptListModel _LocationAcceptList, CardnAccNo _CardnAcctNo) { var _saveLocationAccept = objCardHoldersOps.SaveLocationAccept(_LocationAcceptList); return(Json(new { resultCd = _saveLocationAccept }, JsonRequestBehavior.AllowGet)); }
public async Task <ActionResult> ftLocationList(jQueryDataTableParamModel Params, string AcctNo, CardnAccNo _CardnAccNo) { var list = await objCardHoldersOps.GetLocationAcceptance(AcctNo, _CardnAccNo); var filtered = list.Skip(Params.iDisplayStart).Take(Params.iDisplayLength); return(Json(new { sEcho = Params.sEcho, iTotalRecords = list.Count(), iTotalDisplayRecords = list.Count(), aaData = filtered.Select(x => new object[] { x._CardnAccNo.CardNo, x.DBAName, x.s_state, x.UserId, x.CreationDate }) }, JsonRequestBehavior.AllowGet)); }
public async Task <ActionResult> ftVelocityList(jQueryDataTableParamModel Params, VeloctyLimitListMaintModel VelocityList, CardnAccNo cardnAccNo) { VelocityList._CardnAccNo = cardnAccNo; var list = await objCardHoldersOps.VelocityList(VelocityList); var filtered = list.Skip(Params.iDisplayStart).Take(Params.iDisplayLength); return(Json(new { sEcho = Params.sEcho, iTotalRecords = list.Count(), iTotalDisplayRecords = list.Count(), aaData = filtered.Select(x => new object[] { x.VelocityIndDescp, x.ProdCdDescp, x.velocityCounter, x.ddlVelocityLimit, x.ddlVelocityLitre, x.SpentCnt, x.SpentLimit, x.SpentLitre, x.LastUpdateDate, x.UserId, x.CreationDate, x.SelectedVelocityInd, x.SelectedProdCd }) }, JsonRequestBehavior.AllowGet)); }
public async Task <ActionResult> ftSKDSList(jQueryDataTableParamModel Params, SKDS _SKDS, CardnAccNo _CardnAcct) { _SKDS._CardnAccNo = _CardnAcct; var _filtered = new List <SKDS>(); var list = (await CardAcctSignUpService.GetSKDSList(_SKDS._CardnAccNo.AccNo, _SKDS.ApplId, null)).skdses; if (!string.IsNullOrEmpty(Params.sSearch)) { Params.sSearch = Params.sSearch.ToLower(); } if (!string.IsNullOrEmpty(Params.sSearch)) { _filtered = list.Where(p => (!string.IsNullOrEmpty(p.SKDSNo) ? p.SKDSNo : string.Empty).ToLower().Contains(Params.sSearch) || (!string.IsNullOrEmpty(p.TxnId) ? p.TxnId : string.Empty).Contains(Params.sSearch) || (!string.IsNullOrEmpty(p.EffFromDate) ? p.EffFromDate : string.Empty).Contains(Params.sSearch) || (!string.IsNullOrEmpty(p.EffToDate) ? p.EffToDate : string.Empty).Contains(Params.sSearch) || (!string.IsNullOrEmpty(p.CreationDate) ? p.CreationDate : string.Empty).Contains(Params.sSearch) || (!string.IsNullOrEmpty(p.UserId) ? p.UserId : string.Empty).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.SKDSNo, x.SelectedSubsidyLevel, x.SKDSLitreQuota, x.EffFromDate, x.EffToDate, x.Refference, x.UserId, x.CreationDate, x.TxnId }) }, JsonRequestBehavior.AllowGet)); }
public async Task <ActionResult> SaveVelocityLimit(VeloctyLimitListMaintModel _VelocityLimitnList, string applId, CardnAccNo _cardnAcct, string Func) { _VelocityLimitnList._CardnAccNo = _cardnAcct; _VelocityLimitnList.UserId = GetUserId; var _saveCustAcctVelocity = await CardAcctSignUpService.SaveCustAcctVelocity(_VelocityLimitnList, applId, Func); return(Json(new { resultCd = _saveCustAcctVelocity }, JsonRequestBehavior.AllowGet)); }
public async Task <ActionResult> ftVelocityDetail(VeloctyLimitListMaintModel _VelocityLimit, CardnAccNo _CardnAcct) { _VelocityLimit._CardnAccNo = _CardnAcct; var data = (await CardAcctSignUpService.GetCustAcctVelocityDetail(_VelocityLimit)).veloctyLimit; return(Json(new { velocity = data }, JsonRequestBehavior.AllowGet)); }
public async Task <ActionResult> ftVelocityList(jQueryDataTableParamModel Params, VeloctyLimitListMaintModel _CustAcctVelocity, CardnAccNo cardnAccNo) { _CustAcctVelocity._CardnAccNo = cardnAccNo; var _filtered = new List <VeloctyLimitListMaintModel>(); var list = (await CardAcctSignUpService.GetCustAcctVelocityList(_CustAcctVelocity)).veloctyLimits; if (!string.IsNullOrEmpty(Params.sSearch)) { Params.sSearch = Params.sSearch.ToLower(); } if (!string.IsNullOrEmpty(Params.sSearch)) { _filtered = list.Where(p => (!string.IsNullOrEmpty(p.VelocityIndDescp) ? p.VelocityIndDescp : string.Empty).ToLower().Contains(Params.sSearch) || (!string.IsNullOrEmpty(p.SelectedProdCd) ? p.SelectedProdCd : string.Empty).Contains(Params.sSearch) || (!string.IsNullOrEmpty(p.velocityCounter) ? p.velocityCounter : string.Empty).Contains(Params.sSearch) || (!string.IsNullOrEmpty(p.ddlVelocityLimit) ? p.ddlVelocityLimit : string.Empty).Contains(Params.sSearch) || (!string.IsNullOrEmpty(p.ddlVelocityLitre.ToString()) ? p.ddlVelocityLitre.ToString() : string.Empty).Contains(Params.sSearch) || (!string.IsNullOrEmpty(p.LastUpdateDate) ? p.LastUpdateDate : string.Empty).Contains(Params.sSearch) || (!string.IsNullOrEmpty(p.UserId) ? p.UserId : string.Empty).Contains(Params.sSearch) || (!string.IsNullOrEmpty(p.CreationDate) ? p.CreationDate : string.Empty).Contains(Params.sSearch) || (!string.IsNullOrEmpty(p.SelectedVelocityInd) ? p.SelectedVelocityInd : string.Empty).Contains(Params.sSearch) || (!string.IsNullOrEmpty(p.SelectedProdCd) ? p.SelectedProdCd : string.Empty).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.SelectedVelocityInd, x.VelocityIndDescp, x.velocityCounter, x.ddlVelocityLimit, x.VelocityLitre, x.SpentCnt, x.SpentLimit, x.SpentLitre, x.LastUpdateDate, x.UserId, x.CreationDate, x.SelectedVelocityInd, x.SelectedProdCd })//, x.ddlVelocityLitre }, JsonRequestBehavior.AllowGet)); }
public async Task <List <LocationAcceptListModel> > GetLocationAcceptance(string AcctNo, CardnAccNo _CardnAccNo) { var objDataEngine = new FleetDataEngine(AccessMode.CustomerService, DBType.Maint); try { objDataEngine.InitiateConnection(); SqlParameter[] Parameters = new SqlParameter[3]; Parameters[0] = new SqlParameter("@IssNo", GetIssNo); Parameters[1] = String.IsNullOrEmpty(AcctNo) ? new SqlParameter("@AcctNo", DBNull.Value) : new SqlParameter("@AcctNo", AcctNo); Parameters[2] = String.IsNullOrEmpty(_CardnAccNo.CardNo) ? new SqlParameter("@CardNo", DBNull.Value) : new SqlParameter("@CardNo", _CardnAccNo.CardNo); var reader = await objDataEngine.ExecuteCommandAsync("WebLocationAcceptanceListSelect", CommandType.StoredProcedure, Parameters); var LocationList = new List <LocationAcceptListModel>(); while (reader.Read()) { LocationList.Add(new LocationAcceptListModel { //MerchantId = Convert.ToString(reader["Dealer"]), DBAName = Convert.ToString(reader["DBA Name"]), s_state = Convert.ToString(reader["DBA City"]), UserId = Convert.ToString(reader["User Id"]), CreationDate = Convert.ToString(reader["Creation Date"]), SiteId = Convert.ToString(reader["SiteId"]), BusnLoc = Convert.ToString(reader["MerchantId"]), }); } ; return(LocationList); } finally { objDataEngine.CloseConnection(); } }