AuntieDot.UI.Web.Connector.MySqlConnector.RunSQLSelectQuery C# (CSharp) Method

        public static IList<IList<string>> RunSQLSelectQuery(MySqlCommand query)
        {
            var cnx = new MySqlConnection(ConfigurationManager.ConnectionStrings[ConfigurationManager.AppSettings["DatabaseType"]].ConnectionString);
            var adapter = new MySqlDataAdapter();

            // Connect to News Database and get recent article
            var cmd = query;
            cmd.Connection = cnx;
            MySqlDataReader Reader;
            cnx.Open();
            Reader = cmd.ExecuteReader();

            var thisTable = new List<IList<string>>();

            while (Reader.Read())
            {
                var thisRow = new List<string>();

                for (var c = 0; c < Reader.FieldCount; c++)
                    thisRow.Add(Reader.GetValue(c).ToString());

                thisTable.Add(thisRow);
            }
            Reader.Close();

            cnx.Close();

            return thisTable;
        }

        public static string GetPlayerData(string gamertag)
        {
            var query = new MySqlCommand("SELECT * FROM `cached_players` WHERE (`player_name`= @player_name) LIMIT 0, 1;");

            query.Parameters.AddWithValue("@player_name", gamertag.Trim().ToLower());

            var sql = MySqlConnector.RunSQLSelectQuery(query);

            if (sql.Count == 0)
            {
                return(null);
            }

            // return dat services list, bro
            var result = new DataModels.CachedPlayer()
            {
                Expires    = DateTime.Parse(sql[0][0]),
                JsonCache  = sql[0][1],
                PlayerName = sql[0][2]
            };

            return(result.Expires.Ticks < DateTime.Now.Ticks
                                                ? null
                                                : result.JsonCache);
        }