private void AddButton_Click(object sender, EventArgs e) { string categoryName1 = categoryNameTextBox.Text; string description1 = descriptionTextBox.Text; using (var db = new ProdContext()) { var catID = from c in db.Categories where c.Name == categoryName1 select c.CategoryID; if (catID == null) { Category category = new Category { Name = categoryName1, Description = description1 }; db.Categories.Add(category); MessageBox.Show("Category added"); db.SaveChanges(); this.resetBoxes(); } else { MessageBox.Show("Category exists"); } } }
private void buyButton_Click(object sender, EventArgs e) { if (this.customerNameTextBox.Text == null) { MessageBox.Show("Put your customer data"); } quantity = int.Parse(this.quantityTextBox.Text); if (quantity > this.available | quantity < 0) { MessageBox.Show("Invalid quantity"); } companyName1 = customerNameTextBox.Text; Customer company = prodContext.Customers.Where(c => c.CompanyName == companyName1).Select(c => c).FirstOrDefault(); if (company == null) { MessageBox.Show("Invalid company name"); return; } price = prodContext.Products.Where(p => p.ProductId == productID).Select(p => p.UnitPrice).FirstOrDefault(); string prodName = prodContext.Products.Where(p => p.ProductId == productID).Select(p => p.Name).FirstOrDefault(); decimal value = price * quantity; this.sum += value; sumLabel1.Text = "Sum: " + sum.ToString() + " zl "; this.productsLabel.Text += prodName + " x" + quantity.ToString(); Product product2 = new Product(); product2.ProductId = productID; product2.Name = prodName; product2.UnitsInStock = quantity; product2.UnitPrice = price; products.Add(product2); Product product = (from p in prodContext.Products where p.ProductId == productID select p).FirstOrDefault(); product.UnitsInStock = available - quantity; prodContext.SaveChanges(); }
private void addProductButton_Click(object sender, EventArgs e) { String productName1 = nameTextBox.Text; int unitsInStock1 = 0; while (true) { if (!int.TryParse(unitsInStockTextBox.Text, out unitsInStock1)) { Console.WriteLine("Invalid input units in stock - must be a number"); } else { break; } } decimal unitPrice1 = 0; while (true) { if (!Decimal.TryParse(unitPriceTextBox.Text, out unitPrice1)) { Console.WriteLine("Invalid input units in stock - must be a number"); } else { break; } } String categoryName1 = categoryNameTextBox.Text; using (var db = new ProdContext()) { var catID = from c in db.Categories where c.Name == categoryName1 select c.CategoryID; if (catID == null) { Console.WriteLine("Invalid category name"); this.resetBoxes(); } else { Product product = new Product { Name = productName1, UnitsInStock = unitsInStock1, CategoryID = catID.First(), UnitPrice = unitPrice1 }; db.Products.Add(product); MessageBox.Show("Product added"); db.SaveChanges(); this.resetBoxes(); } } }
private void saveButton_Click(object sender, EventArgs e) { prodContext.SaveChanges(); prodContext.Categories.Load(); prodContext.Products.Load(); this.categoryDataGridView.Refresh(); this.productsDataGridView.Refresh(); }
private void addCustomerButton_Click(object sender, EventArgs e) { if (this.companyNameTextBox.Text == "" | this.cityTextBox.Text == "" | this.addressTextBox.Text == "" | this.cityTextBox.Text == "" | this.postalCodeTextBox.Text == "") { MessageBox.Show("Fullfill all boxes"); } Customer customer = (from c in prodContext.Customers where c.CompanyName == companyNameTextBox.Text select c).FirstOrDefault(); if (customer != null) { MessageBox.Show("This customer already exists"); } Customer customer1 = new Customer { CompanyName = this.companyNameTextBox.Text, Description = this.descriptionTextBox.Text, Address = this.addressTextBox.Text, PostalCode = this.postalCodeTextBox.Text, City = this.cityTextBox.Text, Mail = this.cityTextBox.Text, Phone = this.cityTextBox.Text }; prodContext.Customers.Add(customer1); prodContext.SaveChanges(); this.customerDataGridView.Visible = true; this.customerDataGridView.Update(); this.customerDataGridView.Refresh(); //prodContext.SaveChanges(); MessageBox.Show("Customer added"); }