public async Task RunCheck(Source source, string connectionString)
{
var playlists = await GetSongs(source.Url);
using (SqlConnection conn = new SqlConnection(connectionString))
{
conn.Open();
using (SqlCommand cmd = new SqlCommand(mergeSql, conn))
{
foreach (var playlist in playlists.OrderBy(t => t.Key))
{
cmd.Parameters.Clear();
cmd.Parameters.AddWithValue("Station", playlist.Value.Station);
cmd.Parameters.AddWithValue("Title", playlist.Value.Title);
cmd.Parameters.AddWithValue("Artist", playlist.Value.Artist);
await cmd.ExecuteNonQueryAsync();
}
}
}
}
partial void DeleteSource(Source instance);
partial void UpdateSource(Source instance);
partial void InsertSource(Source instance);
private void detach_Sources(Source entity)
{
this.SendPropertyChanging();
entity.Station1 = null;
}
private void attach_Sources(Source entity)
{
this.SendPropertyChanging();
entity.Station1 = this;
}
