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!"); } } }