public async Task <MsgRetriever> SaveBusnLocTerm(BusnLocTerminal _BusnLocTerminal)
{
var objDataEngine = new FleetDataEngine(AccessMode.CustomerService, DBType.Maint);
objDataEngine.InitiateConnection();
SqlParameter[] Parameters = new SqlParameter[16];
Parameters[0] = new SqlParameter("@AcqNo", this.GetAcqNo);
Parameters[1] = String.IsNullOrEmpty(_BusnLocTerminal.BusnLocation) ? new SqlParameter("@BusnLocation", DBNull.Value) : new SqlParameter("@BusnLocation", _BusnLocTerminal.BusnLocation);
Parameters[2] = String.IsNullOrEmpty(_BusnLocTerminal.TermId) ? new SqlParameter("@TermId", DBNull.Value) : new SqlParameter("@TermId", _BusnLocTerminal.TermId);
Parameters[3] = String.IsNullOrEmpty(_BusnLocTerminal.SelectedStatus) ? new SqlParameter("@Sts", DBNull.Value) : new SqlParameter("@Sts", _BusnLocTerminal.SelectedStatus);
Parameters[4] = String.IsNullOrEmpty(_BusnLocTerminal.DeployDate) ? new SqlParameter("@DeployDate", DBNull.Value) : new SqlParameter("@DeployDate", ConvertDatetimeDB(_BusnLocTerminal.DeployDate));
Parameters[5] = String.IsNullOrEmpty(_BusnLocTerminal.SaleTerritory) ? new SqlParameter("@SaleTerritory", DBNull.Value) : new SqlParameter("@SaleTerritory", _BusnLocTerminal.SaleTerritory);
Parameters[6] = String.IsNullOrEmpty(_BusnLocTerminal.Replacement) ? new SqlParameter("@ReplacedByTermId", DBNull.Value) : new SqlParameter("@ReplacedByTermId", _BusnLocTerminal.Replacement);
Parameters[7] = String.IsNullOrEmpty(_BusnLocTerminal.ReplacedDate) ? new SqlParameter("@ReplacedDate", DBNull.Value) : new SqlParameter("@ReplacedDate", ConvertDatetimeDB(_BusnLocTerminal.ReplacedDate));
Parameters[8] = String.IsNullOrEmpty(_BusnLocTerminal.SelectedReasonCode) ? new SqlParameter("@ReasonCd", DBNull.Value) : new SqlParameter("@ReasonCd", _BusnLocTerminal.SelectedReasonCode);
Parameters[9] = String.IsNullOrEmpty(_BusnLocTerminal.IPEK) ? new SqlParameter("@IPEK", DBNull.Value) : new SqlParameter("@IPEK", _BusnLocTerminal.IPEK);
Parameters[10] = String.IsNullOrEmpty(_BusnLocTerminal.SelectedProdType) ? new SqlParameter("@DeviceModel", DBNull.Value) : new SqlParameter("@DeviceModel", _BusnLocTerminal.SelectedProdType);
Parameters[11] = String.IsNullOrEmpty(_BusnLocTerminal.SerialNo) ? new SqlParameter("@SerialNo", DBNull.Value) : new SqlParameter("@SerialNo", _BusnLocTerminal.SerialNo);
Parameters[12] = String.IsNullOrEmpty(_BusnLocTerminal.Remarks) ? new SqlParameter("@Remarks", DBNull.Value) : new SqlParameter("@Remarks", _BusnLocTerminal.Remarks);
Parameters[13] = String.IsNullOrEmpty(_BusnLocTerminal.SelectedTermType) ? new SqlParameter("@TermType", DBNull.Value) : new SqlParameter("@TermType", _BusnLocTerminal.SelectedTermType);
Parameters[14] = String.IsNullOrEmpty(this.GetUserId) ? new SqlParameter("@UserId", DBNull.Value) : new SqlParameter("@UserId", this.GetUserId);
Parameters[15] = new SqlParameter("@RETURN_VALUE", SqlDbType.BigInt);
Parameters[15].Direction = ParameterDirection.ReturnValue;
var Cmd = objDataEngine.ExecuteWithReturnValue("WebBusnLocationTerminalMaint", CommandType.StoredProcedure, Parameters);
var Result = Convert.ToInt32(Cmd.Parameters["@RETURN_VALUE"].Value);
var Descp = GetMessageCode(Result);
objDataEngine.CloseConnection();
return(await Descp);
}
/*************************************
* Created by: Tuan Tran
* Created on: Mar 3, 2017
* Function: SaveBusnLocTerm
* Purpose: SaveBusnLocTerm
* Inputs: MerchantDetails
* Returns: SaveGeneralInfoResponse
*************************************/
public async Task <SaveAcctSignUpResponse> SaveBusnLocTerm(BusnLocTerminal merch)
{
Logger.Info("Invoking SaveBusnLocTerm function");
var response = new SaveAcctSignUpResponse()
{
Status = ResponseStatus.Failure,
};
try
{
using (var scope = Container.BeginLifetimeScope())
{
var mechSignUpDAO = scope.Resolve <IMechSignUpDAO>();
var controlDAO = scope.Resolve <IControlDAO>();
var busnLocTerminal = Mapper.Map <BusnLocTerminal, BusnLocTerminalDTO>(merch);
var result = await mechSignUpDAO.SaveBusnLocTerm(busnLocTerminal);
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 SaveBusnLocTerm: detail:{0}", ex.Message);
Logger.Error(msg, ex);
response.Status = ResponseStatus.Exception;
response.desp = ex.Message;
response.flag = 1;
response.Message = msg;
}
return(response);
}
public MechSignUpResponse()
{
merchGeneralInfo = new MA_GeneralInfo();
merchantDetail = new MerchantDetails();
merchChangeOwnerships = new List <MerchChangeOwnership>();
merchProductPrizes = new List <MerchProductPrize>();
busnLocTerminal = new BusnLocTerminal();
busnLocTerminals = new List <BusnLocTerminal>();
eService = new eService();
eServices = new List <eService>();
merchantDetails = new List <MerchantDetails>();
merchPostedTxnSearches = new List <MerchPostedTxnSearch>();
merchAgreements = new List <MA_GeneralInfo>();
merchChangeOwnership = new MerchChangeOwnership();
}
public async Task <BusnLocTerminal> GetBusnLocTermDetail(string TermId, string BusnLocation)
{
var objDataEngine = new FleetDataEngine(AccessMode.CustomerService, DBType.Maint);
objDataEngine.InitiateConnection();
SqlParameter[] Parameters = new SqlParameter[3];
Parameters[0] = new SqlParameter("@AcqNo", this.GetAcqNo);
Parameters[1] = String.IsNullOrEmpty(BusnLocation) ? new SqlParameter("@BusnLocation", DBNull.Value) : new SqlParameter("@BusnLocation", BusnLocation);
Parameters[2] = String.IsNullOrEmpty(TermId) ? new SqlParameter("@TermId", DBNull.Value) : new SqlParameter("@TermId", TermId);
var execResult = objDataEngine.ExecuteCommand("WebBusnLocationTerminalSelect", CommandType.StoredProcedure, Parameters);
while (execResult.Read())
{
var _BusnLocTermDetail = new BusnLocTerminal
{
TermId = Convert.ToString(execResult["TermId"]),
SelectedTermType = Convert.ToString(execResult["TermType"]),
SelectedStatus = Convert.ToString(execResult["Sts"]),
DeployDate = DateConverter(execResult["DeployDate"]),
SaleTerritory = Convert.ToString(execResult["SaleTerritory"]),
Replacement = Convert.ToString(execResult["ReplacedByTermId"]),
ReplacedDate = DateConverter(execResult["ReplacedDate"]),
ReasonCd = await BaseClass.WebGetRefLib("TermReasonCd"),
SelectedReasonCode = Convert.ToString(execResult["ReasonCd"]),
IPEK = Convert.ToString(execResult["IPEK"]),
SettlementStart = DateConverter(execResult["SettleFromTime"]),
SettlementEnd = DateConverter(execResult["SettleToTime"]),
LastBatchId = ConvertInt(execResult["LastBatchId"]),
SettleTxnId = ConvertInt(execResult["SettleTxnId"]),
SelectedProdType = Convert.ToString(execResult["DeviceModel"]),
SerialNo = Convert.ToString(execResult["SerialNo"]),
Remarks = Convert.ToString(execResult["Remarks"]),
CreationDate = DateConverter(execResult["CreationDate"]),
UserId = Convert.ToString(execResult["UserId"]),
LastUpdDate = DateConverter(execResult["LastUpdDate"]),
};
objDataEngine.CloseConnection();
return(_BusnLocTermDetail);
}
;
objDataEngine.CloseConnection();
return(new BusnLocTerminal());
}
public async Task <ActionResult> FillData(string prefix, string id)
{
switch (prefix)
{
case "gen":
var data = (await MechSignUpService.GetBusinessLocationGeneralInfoDetail(id)).merchantDetail;
var _dealerGenInfo = new MerchantDetails
{
Ownership = await BaseService.GetRefLib("MerchOwnership"),
SIC = await BaseService.GetMerchType("S"),
DBARegion = await BaseService.GetRefLib("RegionCd"),
DBACity = await BaseService.GetRefLib("City"),
DBAState = await BaseService.WebGetState(null),
BankAcctType = await BaseService.GetRefLib("BankAcctType"),
BankBranchCode = await BaseService.GetRefLib("BranchCd"),
cycNo = await BaseService.GetCycle("A"),
CurrentStatus = await BaseService.GetRefLib("MerchAcctSts"),
ReasonCd = await BaseService.GetRefLib("MerchReasonCd"),
MCC = await BaseService.GetMerchType("MerchType"),
BankAcctName = await BaseService.GetRefLib("Bank"),
AreaCodes = await BaseService.GetRefLib("AreaCd")
};
return(Json(new { Selects = _dealerGenInfo, Model = data }, JsonRequestBehavior.AllowGet));
case "ter":
var term = new BusnLocTerminal
{
Status = await BaseService.GetRefLib("TermSts"),
ProdType = await BaseService.GetDeviceModel(),
TermType = await BaseService.GetRefLib("TermType"),
ReasonCd = await BaseService.GetRefLib("TermReasonCd"),
UserId = this.GetUserId,
CreationDate = NumberExtensions.DateConverter(System.DateTime.Now.ToString())
};
return(Json(new { Selects = term, Model = new BusnLocTerminal() }, JsonRequestBehavior.AllowGet));
case "con":
var otherContactList = new ContactLstModel
{
ContactType = await BaseService.GetRefLib("Contact"),
Occupation = await BaseService.GetRefLib("Occupation"),
Sts = await BaseService.GetRefLib("ContactSts"),
};
var model = new ContactLstModel
{
UserId = HttpContext.User.Identity.Name,
CreationDate = System.DateTime.Now.ToString()
};
return(Json(new { Selects = otherContactList, Model = model }, JsonRequestBehavior.AllowGet));
case "add":
var countries = await BaseService.GetRefLib("Country");
var AddrSelects = new AddrListMaintModel
{
addrtype = await BaseService.GetRefLib("Address"),
State = countries.Count() > 1 ? await BaseService.WebGetState(countries[1].Value) : null, //changes
Country = countries,
region = await BaseService.GetRefLib("RegionCd"),
};
var AddrModel = new AddrListMaintModel
{
UserId = this.GetUserId,
CreationDate = System.DateTime.Now.ToString(),
RefTo = "BUSN",
RefKey = Convert.ToString(id)
};
return(Json(new { Selects = AddrSelects, Model = AddrModel }, JsonRequestBehavior.AllowGet));
case "sts":
var StsDetails = (await CardHolderService.GetChangedAcctStsDetail(id.ToString(), "BUSN")).changeStatus;
var selecs = new ChangeStatus
{
CurrentStatus = await BaseService.GetRefLib("MerchAcctSts"),
RefType = await BaseService.GetRefLib("EventType"),
ReasonCode = await BaseService.GetRefLib("MerchReasonCd", ""),
ChangeStatusTo = await BaseService.GetRefLib("MerchAcctSts")
};
return(Json(new { Model = StsDetails, Selects = selecs }, JsonRequestBehavior.AllowGet));
case "prs":
var _Prz = new MerchProductPrize
{
ProdCd = await BaseService.WebGetProduct(null, false)
};
return(Json(new { Selects = _Prz, Model = new MerchProductPrize() }, JsonRequestBehavior.AllowGet));
case "own":
var _OwnerShip = new MerchChangeOwnership
{
BankAcctType = await BaseService.GetRefLib("BankAcctType"),
BankName = await BaseService.GetRefLib("Bank"),
DBAState = await BaseService.WebGetState(null)
};
var ownershipInfo = (await MechSignUpService.GetMerchChgOwnership(id)).merchChangeOwnership;
return(Json(new { Selects = _OwnerShip, Model = ownershipInfo }, JsonRequestBehavior.AllowGet));
default:
HttpContext.Response.StatusCode = 404;
return(Json(null, JsonRequestBehavior.AllowGet));
}
}
public async Task <ActionResult> SaveTermInventory(BusnLocTerminal _BusnLocTerminal)//DealerSaveTerminal
{
var _saveTermInv = await MechSignUpService.SaveBusnLocTerm(_BusnLocTerminal);
return(Json(new { resultCd = _saveTermInv }, JsonRequestBehavior.AllowGet));
}
public async Task <ActionResult> FillData(string prefix, string AcctNo)
{
switch (prefix)
{
case "gen":
var MerchGenInfo = (await MechSignUpService.GetMAGeneralInfoDetail(AcctNo)).merchGeneralInfo;
var _MAGeneralInfo = new MA_GeneralInfo
{
AffiliatedWithCorpCode = await BaseService.WebGetCorpCd(true),
BankAcctType = await BaseService.GetRefLib("BankAcctType"),
BankBranchCd = await BaseService.GetRefLib("BranchCd"),
CurrentStatus = await BaseService.GetRefLib("MerchAcctSts"),
CycleNo = await BaseService.GetCycle("A"),
ReasonCd = await BaseService.GetRefLib("MerchReasonCd"),
BusnModel = await BaseService.GetRefLib("BusnModel"),
BusnSize = await BaseService.GetRefLib("BusnSize"),
Ownership = await BaseService.GetRefLib("MerchOwnership"),
BankName = await BaseService.GetRefLib("Bank"),
};
return(Json(new { Selects = _MAGeneralInfo, Model = MerchGenInfo }, JsonRequestBehavior.AllowGet));
case "mai":
case "bus":
var _MerchantDetails = new MerchantDetails
{
DBACity = await BaseService.GetRefLib("city"),
DBARegion = await BaseService.GetRefLib("RegionCd"),
DBAState = await BaseService.WebGetState(null),
BankAcctType = await BaseService.GetRefLib("BankAcctType"),
CurrentStatus = await BaseService.GetRefLib("MerchAcctSts"),
Ownership = await BaseService.GetRefLib("MerchOwnership"),
SIC = await BaseService.GetMerchType("S"),
};
return(Json(new { Selects = _MerchantDetails, Model = new MerchantDetails() }, JsonRequestBehavior.AllowGet));
case "car":
return(PartialView(this.getPartialPath("MerchGeneralInfo", "CAMaint_CardRange_Partial")));
case "agr":
var _MA_GeneralInfo = new MA_GeneralInfo
{
AffiliatedWithCorpCode = await BaseService.WebGetCorpCd(true),
BankAcctType = await BaseService.GetRefLib("BankAcctType"),
BankBranchCd = await BaseService.GetRefLib("BranchCd"),
BusnEst = await BaseService.GetRefLib("BusnEst"),
CurrentStatus = await BaseService.GetRefLib("MerchAcctSts"),
ReasonCd = await BaseService.GetRefLib("MerchReasonCd"),
BusnModel = await BaseService.GetRefLib("BusnModel")
};
return(Json(new { Selects = _MA_GeneralInfo, Model = new MA_GeneralInfo() }, JsonRequestBehavior.AllowGet));
case "BusnTerm":
var _BusnLocTerminal = new BusnLocTerminal
{
Status = await BaseService.GetRefLib("MerchAcctSts"),
ProdType = await BaseService.GetRefLib("ProdType"),
ReasonCd = await BaseService.GetRefLib("TermReasonCd"),
UserId = this.GetUserId,
CreationDate = NumberExtensions.DateConverter(System.DateTime.Now.ToString())
};
return(Json(new { Selects = _BusnLocTerminal, Model = new BusnLocTerminal() }, JsonRequestBehavior.AllowGet));
case "mps":
var _merchPstTxnSearch = new MerchPostedTxnSearch
{
Dealer = await BaseService.WebGetDealerByMerch(AcctNo),
TxnCd = await BaseService.WebGetTxnCode("A"),
};
return(Json(new { Selects = _merchPstTxnSearch, Model = new MerchPostedTxnSearch() }, JsonRequestBehavior.AllowGet));
case "evt":
var logger = new EventLogger
{
EventType = await BaseService.GetRefLib("EventType"),
ReasonCd = await BaseService.GetRefLib("MerchReasonCd")
};
return(Json(new { Selects = logger, Model = new EventLogger() }, JsonRequestBehavior.AllowGet));
case "sts":
var stsDetails = await CardHolderService.GetChangedAcctStsDetail(AcctNo.ToString(), "MERCH");
var sts = new ChangeStatus
{
CurrentStatus = await BaseService.GetRefLib("MerchAcctSts"),
RefType = await BaseService.GetRefLib("EventType"),
ReasonCode = await BaseService.GetRefLib("MerchReasonCd", ""),
ChangeStatusTo = await BaseService.GetRefLib("MerchAcctSts")
};
return(Json(new { Selects = sts, Model = stsDetails.changeStatus }, JsonRequestBehavior.AllowGet));
case "mpp":
var model = new MerchProductPrize
{
ProdCd = await BaseService.WebGetProduct(null, false)
};
return(Json(new { Selects = model, Model = new MerchProductPrize() }, JsonRequestBehavior.AllowGet));
default:
return(PartialView());
}
}
