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