private static void UpdateDatabase(Song song) { const string server = "50.62.209.14"; const string database = "preyaticintent_music"; const string uid = "preyaticintent"; const string pass = "******"; const string query = @"INSERT INTO TheBuzz (artist, title, dttm) VALUES (@artist, @title, @date)"; const string mySqLconnectionString = "SERVER=" + server + ";" + "DATABASE=" + database + ";" + "UID=" + uid + ";" + "PWD=" + pass + ";"; try { using (var connection = new MySqlConnection(mySqLconnectionString)) { connection.Open(); using (var queryCommand = new MySqlCommand(query, connection)) { queryCommand.Parameters.Add(new MySqlParameter("@artist", song.Artist)); queryCommand.Parameters.Add(new MySqlParameter("@title", song.Title)); queryCommand.Parameters.Add(new MySqlParameter("@date", DateTime.Now.ToString("yyyy-MM-dd hh:mm"))); var reader = queryCommand.ExecuteNonQuery(); } connection.Close(); } } catch (Exception ex) { Console.WriteLine(ex.Message); } }
private static void GetSong() { const string url = @"http://ktbz.s.widget.ldrhub.com/new/api/now_playing/ktbz/"; var info = DownloadUrl(url); var song = new Song(info); Console.WriteLine(song); UpdateDatabase(song); }