/*************************************
* Created by: dandy
* Created on: May 25, 2017
* Function: SaveGeneralInfo
* Purpose: SaveGeneralInfo
* Inputs: CardHolderInfoDTO,userId
* Returns: SaveAcctSignUpResponse
*************************************/
public async Task <SaveAcctSignUpResponse> SaveGeneralInfo(CardHolderInfoModel cardHolderInfoModel, string userId)
{
Logger.Info("Invoking SaveGeneralInfo 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 cardHolderInfo = Mapper.Map <CardHolderInfoModel, CardHolderInfoDTO>(cardHolderInfoModel);
var result = await cardHolderDAO.SaveGeneralInfo(cardHolderInfo, userId);
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 SaveGeneralInfo: 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 <MsgRetriever> SaveGeneralInfo(CardHolderInfoModel CardData)
{
var objDataEngine = new FleetDataEngine(AccessMode.Admin, DBType.Maint);
try
{
objDataEngine.InitiateConnection();
SqlParameter[] Parameters = new SqlParameter[27];
SqlCommand cmd = new SqlCommand();
Parameters[0] = new SqlParameter("@IssNo", GetIssNo);
Parameters[1] = String.IsNullOrEmpty(CardData.CardNo) ? new SqlParameter("@CardNo", DBNull.Value) : new SqlParameter("@CardNo", ConvertLongToDb(CardData.CardNo));
Parameters[2] = String.IsNullOrEmpty(CardData.EmbossName) ? new SqlParameter("@EmbName", DBNull.Value) : new SqlParameter("@EmbName", CardData.EmbossName);
Parameters[3] = String.IsNullOrEmpty(CardData.SelectedCurrentStatus) ? new SqlParameter("@Sts", DBNull.Value) : new SqlParameter("@Sts", CardData.SelectedCurrentStatus);
Parameters[4] = new SqlParameter("@TerminatedDate", ConvertDatetimeDB(CardData.TerminatedDate));
Parameters[5] = String.IsNullOrEmpty(CardData.vehRegNo) ? new SqlParameter("@VehRegsNo", DBNull.Value) : new SqlParameter("@VehRegsNo", CardData.vehRegNo);
Parameters[6] = String.IsNullOrEmpty(CardData.DriverCd) ? new SqlParameter("@DriverCd", DBNull.Value) : new SqlParameter("@DriverCd", CardData.DriverCd);
Parameters[7] = new SqlParameter("@SKDSInd", ConvertBoolDB(CardData.SelectedSKDSInd));
Parameters[8] = new SqlParameter("@SKDSQuota", ConvertDecimalToDb(CardData.SKDSQuota));
Parameters[9] = String.IsNullOrEmpty(CardData.SelectedSKDSNo) ? new SqlParameter("@SKDSNo", DBNull.Value) : new SqlParameter("@SKDSNo", CardData.SelectedSKDSNo);
Parameters[10] = String.IsNullOrEmpty(CardData.SelectedDialogueInd) ? new SqlParameter("@DialogueInd", DBNull.Value) : new SqlParameter("@DialogueInd", CardData.SelectedDialogueInd);
Parameters[11] = new SqlParameter("@PINInd", ConvertBoolDB(CardData.SelectedPINInd));
Parameters[12] = new SqlParameter("@OdometerInd", ConvertBoolDB(CardData.OdometerIndicator));
Parameters[13] = new SqlParameter("@AcctNo", ConvertLongToDb(CardData.AcctNo));//String.IsNullOrEmpty(CardData.AcctNo) ? new SqlParameter("@AcctNo", DBNull.Value) :
Parameters[14] = new SqlParameter("@PushAlertInd", ConvertBoolDB(CardData.SelectedPushAlertInd));
Parameters[15] = String.IsNullOrEmpty(CardData.SelectedAnnualFee) ? new SqlParameter("@AnnlFee", DBNull.Value) : new SqlParameter("@AnnlFee", CardData.SelectedAnnualFee);
Parameters[16] = String.IsNullOrEmpty(CardData.SelectedJonFee) ? new SqlParameter("@JoiningFee", DBNull.Value) : new SqlParameter("@JoiningFee", CardData.SelectedJonFee);
Parameters[17] = String.IsNullOrEmpty(CardData.SelectedRenewalInd) ? new SqlParameter("@RenewalInd", DBNull.Value) : new SqlParameter("@RenewalInd ", CardData.SelectedRenewalInd);
Parameters[18] = new SqlParameter("@UserId", this.GetUserId);
Parameters[19] = new SqlParameter("@PrimaryCard", ConvertBoolDB(CardData.PrimaryCard));
Parameters[20] = String.IsNullOrEmpty(CardData.SelectedProductUtilization) ? new SqlParameter("@ProductGroup", DBNull.Value) : new SqlParameter("@ProductGroup", CardData.SelectedProductUtilization);
Parameters[21] = String.IsNullOrEmpty(CardData.SelectedCostCentre) ? new SqlParameter("@CostCentre", DBNull.Value) : new SqlParameter("@CostCentre", CardData.SelectedCostCentre);
Parameters[22] = String.IsNullOrEmpty(CardData.SelectedVehicleModel) ? new SqlParameter("@VehModel", DBNull.Value) : new SqlParameter("@VehModel", CardData.SelectedVehicleModel);
Parameters[23] = String.IsNullOrEmpty(CardData.SelectedBranchCd) ? new SqlParameter("@BranchCd", DBNull.Value) : new SqlParameter("@BranchCd", CardData.SelectedBranchCd);
Parameters[24] = String.IsNullOrEmpty(CardData.SelectedDivisionCode) ? new SqlParameter("@DivisionCd", DBNull.Value) : new SqlParameter("@DivisionCd", CardData.SelectedDivisionCode);
Parameters[25] = String.IsNullOrEmpty(CardData.SelectedDeptCd) ? new SqlParameter("@DeptCd", DBNull.Value) : new SqlParameter("@DeptCd", CardData.SelectedDeptCd);
Parameters[26] = new SqlParameter("@RETURN_VALUE", SqlDbType.BigInt);
Parameters[26].Direction = ParameterDirection.ReturnValue;
var Cmd = await objDataEngine.ExecuteWithReturnValueAsync("WebCardGeneralInfoMaint", 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> New2()
{
_cardApplInfoSignUp = new CardHolderInfoModel
{
CardType = await BaseClass.WebGetCardType(null, null, null, Request.QueryString["AcctNo"]),
DialogueInd = await BaseClass.WebGetRefLib("DialogueInd"),
CurrentStatus = await BaseClass.WebGetRefLib("AppcSts"),
SKDSNo = await BaseClass.WebGetSKDS(Request.QueryString["AcctNo"], null),
PINInd = await BaseClass.WebGetRefLib("PinInd"),
ProductUtilization = await BaseClass.WebProductGroupSelect(1),
VehicleModel = await BaseClass.WebGetRefLib("VehSubModel"),
AnnualFee = await BaseClass.WebGetFeeCd("ANN"),
JonFee = await BaseClass.WebGetFeeCd("JON"),
BranchCd = await WebGetRefLib("BranchCd"),
DivisionCode = await WebGetRefLib("DivisionCd"),
DeptCd = await WebGetRefLib("DeptCd")
};
ViewBag.AcctNo = Request.QueryString["AcctNo"];
return(View(_cardApplInfoSignUp));
}
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> WebCardGeneralInfoMaint(CardHolderInfoModel CardDataInfo)
{
var SaveApplGeneralInfoMaint = await CardHolderService.SaveGeneralInfo(CardDataInfo, GetUserId);
return(Json(new { resultCd = SaveApplGeneralInfoMaint }, JsonRequestBehavior.AllowGet));
}
public async Task <ActionResult> SaveAppcGeneralInfo(CardHolderInfoModel _CardData)
{
var SaveApplGeneralInfoMaint = await objCardHoldersOps.SaveGeneralInfo(_CardData);
return(Json(new { resultCd = SaveApplGeneralInfoMaint }, JsonRequestBehavior.AllowGet));
}
//#region "Dropdown"
////For dropdown function
//public static IEnumerable<SelectListItem> WebGetRefLib(string refType, string RefNo = null, string RefInd = null, string RefId = null)
//{
// var objEngine = new FleetDataEngine(AccessMode.CardHolder, DBType.Maint);
// objEngine.InitiateConnection();
// SqlParameter[] Parameters = new SqlParameter[5];
// SqlCommand cmd = new SqlCommand();
// Parameters[0] = new SqlParameter("@IssNo", 1);
// Parameters[1] = new SqlParameter("@RefType", String.IsNullOrEmpty(refType) ? (object)DBNull.Value : refType);
// Parameters[2] = String.IsNullOrEmpty(RefNo) ? new SqlParameter("@RefNo", DBNull.Value) : new SqlParameter("@RefNo", RefNo);
// Parameters[3] = String.IsNullOrEmpty(RefInd) ? new SqlParameter("@RefInd", DBNull.Value) : new SqlParameter("@RefInd", RefInd);
// Parameters[4] = String.IsNullOrEmpty(RefId) ? new SqlParameter("@RefId", DBNull.Value) : new SqlParameter("@RefId", RefId);
// var getObjData = objEngine.ExecuteCommand("WebGetRefLib", CommandType.StoredProcedure, Parameters);
// var list = new List<SelectListItem>();
// while (getObjData.Read())
// {
// list.Add(new SelectListItem
// {
// Text = Convert.ToString(getObjData["Descp"]),
// Value = Convert.ToString(getObjData["RefCd"]),
// Selected = Convert.ToString(getObjData["RefCd"]) == "1" ? true : false
// });
// }
// objEngine.CloseConnection();
// return list;
//}
//#endregion "Dropdown"
#region "Form"
public async Task <CardHolderInfoModel> GeneralInfoSelect(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] = new SqlParameter("@CardNo", cardNo);
var Reader = await objDataEngine.ExecuteCommandAsync("WebCardGeneralInfoSelect", CommandType.StoredProcedure, Parameters);
var info = new CardHolderInfoModel();
while (Reader.Read())
{
info.AcctNo = Convert.ToString(Reader["AcctNo"]);
info.SelectedCostCentre = Convert.ToString(Reader["CostCentre"]);
info.EmbossName = Convert.ToString(Reader["EmbName"]);
info.CardExpiry = Convert.ToString(Reader["CardExpiry"]);
info.SelectedCardType = Convert.ToString(Reader["CardType"]);
info.SelectedCurrentStatus = Convert.ToString(Reader["Sts"]);
info.CardNo = cardNo;
info.SelectedReasonCode = Convert.ToString(Reader["ReasonCd"]);
info.CreationDate = Convert.ToString(Reader["CreationDate"]);
info.MemberSince = Convert.ToString(Reader["MemSince"]);
info.SelectedSKDSNo = Convert.ToString(Reader["SKDSNo"]);
info.oldCardNo = Convert.ToString(Reader["XPreCardNo"]);
info.XRefCardNo = Convert.ToString(Reader["XRefCardNo"]);
info.SelectedCardType = Convert.ToString(Reader["CardType"]);
info.SelectedVehicleModel = Convert.ToString(Reader["Model"]);
info.vehRegNo = Convert.ToString(Reader["VehRegsNo"]);
info.SelectedSKDSInd = BoolConverter(Reader["SKDSInd"]);
info.SKDSQuota = BaseClass.ConverterDecimal(Reader["SKDSQuota"]);
info.DriverCd = Convert.ToString(Reader["DriverCd"]);
info.DriverName = Convert.ToString(Reader["Driver Name"]);
info.BlockedDate = DateTimeConverter(Reader["BlockedDate"]);
info.TerminatedDate = BaseClass.DateConverter(Reader["TerminatedDate"]);
info.PVV = Convert.ToString(Reader["PVV"]);
info.PINOffset = Convert.ToString(Reader["PINoffSet"]);
info.SelectedRenewalInd = Convert.ToString(Reader["RenewalInd"]);
info.EntityId = Convert.ToString(Reader["EntityId"]);
info.SelectedDialogueInd = Convert.ToString(Reader["DialogueInd"]);
info.SelectedPushAlertInd = BaseClass.BoolConverter(Reader["PushAlertInd"]);
info.LocInd = BaseClass.BoolConverter(Reader["LocationInd"]);
info.SelectedLocCheckFlag = BaseClass.BoolConverter(Reader["LocationCheckFlag"]);
info.MaxCountLimit = ConvertInt(Reader["LocationMaxCnt"]);
info.AmtLimit = BaseClass.ConverterDecimal(Reader["LocationMaxAmt"]);
info.SelectedFuelCheckFlag = BaseClass.BoolConverter(Reader["FuelCheckFlag"]);
info.FuelLitre = BaseClass.ConverterDecimal(Reader["FuelLitPerKM"]);
info.PINExceedCnt = BaseClass.ConvertInt(Reader["PINExceedCnt"]);
info.PINAttempted = BaseClass.ConvertInt(Reader["PINAttempted"]);
info.SelectedAnnualFee = Convert.ToString(Reader["AnnlFeeCd"]);
info.SelectedJonFee = Convert.ToString(Reader["JoiningFeeCd"]);
info.SelectedProductUtilization = Convert.ToString(Reader["ProdGroup"]);
info.OdometerIndicator = BaseClass.BoolConverter(Reader["OdometerInd"]);
info.PrimaryCard = BaseClass.BoolConverter(Reader["PrimaryCard"]);
info.SelectedBranchCd = Convert.ToString(Reader["BranchCd"]);
info.SelectedDivisionCode = Convert.ToString(Reader["DivisionCd"]);
info.SelectedDeptCd = Convert.ToString(Reader["DeptCd"]);
info.SelectedCardMedia = Convert.ToString(Reader["CardMedia"]);
return(info);
}
return(new CardHolderInfoModel());
}
finally
{
objDataEngine.CloseConnection();
}
}
