public async Task <ActionResult> SaveLocationAccept(LocationAcceptListModel _LocationAcceptList, CardnAccNo _CardnAcct)
{
_LocationAcceptList._CardnAccNo = _CardnAcct;
var _saveLocationAccept = await CardHolderService.SaveLocationAccept(_LocationAcceptList, _CardnAcct.AccNo, _CardnAcct.CardNo, GetUserId);
return(Json(new { resultCd = _saveLocationAccept }, JsonRequestBehavior.AllowGet));
}
/*************************************
* Created by: dandy
* Created on: 07 06, 2017
* Function: SaveLocationAccept
* Purpose: SaveLocationAccept
* Inputs: changeStatusDto,userId
* Returns: SaveAcctSignUpResponse
*************************************/
public async Task <SaveAcctSignUpResponse> SaveLocationAccept(LocationAcceptListModel locationAcceptModel, string accountNo, string cardNo, string userId)
{
Logger.Info("Invoking SaveLocationAccept 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 locationAcceptDTO = Mapper.Map <LocationAcceptListModel, LocationAcceptDTO>(locationAcceptModel);
var result = await cardHolderDAO.SaveLocationAccept(locationAcceptDTO, accountNo, cardNo, 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 SaveLocationAccept: detail:{0}", ex.Message);
Logger.Error(msg, ex);
response.Status = ResponseStatus.Exception;
response.flag = 1;
response.Message = msg;
}
return(response);
}
public async Task <LocationAcceptListModel> LocationAcceptanceSelect(string AcctNo, string BusnLoc, string CardNo)
{
var objDataEngine = new FleetDataEngine(AccessMode.CustomerService, DBType.Maint);
try
{
objDataEngine.InitiateConnection();
SqlParameter[] Parameters = new SqlParameter[3];
Parameters[0] = new SqlParameter("@IssNo", GetIssNo);
Parameters[1] = String.IsNullOrEmpty(AcctNo) ? new SqlParameter("@AcctNo", DBNull.Value) : new SqlParameter("@AcctNo", AcctNo);
Parameters[2] = String.IsNullOrEmpty(CardNo) ? new SqlParameter("@CardNo", DBNull.Value) : new SqlParameter("@CardNo", CardNo);
Parameters[2] = String.IsNullOrEmpty(BusnLoc) ? new SqlParameter("@BusnLoc", DBNull.Value) : new SqlParameter("@BusnLoc", BusnLoc);
var reader = await objDataEngine.ExecuteCommandAsync("WebLocationAcceptanceSelect", CommandType.StoredProcedure, Parameters);
var LocationAccptInfo = new LocationAcceptListModel();
while (reader.Read())
{
LocationAccptInfo.s_state = Convert.ToString(reader["BusnLocation"]);
LocationAccptInfo.UserId = Convert.ToString(reader["User Id"]);
LocationAccptInfo.CreationDate = DateConverter(reader["Creation Date"]);
return(LocationAccptInfo);
}
return(new LocationAcceptListModel());
}
finally
{
objDataEngine.CloseConnection();
}
}
public async Task <MsgRetriever> SaveLocationAccept(LocationAcceptListModel LocationAcceptance)
{
MsgRetriever Descp = new MsgRetriever();
var objDataEngine = new FleetDataEngine(AccessMode.CustomerService, DBType.Maint);
try
{
if (LocationAcceptance.SelectedStates[0] != "")
{
foreach (var x in LocationAcceptance.SelectedStates)
{
objDataEngine = new FleetDataEngine(AccessMode.CustomerService, DBType.Maint);
objDataEngine.InitiateConnection();
SqlParameter[] Parameters = new SqlParameter[7];
Parameters[0] = new SqlParameter("@IssNo", GetIssNo);
Parameters[1] = String.IsNullOrEmpty(LocationAcceptance._CardnAccNo.AccNo) ? new SqlParameter("@AcctNo", DBNull.Value) : new SqlParameter("@AcctNo", LocationAcceptance._CardnAccNo.AccNo);
Parameters[2] = String.IsNullOrEmpty(LocationAcceptance._CardnAccNo.CardNo) ? new SqlParameter("@CardNo", DBNull.Value) : new SqlParameter("@CardNo", LocationAcceptance._CardnAccNo.CardNo);
Parameters[3] = new SqlParameter("@State", Convert.ToString(x));
Parameters[4] = new SqlParameter("@BusnLocation", DBNull.Value);
Parameters[5] = new SqlParameter("@UserId", GetUserId);
Parameters[6] = new SqlParameter("@RETURN_VALUE", SqlDbType.BigInt);
Parameters[6].Direction = ParameterDirection.ReturnValue;
var Cmd = await objDataEngine.ExecuteWithReturnValueAsync("WebLocationAcceptanceMaint", CommandType.StoredProcedure, Parameters);
var result = Convert.ToInt32(Cmd.Parameters["@RETURN_VALUE"].Value);
Descp = await GetMessageCode(result);
objDataEngine.CloseConnection();
}
objDataEngine.CloseConnection();
return(Descp);
}
else
{
objDataEngine.InitiateConnection();
SqlParameter[] Parameters = new SqlParameter[7];
Parameters[0] = new SqlParameter("@IssNo", GetIssNo);
Parameters[1] = String.IsNullOrEmpty(LocationAcceptance._CardnAccNo.AccNo) ? new SqlParameter("@AcctNo", DBNull.Value) : new SqlParameter("@AcctNo", LocationAcceptance._CardnAccNo.AccNo);
Parameters[2] = String.IsNullOrEmpty(LocationAcceptance._CardnAccNo.CardNo) ? new SqlParameter("@CardNo", DBNull.Value) : new SqlParameter("@CardNo", LocationAcceptance._CardnAccNo.CardNo);
Parameters[3] = new SqlParameter("@State", null);
Parameters[4] = String.IsNullOrEmpty(LocationAcceptance.BusnLoc) ? new SqlParameter("@BusnLocation", DBNull.Value) : new SqlParameter("@BusnLocation", LocationAcceptance.BusnLoc);
Parameters[5] = new SqlParameter("@UserId", GetUserId);
Parameters[6] = new SqlParameter("@RETURN_VALUE", SqlDbType.BigInt);
Parameters[6].Direction = ParameterDirection.ReturnValue;
var Cmd = await objDataEngine.ExecuteWithReturnValueAsync("WebLocationAcceptanceMaint", CommandType.StoredProcedure, Parameters);
var result = Convert.ToInt32(Cmd.Parameters["@RETURN_VALUE"].Value);
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 <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 ActionResult SaveLocationAccept(LocationAcceptListModel _LocationAcceptList, CardnAccNo _CardnAcctNo)
{
var _saveLocationAccept = objCardHoldersOps.SaveLocationAccept(_LocationAcceptList);
return(Json(new { resultCd = _saveLocationAccept }, JsonRequestBehavior.AllowGet));
}
