/*************************************
* Created by: dandy
* Created on: May 25, 2017
* Function: SaveFinancialInfo
* Purpose: SaveFinancialInfo
* Inputs: CardHolderInfoDTO,cardNo
* Returns: SaveAcctSignUpResponse
*************************************/
public async Task <SaveAcctSignUpResponse> SaveFinancialInfo(CardFinancialInfoModel finInfoModel, string cardNo)
{
Logger.Info("Invoking SaveFinancialInfo 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 finInfo = Mapper.Map <CardFinancialInfoModel, CardHolderInfoDTO>(finInfoModel);
var result = await cardHolderDAO.SaveFinancialInfo(finInfo, cardNo);
var message = await controlDAO.GetMessageCode(result);
response.desp = message.Descp;
response.flag = message.Flag;
}
response.Status = ResponseStatus.Success;
}
catch (Exception ex)
{
string msg = string.Format("Error in SaveFinancialInfo: detail:{0}", ex.Message);
Logger.Error(msg, ex);
response.Status = ResponseStatus.Exception;
response.flag = 1;
response.Message = msg;
}
return(response);
}
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 <CardFinancialInfoModel> FinancialInfoSelect(int IssNo, string cardNo)
{
var objDataEngine = new FleetDataEngine(AccessMode.CustomerService, DBType.Maint);
try
{
objDataEngine.InitiateConnection();
SqlParameter[] Parameters = new SqlParameter[2];
Parameters[0] = new SqlParameter("@IssNo", IssNo);
Parameters[1] = String.IsNullOrEmpty(cardNo) ? new SqlParameter("@CardNo", DBNull.Value) : new SqlParameter("@CardNo", cardNo);
var Reader = await objDataEngine.ExecuteCommandAsync("WebCardFinInfoSelect", CommandType.StoredProcedure, Parameters);
var finInfo = new CardFinancialInfoModel();
while (Reader.Read())
{
finInfo.txnLimit = BaseClass.ConverterDecimal(Reader["TxnLimit"]);
finInfo.litLimit = BaseClass.ConverterDecimal(Reader["LitLimit"]);
finInfo.PinExceedCnt = BaseClass.ConvertInt(Reader["PinExceedCnt"]);
finInfo.PinAttempted = BaseClass.ConvertInt(Reader["PinAttempted"]);
finInfo.PinTriedUpdDate = DateTimeConverter(Reader["PinTriedUpdDate"]);
finInfo.PushAlertInd = BoolConverter(Reader["PushAlertInd"]);
finInfo.LocationInd = BoolConverter(Reader["LocationInd"]);
finInfo.LocationCheckFlag = BoolConverter(Reader["LocationCheckFlag"]);
finInfo.LocationMaxCnt = ConvertInt(Reader["LocationMaxCnt"]);
finInfo.LocationMaxAmt = ConvertInt(Reader["LocationMaxAmt"]).ToString("0");
finInfo.FuelCheckFlag = BoolConverter(Reader["FuelCheckFlag"]);
finInfo.FuelLitPerKM = ConverterDecimal(Reader["FuelLitPerKM"]);
finInfo.LastTxnDate = Convert.ToString(Reader["LastTxnDate"]);
return(finInfo);
}
;
return(new CardFinancialInfoModel());
}
finally
{
objDataEngine.CloseConnection();
}
}
public async Task <MsgRetriever> SaveFinancialInfo(CardFinancialInfoModel finInfo, string cardNo)
{
var objDataEngine = new FleetDataEngine(AccessMode.CardHolder, DBType.Maint);
try
{
objDataEngine.InitiateConnection();
SqlParameter[] Parameters = new SqlParameter[15];
SqlCommand cmd = new SqlCommand();
Parameters[0] = new SqlParameter("@IssNo", GetIssNo);
Parameters[1] = String.IsNullOrEmpty(cardNo) ? new SqlParameter("@CardNo", DBNull.Value) : new SqlParameter("@CardNo", cardNo);
Parameters[2] = new SqlParameter("@TxnLimit", ConvertDecimalToDb(finInfo.txnLimit));
Parameters[3] = new SqlParameter("@LitLimit", ConvertDecimalToDb(finInfo.litLimit));
Parameters[4] = new SqlParameter("@PinExceedCnt", ConvertIntToDb(finInfo.PinExceedCnt));
Parameters[5] = new SqlParameter("@PinAttempted", ConvertIntToDb(finInfo.PinAttempted));
Parameters[6] = String.IsNullOrEmpty(finInfo.PinTriedUpdDate) ? new SqlParameter("@PinTriedUpdDate", DBNull.Value) : new SqlParameter("@PinTriedUpdDate", ConvertDatetimeDB(finInfo.PinTriedUpdDate));
Parameters[7] = new SqlParameter("@PushAlertInd", ConvertIntToDb(finInfo.PushAlertInd));
Parameters[8] = new SqlParameter("@LocationInd", ConvertIntToDb(finInfo.LocationInd));
Parameters[9] = new SqlParameter("@LocationCheckFlag", ConvertIntToDb(finInfo.LocationCheckFlag));
Parameters[10] = new SqlParameter("@LocationMaxCnt", ConvertIntToDb(finInfo.LocationMaxCnt));
Parameters[11] = new SqlParameter("@LocationMaxAmt", ConvertDecimalToDb(finInfo.LocationMaxAmt));
Parameters[12] = new SqlParameter("@FuelCheckFlag", ConvertIntToDb(finInfo.FuelCheckFlag));
Parameters[13] = new SqlParameter("@FuelLitPerKM", ConvertDecimalToDb(finInfo.FuelLitPerKM));
Parameters[14] = new SqlParameter("@RETURN_VALUE", SqlDbType.BigInt);
Parameters[14].Direction = ParameterDirection.ReturnValue;
var Cmd = await objDataEngine.ExecuteWithReturnValueAsync("WebCardFinInfoMaint", CommandType.StoredProcedure, Parameters);
var Result = Convert.ToInt32(Cmd.Parameters["@RETURN_VALUE"].Value);
var Descp = await GetMessageCode(Result);
return(Descp);
}
finally
{
objDataEngine.CloseConnection();
}
}
public async Task <ActionResult> SaveFinancialInfo(CardFinancialInfoModel finInfo, string cardNo)
{
var _SaveFinancial = await CardHolderService.SaveFinancialInfo(finInfo, cardNo);
return(Json(new { resultCd = _SaveFinancial }, JsonRequestBehavior.AllowGet));
}
public async Task <ActionResult> SaveFinancialInfo(CardFinancialInfoModel cardfinInfo, string _AppcId)
{
var _SaveFinancialInfoMaint = await ApplicantSignUpService.SaveFinancial(cardfinInfo, _AppcId);
return(Json(new { resultCd = _SaveFinancialInfoMaint }, JsonRequestBehavior.AllowGet));
}
public ApplicantSignUpResponse()
{
cardAppcInfo = new CardAppcInfoModel();
cardFinancialInfo = new CardFinancialInfoModel();
cardAppcInfoLst = new List <CardAppcInfoModel>();
}
