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