public async Task <MsgRetriever> SaveBusnLocationGeneralInfo(MerchantDetails merch) { var objDataEngine = new FleetDataEngine(AccessMode.CustomerService, DBType.Maint); objDataEngine.InitiateConnection(); SqlParameter[] Parameters = new SqlParameter[41]; Parameters[0] = new SqlParameter("@Func", GetIssNo); Parameters[1] = new SqlParameter("@AcqNo", this.GetAcqNo); Parameters[2] = String.IsNullOrEmpty(merch.AcctNo) ? new SqlParameter("@AcctNo", DBNull.Value) : new SqlParameter("@AcctNo", merch.AcctNo); Parameters[3] = String.IsNullOrEmpty(merch.BusnLoc) ? new SqlParameter("@BusnLocation", DBNull.Value) : new SqlParameter("@BusnLocation", merch.BusnLoc); Parameters[4] = String.IsNullOrEmpty(merch.BusinessName) ? new SqlParameter("@BusnName", DBNull.Value) : new SqlParameter("@BusnName", merch.BusinessName); Parameters[5] = String.IsNullOrEmpty(merch.SiteId) ? new SqlParameter("@SiteId", DBNull.Value) : new SqlParameter("@SiteId", merch.SiteId); Parameters[6] = String.IsNullOrEmpty(merch.AgreementNo) ? new SqlParameter("@AgreeNo", DBNull.Value) : new SqlParameter("@AgreeNo", merch.AgreementNo); Parameters[7] = new SqlParameter("@AgreeDate", BaseClass.DateConverterDB(merch.AgreementDate)); Parameters[8] = String.IsNullOrEmpty(merch.PersonInCharge) ? new SqlParameter("@PersonInChrg", DBNull.Value) : new SqlParameter("@PersonInChrg", merch.PersonInCharge); Parameters[9] = String.IsNullOrEmpty(merch.selectedOwnershsip) ? new SqlParameter("@Ownership", DBNull.Value) : new SqlParameter("@Ownership", merch.selectedOwnershsip); Parameters[10] = String.IsNullOrEmpty(merch.BusnSize) ? new SqlParameter("@Establishment", DBNull.Value) : new SqlParameter("@Establishment", merch.BusnSize); Parameters[11] = String.IsNullOrEmpty(merch.SelectedSIC) ? new SqlParameter("@Sic", DBNull.Value) : new SqlParameter("@Sic", merch.SelectedSIC); Parameters[12] = String.IsNullOrEmpty(merch.MCC) ? new SqlParameter("@Mcc", DBNull.Value) : new SqlParameter("@Mcc", merch.MCC); Parameters[13] = String.IsNullOrEmpty(merch.CoRegNo) ? new SqlParameter("@CoRegNo", DBNull.Value) : new SqlParameter("@CoRegNo", merch.CoRegNo); Parameters[14] = String.IsNullOrEmpty(merch.CoRegName) ? new SqlParameter("@CoRegName", DBNull.Value) : new SqlParameter("@CoRegName", merch.CoRegName); Parameters[15] = new SqlParameter("@CoRegDate", BaseClass.DateConverterDB(merch.CoRegDate)); Parameters[16] = new SqlParameter("@OwnershipTrsfDate", BaseClass.DateConverterDB(merch.OwnershipTrsfDate)); Parameters[17] = String.IsNullOrEmpty(merch.OwnershipTo) ? new SqlParameter("@OwnershipTo", DBNull.Value) : new SqlParameter("@OwnershipTo", merch.OwnershipTo); Parameters[18] = String.IsNullOrEmpty(merch.DBAName) ? new SqlParameter("@DBAName", DBNull.Value) : new SqlParameter("@DBAName", merch.DBAName); Parameters[19] = String.IsNullOrEmpty(merch.SelectDBARegion) ? new SqlParameter("@DBARegion", DBNull.Value) : new SqlParameter("@DBARegion", merch.SelectDBARegion); Parameters[20] = String.IsNullOrEmpty(merch.SelectDBACity) ? new SqlParameter("@DBACity", DBNull.Value) : new SqlParameter("@DBACity", merch.SelectDBACity); Parameters[21] = String.IsNullOrEmpty(merch.SelectDBAState) ? new SqlParameter("@DBAState", DBNull.Value) : new SqlParameter("@DBAState", merch.SelectDBAState); Parameters[22] = String.IsNullOrEmpty(merch.PayeeName) ? new SqlParameter("@PayeeName", DBNull.Value) : new SqlParameter("@PayeeName", merch.PayeeName); Parameters[23] = new SqlParameter("@AutoDebit", BaseClass.ConvertBoolDB(merch.AutoDebitInd)); Parameters[24] = String.IsNullOrEmpty(merch.BankAcctName) ? new SqlParameter("@BankName", DBNull.Value) : new SqlParameter("@BankName", merch.BankAcctName); Parameters[25] = String.IsNullOrEmpty(merch.selectedBankAcctType) ? new SqlParameter("@BankAcctType", DBNull.Value) : new SqlParameter("@BankAcctType", merch.selectedBankAcctType); Parameters[26] = String.IsNullOrEmpty(merch.BankAccountNo) ? new SqlParameter("@BankAcctNo", DBNull.Value) : new SqlParameter("@BankAcctNo", merch.BankAccountNo); Parameters[27] = String.IsNullOrEmpty(merch.SelectedBankBranchCode) ? new SqlParameter("@BankBranchCd", DBNull.Value) : new SqlParameter("@BankBranchCd", merch.SelectedBankBranchCode); Parameters[28] = String.IsNullOrEmpty(merch.selectedCurrentStatus) ? new SqlParameter("@Sts", DBNull.Value) : new SqlParameter("@Sts", merch.selectedCurrentStatus); Parameters[29] = String.IsNullOrEmpty(merch.EntityId) ? new SqlParameter("@EntityId", DBNull.Value) : new SqlParameter("@EntityId", merch.EntityId); Parameters[30] = String.IsNullOrEmpty(merch.TaxId) ? new SqlParameter("@TaxId", DBNull.Value) : new SqlParameter("@TaxId", merch.TaxId); Parameters[31] = new SqlParameter("@WithholdInd", BaseClass.ConvertBoolDB(merch.WithholdingTaxInd)); Parameters[32] = String.IsNullOrEmpty(merch.WithholdingTaxRate) ? new SqlParameter("@WithholdRate", DBNull.Value) : new SqlParameter("@WithholdRate", merch.WithholdingTaxRate); Parameters[33] = String.IsNullOrEmpty(merch.SelectedcycNo) ? new SqlParameter("@CycNo", DBNull.Value) : new SqlParameter("@CycNo", merch.SelectedcycNo); Parameters[34] = new SqlParameter("@UserId", this.GetUserId); Parameters[35] = new SqlParameter("@CreationDate", BaseClass.DateConverterDB(merch.CreationDate)); Parameters[36] = String.IsNullOrEmpty(merch.SelectedReasonCode) ? new SqlParameter("@ReasonCd", DBNull.Value) : new SqlParameter("@ReasonCd", merch.SelectedReasonCode); Parameters[37] = new SqlParameter("@StmtPrint", BaseClass.ConvertBoolDB(merch.StmtPrintInd)); Parameters[38] = new SqlParameter("@oBusnLocation", SqlDbType.VarChar, 20); Parameters[38].Direction = ParameterDirection.Output; Parameters[39] = new SqlParameter("@oEntityId", SqlDbType.VarChar, 20); Parameters[39].Direction = ParameterDirection.Output; Parameters[40] = new SqlParameter("@RETURN_VALUE", SqlDbType.BigInt); Parameters[40].Direction = ParameterDirection.ReturnValue; var Cmd = objDataEngine.ExecuteWithReturnValue("WebBusnLocationGeneralInfoMaint", CommandType.StoredProcedure, Parameters); var Result = Convert.ToInt32(Cmd.Parameters["@RETURN_VALUE"].Value); this.EntityId = Convert.ToString(Cmd.Parameters["@oEntityId"].Value); this.BusnLoc = Convert.ToString(Cmd.Parameters["@oBusnLocation"].Value); var Descp = GetMessageCode(Result); objDataEngine.CloseConnection(); return(await Descp); }
public async Task <MerchantDetails> GetBusinessLocationGeneralInfoDetail(string acctNo, string BusnLocation) { var objDataEngine = new FleetDataEngine(AccessMode.CustomerService, DBType.Maint); objDataEngine.InitiateConnection(); SqlParameter[] Parameters = new SqlParameter[2]; Parameters[0] = new SqlParameter("@AcqNo", this.GetAcqNo); Parameters[1] = String.IsNullOrEmpty(BusnLocation) ? new SqlParameter("@BusnLocation", DBNull.Value) : new SqlParameter("@BusnLocation", BusnLocation); var Reader = objDataEngine.ExecuteCommand("WebBusnLocationGeneralInfoSelect", CommandType.StoredProcedure, Parameters); while (Reader.Read()) { var _BusinessLocation = new MerchantDetails { BusinessName = Convert.ToString(Reader["BusnName"]), AgreementNo = Convert.ToString(Reader["AgreementNo"]), AgreementDate = BaseClass.DateConverter(Reader["AgreementDate"]), PersonInCharge = Convert.ToString(Reader["PersonInCharge"]), Ownership = await BaseClass.WebGetRefLib("MerchOwnership"), selectedOwnershsip = Convert.ToString(Reader["Ownership"]), BusnSize = Convert.ToString(Reader["Establishment"]), SIC = await BaseClass.WebGetMerchType("S"), SelectedSIC = Convert.ToString(Reader["Sic"]), MCC = Convert.ToString(Reader["Mcc"]), CoRegNo = Convert.ToString(Reader["CoRegNo"]), CoRegName = Convert.ToString(Reader["CoRegName"]), CoRegDate = BaseClass.DateConverter(Reader["CoRegDate"]), OwnershipTrsfDate = Convert.ToString(Reader["OwnershipTrsfDate"]), OwnershipTo = Convert.ToString(Reader["OwnershipTo"]), DBAName = Convert.ToString(Reader["DBAName"]), DBARegion = await BaseClass.WebGetRefLib("RegionCd"), SelectDBARegion = Convert.ToString(Reader["DBARegion"]), DBACity = await BaseClass.WebGetRefLib("City"), SelectDBACity = Convert.ToString(Reader["DBACity"]), DBAState = await BaseClass.WebGetState(GetIssNo, null), SelectDBAState = Convert.ToString(Reader["DBAState"]), PayeeName = Convert.ToString(Reader["PayeeName"]), AutoDebitInd = BaseClass.BoolConverter(Reader["AutoDebitInd"]), BankAcctName = Convert.ToString(Reader["BankName"]), BankAcctType = await BaseClass.WebGetRefLib("BankAcctType"), selectedBankAcctType = Convert.ToString(Reader["BankAcctType"]), BankAccountNo = Convert.ToString(Reader["BankAcctNo"]), BankBranchCode = await BaseClass.WebGetRefLib("BranchCd"), SelectedBankBranchCode = Convert.ToString(Reader["BankBranchCd"]), CurrentStatus = await BaseClass.WebGetRefLib("MerchAcctSts"), selectedCurrentStatus = Convert.ToString(Reader["Sts"]), EntityId = Convert.ToString(Reader["EntityId"]), WithholdingTaxInd = BaseClass.BoolConverter(Reader["WithholdingTaxInd"]), WithholdingTaxRate = Convert.ToString(Reader["WithholdingTaxRate"]), cycNo = await BaseClass.WebGetCycle("A"), SelectedcycNo = Convert.ToString(Reader["CycNo"]), UserID = Convert.ToString(Reader["UserId"]), CreationDate = BaseClass.DateConverter(Reader["CreationDate"]), ReasonCd = await BaseClass.WebGetRefLib("MerchReasonCd"), SelectedReasonCode = Convert.ToString(Reader["ReasonCd"]), StmtPrintInd = BaseClass.BoolConverter(Reader["StmtPrint"]), SiteId = Convert.ToString(Reader["ReconAcct"]), BusnLoc = Convert.ToString(Reader["BusnLocation"]), //PaymentTerms=Convert.ToString(Reader["PaymentTrms"]), // TaxCategory =Convert.ToString(Reader["TaxCode"]) }; objDataEngine.CloseConnection(); return(_BusinessLocation); } ; return(new MerchantDetails()); }