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()); } }