private void PopulateMissedEpisodes()
{
dgvMissedEpisodes.DataSource = null;
dgvMissedEpisodes.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> missedEpisodes = _dbManager.GetMissedEpisodes(false);
_dbManager.CloseConnection();
foreach (Episode episode in missedEpisodes.Values)
{
object[] row = new object[4]
{
episode.SeriesName,
episode.Season + "-" + episode.EpisodeNumber,
episode.Name,
episode.FirstAired.ToString("dd-MMM-yyyy")
};
dataTable.Rows.Add(row);
}
dgvMissedEpisodes.DataSource = dataTable;
dgvMissedEpisodes.Columns["Series Name"].SortMode = DataGridViewColumnSortMode.NotSortable;
dgvMissedEpisodes.Columns["Series Name"].AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill;
dgvMissedEpisodes.Columns["Episode Number"].SortMode = DataGridViewColumnSortMode.NotSortable;
dgvMissedEpisodes.Columns["Episode Number"].AutoSizeMode = DataGridViewAutoSizeColumnMode.DisplayedCells;
dgvMissedEpisodes.Columns["Episode Name"].SortMode = DataGridViewColumnSortMode.NotSortable;
dgvMissedEpisodes.Columns["Episode Name"].AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill;
dgvMissedEpisodes.Columns["Air Date"].SortMode = DataGridViewColumnSortMode.NotSortable;
dgvMissedEpisodes.Columns["Air Date"].AutoSizeMode = DataGridViewAutoSizeColumnMode.DisplayedCells;
}
