public static void InsertOrderDetail(OrderDetailCL orDe) { try { SqlCommand cmd = new SqlCommand("insert into OrderDetails(OrderID,ProductID,Quantity,UnitPrice) " +"values (@OrderID,@ProductID,@Quantity,@UnitPrice)", con); cmd.Parameters.AddWithValue("@OrderID", orDe.OrderID); cmd.Parameters.AddWithValue("@ProductID", orDe.ProductID); cmd.Parameters.AddWithValue("@Quantity", orDe.Quantity); cmd.Parameters.AddWithValue("@UnitPrice", orDe.Price); con.Open(); cmd.ExecuteNonQuery(); con.Close(); } catch (Exception ex) { MessageBox.Show(ex.Message); } }
private void btComplete_Click(object sender, EventArgs e) { if (dataGridView1.Rows.Count > 0) { int tradingCode = int.Parse(txtTradingCode.Text); int empId = SelectDA.getEmpID(txtSeller.Text); int cusID = int.Parse(txtCustomer.Text); int dis = int.Parse(txtDiscount.Text); OrderCL or = new OrderCL(tradingCode, cusID, empId, dis); InsertDA.InsertOrder(or); int proID = 0, quan = 0, pri = 0; for (int i = 0; i < dataGridView1.Rows.Count; i++) { proID = int.Parse(dataGridView1.Rows[i].Cells[0].Value.ToString()); quan = int.Parse(dataGridView1.Rows[i].Cells[4].Value.ToString()); pri = int.Parse(dataGridView1.Rows[i].Cells[3].Value.ToString()); OrderDetailCL orDe = new OrderDetailCL(tradingCode, proID, quan, pri); InsertDA.InsertOrderDetail(orDe); } tradingCode++; txtTradingCode.Text = tradingCode + ""; setToDefault(); } else { MessageBox.Show("Input product to sell !"); } }