/*************************************
* 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
}
