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