public bool update(PlayerDTO player)
{
DBConnector dbCon = new DBConnector();
if(dbCon.openConnection() == true){
string query = "UPDATE `player` SET `name`='" + player.name + "',`status`='" + player.status + "' WHERE id='" + player.id + "'";
MySqlCommand cmd = new MySqlCommand(query, dbCon.connection);
cmd.ExecuteNonQuery();
dbCon.closeConnection();
return true;
}
return false;
}
public bool create(ScoreDTO score)
{
DBConnector dbCon = new DBConnector();
if (dbCon.openConnection() == true)
{
string query = "INSERT INTO `score`(`id`, `player_id`,`score`,`difficulty`,`game_mode`) VALUES (null,'" + score.player_id + "','"+score.score+"','"+ (int)score.difficulty +"','"+(int)score.game_mode+"')";
MySqlCommand cmd = new MySqlCommand(query, dbCon.connection);
cmd.ExecuteNonQuery();
dbCon.closeConnection();
return true;
}
return false;
}
public bool create(Player player)
{
DBConnector dbCon = new DBConnector();
if (dbCon.openConnection() == true)
{
string query = "INSERT INTO `player`(`id`, `name`,`status`) VALUES (null,'" + player.name + "','1')";
MySqlCommand cmd = new MySqlCommand(query, dbCon.connection);
cmd.ExecuteNonQuery();
dbCon.closeConnection();
return true;
}
return false;
}
public ScoreDTO getHighScore(PlayerDTO player)
{
string query = "SELECT max(score) FROM score WHERE player_id='" + player.id + "'";
ScoreDTO score = null;
DBConnector dbCon = new DBConnector();
if (dbCon.openConnection() == true)
{
MySqlCommand cmd = new MySqlCommand(query, dbCon.connection);
MySqlDataReader dataReader = cmd.ExecuteReader();
score.score = Int32.Parse(cmd.ExecuteScalar().ToString());
dataReader.Close();
dbCon.closeConnection();
}
return score;
}
public int count()
{
DBConnector dbCon = new DBConnector();
if (dbCon.openConnection() == true)
{
string query = "SELECT * FROM `player`";
int count = 0;
MySqlCommand cmd = new MySqlCommand(query, dbCon.connection);
MySqlDataReader dataReader = cmd.ExecuteReader();
while (dataReader.Read())
{
count++;
}
dbCon.closeConnection();
return count;
}
return -1;
}
public List<PlayerDTO> selectAll()
{
string query = "SELECT * FROM player WHERE status='1'";
List<PlayerDTO> list = new List<PlayerDTO>();
DBConnector dbCon = new DBConnector();
if (dbCon.openConnection() == true)
{
MySqlCommand cmd = new MySqlCommand(query, dbCon.connection);
MySqlDataReader dataReader = cmd.ExecuteReader();
while (dataReader.Read())
{
PlayerDTO tmp = new PlayerDTO();
tmp.id = Int32.Parse(dataReader["id"].ToString());
tmp.name = dataReader["name"].ToString();
list.Add(tmp);
}
dataReader.Close();
dbCon.closeConnection();
}
return list;
}
public List<ScoreDTO> getScore(PlayerDTO player)
{
string query = "SELECT * FROM score WHERE player_id='"+ player.id +"'";
List<ScoreDTO> list = new List<ScoreDTO>();
DBConnector dbCon = new DBConnector();
if (dbCon.openConnection() == true)
{
MySqlCommand cmd = new MySqlCommand(query, dbCon.connection);
MySqlDataReader dataReader = cmd.ExecuteReader();
while (dataReader.Read())
{
ScoreDTO tmp = new ScoreDTO();
tmp.id = Int32.Parse(dataReader["id"].ToString());
tmp.player_id = player.id;
tmp.score = Int32.Parse(dataReader["score"].ToString());
tmp.difficulty = (Difficulty)Int32.Parse(dataReader["difficulty"].ToString());
tmp.game_mode = (GameMode)Int32.Parse(dataReader["game_mode"].ToString());
list.Add(tmp);
}
dataReader.Close();
dbCon.closeConnection();
}
return list;
}