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