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