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();
}
}
