private void categoryFilterButton_Click(object sender, EventArgs e) { ProdContext prodContext = new ProdContext(); Boolean parse1; Boolean parse2; Decimal minPrice = 0; Decimal maxPrice = Decimal.MaxValue; if (this.minPriceTextBox.Text == "" || this.maxPriceTextBox.Text == "") { if (minPriceTextBox.Text == "") { minPrice = 0; } if (maxPriceTextBox.Text == "") { maxPrice = Decimal.MaxValue; } } else if (!Decimal.TryParse(this.minPriceTextBox.Text, out minPrice) || !Decimal.TryParse(this.maxPriceTextBox.Text, out maxPrice) || minPrice > maxPrice) { MessageBox.Show("Bad price filters"); } ; this.categoryDataGridView.DataSource = prodContext.Categories.Where(category => (filterButton.Text != "" && category.Name.ToString().Contains(categoryNameFilterTextBox.Text) == true)).ToList(); if (checkBox1.Checked == true) { this.productsDataGridView.DataSource = prodContext.Products.Where(product => ((product.Name.ToString().Contains(this.productNameFiltertextBox.Text)) == true) && (product.UnitPrice > minPrice) && product.UnitPrice < maxPrice && product.UnitsInStock > 0).ToList(); } else { this.productsDataGridView.DataSource = prodContext.Products.Where(product => ((product.Name.ToString().Contains(this.productNameFiltertextBox.Text)) == true) && (product.UnitPrice > minPrice) && product.UnitPrice < maxPrice).ToList(); } this.categoryDataGridView.Update(); this.productsDataGridView.Refresh(); this.productsDataGridView.Update(); this.categoryDataGridView.Refresh(); }
private static void showCategoriesWithAmout(ProdContext context) { var query = from category in context.Categories join product in context.Products on category.CategoryID equals product.CategoryID into categorygroup select new { Category = category.CategoryID, Ammount = categorygroup.Count() }; foreach (var item in query) { Console.WriteLine(item); } }
static void Main(string[] args) { using (ProdContext db = new ProdContext()) { // Create and save a new Blog //Console.Write("Enter a name for a new Category: "); //String cat_name = Console.ReadLine(); //Category category = new Category { Name = cat_name }; //db.Categories.Add(category); //db.SaveChanges(); var query = from c in db.Categories orderby c.Name descending select c.Name; foreach (var cat in query) { Console.WriteLine("----" + cat); } ; showCategories(db); showProductsWithCategories(db); showCategoriesWithAmout(db); showCategoriesWithAmout2(db); //OrderHistoryForm orderHistoryForm = new OrderHistoryForm(); //orderHistoryForm.ShowDialog(); CategoryForm categoryForm = new CategoryForm(); categoryForm.ShowDialog(); //AddCategoryForm addCat = new AddCategoryForm(); //addCat.ShowDialog(); //AddOrderForm addOrderForm = new AddOrderForm(); //addOrderForm.ShowDialog(); //AddCustomer addCustomer = new AddCustomer(); //addCustomer.ShowDialog(); } }
private void AddCustomer_Load(object sender, EventArgs e) { prodContext = new ProdContext(); prodContext.Customers.Load(); this.customerBindingSource.DataSource = prodContext.Customers.Local.ToBindingList(); }
public AddCustomer() { InitializeComponent(); this.prodContext = new ProdContext(); }
public void OrderHistoryForm_Load(object sender, EventArgs e) { this.prodContext = new ProdContext(); this.prodContext.Orders.Load(); this.orderBindingSource.DataSource = prodContext.Orders.Local.ToBindingList(); }