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