private void btn_RemoveTeam_Click(object sender, RoutedEventArgs e)
{
if (LeagueGrid.SelectedValue != null)
{
TeamTBL selected = LeagueGrid.SelectedValue as TeamTBL;
var removeTeam = from team in db.TeamTBLs
where team.TeamName == selected.TeamName
select team;
db.TeamTBLs.RemoveRange(removeTeam);
db.SaveChanges();
}
else if (tbxTeamName.Text != null)
{
var removeTeam = from team in db.TeamTBLs
where team.TeamName == tbxTeamName.Text
select team;
db.TeamTBLs.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 LeagueGrid_SelectionChanged(object sender, SelectionChangedEventArgs e)
{
TeamTBL selected = LeagueGrid.SelectedValue as TeamTBL;
if (selected != null)
{
tbxTeamName.Text = selected.TeamName.ToString();
tbxClubPoints.Text = selected.Points.ToString();
tbxGoalDifference.Text = selected.GoalDif.ToString();
txtbox_Manager.Text = selected.ManagerName.ToString();
}
}
private void btnAddTeam_Click(object sender, RoutedEventArgs e)
{
var query = (from t in db.TeamTBLs
select t).First();
TeamTBL newTeam = new TeamTBL
{
TeamName = tbxTeamName.Text,
Points = Convert.ToInt32(tbxClubPoints.Text),
GoalDif = Convert.ToInt32(tbxGoalDifference.Text),
ManagerName = txtbox_Manager.Text
};
db.TeamTBLs.Add(newTeam);
db.SaveChanges();
MessageBox.Show("WORLD NEWS!!!\tNew unknown team have made a dramatic entrance into the Premier League");
}
