public IList <ADM_UBIGEO> GetAllFilters(ADM_UBIGEO entity)
        {
            List <ADM_UBIGEO> ubigeo = new List <ADM_UBIGEO>();

            using (var comando = _database.GetStoredProcCommand(string.Format("{0}{1}", ConectionStringRepository.EsquemaName, "p_ADM_UBIGEO_GetAllFilters")))
            {
                _database.AddInParameter(comando, "@valor", DbType.String, entity.ValorBusqueda);

                using (var lector = _database.ExecuteReader(comando))
                {
                    while (lector.Read())
                    {
                        ubigeo.Add(new ADM_UBIGEO
                        {
                            id_ubigeo      = lector.IsDBNull(lector.GetOrdinal("id_ubigeo")) ? default(int) : lector.GetInt32(lector.GetOrdinal("id_ubigeo")),
                            c_codigo       = lector.IsDBNull(lector.GetOrdinal("c_codigo")) ? default(string) : lector.GetString(lector.GetOrdinal("c_codigo")),
                            t_pais         = lector.IsDBNull(lector.GetOrdinal("t_pais")) ? default(string) : lector.GetString(lector.GetOrdinal("t_pais")),
                            t_departamento = lector.IsDBNull(lector.GetOrdinal("t_departamento")) ? default(string) : lector.GetString(lector.GetOrdinal("t_departamento")),
                            t_provincia    = lector.IsDBNull(lector.GetOrdinal("t_provincia")) ? default(string) : lector.GetString(lector.GetOrdinal("t_provincia")),
                            t_distrito     = lector.IsDBNull(lector.GetOrdinal("t_distrito")) ? default(string) : lector.GetString(lector.GetOrdinal("t_distrito")),
                        });
                    }
                }
            }

            return(ubigeo);
        }
 public IList <ADM_UBIGEO> GetById(ADM_UBIGEO entity)
 {
     throw new NotImplementedException();
 }
 public int Delete(ADM_UBIGEO entity)
 {
     throw new NotImplementedException();
 }
 public bool Exists(ADM_UBIGEO entity)
 {
     throw new NotImplementedException();
 }
 public IList <ADM_UBIGEO> GetAllFilters(ADM_UBIGEO entity)
 {
     return(ADM_UBIGEORepository.Instancia.GetAllFilters(entity));
 }