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

        public static int RunSQLUpdateQuery(MySqlCommand query)
        {
            try
            {
                var cnx = new MySqlConnection(ConfigurationManager.ConnectionStrings[ConfigurationManager.AppSettings["DatabaseType"]].ConnectionString);

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

                return 1;
            }
            catch
            {
                return 2;
            }
        }

        public static void SetPlayerData(string playerData, string gamertag)
        {
            var playerDataModel = new DataModels.CachedPlayer()
            {
                Expires    = DateTime.Now.AddHours(3),
                JsonCache  = playerData,
                PlayerName = gamertag.Trim().ToLower()
            };

            // TRUNCATE TABLE `cached_players`
            // INSERT INTO `cached_players`

            // Delete Row in Table
            var query = new MySqlCommand
            {
                CommandText = @"DELETE FROM `cached_players` WHERE `player_name` = @player_name"
            };

            query.Parameters.AddWithValue("@player_name", playerDataModel.PlayerName);
            MySqlConnector.RunSQLUpdateQuery(query);

            // Add new PlayerData
            query = new MySqlCommand
            {
                CommandText = @"INSERT INTO `cached_players`
(
`expires`, 
`json_cache`, 
`player_name`
)
VALUES
(
@expires, 
@json_cache, 
@player_name
);
"
            };

            query.Parameters.AddWithValue("@expires", playerDataModel.Expires);
            query.Parameters.AddWithValue("@json_cache", playerDataModel.JsonCache);
            query.Parameters.AddWithValue("@player_name", playerDataModel.PlayerName);
            MySqlConnector.RunSQLUpdateQuery(query);
        }