private void ShowMovieButton_Click(object sender, RoutedEventArgs e) { if (Search_Results.SelectedIndex == -1) { MessageBox.Show("Nie wybrano żadnego filmu"); } else { SearchingMoviesList selected = Search_Results.Items[Search_Results.SelectedIndex] as SearchingMoviesList; int index = ListOfMovies.FindIndex(a => a.Title == selected.Title); MovieWindow Movie = new MovieWindow(ListOfMovies[index].IdMovie, Reloading, this); Movie.ShowDialog(); } }
public void SearchDatabase(string SearchContent) { if (SearchContent == "Czego szukasz ?" || SearchContent == "") { Search_Results.Items.Clear(); try { using (SQLiteConnection DatabaseConnection = new SQLiteConnection("Data Source=database.sqlite3")) { DatabaseConnection.Open(); string query = "SELECT Movies.idMovie, Movies.Title, Categories.Name FROM Movies, Categories WHERE Movies.idCategory = Categories.idCategory"; using (SQLiteCommand Command = new SQLiteCommand(query, DatabaseConnection)) { using (SQLiteDataReader result = Command.ExecuteReader()) { if (result.HasRows) { while (result.Read()) { ListOfMovies.Add(new SearchingMoviesList(result.GetInt32(0), result[1].ToString(), result[2].ToString())); var data = new SearchingMoviesList { Title = result[1].ToString(), CategoryName = result[2].ToString() }; Search_Results.Items.Add(data); } } else { Search_Results.Items.Clear(); throw new Exception("Nie znaleziono filmu"); } } } } } catch (Exception ex) { MessageBox.Show(ex.Message); } } else { Search_Results.Items.Clear(); try { using (SQLiteConnection DatabaseConnection = new SQLiteConnection("Data Source=database.sqlite3")) { DatabaseConnection.Open(); string query = "SELECT Movies.idMovie, Movies.Title, Categories.Name FROM Movies, Categories WHERE title LIKE '%'||@search||'%' AND Movies.idCategory = Categories.idCategory"; using (SQLiteCommand Command = new SQLiteCommand(query, DatabaseConnection)) { Command.Parameters.AddWithValue("@search", SearchContent); using (SQLiteDataReader result = Command.ExecuteReader()) { if (result.HasRows) { while (result.Read()) { ListOfMovies.Add(new SearchingMoviesList(result.GetInt32(0), result[1].ToString(), result[2].ToString())); var data = new SearchingMoviesList { Title = result[1].ToString(), CategoryName = result[2].ToString() }; Search_Results.Items.Add(data); } } else { Search_Results.Items.Clear(); throw new Exception("Nie znaleziono filmu"); } } } } } catch (Exception ex) { MessageBox.Show(ex.Message); } } }