private void frmFavourites_Load(object sender, EventArgs e) { _dbManager.DataSource = Environment.GetFolderPath(Environment.SpecialFolder.LocalApplicationData) + "\\Personal TV Organiser\\" + "db.sqlite"; try { _dbManager.InitializeConnection(); _dbManager.OpenConnection(); _favourites = _dbManager.GetFavourites(); } catch (Exception ex) { MessageBox.Show("Couldn't read favoutites"); } finally { _dbManager.CloseConnection(); } if (_favourites.Count > 0) { PopulateFavoutitesPanel(); } else { lblAddFavourites.Visible = true; } }
private void frmCalendar_Load(object sender, EventArgs e) { _dbManager.DataSource = Environment.GetFolderPath(Environment.SpecialFolder.LocalApplicationData) + "\\Personal TV Organiser" + "\\db.sqlite"; _dbManager.InitializeConnection(); _dbManager.OpenConnection(); _episodes = _dbManager.GetEpisodesWithDates(false); _dbManager.CloseConnection(); foreach (Episode episode in _episodes.Values) { DateTime startDate = episode.FirstAired; if (episode.TimeAirs > Convert.ToDateTime("01/01/0001")) { string airDate = episode.FirstAired.ToString("dd MMM yyyy"); string airTime = episode.TimeAirs.ToString("HH:mm"); startDate = Convert.ToDateTime(airDate + " " + airTime); } DateTime endDate = episode.Runtime <= 0 ? startDate.AddHours(1) : startDate.AddMinutes(episode.Runtime); CalendarItem calendarItem = new CalendarItem(calendar1, startDate, endDate, episode.ToString()); calendarItem.Tag = episode.EpisodeID; if (episode.Watched) { calendarItem.ApplyColor(Color.FromArgb(0, 192, 192, 192)); } else if (episode.FirstAired <= DateTime.Now) { calendarItem.ApplyColor(Color.FromArgb(0, 255, 0, 0)); } _items.Add(episode.EpisodeID, calendarItem); } calendar1.MaximumFullDays = 7; SetCalendarView(); lblMonth.Text = DateTime.Today.ToString("MMMM yyyy"); lineShape1.X2 = Width - calendar1.Width - 35; }
public bool Insert() { bool result = false; string query = @"INSERT INTO captcha_attributes(CaptchaId,Tile1Angle,Tile2Angle,Tile3Angle,Tile4Angle, " + "Tile5Angle, Tile6Angle, Tile7Angle, Tile8Angle, Tile9Angle) VALUES(@captchaId, @tile1, @tile2, @tile3, @tile4, @tile5, @tile6, @tile7, @tile8, @tile9)"; if (database.OpenConnection()) { using (MySqlCommand cmd = new MySqlCommand(query, database.Connection)) { cmd.Parameters.AddWithValue("@captchaId", CaptchaID); cmd.Parameters.AddWithValue("@tile1", Tile1Angle); cmd.Parameters.AddWithValue("@tile2", Tile2Angle); cmd.Parameters.AddWithValue("@tile3", Tile3Angle); cmd.Parameters.AddWithValue("@tile4", Tile4Angle); cmd.Parameters.AddWithValue("@tile5", Tile5Angle); cmd.Parameters.AddWithValue("@tile6", Tile6Angle); cmd.Parameters.AddWithValue("@tile7", Tile7Angle); cmd.Parameters.AddWithValue("@tile8", Tile8Angle); cmd.Parameters.AddWithValue("@tile9", Tile9Angle); int numberOfRows = cmd.ExecuteNonQuery(); if (numberOfRows >= 1) { result = true; } } } database.CloseConnection(); return(result); }
private Series GetSeriesInfo(string source) { Series series = new Series(); Series seriesInfo; if (source == "XML") { seriesInfo = _tvdbAPI.GetSeriesInfo(_showID); btnFavourite.ImageIndex = 1; toolTip1.SetToolTip(btnFavourite, "Favourite"); } else { _dbManager.OpenConnection(); seriesInfo = _dbManager.GetSeriesInfo(_showID); _dbManager.CloseConnection(); btnFavourite.ImageIndex = 0; toolTip1.SetToolTip(btnFavourite, "Unfavourite"); } return(seriesInfo); }
private void frmMain_Load(object sender, EventArgs e) { string localAppFolder = Environment.GetFolderPath(Environment.SpecialFolder.LocalApplicationData) + "\\Personal TV Organiser"; _dbManager.DataSource = localAppFolder + "\\db.sqlite"; if (!File.Exists(localAppFolder + "\\db.sqlite")) { if (!Directory.Exists(localAppFolder)) { Directory.CreateDirectory(localAppFolder); } try { _dbManager.CreateDatabase(); _dbManager.InitializeConnection(); _dbManager.OpenConnection(); _dbManager.BeginTransaction(); InitializeDatabase(); _dbManager.Commit(); } catch (Exception ex) { MessageBox.Show("There was a problem creating the database"); } finally { if (_dbManager.TheTransaction != null) { _dbManager.Rollback(); } _dbManager.CloseConnection(); } } else { prgMain.Value = 0; prgMain.Visible = true; lblStatus.Visible = true; lblStatus.Text = "Getting Updates..."; _dbManager.InitializeConnection(); bgwUpdate.RunWorkerAsync(); StartTimer(); } try { _dbManager.OpenConnection(); _favourites = _dbManager.GetFavourites(); } catch (Exception ex) { MessageBox.Show("Couldn't read favoutites"); } finally { _dbManager.CloseConnection(); } PopulateUpcomingEpisodes(); PopulateMissedEpisodes(); }
public CaptchaSession GetCaptchaSession(int captchaId) { CaptchaSession obj = new CaptchaSession(); string queryString = "SELECT * FROM captcha_session WHERE CaptchaId = @captchaId"; if (database.OpenConnection()) { using (MySqlCommand cmd = new MySqlCommand(queryString, database.Connection)) { cmd.Parameters.AddWithValue("@captchaId", captchaId); using (MySqlDataReader dataReader = cmd.ExecuteReader()) { while (dataReader.Read()) { string tempHolder = dataReader["CaptchaId"].ToString(); obj.CaptchaId = Convert.ToInt32(tempHolder); obj.ImageName = dataReader["ImageName"].ToString(); string isvalid = dataReader["IsValid"].ToString(); if (isvalid.Equals("0")) { obj.IsValid = false; } else { obj.IsValid = true; } } } } } database.CloseConnection(); return(obj); }
private void bgwUpdate_DoWork(object sender, DoWorkEventArgs e) { Thread.Sleep(100); DatabaseManager.DatabaseManager databaseManager = new DatabaseManager.DatabaseManager(); string localAppFolder = Environment.GetFolderPath(Environment.SpecialFolder.LocalApplicationData) + "\\Personal TV Organiser"; databaseManager.DataSource = localAppFolder + "\\db.sqlite"; databaseManager.InitializeConnection(); Update update = new Update(); List <Series> seriesToUpdate = new List <Series>(); List <Episode> episodesToUpdate = new List <Episode>(); try { databaseManager.OpenConnection(); Dictionary <string, string> settings = databaseManager.GetSettings("previousServerTime"); databaseManager.CloseConnection(); Update updates = _tvdbAPI.GetUpdates(settings["previousServerTime"]); int totalUpdates = _favourites.Count + updates.EpisodeUpdates.Count; int percentProgress = 0; double progress = 0; bgwUpdate.ReportProgress(percentProgress); foreach (int seriesID in _favourites.Keys) { if (updates.SeriesUpdates.Contains(seriesID)) { Series seriesUpdates = _tvdbAPI.GetSeriesUpdates(seriesID); if (seriesUpdates != null) { seriesToUpdate.Add(seriesUpdates); } } ++progress; bgwUpdate.ReportProgress((int)Math.Round(progress / totalUpdates * 100.0)); } foreach (int episodeID in updates.EpisodeUpdates) { Episode episodeUpdates = _tvdbAPI.GetEpisodeUpdates(episodeID); if (episodeUpdates != null) { if (_favourites.Keys.Contains(episodeUpdates.SeriesID)) { episodesToUpdate.Add(episodeUpdates); } } ++progress; bgwUpdate.ReportProgress((int)Math.Round(progress / totalUpdates * 100.0)); } databaseManager.OpenConnection(); databaseManager.BeginTransaction(); foreach (Series series in seriesToUpdate) { databaseManager.UpdateSeries(series); } string seriesName = ""; foreach (Episode episode in episodesToUpdate) { seriesName = _favourites[episode.SeriesID].SeriesName; databaseManager.UpdateEpisode(episode, seriesName); } databaseManager.UpdateSetting("previousServerTime", updates.Time); databaseManager.Commit(); bgwUpdate.ReportProgress(100); } catch (Exception ex) { } finally { if (databaseManager.TheTransaction != null) { databaseManager.Rollback(); } databaseManager.CloseConnection(); } }