public void oderMenu(CusOrder a, string customerid, DateTime expirydate, DataGridView datagridview1, string ordernumber) { SqlCommand cmd = new SqlCommand("insert into Customer values('" + a.cusName + "','" + a.cusTel + "','" + a.cusAdd1 + "','" + a.cusAdd2 + "','" + a.cusAdd3 + "')", con); con.Open(); cmd.ExecuteNonQuery(); cmd = new SqlCommand("insert into CusOrderHeader values('" + DateTime.Now.Date + "','" + expirydate.Date + "','" + Convert.ToInt32(customerid) + "')", con); cmd.ExecuteNonQuery(); con.Close(); foreach (DataGridViewRow row in datagridview1.Rows) { try { con.Open(); cmd = new SqlCommand("insert into CusOrderDetail values('" + Convert.ToInt32(ordernumber) + "','" + Convert.ToInt16(row.Cells["item Code"].Value.ToString()) + "','" + Convert.ToInt32(row.Cells["Quantity"].Value.ToString()) + "','" + Convert.ToInt32(row.Cells["Subtotal"].Value.ToString()) + "')", con); cmd.ExecuteNonQuery(); con.Close(); } catch { con.Close(); return; } } }
public DataTable viewOrder(CusOrder b) { SqlCommand cmd = new SqlCommand("select * from CusOrderDetail where OrderNumber='" + b.orderNumber + "'", con); con.Open(); SqlDataAdapter da = new SqlDataAdapter(cmd); DataTable dt = new DataTable(); da.Fill(dt); return(dt); }