public DataSet BuscarPokemonPorNombre(RequestBuscarPokemonPorNombre oPokemonRequest) { using (SqlConnection cn = SqlCN) { DataSet ds = new DataSet(); SqlDataAdapter sql_adapter; try { cn.Open(); using (SqlCommand cmd = new SqlCommand("SP_BuscarPokemonPorNombre", cn)) { cmd.CommandType = System.Data.CommandType.StoredProcedure; cmd.Parameters.Add(new SqlParameter("@TextoBusqueda", oPokemonRequest.ValorBusqueda)); sql_adapter = new SqlDataAdapter(cmd); sql_adapter.Fill(ds); } } catch (Exception ex) { throw ex; } finally { cn.Close(); cn.Dispose(); } return(ds); } }
public List <ResponseBuscarPokemonPorNombre> BuscarPokemonPorNombre([FromBody] RequestBuscarPokemonPorNombre RequestPokemon) { try { List <ResponseBuscarPokemonPorNombre> oPokemonResponse = new List <ResponseBuscarPokemonPorNombre>(); DataSet ds = oDatos.BuscarPokemonPorNombre(RequestPokemon); int idPokemon; if (ds.Tables[0].Rows.Count > 0) { for (int i = 0; i < ds.Tables[0].Rows.Count; i++) { ResponseBuscarPokemonPorNombre oPokemon = new ResponseBuscarPokemonPorNombre(); idPokemon = Convert.ToInt32(ds.Tables[0].Rows[i]["id"].ToString()); oPokemon.id_pokemon = idPokemon; oPokemon.nombre_pokemon = ds.Tables[0].Rows[i]["pokemon_name"].ToString(); oPokemon.img_pokemon = ds.Tables[0].Rows[i]["name_img"].ToString(); if (ds.Tables[1].Rows.Count > 0) { List <Tipos> oTiposResponse = new List <Tipos>(); for (int x = 0; x < ds.Tables[1].Rows.Count; x++) { if (ds.Tables[1].Rows[x]["id"].ToString() == idPokemon.ToString()) { Tipos oENT_Tipos = new Tipos(); oENT_Tipos.Tipo_Nombre = ds.Tables[1].Rows[x]["español_name"].ToString(); oTiposResponse.Add(oENT_Tipos); } } oPokemon.Tipos = oTiposResponse; } oPokemonResponse.Add(oPokemon); } } return(oPokemonResponse); } catch (Exception ex) { throw ex; } }