private void addBut_Click(object sender, EventArgs e) { if (ValidateFields()) { switch (mode) { case AddPlayerMode.Add: station.AddPlayer(usernameInput.Text, playerNameInput.Text, passwordInput.Text, healthTrackBar.Value.ToString(), ammoTrackBar.Value.ToString(), isBanned); station.UpdatePlayerDataBase(); Close(); break; case AddPlayerMode.Update: station.UpdatePlayer(id, usernameInput.Text, playerNameInput.Text, passwordInput.Text, healthTrackBar.Value.ToString(), ammoTrackBar.Value.ToString(), isBanned); station.UpdatePlayerDataBase(); Close(); break; } } }
private void DatabaseControl_Load(object sender, EventArgs e) { playerList.Columns.Add("playerID", "ID", 50); playerList.Columns.Add("userName", "User Name", 100); playerList.Columns.Add("password", "Password", 100); playerList.Columns.Add("playerName", "Name", 180); playerList.Columns.Add("health", "Health", 50); playerList.Columns.Add("ammo", "Ammo", 50); playerList.Columns.Add("banned", "Banned", 45); playerList.View = View.Details; playerList.FullRowSelect = true; station.UpdatePlayerDataBase(); }
public void Delete(int _id, bool popUp = false) { string query; if (popUp) { DialogResult dialogResult = CustomMessageBox.Show("Are you sure you want to delete this player ? ", "Delete Player"); if (dialogResult == DialogResult.Yes) { query = "DELETE FROM `spacefight`.`playerdata` WHERE `idplayerdata`='" + _id + "';"; ExecuteNonQuery(query); station.UpdateLog("Player : " + _id + " deleted from database \n"); station.UpdatePlayerDataBase(); } } else { query = "DELETE FROM `spacefight`.`playerdata` WHERE `idplayerdata`='" + _id + "';"; ExecuteNonQuery(query); station.UpdateLog("Player : " + _id + " deleted from database \n"); station.UpdatePlayerDataBase(); } }