private void MainForm_Load(object sender, EventArgs e)
{
ctx = new ZooDataLibrary.ZooShopEntities();
ctx.Products.Load();
this.productsBindingSource.DataSource = ctx.Products.Local.ToBindingList();
ctx.AnimalKinds.Load();
this.animalKindsBindingSource.DataSource = ctx.AnimalKinds.Local.ToBindingList();
ctx.ProductKinds.Load();
this.productKindsBindingSource.DataSource = ctx.ProductKinds.Local.ToBindingList();
ctx.Providers.Load();
this.providersBindingSource.DataSource = ctx.Providers.Local.ToBindingList();
ctx.Citys.Load();
this.citysBindingSource.DataSource = ctx.Citys.Local.ToBindingList();
ctx.Orders.Load();
this.ordersBindingSource.DataSource = ctx.Orders.Local.ToBindingList();
ctx.Clients.Load();
this.clientsBindingSource.DataSource = ctx.Clients.Local.ToBindingList();
ctx.Status.Load();
this.statusBindingSource.DataSource = ctx.Status.Local.ToBindingList();
}
private void AddProvProd_Load(object sender, EventArgs e)
{
ctx = new ZooShopEntities();
ctx.Providers.Load();
this.providersBindingSource.DataSource = ctx.Providers.Local.ToBindingList();
ctx.Products.Load();
this.productsBindingSource.DataSource = ctx.Products.Local.ToBindingList();
}
private void ProviderCB_SelectedIndexChanged(object sender, EventArgs e)
{
ctx = new ZooShopEntities();
int prov_id = (int)this.ProviderCB.SelectedValue;
Providers provider = (from q in ctx.Providers where q.Id == prov_id select q).FirstOrDefault();
var query = (from q in ctx.Products select q).Where(q => q.Providers.Select(w => w.Id).ToList().Contains(prov_id));
query.Load();
this.productsBindingSource.DataSource = ctx.Products.Local.ToBindingList();
}