public LoadOpponent(int rank, MySqlConnection con)
{
OpponentLineUp = new List <Pokemon>();
OpponentName = FindOpponent(rank, con);
LoadPokemonFromDB loading = new LoadPokemonFromDB(OpponentName, con);
OpponentLineUp = loading.LoadedLineUp;
}
public void LoadLineup()
{
var tempLineUp = new List <Pokemon>();
var getPokemonQuery = "SELECT `Pokemon1`,`Pokemon2`,`Pokemon3`,`Pokemon4`,`Pokemon5`,`Pokemon6`" +
" FROM sql3346222.TrainerLineup WHERE(UserID = " + UserID + ");";
//Get pokemon from DB
Con.Open();
MySqlCommand cmd = new MySqlCommand(getPokemonQuery, Con);
using (MySqlDataReader reader = cmd.ExecuteReader())
{
while (reader.Read())
{
for (int i = 0; i < 6; i++)
{
Console.WriteLine(reader[i].ToString());
}
}
}
Con.Close();
while (true)
{
Console.WriteLine("Use this lineup? (Y/N)");
string choice = Console.ReadLine().Trim();
if (Grand.yes.IsMatch(choice))
{
var loader = new LoadPokemonFromDB(UserID, Con);
tempLineUp = loader.LoadedLineUp;
GhostTrainer.Pokemon = tempLineUp;
break;
}
else if (Grand.no.IsMatch(choice))
{
NewLineupChoice();
break;
}
else
{
Console.WriteLine("Invalid choice!");
}
}
}
