private static void WriteToDB(string searchText, EpisodeInformation episode)
{
var connStr = ConfigurationManager.ConnectionStrings["ShowAlerts.Properties.Settings.ShowDBConnectionString"].ConnectionString;
using (var connection = new SqlConnection(connStr))
{
var cmd = new SqlCommand("Insert into [dbo].[Table] Values (@ShowName, @PrevDate, @PrevEpisode,@NextDate, @NextEpisode)");
cmd.CommandType = CommandType.Text;
cmd.Connection = connection;
cmd.Parameters.AddWithValue("@ShowName", episode.EpisodeName);
cmd.Parameters.AddWithValue("@PrevDate", episode.PrevDate);
cmd.Parameters.AddWithValue("@PrevEpisode", episode.PrevEpisode);
cmd.Parameters.AddWithValue("@NextDate", episode.NextDate);
cmd.Parameters.AddWithValue("@NextEpisode", episode.NextEpisode);
connection.Open();
cmd.ExecuteNonQuery();
}
System.Windows.Forms.MessageBox.Show("Success!");
}
private void button1_Click(object sender, EventArgs e)
{
if (CheckDB(search.Text))
{
return;
}
EpisodeInformation episode = new EpisodeInformation();
using (WebClient wc = new WebClient())
{
try {
var json = wc.DownloadString(@"http://api.tvmaze.com/singlesearch/shows?q=" + search.Text);
dynamic showJsonObject = JsonConvert.DeserializeObject(json);
episode.SetEpisodeName(showJsonObject.name);
if (showJsonObject._links.nextepisode != null)
{
var nextEpisodeLink = showJsonObject._links.nextepisode.href.Value;
episode.GetDateFromJson(wc, nextEpisodeLink, true);
}
if (showJsonObject._links.previousepisode != null)
{
var prevEpisodeLink = showJsonObject._links.previousepisode.href.Value;
episode.GetDateFromJson(wc, prevEpisodeLink, false);
}
WriteToDB(search.Text, episode);
}
catch (Exception ex)
{
if (ex.Message.Contains("404"))
{
MessageBox.Show("Could not find tv show");
}
else
{
MessageBox.Show("An unknown error has occured");
}
}
}
}