public UbigeoBEList GetListaProvincia(String idDepartamento)
{
UbigeoBEList lista = new UbigeoBEList();
IDataReader DReader = null;
try
{
using (Database db = new Database())
{
db.ProcedureName = "sgsnet_sps_listado_provincia";
db.AddParameter("@vi_ch_cod_dpto", DbType.String, ParameterDirection.Input, idDepartamento);
DReader = db.GetDataReader();
}
while (DReader.Read())
{
UbigeoBE oUbigeoBE = CrearEntidadProvincia(DReader);
lista.Add(oUbigeoBE);
}
DReader.Close();
}
catch
{
if (DReader != null && !DReader.IsClosed)
{
DReader.Close();
}
throw;
}
return(lista);
}
public UbigeoBEList GetListaLeyendaUbigeo()
{
UbigeoBEList lista = new UbigeoBEList();
IDataReader DReader = null;
try
{
using (Database db = new Database())
{
db.ProcedureName = "sgsnet_sps_listado_leyenda_ubigeo";
DReader = db.GetDataReader();
}
while (DReader.Read())
{
UbigeoBE oUbigeoBE = CrearEntidadLeyendaUbigeo(DReader);
lista.Add(oUbigeoBE);
}
DReader.Close();
}
catch
{
if (DReader != null && !DReader.IsClosed)
{
DReader.Close();
}
throw;
}
return(lista);
}