private void btnApproveOrder_Click(object sender, EventArgs e)
{
if (comboBoxCustomer == null || comboBoxEmployee == null || comboBoxShipping == null)
{
MessageBox.Show("Missing Information");
return;
}
NorthWindDataContext dc = new NorthWindDataContext();
Order neworder = new Order();
neworder.OrderDate = DateTime.Now;
neworder.CustomerID = comboBoxCustomer.SelectedValue.ToString();
neworder.EmployeeID = (int)comboBoxEmployee.SelectedValue;
neworder.ShipVia = (int)comboBoxShipping.SelectedValue;
dc.Orders.InsertOnSubmit(neworder);
dc.SubmitChanges();
foreach (ListViewItem item in listViewProducts.Items)
{
Order_Detail orderdetail = new Order_Detail();
orderdetail.OrderID = neworder.OrderID;
orderdetail.ProductID = (int)item.Tag;
orderdetail.UnitPrice = decimal.Parse(item.SubItems[1].Text);
orderdetail.Quantity = short.Parse(item.SubItems[2].Text);
orderdetail.Discount = float.Parse(item.SubItems[3].Text) / 100;
dc.Order_Details.InsertOnSubmit(orderdetail);
dc.SubmitChanges();
}
listViewProducts.Items.Clear();
comboBoxCustomer.SelectedIndex = comboBoxEmployee.SelectedIndex = comboBoxShipping.SelectedIndex = -1;
}
public void AddProduct(string name, string category, decimal price) //add product to specific category
{
var categories = from c in database.Categories //Get category
where c.CategoryName == category
select new { GetCat = c.CategoryID };
int myCategory = 0;
// SomeClass a = new SomeClass();
//myCategory = a.GetCat;
foreach (var i in categories)
{
myCategory = i.GetCat;
}
var productIDs = from p in database.Products//selects all Products ID's
select p.ProductID;
int count = 0;
foreach (var i in productIDs)
{
count++;
}
int newid = count + 1;
Product newproduct = new Product();
newproduct.ProductID = newid;
newproduct.ProductName = name;
newproduct.UnitPrice = price;
newproduct.CategoryID = myCategory;//assign category to new product
database.Products.InsertOnSubmit(newproduct);
database.SubmitChanges();
}