public async Task <ActionResult> GetFraudCustomerDetailsList(string AcctNo, string EventId)
{
var customerDetailsShowList = (await FraudOpService.FraudCustomerDetailsByacctNoEventId(AcctNo, EventId)).fraudCustomerDetails;
return(Json(
new
{
model = customerDetailsShowList.Select(x => new object[] { x.CmpyName1, x.AccountType, x.ClientType, x.AgeingDays,
x.Month1Date, x.Month2Date, x.Month3Date, x.Month4Date, x.Month5Date, x.Month6Date, x.AvgSalesDisplay }).FirstOrDefault(),
aaData = customerDetailsShowList.Select(x => new object[] { x.Month1Amt, x.Month2Amt, x.Month3Amt, x.Month4Amt, x.Month5Amt, x.Month6Amt, x.AvgSales })
}
, JsonRequestBehavior.AllowGet));
}
public async Task <ActionResult> GetFraudTxnSearch(jQueryDataTableParamModel Params, FraudTxnDisputeViewModel _FraudTxnDisputeViewModel, string IsPostedDispute)
{
var _filtered = new List <FraudTxnDisputeViewModel>();
var list = (await FraudOpService.GetFraudDisputeTxnSearch(NumberExtensions.ConvertLongToDb(_FraudTxnDisputeViewModel.EventId), Convert.ToInt32(IsPostedDispute), _FraudTxnDisputeViewModel.SelectedTxnCategory, _FraudTxnDisputeViewModel.SelectedTxnCd, _FraudTxnDisputeViewModel.AcctNo, _FraudTxnDisputeViewModel.SelectedCardNo, _FraudTxnDisputeViewModel.FromDate, _FraudTxnDisputeViewModel.ToDate)).fraudTxnDisputes;
_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[] { null, x.TxnId, x.TxnDesp, x.TxnDate, x.AuthCardNo,
x.VehRegNo, x.Stan, x.RRn, x.BSNLocation, x.BSNLocationName, x.TermId, x.TxnAmt })
}, JsonRequestBehavior.AllowGet));
}
public async Task <ActionResult> FTGetFraudCaseList(jQueryDataTableParamModel Params)
{
var _filtered = new List <FraudCaseListViewModel>();
var list = (await FraudOpService.GetFraudCases()).fraudCases;
if (!string.IsNullOrEmpty(Params.sSearch))
{
Params.sSearch = Params.sSearch.ToLower();
}
if (!string.IsNullOrEmpty(Params.sSearch))
{
_filtered = list.Where(p => (!string.IsNullOrEmpty(p.EventId.ToString()) ? p.EventId.ToString() : string.Empty).ToLower().Contains(Params.sSearch) ||
(!string.IsNullOrEmpty(p.RefKey) ? p.RefKey : string.Empty).ToLower().Contains(Params.sSearch) ||
(!string.IsNullOrEmpty(p.e_Descp) ? p.e_Descp : string.Empty).ToLower().Contains(Params.sSearch) ||
(!string.IsNullOrEmpty(p.CloseDate) ? p.CloseDate : string.Empty).ToLower().Contains(Params.sSearch) ||
(!string.IsNullOrEmpty(p.LastUpdDate) ? p.LastUpdDate : string.Empty).ToLower().Contains(Params.sSearch) ||
(!string.IsNullOrEmpty(p.CreatedBy) ? p.CreatedBy : string.Empty).ToLower().Contains(Params.sSearch) ||
(!string.IsNullOrEmpty(p.CreationDate) ? p.CreationDate : string.Empty).ToLower().Contains(Params.sSearch) ||
(!string.IsNullOrEmpty(p.et_Descp) ? p.et_Descp : string.Empty).ToLower().Contains(Params.sSearch) ||
(!string.IsNullOrEmpty(p.CmpyName1) ? p.CmpyName1 : 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.EventId, x.et_Descp, x.RefKey, x.CmpyName1, x.e_Descp, x.CloseDate, x.UserId, x.LastUpdDate, x.CreatedBy, x.CreationDate })
}, JsonRequestBehavior.AllowGet));
}
public async Task <ActionResult> GetCardDetailsList_ByAcctNoCardNo(FraudCardDetailsViewModel _FraudCardDetailsViewModel)
{
try
{
FraudCards fraudCards = _FraudCardDetailsViewModel.FraudCards[0];
var cardNoes = new List <string>();
if (_FraudCardDetailsViewModel.FraudCards.Count() > 0)
{
foreach (var item in _FraudCardDetailsViewModel.FraudCards)
{
cardNoes.Add(item.SelectedCardNo);
}
}
var listFraudIncident = (await FraudOpService.GetFraudCardDetailsList(cardNoes, _FraudCardDetailsViewModel.AcctNo, null, fraudCards)).fraudCardDetails;
var CardMonth1Date = listFraudIncident.Where(s => !string.IsNullOrEmpty(s.CardMonth1Date)).Distinct().Select(s => s.CardMonth1Date).FirstOrDefault();
var CardMonth2Date = listFraudIncident.Where(s => !string.IsNullOrEmpty(s.CardMonth2Date)).Distinct().Select(s => s.CardMonth2Date).FirstOrDefault();
var CardMonth3Date = listFraudIncident.Where(s => !string.IsNullOrEmpty(s.CardMonth3Date)).Distinct().Select(s => s.CardMonth3Date).FirstOrDefault();
var CardMonth4Date = listFraudIncident.Where(s => !string.IsNullOrEmpty(s.CardMonth4Date)).Distinct().Select(s => s.CardMonth4Date).FirstOrDefault();
var CardMonth5Date = listFraudIncident.Where(s => !string.IsNullOrEmpty(s.CardMonth5Date)).Distinct().Select(s => s.CardMonth5Date).FirstOrDefault();
var CardMonth6Date = listFraudIncident.Where(s => !string.IsNullOrEmpty(s.CardMonth6Date)).Distinct().Select(s => s.CardMonth6Date).FirstOrDefault();
var CardAvgSalesDisplay = listFraudIncident.Where(s => !string.IsNullOrEmpty(s.CardAvgSalesDisplay)).Distinct().Select(s => s.CardAvgSalesDisplay).FirstOrDefault();
return(Json(
new
{
model = new object[] { CardMonth1Date, CardMonth2Date, CardMonth3Date, CardMonth4Date, CardMonth5Date, CardMonth6Date, CardAvgSalesDisplay },
aaData = listFraudIncident.Select(x => new object[] { x.FraudCards[0].SelectedCardNo, x.CardMonth1Amt, x.CardMonth2Amt, x.CardMonth3Amt, x.CardMonth4Amt, x.CardMonth5Amt, x.CardMonth6Amt, x.CardAvgSales, x.SingleTxn, x.DailyTxn, x.MonthlyTxn })
}
, JsonRequestBehavior.AllowGet));
}
catch (Exception ex)
{
return(null);
}
}
public async Task <JsonResult> FillData(string Prefix, string EventId)
{
try
{
switch (Prefix.ToLower())
{
case "details":
string Enum_NatureOfIncident = Convert.ToString(En.NatureOfIncident.O);
//load/bind dropdown
var DropdownFraudIncidentsViewModel = new FraudIncidentsViewModel
{
ReportedVia = await BaseService.GetRefLib("ReportVia"),
NextStatus = await BaseService.GetRefLib("FraudSts"),
NatureOfIncident = await BaseService.GetRefLib("NtfIncidentType"),
InvestigatedBy = await FraudOpService.GetFraudDropdown((int)En.FraudSection.IncidentInvestigationTeam, "Y", null, null, null)
};
var fraudMainViewModel = (await FraudOpService.GetFraudByEventId(EventId)).webFraudDetail;
//get customer sale list
var customerDetailsShowList = (await FraudOpService.FraudCustomerDetailsByacctNoEventId(fraudMainViewModel.FraudCustomerDetailsViewModel.AcctNo, EventId)).fraudCustomerDetails;
var cardNoLst = (await FraudOpService.GetCardNoListByAcctNo((int)En.FraudSection.CardDetails, "Y", null, fraudMainViewModel.FraudCustomerDetailsViewModel.AcctNo, EventId)).fraudCard;
var cardDetailsShowList = (await FraudOpService.GetFraudCardDetailsList(null, fraudMainViewModel.FraudCustomerDetailsViewModel.AcctNo, EventId, cardNoLst)).fraudCardDetails;
var CardMonth1Date = cardDetailsShowList.Where(s => !string.IsNullOrEmpty(s.CardMonth1Date)).Distinct().Select(s => s.CardMonth1Date).FirstOrDefault();
var CardMonth2Date = cardDetailsShowList.Where(s => !string.IsNullOrEmpty(s.CardMonth2Date)).Distinct().Select(s => s.CardMonth2Date).FirstOrDefault();
var CardMonth3Date = cardDetailsShowList.Where(s => !string.IsNullOrEmpty(s.CardMonth3Date)).Distinct().Select(s => s.CardMonth3Date).FirstOrDefault();
var CardMonth4Date = cardDetailsShowList.Where(s => !string.IsNullOrEmpty(s.CardMonth4Date)).Distinct().Select(s => s.CardMonth4Date).FirstOrDefault();
var CardMonth5Date = cardDetailsShowList.Where(s => !string.IsNullOrEmpty(s.CardMonth5Date)).Distinct().Select(s => s.CardMonth5Date).FirstOrDefault();
var CardMonth6Date = cardDetailsShowList.Where(s => !string.IsNullOrEmpty(s.CardMonth6Date)).Distinct().Select(s => s.CardMonth6Date).FirstOrDefault();
var CardAvgSalesDisplay = cardDetailsShowList.Where(s => !string.IsNullOrEmpty(s.CardAvgSalesDisplay)).Distinct().Select(s => s.CardAvgSalesDisplay).FirstOrDefault();
return(Json(new
{
_FraudIncidentsViewModel = fraudMainViewModel.FraudIncidentsViewModel,
_FraudCustomerDetailsViewModel = fraudMainViewModel.FraudCustomerDetailsViewModel,
_FraudCardDetailsViewModel = fraudMainViewModel.FraudCardDetailsViewModel,
Selects = DropdownFraudIncidentsViewModel,
CardNo = cardNoLst,
model = customerDetailsShowList.Select(x => new object[] { x.CmpyName1, x.AccountType, x.ClientType, x.AgeingDays,
x.Month1Date, x.Month2Date, x.Month3Date, x.Month4Date, x.Month5Date, x.Month6Date, x.AvgSalesDisplay, x.SubsidyNo }).FirstOrDefault(),
aaData = customerDetailsShowList.Select(x => new object[] { x.Month1Amt, x.Month2Amt, x.Month3Amt, x.Month4Amt, x.Month5Amt, x.Month6Amt, x.AvgSales }),
cardModel = new object[] { CardMonth1Date, CardMonth2Date, CardMonth3Date, CardMonth4Date, CardMonth5Date, CardMonth6Date, CardAvgSalesDisplay },
cardaaData = cardDetailsShowList.Select(x => new object[] { x.FraudCards[0].SelectedCardNo, x.CardMonth1Amt, x.CardMonth2Amt, x.CardMonth3Amt, x.CardMonth4Amt, x.CardMonth5Amt, x.CardMonth6Amt, x.CardAvgSales, x.LitLimit, x.SingleTxn, x.DailyTxn, x.MonthlyTxn, x.DailyCnt, x.MonthlyCnt, x.DailyLitre, x.MonthlyLitre }),
liFraudCards = cardDetailsShowList.SelectMany(x => x.FraudCards),
Enum_NatureOfIncident = Enum_NatureOfIncident
}, JsonRequestBehavior.AllowGet));
case "txn":
var _FraudTxnDisputeViewModel = new FraudTxnDisputeViewModel
{
TxnCategory = await BaseService.GetTransactionCategory(),
TxnCd = await BaseService.WebGetTxnCode("I")
};
var json = Json(new { Selects = _FraudTxnDisputeViewModel }, JsonRequestBehavior.AllowGet);
json.MaxJsonLength = int.MaxValue;
return(json);
default:
HttpContext.Response.StatusCode = 404;
return(Json(null, JsonRequestBehavior.AllowGet));
}
}
catch (Exception ex)
{
HttpContext.Response.StatusCode = 404;
return(Json(null, JsonRequestBehavior.AllowGet));
}
}
public async Task <ActionResult> SaveTxn(List <string> liTxnId, string EventId, string AcctNo, string CardNo, string IsPostedDispute)
{
var result = await FraudOpService.SaveTransaction(liTxnId, EventId, AcctNo, CardNo, IsPostedDispute);
return(Json(new { resultCd = result }));
}
public async Task <JsonResult> SaveFraud(FraudCustomerDetailsViewModel fraudCustomerDetailsViewModel, FraudCardDetailsViewModel fraudCardDetailsViewModel, FraudIncidentsViewModel fraudIncidentsViewModel)
{
var result = await FraudOpService.SaveFraud(fraudCustomerDetailsViewModel, fraudCardDetailsViewModel, fraudIncidentsViewModel, GetUserId);
return(Json(new { resultCd = result, _eventId = result.returnValue.BatchId }));
}
/// <summary>
/// Get dropdown CardNo
/// </summary>
public async Task <JsonResult> GetCardNoList_ByAcctNo(string AcctNo, string EventId)
{
var cardList = (await FraudOpService.GetCardNoByAcctNo((int)En.FraudSection.CardDetails, "Y", null, AcctNo, EventId)).fraudCard;
return(Json(new { cardList = cardList }, JsonRequestBehavior.AllowGet));
}
