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