private void button3_Click(object sender, RoutedEventArgs e)
{
mbdisp a = new mbdisp();
a.Show();
this.Hide();
}
private void button_Click(object sender, RoutedEventArgs e)
{
String sqll = "create or replace view filter as select * from filterbrand";
OracleCommand cmd2 = new OracleCommand(sqll, con);
cmd2.ExecuteNonQuery();
mbdisp a = new mbdisp();
this.Hide();
a.Show();
mediaElement.Stop();
}
private void button_Copy_Click(object sender, RoutedEventArgs e)
{
String sql = "";
if (String.IsNullOrEmpty(search.Text))
{
sql = "create or replace view filter as select * from device";
}
else
{
sql = "create or replace view filter as select * from device where device_model like '%" + search.Text.ToString() + "%'";
}
OracleCommand cmdz = new OracleCommand(sql, con);
cmdz.ExecuteNonQuery();
mbdisp ob = new mbdisp();
ob.Show();
this.Hide();
}
private void button1_Click(object sender, RoutedEventArgs e)
{
sql = sql + " intersect " + sqlp;
String sqll1 = "", sqll2 = "", sqll3 = "", sqll4 = "";
sqll1 = "(" + sql0 + " intersect " + sql1 + " intersect " + sql2 + " intersect " + sql3 + " intersect " + sql4 + " intersect " + sql5 + " intersect " + sql6 + " intersect " + sql61 + " intersect " + sql7 + " intersect " + sql8 + " intersect " + sql9 + " intersect " + sql10 + " intersect " + sql11 + " intersect " + sql12 + ")";
if (f13 == 0 && f131 == 0 && f14 == 0)
{
sqll2 = "select * from filterbrand";
}
else
{
sqll2 = "(" + sql13 + " union " + sql131 + " union " + sql14 + ")";
}
if (f15 == 0 && f16 == 0 && f17 == 0 && f18 == 0 && f19 == 0 && f20 == 0 && f201 == 0)
{
sqll3 = "select * from filterbrand";
}
else
{
sqll3 = "(" + sql15 + " union " + sql16 + " union " + sql17 + " union " + sql18 + " union " + sql19 + " union " + sql20 + " union " + sql201 + ")";
}
if (f21 == 0 && f22 == 0 && f23 == 0 && f24 == 0 && f25 == 0)
{
sqll4 = "select * from filterbrand";
}
else
{
sqll4 = "(" + sql21 + " union " + sql22 + " union " + sql23 + " union " + sql24 + " union " + sql25 + ")";
}
sql = sql + " intersect " + sqll1 + " intersect " + sqll2 + " intersect " + sqll3 + " intersect " + sqll4;
OracleCommand cmd2 = new OracleCommand(sql, con);
cmd2.ExecuteNonQuery();
mbdisp a = new mbdisp();
// mediaElement.Stop();
this.Hide();
a.Show();
mediaElement.Stop();
}