public static Dictionary <int, LandingCompetition> ReadCompetitions()
{
Dictionary <int, LandingCompetition> competitions = new Dictionary <int, LandingCompetition>();
using (DatabaseConnection dbClient = Alias.Server.DatabaseManager.GetConnection())
{
using (MySqlDataReader Reader = dbClient.DataReader("SELECT * FROM `landing_competitions`"))
{
while (Reader.Read())
{
LandingCompetition competiton = new LandingCompetition()
{
Name = Reader.GetString("name"),
Users = ReadCompetitionUsers(Reader.GetString("query"))
};
if (!competitions.ContainsKey(Reader.GetInt32("id")))
{
competitions.Add(Reader.GetInt32("id"), competiton);
}
}
}
}
return(competitions);
}
public bool TryGetCompetition(int id, out LandingCompetition data)
{
return(this.Competitions.TryGetValue(id, out data));
}