public List <CSGOMatch> getPlayersMatches(int id) { List <CSGOMatch> toReturn = new List <CSGOMatch>(); var Connection = new MySqlConnection(ConnectionString); Connection.Open(); string SQLStatement = "SELECT * FROM csgo_match_player LEFT JOIN csgomatch ON csgomatch.id = csgo_match_player.csgomatch_id WHERE player_id = " + id + " AND endTime is not null"; var Command = new MySqlCommand(SQLStatement, Connection); MySqlDataReader Reader = Command.ExecuteReader(); List <CSGOMatchPlayer> tempList = new List <CSGOMatchPlayer>(); if (Reader.HasRows) { while (Reader.Read()) { CSGOMatch temp = new CSGOMatch(); temp.id = Reader.GetInt32(4); temp.winner = Reader.GetInt32(5); temp.startTime = Reader.GetDateTime(6); temp.endTime = Reader.GetDateTime(7); if (temp.winner == Reader.GetInt32(0)) { temp.winner = 1; } else { temp.winner = 0; } toReturn.Add(temp); } } Connection.Close(); return(toReturn); }
public CSGOMatchPlayer(int _teamNo, Player _player, CSGOMatch _csgomatch, bool _admittedDefeat) { teamNo = _teamNo; player = _player; csgomatch = _csgomatch; admittedDefeat = _admittedDefeat; }
public CSGOMatch getLastPlayedMatch(int player_id) { CSGOMatch toReturn = new CSGOMatch(); //CSGOMatch toReturn = new CSGOMatch(); var Connection = new MySqlConnection(ConnectionString); Connection.Open(); string SQLStatement = "SELECT * FROM csgomatch Where id in " + "(SELECT csgomatch_id FROM csgo_match_player WHERE player_id = '" + player_id + "' ) ORDER BY endTime DESC LIMIT 1"; //string SQLStatement = "SELECT csgomatch_id FROM csgo_match_player WHERE player_id = " + player_id; var Command = new MySqlCommand(SQLStatement, Connection); MySqlDataReader Reader = Command.ExecuteReader(); if (Reader.HasRows) { Reader.Read(); toReturn.id = Reader.GetInt32(0); toReturn.winner = Reader.GetInt32(1); if (Reader.IsDBNull(2)) { toReturn.startTime = new DateTime(0); } else { toReturn.startTime = Reader.GetDateTime(2); } if (Reader.IsDBNull(3)) { toReturn.endTime = new DateTime(0); } else { toReturn.endTime = Reader.GetDateTime(3); } } Reader.Close(); List <CSGOMatchPlayer> playersOfMatch = new List <CSGOMatchPlayer>(); if (toReturn.id != 0) { SQLStatement = "SELECT * FROM csgo_match_player Where csgomatch_id = " + toReturn.id; Command = new MySqlCommand(SQLStatement, Connection); Reader = Command.ExecuteReader(); if (Reader.HasRows) { while (Reader.Read()) { playersOfMatch.Add(new CSGOMatchPlayer(-1, new Player(Reader.GetInt32(2), 0, 0, 0, false, "0", new DateTime(0)), null, false)); } } } Reader.Close(); Connection.Close(); toReturn.player = playersOfMatch.ToArray(); Connection.Close(); return(toReturn); }