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