public JsonResult GetHotCardInfo(string CardNo) { CardTypesDataAccess obj = new CardTypesDataAccess(); List <CustomerAccountVM> lst = new List <CustomerAccountVM>(); lst = CardReportMethods.GetCustomerAccount(CardNo); if (lst.Count <= 0) { return(Json(new { Result = lst, ErrorMessage = CustomMessages.CardNotExists }, JsonRequestBehavior.AllowGet)); } else if (lst.Count > 0 && lst.FirstOrDefault().CardStatusActive == true) { return(Json(new { Result = lst, ErrorMessage = "Card is Already Active" }, JsonRequestBehavior.AllowGet)); } else { var CardIssuance = lst.FirstOrDefault().CardIssuance.ToString(); var CardExpiry = lst.FirstOrDefault().CardExpiry.ToString(); var DOB = lst.FirstOrDefault().DateofBirth.ToString(); var CardTypes = obj.GetCardTypes("A"); CardTypes = (CardTypes.Where(s => s.ID == lst.FirstOrDefault().CardTypeID)).ToList(); var CardType = ""; if (CardTypes.Count != 0) { CardType = CardTypes[0].Title; } List <CustomerAccountVM> DelinkInfo = new List <CustomerAccountVM>(); DelinkInfo = CommonMethods.GetAccountInfo(CardNo, lst.FirstOrDefault()?.AccountNo ?? "0"); return(Json(new { Result = lst, CardIssuance = CardIssuance, CardExpiry = CardExpiry, DOB = DOB, DelinkInfo = DelinkInfo, CardType = CardType, ErrorMessage = CustomMessages.Success }, JsonRequestBehavior.AllowGet)); } }
public static CardTypeVM GetCardTypeById(int id, string authorizeStatus = default(string)) { var query = new CardTypesDataAccess().GetCardType(id); if (!string.IsNullOrEmpty(authorizeStatus)) { query = (query?.AuthorizationStatus ?? string.Empty) == authorizeStatus ? query : null; } if (query == null) { return(null); } return(new CardTypeVM { Description = query.Description, AuthorizationStatus = query.AuthorizationStatus, ID = query.ID, AuthorizationComments = query.AuthorizationComments, IsActive = query.IsActive, Title = query.Title, CardCode = query.CardCode, IsIssuance = query.IsIssuance, IsReplacement = query.IsReplacement, IsUpgrade = query.IsUpgrade, UpgradeChildTypes = query.tbl_Card_Upgrade_Types.Select(e => e.ParentCardType).ToList(), ParentTypes = new CardTypesDataAccess().GetParentCardTypesByChildId(query.ID) }); }
public ActionResult RecoveryExceptionReport() { var branches = new RegionDataAccess().GetAllRegions(); var cardtypes = new CardTypesDataAccess().GetCardTypes("A"); ViewData["Branches"] = branches ?? new List <tbl_Region>(); return(View()); }
public ActionResult CardImportReport() { var viewModel = new List <ReportCardImportVM>(); var branches = new RegionDataAccess().GetAllRegions(); var cardtypes = new CardTypesDataAccess().GetCardTypes("A"); ViewData["Branches"] = branches ?? new List <tbl_Region>(); ViewData["CardTypes"] = cardtypes ?? new List <tbl_Card_Types>(); return(View(viewModel)); }
public JsonResult SearchCardDetail(string CardNo) { CardTypesDataAccess obj = new CardTypesDataAccess(); List <CustomerAccountVM> lst = new List <CustomerAccountVM>(); NewCISSB.SONFETCHCARDINFOTypeGSONFETCHCARDINFODetailTypeMSONFETCHCARDINFODetailType resp = new NewCISSB.SONFETCHCARDINFOTypeGSONFETCHCARDINFODetailTypeMSONFETCHCARDINFODetailType(); lst = CardReportMethods.GetCustomerAccount(CardNo); if (lst.Count <= 0) { return(Json(new { Result = lst, ErrorMessage = CustomMessages.CardNotExists }, JsonRequestBehavior.AllowGet)); } else { var request = new RequestDataAccess().GetRequest(CardNo, lst.FirstOrDefault()?.AccountNo ?? string.Empty, lst.FirstOrDefault()?.CIF ?? string.Empty); var requestdata = new RequestVM { ID = request?.ID ?? 0, RequestType = request?.RequestType ?? string.Empty, Waive = request != null?request.WaiveCharges.GetValueOrDefault() : false }; var userlog = new UserLogDataAccess().GetUserLogByEntityId(request?.ID ?? 0, "tbl_Requests"); var creator = userlog.Where(e => e.EventName == "i").FirstOrDefault()?.tbl_Users?.UserName ?? string.Empty; var authorizer = userlog.Where(e => e.EventName == "A").OrderByDescending(e => e.ID).FirstOrDefault()?.tbl_Users?.UserName ?? string.Empty; try { resp = T24Methods.FetchAccount(lst.FirstOrDefault()?.AccountNo ?? string.Empty, lst.FirstOrDefault()?.CIF ?? string.Empty); } catch { resp = new NewCISSB.SONFETCHCARDINFOTypeGSONFETCHCARDINFODetailTypeMSONFETCHCARDINFODetailType(); } //var CardIssuance = lst.FirstOrDefault().CardIssuance.ToString(); //var CardExpiry = lst.FirstOrDefault().CardExpiry.ToString(); //var DOB = lst.FirstOrDefault().DateofBirth.ToString(); var CardTypes = obj.GetCardTypes("A"); CardTypes = (CardTypes.Where(s => s.ID == (lst.FirstOrDefault()?.CardTypeID ?? 0))).ToList(); var CardType = (CardTypes.Count > 0) ? CardTypes[0].Title : string.Empty; List <CustomerAccountVM> DelinkInfo = new List <CustomerAccountVM>(); //DelinkInfo = CommonMethods.GetAccountInfo(CardNo, lst.FirstOrDefault()?.AccountNo ?? "0"); var DelinkInfoStr = CommonMethods.GetLinkedAccounts(CardNo, lst.FirstOrDefault()?.AccountNo ?? "0"); var Product = new AccountTypeDataAccess().GetAccountTypeById(lst.FirstOrDefault().AccountTypeID ?? 0)?.Name ?? string.Empty; return(Json(new { Result = lst, /*CardIssuance=CardIssuance, CardExpiry= CardExpiry,DOB=DOB,*/ DelinkInfoStr = DelinkInfoStr, CardType = CardType, Product = Product, Request = requestdata, AccountResponse = resp, Creator = creator, Authorizer = authorizer, ErrorMessage = CustomMessages.Success }, JsonRequestBehavior.AllowGet)); } }