private void PopulateUpcomingEpisodes()
{
dgvUpcomingEpisodes.DataSource = null;
dgvUpcomingEpisodes.Rows.Clear();
DataTable dataTable = new DataTable();
dataTable.Columns.Add("Series Name");
dataTable.Columns.Add("Episode Number");
dataTable.Columns.Add("Episode Name");
dataTable.Columns.Add("Air Date");
_dbManager.OpenConnection();
Dictionary <int, Episode> upcomingEpisodes = _dbManager.GetUpcomingEpisodes(false);
_dbManager.CloseConnection();
foreach (Episode episode in upcomingEpisodes.Values)
{
object[] row = new object[4]
{
episode.SeriesName,
episode.Season + "-" + episode.EpisodeNumber,
episode.Name,
episode.FirstAired.ToString("ddd dd-MMM")
};
dataTable.Rows.Add(row);
}
dgvUpcomingEpisodes.DataSource = dataTable;
dgvUpcomingEpisodes.Columns["Series Name"].SortMode = DataGridViewColumnSortMode.NotSortable;
dgvUpcomingEpisodes.Columns["Series Name"].AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill;
dgvUpcomingEpisodes.Columns["Episode Number"].SortMode = DataGridViewColumnSortMode.NotSortable;
dgvUpcomingEpisodes.Columns["Episode Number"].AutoSizeMode = DataGridViewAutoSizeColumnMode.DisplayedCells;
dgvUpcomingEpisodes.Columns["Episode Name"].SortMode = DataGridViewColumnSortMode.NotSortable;
dgvUpcomingEpisodes.Columns["Episode Name"].AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill;
dgvUpcomingEpisodes.Columns["Air Date"].SortMode = DataGridViewColumnSortMode.NotSortable;
dgvUpcomingEpisodes.Columns["Air Date"].AutoSizeMode = DataGridViewAutoSizeColumnMode.DisplayedCells;
}
