/// <summary> /// Refreshes values in DataGridView /// </summary> private void refreshTable() { try { DBReader.connectionOpen(connection); adapter = new MySqlDataAdapter(); if (textBoxSelectedPlayer.Text == "For all") { adapter.SelectCommand = DBReader.commandForTheWholeTable(connection, entityName); } else if (textBoxSelectedPlayer.Text.StartsWith("Player ")) { playersID = DBReader.selectAllPlayersID(connection, DBName); int ID = playersID[Int32.Parse(textBoxSelectedPlayer.Text.Substring(7)) - 1]; adapter.SelectCommand = DBReader.commandForSelectedPlayer(connection, entityName, ID); } dataSet = new DataTable(); adapter.Fill(dataSet); BindingSource source = new BindingSource(); source.DataSource = dataSet; tableEntity.DataSource = source; adapter.Update(dataSet); } catch (MySqlException ex) { MessageBox.Show(ex.Message); } finally { DBReader.connectionEnd(connection); } }
/// <summary> /// Rotates players when clicked /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void buttonRightArrow_Click(object sender, EventArgs e) { playersID = new List <int>(); try { DBReader.connectionOpen(connection); playersID = DBReader.selectAllPlayersID(connection, DBName); if (textBoxSelectedPlayer.Text == "For all") { buttonInsUp.Enabled = false; currentID = 0; textBoxSelectedPlayer.Text = "Player " + playersID[0]; } else if (textBoxSelectedPlayer.Text == "Player " + playersID[playersID.Count() - 1]) { if (textBoxSelectedItem.Text != "") { buttonInsUp.Enabled = true; } else { buttonInsUp.Enabled = false; } currentID = -1; textBoxSelectedPlayer.Text = "For all"; } else if (textBoxSelectedPlayer.Text.StartsWith("Player ")) { buttonInsUp.Enabled = false; currentID++; textBoxSelectedPlayer.Text = "Player " + playersID[currentID]; } } catch (MySqlException ex) { MessageBox.Show(ex.Message); } finally { DBReader.connectionEnd(connection); } }