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