/************************************* * Created by: dandy * Created on: May 30, 2017 * Function: SaveCardReplacement * Purpose: SaveCardReplacement * Inputs: personalInfoDto,entityId * Returns: SaveAcctSignUpResponse *************************************/ public async Task <SaveAcctSignUpResponse> SaveCardReplacement(CardReplacement cardReplacement, string userId) { Logger.Info("Invoking SaveCardReplacement function"); var response = new SaveAcctSignUpResponse() { Status = ResponseStatus.Failure, }; try { using (var scope = Container.BeginLifetimeScope()) { var cardHolderDAO = scope.Resolve <ICardHolderDAO>(); var controlDAO = scope.Resolve <IControlDAO>(); var cardReplacementDto = Mapper.Map <CardReplacementDTO>(cardReplacement); var result = await cardHolderDAO.SaveCardReplacement(cardReplacementDto, userId); var message = await controlDAO.GetMessageCode(result.Flag); response.returnValue.NewcardNo = result.paraOut.NewcardNo; response.desp = message.Descp; response.flag = message.Flag; } response.Status = ResponseStatus.Success; } catch (Exception ex) { string msg = string.Format("Error in SaveCardReplacement: detail:{0}", ex.Message); Logger.Error(msg, ex); response.Status = ResponseStatus.Exception; response.flag = 1; response.Message = msg; } return(response); }
public async Task <MsgRetriever> SaveCardReplacement(CardReplacement CardReplace) { var objDataEngine = new FleetDataEngine(AccessMode.CardHolder, DBType.Maint); try { objDataEngine.InitiateConnection(); SqlParameter[] Parameters = new SqlParameter[10]; Parameters[0] = new SqlParameter("@IssNo", GetIssNo); Parameters[1] = String.IsNullOrEmpty(CardReplace.CardNo) ? new SqlParameter("@CardNo", DBNull.Value) : new SqlParameter("@CardNo", CardReplace.CardNo); Parameters[2] = new SqlParameter("@NewCardNo", SqlDbType.VarChar, 19); Parameters[2].Direction = ParameterDirection.Output; Parameters[3] = String.IsNullOrEmpty(CardReplace.ExpiryDate) ? new SqlParameter("@ExpiryDate", DBNull.Value) : new SqlParameter("@ExpiryDate", CardReplace.ExpiryDate);// new SqlParameter("@ExpiryDate", ConvertDatetimeDB(CardReplace.ExpiryDate)); Parameters[4] = String.IsNullOrEmpty(CardReplace.SelectedFeeCd) ? new SqlParameter("@FeeCd", DBNull.Value) : new SqlParameter("@FeeCd", CardReplace.SelectedFeeCd); Parameters[5] = String.IsNullOrEmpty(CardReplace.SelectedReasonCode) ? new SqlParameter("@ReasonCd", DBNull.Value) : new SqlParameter("@ReasonCd", CardReplace.SelectedReasonCode); Parameters[6] = String.IsNullOrEmpty(CardReplace.Remarks) ? new SqlParameter("@Remarks", DBNull.Value) : new SqlParameter("@Remarks", CardReplace.Remarks); Parameters[7] = String.IsNullOrEmpty(this.GetUserId) ? new SqlParameter("@UserId", DBNull.Value) : new SqlParameter("@UserId", this.GetUserId); Parameters[8] = String.IsNullOrEmpty(CardReplace.SelectedCardMediaType) ? new SqlParameter("@CardMedia", DBNull.Value) : new SqlParameter("@CardMedia", CardReplace.SelectedCardMediaType); Parameters[9] = new SqlParameter("@RETURN_VALUE", SqlDbType.BigInt); Parameters[9].Direction = ParameterDirection.ReturnValue; var Cmd = await objDataEngine.ExecuteWithReturnValueAsync("WebCardReplacementMaint", CommandType.StoredProcedure, Parameters); var Result = Convert.ToInt32(Cmd.Parameters["@RETURN_VALUE"].Value); NewcardNo = Convert.ToString(Cmd.Parameters["@NewCardNo"].Value); var Descp = await GetMessageCode(Result); return(Descp); } finally { objDataEngine.CloseConnection(); } }
public CardHolderResponse() { cardHolderInfo = new CardHolderInfoModel(); personalInfo = new PersonInfoModel(); changeStatus = new ChangeStatus(); cardReplacement = new CardReplacement(); cardFinancialInfoModel = new CardFinancialInfoModel(); cardHolderInfos = new List <CardHolderInfoModel>(); locationAccepts = new List <LocationAcceptListModel>(); locationAccept = new LocationAcceptListModel(); }
public async Task <CardReplacement> CardReplacementInfoSelect(string CardNo) { var objDataEngine = new FleetDataEngine(AccessMode.CustomerService, DBType.Maint); try { objDataEngine.InitiateConnection(); SqlParameter[] Parameters = new SqlParameter[2]; Parameters[0] = new SqlParameter("@IssNo", GetIssNo); Parameters[1] = String.IsNullOrEmpty(CardNo) ? new SqlParameter("@CardNo", DBNull.Value) : new SqlParameter("@CardNo", CardNo); var reader = await objDataEngine.ExecuteCommandAsync("WebCardReplacementSelect", CommandType.StoredProcedure, Parameters); var CardReplacementInfo = new CardReplacement(); while (reader.Read()) { CardReplacementInfo.NewCardNo = Convert.ToString(reader["NewCardNo"]); CardReplacementInfo.XReferenceNo = Convert.ToString(reader["PrevCardNo"]); CardReplacementInfo.ExpiryDate = DateConverter(reader["CardExpiry"]); CardReplacementInfo.TerminatedDate = Convert.ToString(reader["TerminatedDate"]); CardReplacementInfo.SelectedCurrentStatus = Convert.ToString(reader["Sts"]); CardReplacementInfo.Remarks = Convert.ToString(reader["Remarks"]); CardReplacementInfo.SelectedFeeCd = Convert.ToString(reader["FeeCd"]); CardReplacementInfo.SelectedReasonCode = Convert.ToString(reader["ReasonCd"]); CardReplacementInfo.SelectedCardMediaType = Convert.ToString(reader["CardMedia"]); //objDataEngine.CloseConnection(); } ; if (string.IsNullOrEmpty(CardReplacementInfo.SelectedFeeCd)) { CardReplacementInfo.SelectedFeeCd = "301"; } return(CardReplacementInfo); } finally { objDataEngine.CloseConnection(); } }
public async Task <JsonResult> FillData(string Prefix, string CardNo)//,string acctNo { switch (Prefix) { case "gen": var data = (await CardHolderService.GetGeneralInfo(CardNo)).cardHolderInfo; var _cardAppcInfoSignUp = new CardHolderInfoModel { CardType = await BaseService.GetCardType(null, null, null, Request.QueryString["AcctNo"]), CostCentre = await BaseService.GetCostCentre(Request.QueryString["AcctNo"], "ACCT", true), ReasonCd = await BaseService.GetRefLib("ReasonCd"), SKDSNo = await BaseService.GetSKDS(null, Request.QueryString["AcctNo"]), RenewalInd = await BaseService.GetRefLib("RenewalInd"), DialogueInd = await BaseService.GetRefLib("DialogueInd"), PINInd = await BaseService.GetRefLib("PinInd"), ProductUtilization = await BaseService.WebProductGroupSelect(), VehicleModel = await BaseService.GetRefLib("VehSubModel"), AnnualFee = await BaseService.GetFeeCd("ANN", true), JonFee = await BaseService.GetFeeCd("JON", true), BranchCd = await BaseService.GetRefLib("BranchCd"), DivisionCode = await BaseService.GetRefLib("DivisionCd"), DeptCd = await BaseService.GetRefLib("DeptCd"), CardMedia = await BaseService.GetCardMedia() }; ViewBag.AcctNo = Request.QueryString["AcctNo"]; return(Json(new { Model = data, Selects = _cardAppcInfoSignUp }, JsonRequestBehavior.AllowGet)); case "fin": var fin = (await CardHolderService.GetFinancialInfo(CardNo)).cardFinancialInfoModel; return(Json(new { Model = fin }, JsonRequestBehavior.AllowGet)); case "per": var per = (await CardHolderService.GetPersonInfo(Request.QueryString["EntityId"])).personalInfo; var Selects = new PersonInfoModel { title = await BaseService.GetRefLib("Title"), IdType = await BaseService.GetRefLib("IcType"), AltIdType = await BaseService.GetRefLib("IcType"), gender = await BaseService.GetRefLib("Gender"), Occupation = await BaseService.GetRefLib("Occupation"), DeptId = await BaseService.GetRefLib("Dept") }; return(Json(new { Model = per, Selects = Selects }, JsonRequestBehavior.AllowGet)); case "sts": var stsDetails = await CardHolderService.GetChangedAcctStsDetail(CardNo, "CARD"); var selecs = new ChangeStatus { CurrentStatus = await BaseService.GetRefLib("CardSts"), RefType = await BaseService.GetRefLib("EventType"), ReasonCode = await BaseService.GetRefLib("ReasonCd", "32"), ChangeStatusTo = await BaseService.GetRefLib("CardSts") }; return(Json(new { Model = stsDetails.changeStatus, Selects = selecs }, JsonRequestBehavior.AllowGet)); case "rep": var rep = (await CardHolderService.GetCardReplacementInfo(CardNo)).cardReplacement; var repSelects = new CardReplacement { FeeCd = await BaseService.GetFeeCd("RPL"), ReasonCd = await BaseService.GetRefLib("ReasonCd", "32"), CurrentStatus = await BaseService.GetRefLib("CardSts"), CardMedia = await BaseService.GetCardMedia() }; return(Json(new { Model = rep, Selects = repSelects }, JsonRequestBehavior.AllowGet)); case "loc": var locationAcceptanceList = new LocationAcceptListModel { State = await BaseService.WebGetState("608"), BusnLocations = new List <SelectListItem>(), UserId = HttpContext.User.Identity.Name, CreationDate = System.DateTime.Now.ToString() }; return(Json(new { Selects = locationAcceptanceList, Model = new LocationAcceptListModel() }, JsonRequestBehavior.AllowGet)); case "pdc": var _prodDiscount = new ProductDiscount { ProdCd = await BaseService.WebProductGroupSelect(), RebatePlan = await BaseService.WebGetPlan("2"), DiscPlan = await BaseService.WebGetPlan("1"), ProdDiscType = await BaseService.GetRefLib("ProdDiscType"), PlanId = new List <SelectListItem>() }; return(Json(new { Selects = _prodDiscount, Model = new ProductDiscount() }, JsonRequestBehavior.AllowGet)); default: return(Json(new { })); } }
public async Task <ActionResult> SaveCardReplacementInfo(CardReplacement CardReplace) { var _SaveChangedStatus = await CardHolderService.SaveCardReplacement(CardReplace, GetUserId); return(Json(new { resultCd = _SaveChangedStatus, NewCard = _SaveChangedStatus.returnValue.NewcardNo }, JsonRequestBehavior.AllowGet)); //, newCardNo = objCardHoldersOps.NewcardNo }