private void ListBox2_SelectionChanged(object sender, SelectionChangedEventArgs e)
{
order = (Order)ListBox2.SelectedItem;
using (var db = new NorthwindEntities2())
{
ODList = db.Order_Details.Where(od => od.OrderID == order.OrderID).ToList();
ListBox3.DisplayMemberPath = "ProductID";
ListBox3.ItemsSource = ODList;
}
}
private void Products_Click(object sender, RoutedEventArgs e)
{
CustomersButton = false;
EmployeeButton = false;
ProductButton = true;
SupplierButton = false;
ListBox1.ItemsSource = null;
ListBox2.ItemsSource = null;
ListBox3.ItemsSource = null;
using (var db = new NorthwindEntities2())
{
ProductList = db.Products.ToList();
ListBox1.DisplayMemberPath = "ProductName";
ListBox1.ItemsSource = ProductList;
}
}
private void ListBox1_SelectionChanged(object sender, SelectionChangedEventArgs e)
{
if (CustomersButton == true)
{
customer = (Customer)ListBox1.SelectedItem;
using (var db = new NorthwindEntities2())
{
OrderList = db.Orders.Where(o => o.CustomerID == customer.CustomerID).ToList();
ListBox2.DisplayMemberPath = "OrderID";
ListBox2.ItemsSource = OrderList;
}
}
else
{
ListBox2.ItemsSource = null;
}
}
