private void Process_Click(object sender, RoutedEventArgs e)
{
Output.Items.Clear();
query = null;
queryIndex = 0;
if (ListMode.IsChecked == true)
{
TitleSearch.Clear();
//Output.Items.Add("Searching with filters...");
if (OwnerDrop.SelectedIndex != 0)
{
query += "owner = '" + OwnerDrop.Text.ToLower() + "'";
queryIndex++;
}
//Output.Items.Add(OwnerDrop.Text);
if (GenreDrop.SelectedIndex != 0)
{
if (queryIndex > 0)
{
query += " AND ";
}
query += "genre = '" + GenreDrop.Text.ToLower() + "'";
queryIndex++;
}
//Output.Items.Add(GenreDrop.Text);
if (RatedDrop.SelectedIndex != 0)
{
if (queryIndex > 0)
{
query += " AND ";
}
query += "mpaa = '" + RatedDrop.Text.ToLower() + "'";
queryIndex++;
}
//Output.Items.Add(RatedDrop.Text);
if (OwnRateDrop.SelectedIndex != 0)
{
if (queryIndex > 0)
{
query += " AND ";
}
query += "ownrate = '" + OwnRateDrop.Text.ToLower() + "'";
queryIndex++;
}
// Output.Items.Add(OwnRateDrop.Text);
if (RottenToDrop.SelectedIndex != 0)
{
if (queryIndex > 0)
{
query += " AND ";
}
query += "rottentomatoes = '" + RottenToDrop.Text.ToLower() + "'";
queryIndex++;
}
//Output.Items.Add(RottenToDrop.Text);
}
else if (SearchMode.IsChecked == true)
{
OwnerDrop.SelectedIndex = 0;
GenreDrop.SelectedIndex = 0;
RatedDrop.SelectedIndex = 0;
OwnRateDrop.SelectedIndex = 0;
RottenToDrop.SelectedIndex = 0;
//Output.Items.Add("Searching for " + TitleSearch.Text);
query = "title = '" + TitleSearch.Text.ToLower() + "'";
queryIndex++;
//straight to SQL stuff
}
if (queryIndex == 0)
{
beginQuery = "SELECT * FROM moviedata;";
}
else
{
beginQuery = "SELECT * FROM moviedata WHERE " + query + ";";
}
//Put code here to query
MySqlConnection connect = new MySqlConnection("SERVER=localhost; user id=root; password=root; database=movies");
MySqlCommand cmd = new MySqlCommand(beginQuery);
cmd.CommandType = CommandType.Text;
cmd.Connection = connect;
connect.Open();
try
{
MySqlDataReader dr;
dr = cmd.ExecuteReader();
while (dr.Read())
{
this.Output.Items.Add(new MyItem {
Title = dr.GetString(0), Year = dr.GetString(1), Owner = dr.GetString(2), Genre = dr.GetString(3), MPAA_Rating = dr.GetString(4), Owner_Rating = dr.GetString(5), RT = dr.GetString(6)
});
}
dr.Close();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
finally
{
if (connect.State == ConnectionState.Open)
{
connect.Close();
}
}
//Output.Items.Add(beginQuery);
}
private void ListMode_Checked(object sender, RoutedEventArgs e)
{
TitleSearch.Clear();
ListMode.IsChecked = true;
}
