public List <ValueListsBE> listCuentasBancarias()
{
List <ValueListsBE> lstValoresGeneralesBE = new List <ValueListsBE>();
IDataReader dr = null;
try
{
using (DbCommand cmd = dbFenixCat.GetStoredProcCommand(GetNameStoreProcedure.spSelectCtasBancariasTR))
{
//cmd.CommandTimeout = 0;
dbFenixCat.AddInParameter(cmd, "@ctasBancariasID", DbType.String, DBNull.Value);
dbFenixCat.AddInParameter(cmd, "@ctasBanEstado", DbType.String, "1");
dbFenixCat.AddInParameter(cmd, "@PlazaID", DbType.String, DBNull.Value);
dbFenixCat.AddInParameter(cmd, "@ctasBanNumCta", DbType.String, DBNull.Value);
dbFenixCat.AddInParameter(cmd, "@valorTipoEntFinID", DbType.String, DBNull.Value);
dbFenixCat.AddInParameter(cmd, "@valorMonedaID", DbType.String, DBNull.Value);
dr = dbFenixCat.ExecuteReader(cmd);
while (dr.Read())
{
lstValoresGeneralesBE.Add(ValoresGeneralesP.obtenerCuentasBancarias(dr));
}
}
}
catch (Exception)
{
if (dr != null && !dr.IsClosed)
{
dr.Close();
}
throw;
}
return(lstValoresGeneralesBE);
}
public List <ValoresGeneralesBE> listValoresGenerales(ValoresGeneralesBE pValoresGeneralesBE)
{
List <ValoresGeneralesBE> lstValoresGeneralesBE = new List <ValoresGeneralesBE>();
IDataReader dr = null;
try
{
using (DbCommand cmd = dbFenixCat.GetStoredProcCommand(GetNameStoreProcedure.spSelectValorGenerales))
{
//cmd.CommandTimeout = 0;
dbFenixCat.AddInParameter(cmd, "valorID", DbType.Int32, pValoresGeneralesBE.valorID);
dbFenixCat.AddInParameter(cmd, "varCodigo", DbType.Int32, pValoresGeneralesBE.varCodigo);
dr = dbFenixCat.ExecuteReader(cmd);
while (dr.Read())
{
lstValoresGeneralesBE.Add(ValoresGeneralesP.obtenerValoresGenerales(dr));
}
}
}
catch (Exception)
{
if (dr != null && !dr.IsClosed)
{
dr.Close();
}
throw;
}
return(lstValoresGeneralesBE);
}
