private void AddProvider_Load(object sender, EventArgs e) { ZooDataLibrary.ZooShopEntities ctx = new ZooShopEntities(); ctx.Citys.Load(); citysBindingSource.DataSource = ctx.Citys.Local.ToBindingList(); }
private void Search() { ctx = new ZooShopEntities(); var query = (from c in ctx.Products select c); if (this.NameChB.Checked) { string name = NameTB.Text.Trim(); query = query.Where(c => c.Name.Contains(name)); } if (this.PriceChB.Checked) { int pricefrom = (int)PriceFromNUD.Value; int priceto = (int)PriceToNUD.Value; query = query.Where(c => c.Price >= pricefrom && c.Price <= priceto); } if (this.Anim_kindChB.Checked) { int animid = (int)this.Anim_kindCB.SelectedValue; query = query.Where(c => c.Anim_kind == animid); } if (this.Product_kindChB.Checked) { int productkind = (int)this.Product_kindCB.SelectedValue; query = query.Where(c => c.Product_kind == productkind); } query.Load(); this.productsBindingSource.DataSource = ctx.Products.Local.ToBindingList(); }
private void SearchOrderByClientButton_Click(object sender, EventArgs e) { ZooShopEntities ctx1 = new ZooShopEntities(); int clientid = (int)this.SearchOrderByClientCB.SelectedValue; var query = (from q in ctx1.Orders where q.Id_client == clientid select q); query.Load(); this.ordersBindingSource.DataSource = ctx1.Orders.Local.ToBindingList(); }
private void AddProduct_Load(object sender, EventArgs e) { ZooDataLibrary.ZooShopEntities ctx = new ZooShopEntities(); ctx.AnimalKinds.Load(); this.animalKindsBindingSource.DataSource = ctx.AnimalKinds.Local.ToBindingList(); ctx.ProductKinds.Load(); this.productKindsBindingSource.DataSource = ctx.ProductKinds.Local.ToBindingList(); }
private void ProdByProvButton_Click(object sender, EventArgs e) { ZooDataLibrary.ZooShopEntities ctx1 = new ZooShopEntities(); int prov_id = (int)this.ProvForProdCB.SelectedValue; Providers provider = (from q in ctx1.Providers where q.Id == prov_id select q).FirstOrDefault(); var query = (from q in ctx1.Products select q).Where(q => q.Providers.Select(w => w.Id).ToList().Contains(prov_id)); query.Load(); this.productsForProvidersBindingSource.DataSource = ctx1.Products.Local.ToBindingList(); }
private void AddOrder_Load(object sender, EventArgs e) { ZooDataLibrary.ZooShopEntities ctx = new ZooShopEntities(); ctx.Clients.Load(); this.clientsBindingSource.DataSource = ctx.Clients.Local.ToBindingList(); ctx.Products.Load(); this.productsBindingSource.DataSource = ctx.Products.Local.ToBindingList(); ctx.Status.Load(); this.statusBindingSource.DataSource = ctx.Status.Local.ToBindingList(); }
private void SearchProducts_Load(object sender, EventArgs e) { ctx = new ZooShopEntities(); ctx.Products.Load(); this.productsBindingSource.DataSource = ctx.Products.Local.ToBindingList(); ctx.ProductKinds.Load(); this.productKindsBindingSource.DataSource = ctx.ProductKinds.Local.ToBindingList(); ctx.AnimalKinds.Load(); this.animalKindsBindingSource.DataSource = ctx.AnimalKinds.Local.ToBindingList(); }