private void btnConfirm_Click(object sender, EventArgs e) { List <Episode> watchedEpisodes = new List <Episode>(); Cursor.Current = Cursors.WaitCursor; for (int i = 0; i < dgvEpisodes.RowCount; ++i) { Episode episode = new Episode(); int num; if (int.TryParse(dgvEpisodes.Rows[i].Cells[0].Value.ToString(), out num)) { episode.EpisodeID = num; } bool boolean; if (bool.TryParse(dgvEpisodes.Rows[i].Cells[5].Value.ToString(), out boolean)) { episode.Watched = boolean; } watchedEpisodes.Add(episode); } _dbManager.OpenConnection(); _dbManager.BeginTransaction(); _dbManager.UpdateWatchedEpisodes(watchedEpisodes); _dbManager.Commit(); _dbManager.CloseConnection(); Cursor.Current = Cursors.Default; MessageBox.Show("Saved!"); }
private void chkWatched_Click(object sender, EventArgs e) { if (chkWatched.Checked) { DialogResult result = MessageBox.Show("Are you sure you want to mark this episode as watched?", "Mark as Watched", MessageBoxButtons.YesNo); switch (result) { case System.Windows.Forms.DialogResult.Yes: lastSelectedEpisode.Watched = true; _dbManager.OpenConnection(); _dbManager.BeginTransaction(); _dbManager.UpdateWatchedEpisodes(new List <Episode> { lastSelectedEpisode }); _dbManager.Commit(); _dbManager.CloseConnection(); _items[lastSelectedEpisode.EpisodeID].ApplyColor(Color.FromArgb(0, 192, 192, 192)); break; case System.Windows.Forms.DialogResult.No: chkWatched.Checked = false; break; default: break; } } else { DialogResult result = MessageBox.Show("Are you sure you want to mark this episode as unwatched?", "Mark as Unwatched", MessageBoxButtons.YesNo); switch (result) { case System.Windows.Forms.DialogResult.Yes: lastSelectedEpisode.Watched = false; _dbManager.OpenConnection(); _dbManager.BeginTransaction(); _dbManager.UpdateWatchedEpisodes(new List <Episode> { lastSelectedEpisode }); _dbManager.Commit(); _dbManager.CloseConnection(); if (lastSelectedEpisode.FirstAired <= DateTime.Now) { _items[lastSelectedEpisode.EpisodeID].ApplyColor(Color.FromArgb(0, 255, 0, 0)); } else { _items[lastSelectedEpisode.EpisodeID].RemoveColors(); } break; case System.Windows.Forms.DialogResult.No: chkWatched.Checked = true; break; default: break; } } calendar1.Items.Clear(); PlaceItems(); }