public pokemonInfo(pokemonObject poke)
{
int pokeIDInt = Convert.ToInt32(poke.pokeID);
setPokemonStats(poke);
setPokemonType(pokeIDInt, poke);
setPokemonAbilities(poke);
}
public void setPokemonAbilities(pokemonObject poke)
{
int slot = 0;
try
{
SqlConnectionStringBuilder builder = new SqlConnectionStringBuilder();
builder.DataSource = "MSI\\MSSQLSERVER01"; // update me
builder.UserID = "pokeuser"; // update me
builder.Password = "******"; // update me
builder.InitialCatalog = "PokemonDatabase";
using (connection = new SqlConnection(builder.ConnectionString))
{
int pokeIDInt = Convert.ToInt32(poke.pokeID);
connection.Open();
SqlDataReader sdr = null;
string sqlText = "pokemon.pr_vSelectPokemonByID_AbilitiesNameAndSlot";
SqlCommand cmd = new SqlCommand(sqlText, connection);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@ID", pokeIDInt);
sdr = cmd.ExecuteReader();
while (sdr.Read())
{
slot = sdr.GetInt32(1);
if (slot > 3)
{
slot = 3;
}
switch (slot)
{
case 1:
poke.abilityOne = sdr.GetString(0);
break;
case 2:
poke.abilityTwo = sdr.GetString(0);
break;
case 3:
poke.abilityThree = sdr.GetString(0);
break;
default:
poke.abilityThree = sdr.GetString(0);
break;
}
}
}
}
catch (SqlException e)
{
Console.WriteLine(e.ToString());
}
}
public void pokemonSelection(pokemonObject si)
{
pokemonObject currentPokemon = si;
pi = new pokemonInfo(currentPokemon);
drawReset();//Reset Statbar drawings
pokemonNameLabel.Text = currentPokemon.pokeIdentifier;
#region
//currentPokemon.hpStat = statsArray[0];
hpLabel.Text = "HP: " + currentPokemon.hpStat.ToString(); //Set Up Label for HP stat
sb.setRect(80, (hpLabel.Location.Y), (Convert.ToInt16(currentPokemon.hpStat))); //this set up rectangle to represent the stat bar
drawRect(); //draw method for stat bar
//currentPokemon.attStat = statsArray[1];
attackLabel.Text = "Attack: " + currentPokemon.attStat.ToString();
sb.setRect(80, (attackLabel.Location.Y), Convert.ToInt16(currentPokemon.attStat));
drawRect();
//currentPokemon.defStat = statsArray[2];
defLabel.Text = "Def: " + currentPokemon.defStat.ToString();
sb.setRect(80, (defLabel.Location.Y), Convert.ToInt16(currentPokemon.defStat));
drawRect();
//currentPokemon.spatkStat = statsArray[3];
spattLabel.Text = "SpAtt: " + currentPokemon.spatkStat.ToString();
sb.setRect(80, (spattLabel.Location.Y), Convert.ToInt16(currentPokemon.spatkStat));
drawRect();
//currentPokemon.spdefStat = statsArray[4];
spdefLabel.Text = "SpDef: " + currentPokemon.spdefStat.ToString();
sb.setRect(80, (spdefLabel.Location.Y), Convert.ToInt16(currentPokemon.spdefStat));
drawRect();
//currentPokemon.spdStat = statsArray[5];
spdLabel.Text = "Speed: " + currentPokemon.spdStat.ToString();
sb.setRect(80, (spdLabel.Location.Y), Convert.ToInt16(currentPokemon.spdStat));
drawRect();
#endregion Setting up stats and draw rectangles
pokemonTypeOneLabel.Text = currentPokemon.typeOne;
pokemonTypeTwoLabel.Text = currentPokemon.typeTwo;
pokemonAbilityOneLabel.Text = currentPokemon.abilityOne;
pokemonAbilityTwoLabel.Text = currentPokemon.abilityTwo;
pokemonAbilityThreeLabel.Text = currentPokemon.abilityThree;
toolTip1.SetToolTip(pokemonAbilityOneLabel, pi.getPokemonAbilitiesFlavorText(pokemonAbilityOneLabel.Text));
toolTip1.SetToolTip(pokemonAbilityTwoLabel, pi.getPokemonAbilitiesFlavorText(pokemonAbilityTwoLabel.Text));
toolTip1.SetToolTip(pokemonAbilityThreeLabel, pi.getPokemonAbilitiesFlavorText(pokemonAbilityThreeLabel.Text));
}
public Double[] setPokemonStats(pokemonObject poke)
{
Double[] statsArray = new Double[6];
try
{
SqlConnectionStringBuilder builder = new SqlConnectionStringBuilder();
builder.DataSource = "MSI\\MSSQLSERVER01"; // update me
builder.UserID = "pokeuser"; // update me
builder.Password = "******"; // update me
builder.InitialCatalog = "PokemonDatabase";
using (connection = new SqlConnection(builder.ConnectionString))
{
int pokeIDInt = Convert.ToInt32(poke.pokeID);
connection.Open();
SqlDataReader sdr = null;
string sqlText = "pokemon.pr_vSelectPokemonByID_StatsOnly";
SqlCommand cmd = new SqlCommand(sqlText, connection);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@ID", pokeIDInt);
sdr = cmd.ExecuteReader();
int counter = 0;
while (sdr.Read())
{
statsArray[counter] = sdr.GetDouble(0);
counter++;
}
poke.hpStat = statsArray[0];
poke.attStat = statsArray[1];
poke.defStat = statsArray[2];
poke.spatkStat = statsArray[3];
poke.spdefStat = statsArray[4];
poke.spdStat = statsArray[5];
}
}
catch (SqlException e)
{
Console.WriteLine(e.ToString());
}
return(statsArray);
}
public void setPokemonType(int pID, pokemonObject poke)
{
try
{
SqlConnectionStringBuilder builder = new SqlConnectionStringBuilder();
builder.DataSource = "MSI\\MSSQLSERVER01"; // update me
builder.UserID = "pokeuser"; // update me
builder.Password = "******"; // update me
builder.InitialCatalog = "PokemonDatabase";
using (connection = new SqlConnection(builder.ConnectionString))
{
connection.Open();
SqlDataReader sdr = null;
string sqlText = "pokemon.pr_vSelectPokemonByID_TypesOnly";
SqlCommand cmd = new SqlCommand(sqlText, connection);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@ID", pID);
sdr = cmd.ExecuteReader();
if (sdr.Read())
{
poke.typeOne = sdr.GetString(0);
}
if (sdr.Read())
{
poke.typeTwo = sdr.GetString(0);
}
else
{
poke.typeTwo = "-";
}
}
}
catch (SqlException e)
{
Console.WriteLine(e.ToString());
}
}
private void pokemonListComboBox_SelectedIndexChanged(object sender, EventArgs e)
{
pokemonObject selectedItem = (pokemonObject)pokemonListComboBox.SelectedItem;
pokemonSelection(selectedItem);
}