public OutBanks GetBanks()
{
OutBanks data = new OutBanks();
try
{
ParametersDAO dao = new ParametersDAO();
data = dao.GetBanks();
}
catch (Exception ex)
{
//escribir en el log
LogHelper.WriteLog("Models", "ManagerParameters", "GetBanks", ex, "");
}
return(data);
}
/// <summary>
/// Gets the banks.
/// </summary>
/// <returns></returns>
/// <exception cref="Exception">ParametersDAO.GetBanks</exception>
public OutBanks GetBanks()
{
string connectionString = DataBaseHelper.GetConnectionString("DLG");
OutBanks response = new OutBanks();
var ora = new OracleServer(connectionString);
Banks bank;
List <Banks> list = new List <Banks>();
string command = string.Empty;
try
{
command = " select trim(A.BCO_NIT_ENTIDAD) as BCO_NIT_ENTIDAD, trim(A.Bco_Nombre_Entidad ) as Bco_Nombre_Entidad ";
command = command + " from dfcpsn02_bancos A where A.nui > 0 order by 2";
var rdr = ora.ExecuteCommand(command);
while (rdr.Read())
{
bank = new Banks();
bank.entityNIT = DBNull.Value.Equals(rdr["BCO_NIT_ENTIDAD"]) ? string.Empty : rdr["BCO_NIT_ENTIDAD"].ToString();
bank.entityName = DBNull.Value.Equals(rdr["Bco_Nombre_Entidad"]) ? string.Empty : rdr["Bco_Nombre_Entidad"].ToString();
list.Add(bank);
}
rdr.Close();
response.lstBanks = list;
response.msg = new Response();
response.msg.errorCode = "200";
response.msg.errorMessage = "OK";
}
catch (Exception ex)
{
throw new Exception("ParametersDAO.GetBanks", ex);
}
finally
{
ora.Dispose();
}
return(response);
}
