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();
}
