private void SubmitButton_Click(object sender, EventArgs e) { var newProduct = new Product { Name = NameTextBox.Text.ToString(), UnitsInStock = Convert.ToInt32(UnitsTextBox.Text.ToString()), CategoryID = Convert.ToInt32(CategoryTextBox.Text.ToString()), UnitPrice = Convert.ToDecimal(PriceTextBox.Text.ToString()) }; db.Products.Add(newProduct); db.SaveChanges(); Close(); }
private void OrderButton_Click(object sender, EventArgs e) { var CID = Convert.ToInt32(CustomerIDTextBox.Text.ToString()); var newOrder = new Order { CustomerID = CID }; var details = new List <OrderDetails>(); for (int i = 0; i < SelectedDgv.Rows.Count; i++) { details.Add(new OrderDetails { OrderID = newOrder.OrderID, ProductID = Convert.ToInt32(SelectedDgv.Rows[i].Cells[0].Value.ToString()), Quantity = Convert.ToInt32(SelectedDgv.Rows[i].Cells[2].Value.ToString()) }); } newOrder.Details = details; db.Orders.Add(newOrder); db.SaveChanges(); Close(); }