private void getAwayTeamButton_Click(object sender, EventArgs e)
{
AwayTeamPlayersModel awayTeamPlayers = new AwayTeamPlayersModel();
awayTeamPlayers = GlobalConfig.Connection.GetAwayTeamPlayers(thisGame);
thisGame.AwayTeamPlayer1 = (PersonModel)thisGame.AwayTeamPlayers.FirstOrDefault((x => x.PersonID == awayTeamPlayers.AwayTeamPlayer1));
T2P1ComboBox.SelectedItem = thisGame.AwayTeamPlayer1;
thisGame.AwayTeamPlayer2 = (PersonModel)thisGame.AwayTeamPlayers.FirstOrDefault((x => x.PersonID == awayTeamPlayers.AwayTeamPlayer2));
T2P2ComboBox.SelectedItem = thisGame.AwayTeamPlayer2;
thisGame.AwayTeamPlayer3 = (PersonModel)thisGame.AwayTeamPlayers.FirstOrDefault((x => x.PersonID == awayTeamPlayers.AwayTeamPlayer3));
T2P3ComboBox.SelectedItem = thisGame.AwayTeamPlayer3;
thisGame.AwayTeamPlayer4 = (PersonModel)thisGame.AwayTeamPlayers.FirstOrDefault((x => x.PersonID == awayTeamPlayers.AwayTeamPlayer4));
T2P4ComboBox.SelectedItem = thisGame.AwayTeamPlayer4;
thisGame.AwayTeamPlayer5 = (PersonModel)thisGame.AwayTeamPlayers.FirstOrDefault((x => x.PersonID == awayTeamPlayers.AwayTeamPlayer5));
T2P5ComboBox.SelectedItem = thisGame.AwayTeamPlayer5;
thisGame.AwayTeamPlayer6 = (PersonModel)thisGame.AwayTeamPlayers.FirstOrDefault((x => x.PersonID == awayTeamPlayers.AwayTeamPlayer6));
T2P6ComboBox.SelectedItem = thisGame.AwayTeamPlayer6;
thisGame.AwayTeamPlayer7 = (PersonModel)thisGame.AwayTeamPlayers.FirstOrDefault((x => x.PersonID == awayTeamPlayers.AwayTeamPlayer7));
T2P7ComboBox.SelectedItem = thisGame.AwayTeamPlayer7;
thisGame.AwayTeamPlayer8 = (PersonModel)thisGame.AwayTeamPlayers.FirstOrDefault((x => x.PersonID == awayTeamPlayers.AwayTeamPlayer8));
T2P8ComboBox.SelectedItem = thisGame.AwayTeamPlayer8;
wireupEightBallComboBox();
}
public AwayTeamPlayersModel GetAwayTeamPlayers(GameModel Gmodel)
{
List <AwayTeamPlayersModel> output;
AwayTeamPlayersModel model = new AwayTeamPlayersModel();
using (IDbConnection connection = new MySqlConnection(GlobalConfig.CnnString(db)))
{
var p = new DynamicParameters();
p.Add("@InGameID", Gmodel.GameID);
output = connection.Query <AwayTeamPlayersModel>("spGetAwayTeamPlayers", p, commandType: CommandType.StoredProcedure).ToList();
}
foreach (AwayTeamPlayersModel m in output)
{
model = m;
}
return(model);
}
