private void button1_Click(object sender, EventArgs e) { var vCompanyName = textBox1.Text; var vDescription = textBox2.Text; using (var prodDB = new ProdContent()) { var isCompanyNameExists = from c in prodDB.Customers where c.CompanyName == vCompanyName select c.CompanyName; if (isCompanyNameExists.Contains(vCompanyName)) { MessageBox.Show("Company with this name exists"); return; } var newCustomer = new Customer(); newCustomer.CompanyName = vCompanyName; newCustomer.Description = vDescription; prodDB.Customers.Add(newCustomer); prodDB.SaveChanges(); } Hide(); DestroyHandle(); }
private void button1_Click(object sender, EventArgs e) { var vCategoryName = textBox1.Text; var vDescription = textBox2.Text; using (var prodDB = new ProdContent()) { var isCategoryExists = prodDB.Category .Where(cat => cat.Name == vCategoryName) .Select(c => c.Name); if (isCategoryExists.Contains(vCategoryName)) { MessageBox.Show("Category with this name already exists"); return; } var newCategory = new Category(); newCategory.Name = vCategoryName; newCategory.Description = vDescription; prodDB.Category.Add(newCategory); prodDB.SaveChanges(); } Hide(); DestroyHandle(); }
public NewOrder() { InitializeComponent(); using (var prodDB = new ProdContent()) { var customers = from c in prodDB.Customers orderby c.CompanyName select c.CompanyName; foreach (var c in customers) { comboBox1.Items.Add(c); } var categories = from c in prodDB.Category orderby c.Name select c.Name; foreach (var c in categories) { comboBox3.Items.Add(c); } } }
private void button1_Click(object sender, EventArgs e) { var selectedCustomer = (string)comboBox1.SelectedItem; var selectedProduct = (string)comboBox2.SelectedItem; int selectedQuantity = Int32.Parse(textBox1.Text); using (var prodDB = new ProdContent()) { var availableQuantity = from p in prodDB.Product where p.Name == selectedProduct select p.UnitsInStock; if (selectedQuantity > availableQuantity.First()) { MessageBox.Show("Do not have enough product available"); return; } var selectedProductID = from p in prodDB.Product where p.Name == selectedProduct select p.ProductID; var vOrder = new Order(); vOrder.CompanyName = selectedCustomer; vOrder.ProductID = selectedProductID.First(); vOrder.Quantity = selectedQuantity; prodDB.Orders.Add(vOrder); prodDB.SaveChanges(); } Hide(); DestroyHandle(); }
private void statisticsForm_Load(object sender, EventArgs e) { using (var prodDB = new ProdContent()) { label7.Text = prodDB.Customers.Count().ToString(); label8.Text = prodDB.Category.Count().ToString(); label9.Text = prodDB.Product.Count().ToString(); label10.Text = prodDB.Orders.Count().ToString(); } }
private void button1_Click(object sender, EventArgs e) { using (var prodDB = new ProdContent()) { var orders = prodDB.Customers.Include("Orders") .Where(c => c.CompanyName == comboBox1.SelectedItem.ToString()) .Select(c => c.Orders).ToList(); foreach (List <Order> o in orders) { dataGridView1.DataSource = o; } dataGridView1.Update(); } }
public findClientOrdersForm() { InitializeComponent(); using (var prodDB = new ProdContent()) { var customers = from c in prodDB.Customers orderby c.CompanyName select c.CompanyName; foreach (var c in customers) { comboBox1.Items.Add(c); } } }
public newProductForm() { InitializeComponent(); pDB = new ProdContent(); using (var prodDB = new ProdContent()) { var categories = from c in prodDB.Category orderby c.Name select c.Name; foreach (var c in categories) { comboBox2.Items.Add(c); } } }
private void button1_Click(object sender, EventArgs e) { var vProductName = textBox1.Text; var vUnitsInStock = Int32.Parse(textBox2.Text); var vCategory = (String)comboBox2.SelectedItem; var vUnitPrice = textBox3.Text; using (var prodDB = new ProdContent()) { var catId = (from c in prodDB.Category where c.Name == vCategory select c.CategoryId).FirstOrDefault(); if (catId == 0) { MessageBox.Show("You have to choose category!"); return; } var isProductExists = from p in prodDB.Product where p.Name == vProductName select p.Name; if (isProductExists.Contains(vProductName)) { MessageBox.Show("Product with this name already exists"); return; } var newProduct = new Product(); newProduct.Name = vProductName; newProduct.UnitsInStock = vUnitsInStock; newProduct.CategoryId = catId; newProduct.Unitprice = Decimal.Parse(vUnitPrice); prodDB.Product.Add(newProduct); prodDB.SaveChanges(); } Hide(); DestroyHandle(); }
private void comboBox3_SelectedIndexChanged(object sender, EventArgs e) { using (var prodDB = new ProdContent()) { var selectedCategory = (string)comboBox3.SelectedItem; var selectedCategoryID = (from c in prodDB.Category where c.Name == selectedCategory select c.CategoryId).First(); var products = from p in prodDB.Product where p.CategoryId == selectedCategoryID select p.Name; comboBox2.Items.Clear(); foreach (var p in products) { comboBox2.Items.Add(p); } } }
public NewCustomerForm() { InitializeComponent(); pDB = new ProdContent(); }
public newCategoryForm() { InitializeComponent(); prodDB = new ProdContent(); }
public StartForm() { InitializeComponent(); prodDB = new ProdContent(); }