private void lbTeamChart_SelectedIndexChanged(object sender, EventArgs e) { label12.Text = Convert.ToString(lbTeamChart.SelectedItem.ToString()) + ""; selectedTeam = (Team)lbTeamChart.SelectedItem; lbPlayerInTeam.DataSource = Methods.GetPlayerInTeam(selectedTeam.teamId); }
//Denna kod låg här tidigare, den fungerar och därför kommenterar jag endast bort den istället för att radera /* selectedPlayer = (Player)lbPlayers.SelectedItem; selectedTeam = (Team)lbTeamChart.SelectedItem; NpgsqlConnection conn = new NpgsqlConnection("Server=webblabb.miun.se;Port=5432;Database=grp3vt13;User Id=grp3vt13;Password=XmFGFwX6t;SSL=true"); try { conn.Open(); NpgsqlCommand command = new NpgsqlCommand("UPDATE player SET team_id = " + selectedTeam.teamId + " WHERE golfid = (" + selectedPlayer.golfId + " )", conn); int antal = command.ExecuteNonQuery(); } catch (Exception ex) { MessageBox.Show(ex.ToString()); } finally { conn.Close(); } lbPlayerInTeam.DataSource = Methods.GetPlayerInTeam(selectedTeam.teamId); lbPlayers.DataSource = Methods.GetAvailablePlayers(); }*/ private void btnDeletePlayerFromTeam_Click(object sender, EventArgs e) { selectedPlayer = (Player)lbPlayerInTeam.SelectedItem; selectedTeam = (Team)lbTeamChart.SelectedItem; DialogResult dropPlayerFromTeam = MessageBox.Show("Vill du verkligen ta bort den markerade spelaren från laget?", "Ta bort spelare", MessageBoxButtons.OKCancel); if (dropPlayerFromTeam == DialogResult.OK) { NpgsqlConnection conn = new NpgsqlConnection("Server=webblabb.miun.se;Port=5432;Database=grp3vt13;User Id=grp3vt13;Password=XmFGFwX6t;SSL=true"); try { string sql = "UPDATE player SET team_id = null WHERE team_id = " + selectedTeam.teamId + " AND golfid = " + selectedPlayer.golfId + ""; conn.Open(); NpgsqlCommand command = new NpgsqlCommand(sql, conn); int antal = command.ExecuteNonQuery(); } catch (Exception ex) { MessageBox.Show(ex.ToString()); } finally { conn.Close(); } lbPlayerInTeam.DataSource = Methods.GetPlayerInTeam(selectedTeam.teamId); lbPlayers.DataSource = Methods.GetAvailablePlayers(); MessageBox.Show("Spelaren är nu borttagen från laget."); } else if (dropPlayerFromTeam == DialogResult.Cancel) { } }
private void btnDeleteTeam_Click(object sender, EventArgs e) { DialogResult dropTeam = MessageBox.Show("Vill du verkligen ta bort det markerade laget?", "Ta bort lag", MessageBoxButtons.OKCancel); if (dropTeam == DialogResult.OK) { selectedTeam = (Team)lbTeamChart.SelectedItem; NpgsqlConnection conn = new NpgsqlConnection("Server=webblabb.miun.se;Port=5432;Database=grp3vt13;User Id=grp3vt13;Password=XmFGFwX6t;SSL=true"); try { string sql = "DELETE FROM team WHERE id = " + selectedTeam.teamId + ""; conn.Open(); NpgsqlCommand command = new NpgsqlCommand(sql, conn); int antal = command.ExecuteNonQuery(); } catch (Exception ex) { MessageBox.Show(ex.ToString()); } finally { conn.Close(); } lbTeamChart.DataSource = Methods.GetTeams(); lbPlayers.DataSource = Methods.GetAvailablePlayers(); } else if (dropTeam == DialogResult.Cancel) { } }
private void btnAddPlayerToTeam_Click(object sender, EventArgs e) { for (int x = 0; x < lbPlayerInTeam.Items.Count; x++) //ser till så att inte fler än 4 kan vara med i samma grupp { lbPlayerInTeam.SetSelected(x, true); } if (lbPlayerInTeam.Items.Count >= 4) { MessageBox.Show("Du kan inte lägga till fler spelare"); } else { selectedTeam = (Team)lbTeamChart.SelectedItem; NpgsqlConnection conn = new NpgsqlConnection("Server=webblabb.miun.se;Port=5432;Database=grp3vt13;User Id=grp3vt13;Password=XmFGFwX6t;SSL=true"); selectedPlayer = (Player)lbPlayers.SelectedItem; selectedTeam = (Team)lbTeamChart.SelectedItem; try { conn.Open(); NpgsqlCommand command1 = new NpgsqlCommand("UPDATE player SET team_id = " + selectedTeam.teamId + " WHERE golfid = (" + selectedPlayer.golfId + " )", conn); int antal = command1.ExecuteNonQuery(); } catch (Exception ex) { MessageBox.Show(ex.ToString()); } finally { conn.Close(); } lbPlayerInTeam.DataSource = Methods.GetPlayerInTeam(selectedTeam.teamId); lbPlayers.DataSource = Methods.GetAvailablePlayers(); } }