private void Button_Click(object sender, RoutedEventArgs e)
{
// Home Page
MovieInterfaceHome movieInterfaceHome = new MovieInterfaceHome();
this.NavigationService.Navigate(movieInterfaceHome);
}
private void Button_Click(object sender, RoutedEventArgs e)
{
TitleText.Content = "";
GenreText.Content = "";
this.directors.Clear();
// Home Page
MovieInterfaceHome movieInterfaceHome = new MovieInterfaceHome();
this.NavigationService.Navigate(movieInterfaceHome);
}
private void SearchMovie(object sender, RoutedEventArgs e)
{
using (OleDbConnection cn = new OleDbConnection(@"Provider = Microsoft.ACE.OLEDB.12.0;
Data Source =|DataDirectory|\MartinMovies.accdb"))
{
string query = "";
if (searchType == "Title")
{
query = "select Titles, [Release Date], Description, Director, Genre from Titles where Titles LIKE '%' + @value + '%'";
}
else if (searchType == "Director")
{
query = "select Titles, [Release Date], Description, Director, Genre from Titles where Director LIKE '%' + @value + '%'";
}
else
{
query = "select Titles, [Release Date], Description, Director, Genre from Titles where Genre LIKE '%' + @value + '%'";
}
OleDbCommand cmd = new OleDbCommand(query, cn);
OleDbParameter titleParam = new OleDbParameter();
titleParam.OleDbType = OleDbType.VarChar;
titleParam.ParameterName = "@value";
titleParam.Value = SearchText.Text;
cmd.Parameters.Add(titleParam);
cn.Open();
MovieInterfaceHome searchMovies = new MovieInterfaceHome();
OleDbDataReader read = cmd.ExecuteReader();
searchMovies.clearList();
while (read.Read())
{
List <string> items = new List <string>();
for (int i = 0; i < 5; i++)
{
items.Add(read[i].ToString());
}
searchMovies.addItemToList(items);
}
read.Close();
this.NavigationService.Navigate(searchMovies);
}
}