private void btn_RemovePlayer_Click(object sender, RoutedEventArgs e)
{
if (listBox_Players.SelectedValue != null)
{
PlayerTBL selected = listBox_Players.SelectedValue as PlayerTBL;
var removePlayer = from player in db.PlayerTBLs
where player.PlayerName == selected.PlayerName
select player;
db.PlayerTBLs.RemoveRange(removePlayer);
db.SaveChanges();
}
else if (Player_Surname.Text != null)
{
var removeTeam = from player in db.PlayerTBLs
where player.PlayerName == tbxTeamName.Text
select player;
db.PlayerTBLs.RemoveRange(removeTeam);
db.SaveChanges();
}
else
{
MessageBox.Show("Please select a team from the league or input a team name into the 'Team Name:' box");
}
}
private void btn_AddPlayer_Click(object sender, RoutedEventArgs e)
{
var query = (from t in db.PlayerTBLs
select t).First();
PlayerTBL newPlayer = new PlayerTBL
{
PlayerName = Player_Surname.Text,
PlayerNationality = Player_Nationality.Text,
PlayerNumber = Player_Number.Text,
PlayerPosition = txtbox_PlayerPosition.Text,
TeamName = txtbox_PlayerTeam.Text,
TeamTBLTeamName = txtbox_PlayerTeam.Text
};
db.PlayerTBLs.Add(newPlayer);
db.SaveChanges();
MessageBox.Show("Transfer news as new wiz kid, " + Player_Surname.Text + " signs for " + txtbox_PlayerTeam);
}
