internal Lists.MovieList GetAll() { Lists.MovieList list = new Lists.MovieList(); //Open connection if (dh.OpenConnection() == true) { string q = "SELECT * FROM Movies"; //Create Command SQLiteCommand cmd = new SQLiteCommand(q, dh.connection); //Create a data reader and Execute the command SQLiteDataReader dataReader = cmd.ExecuteReader(); //Read the data and store them in the list Movie m = null; while (dataReader.Read()) { m = new Movie(); //if (dh.HasColumn(dataReader, "ROWID")) // m.ID = Convert.ToInt32(dataReader["ROWID"]); if (dh.HasColumn(dataReader, "Title")) m.Title = dataReader["Title"].ToString(); if (dh.HasColumn(dataReader, "Synopsis")) m.Synopsis = dataReader["Synopsis"].ToString(); if (dh.HasColumn(dataReader, "Year")) m.Year = Convert.ToInt32(dataReader["Year"]); if (dh.HasColumn(dataReader, "Duration")) m.Duration = Convert.ToInt32(dataReader["Duration"]); if (dh.HasColumn(dataReader, "Rating")) m.Rating = Convert.ToInt32(dataReader["Rating"]); if (dh.HasColumn(dataReader, "AgeRestriction")) m.AgeRestriction = dataReader["AgeRestriction"].ToString(); if (dh.HasColumn(dataReader, "TMDBID")) m.TMDBID = Convert.ToInt32(dataReader["TMDBID"]); m.RecordExists = true; list.Add(m); } //close Data Reader dataReader.Close(); //close Connection dh.CloseConnection(); } return list; }
private void buttonTitle_Click(object sender, RoutedEventArgs e) { RenameMovieWindow renameMovieWindow = new RenameMovieWindow(); renameMovieWindow.OriginalName = Title; renameMovieWindow.NewName = Title; renameMovieWindow.Rename += delegate { BackgroundWorker bg = new BackgroundWorker(); bg.DoWork += delegate { try { FileInfo fi = new FileInfo(FullPath); string newName = ""; if (renameMovieWindow.textBoxNewName.Dispatcher.CheckAccess()) { newName = fi.Directory + "\\" + renameMovieWindow.NewName + fi.Extension; } else { renameMovieWindow.textBoxNewName.Dispatcher.Invoke(delegate { newName = fi.Directory + "\\" + renameMovieWindow.NewName + fi.Extension; }); } File.Move(FullPath, newName); FullPath = newName; Movie = new DiscordiaGenLib.GenLib.Business.Movie(); FindMovieInfo(); UpdateUI(); } catch (Exception ex) { MessageBox.Show(ex.Message + Environment.NewLine + ex.ToString()); } }; bg.RunWorkerAsync(); }; if (renameMovieWindow.ShowDialog() == true) { } }