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