private void FrmProducts_Load(object sender, EventArgs e)
{
using (var db = new NORTHWNDEntities())
{
cmbCategory.DataSource = db.Categories.ToList();
cmbSupplier.DataSource = db.Suppliers.ToList();
}
}
private void btnShowReport_Click(object sender, EventArgs e)
{
Category category = cmbCategory.SelectedItem as Category;
Supplier supplier = cmbSupplier.SelectedItem as Supplier;
CategoryBindingSource.DataSource = category;
SupplierBindingSource.DataSource = supplier;
//TODO - Get products for this supplier and category
using (var db = new NORTHWNDEntities())
{
var query = from p in db.Products
where p.Category.CategoryID == category.CategoryID && p.Supplier.SupplierID == supplier.SupplierID
select p;
List <Product> allproducts = query.ToList();
ProductBindingSource.DataSource = allproducts;
}
//TODO - Send all data to the report and show the report
this.reportViewer1.RefreshReport();
}
