public List <VE_Bank> getCompanyBankBalanceDetail(string companyCode) { VE_Bank _veBank = null; List <VE_Bank> _lstBank = new List <VE_Bank>(); Dictionary <string, object> parameters = new Dictionary <string, object>() { { "_companyCode", companyCode } }; var rows = _database.QuerySP("sps_obtenerBalanceBanco", parameters); foreach (var row in rows) { _veBank = new VE_Bank(); _veBank.bankId = string.IsNullOrEmpty(row["id"]) ? 0 : int.Parse(row["id"]); _veBank.bankInterCode = row["BankInterCode"]; _veBank.bankName = row["BankName"]; _veBank.bankShortName = row["BankShortName"]; _veBank.accountNumber = row["AccountNumber"]; _veBank.currency = row["Currency"]; _veBank.status = row["Status"]; _veBank.balance = row["Balance"]; _veBank.accounting = row["Accounting"]; _veBank.cash = row["Cash"]; _lstBank.Add(_veBank); } return(_lstBank); }
public VE_Bank createBank(VE_Bank _VeBank) { int filasAfectadas = 0; string strError_Mensaje = string.Empty; bool boResultado = false; Dictionary <string, object> parameters = new Dictionary <string, object>(); parameters.Add("_id", _VeBank.bankId); parameters.Add("_bankInterCode", _VeBank.bankInterCode); parameters.Add("_bankName", _VeBank.bankName); parameters.Add("_bankShortName", _VeBank.bankShortName); parameters.Add("_bankMasterId", _VeBank.bankMasterId); parameters.Add("_isEnabled", _VeBank.isEnabled); parameters.Add("_userAudit", _VeBank.userAudit); filasAfectadas = _database.ExecuteSP("spi_insertBank", parameters); boResultado = (filasAfectadas > 0); if (boResultado) { return(_VeBank); } return(null); }
public BE_Json DeleteBank([FromBody] VE_Bank _VeBank) { //BL_Bank _blBank = new BL_Bank(); //_blBank.connectionString = AppConfig.DbConnection; //return _blBank.DeleteBank(_VeBank); BE_Json objJson = null; var objListaAux = string.Empty; try { BL_Bank _blBank = new BL_Bank(); _blBank.connectionString = AppConfig.DbConnection; //return _blBank.GetCompanyBankBalance(companyCode); objListaAux = JsonConvert.SerializeObject(_blBank.DeleteBank(_VeBank)); objJson = new BE_Json(); objJson.data = objListaAux; objJson.status = CManager.RESULTADO_WCF.OK; } catch (Exception ex) { objJson = new BE_Json(); objJson.data = "Hubo en error en servidor:" + ex.Message + ";" + ex.StackTrace + ";" + ex.ToString(); objJson.status = CManager.RESULTADO_WCF.ERROR; objJson.status = CManager.RESULTADO_WCF.ERROR; } finally { objListaAux = null; } return(objJson); }
public List <VE_Bank> getBankAccountByAuthId(int paymentAuthId) { VE_Bank _beBank = null; List <VE_Bank> _lstBankAccount = new List <VE_Bank>(); Dictionary <string, object> parameters = new Dictionary <string, object>() { { "_paymentAuthId", paymentAuthId } }; var rows = _database.QuerySP("sps_getBankAccountByAuthId", parameters); foreach (var row in rows) { _beBank = new VE_Bank(); _beBank.bankId = string.IsNullOrEmpty(row["BankId"]) ? 0 : int.Parse(row["BankId"]); _beBank.paymentAuthId = string.IsNullOrEmpty(row["PaymentAuthId"]) ? 0 : int.Parse(row["PaymentAuthId"]); // _beBank.companyCode = row["CompanyCode"]; _beBank.bankShortName = row["BankShortName"]; // _beBank.currency = row["Currency"]; // _beBank.balance = row["Balance"]; _beBank.bankAccountId = string.IsNullOrEmpty(row["BankAccountId"]) ? 0 : int.Parse(row["BankAccountId"]); _beBank.accountNumber = row["BankAccountNumber"]; _lstBankAccount.Add(_beBank); } return(_lstBankAccount); }
public VE_Bank CreateBank(VE_Bank _VeBank) { _database = new MySQLDatabase(connectionString); return(new DA_Bank(_database).createBank(_VeBank)); }