private void getOtherTeamsButton_Click(object sender, EventArgs e) { HomeTeamPlayersModel homeTeamPlayers = new HomeTeamPlayersModel(); homeTeamPlayers = GlobalConfig.Connection.GetHomeTeamPlayers(thisGame); //TODO work out how to do this better so much room to make errors here thisGame.HomeTeamPlayer1 = (PersonModel)thisGame.HomeTeamPlayers.FirstOrDefault((x => x.PersonID == homeTeamPlayers.HomeTeamPlayer1)); T1P1ComboBox.SelectedItem = thisGame.HomeTeamPlayer1; thisGame.HomeTeamPlayer2 = (PersonModel)thisGame.HomeTeamPlayers.FirstOrDefault((x => x.PersonID == homeTeamPlayers.HomeTeamPlayer2)); T1P2ComboBox.SelectedItem = thisGame.HomeTeamPlayer2; thisGame.HomeTeamPlayer3 = (PersonModel)thisGame.HomeTeamPlayers.FirstOrDefault((x => x.PersonID == homeTeamPlayers.HomeTeamPlayer3)); T1P3ComboBox.SelectedItem = thisGame.HomeTeamPlayer3; thisGame.HomeTeamPlayer4 = (PersonModel)thisGame.HomeTeamPlayers.FirstOrDefault((x => x.PersonID == homeTeamPlayers.HomeTeamPlayer4)); T1P4ComboBox.SelectedItem = thisGame.HomeTeamPlayer4; thisGame.HomeTeamPlayer5 = (PersonModel)thisGame.HomeTeamPlayers.FirstOrDefault((x => x.PersonID == homeTeamPlayers.HomeTeamPlayer5)); T1P5ComboBox.SelectedItem = thisGame.HomeTeamPlayer5; thisGame.HomeTeamPlayer6 = (PersonModel)thisGame.HomeTeamPlayers.FirstOrDefault((x => x.PersonID == homeTeamPlayers.HomeTeamPlayer6)); T1P6ComboBox.SelectedItem = thisGame.HomeTeamPlayer6; thisGame.HomeTeamPlayer7 = (PersonModel)thisGame.HomeTeamPlayers.FirstOrDefault((x => x.PersonID == homeTeamPlayers.HomeTeamPlayer7)); T1P7ComboBox.SelectedItem = thisGame.HomeTeamPlayer7; thisGame.HomeTeamPlayer8 = (PersonModel)thisGame.HomeTeamPlayers.FirstOrDefault((x => x.PersonID == homeTeamPlayers.HomeTeamPlayer8)); T1P8ComboBox.SelectedItem = thisGame.HomeTeamPlayer8; wireupEightBallComboBox(); }
public HomeTeamPlayersModel GetHomeTeamPlayers(GameModel Gmodel) { List <HomeTeamPlayersModel> output; HomeTeamPlayersModel model = new HomeTeamPlayersModel(); using (IDbConnection connection = new MySqlConnection(GlobalConfig.CnnString(db))) { var p = new DynamicParameters(); p.Add("@InGameID", Gmodel.GameID); output = connection.Query <HomeTeamPlayersModel>("spGetHomeTeamPlayers", p, commandType: CommandType.StoredProcedure).ToList(); } foreach (HomeTeamPlayersModel m in output) { model = m; } return(model); }