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 !");
}
}