01.[WebMethod]
02. public void addOrder(string orderID, string orderDate, string orderTime, string staffID, string custID, string recvFName, string recvLName, string recvAddress, string recvTel, double totalPrice, string orderComplete)
03. {
04. SqlConnection sqlConn = new SqlConnection();
05. sqlConn.ConnectionString = ConfigurationManager.ConnectionStrings["StockProductInfo"].ConnectionString;
06. SqlCommand sqlComm = new SqlCommand();
07. sqlConn.Open();
08.
09. SqlCommand cmd = new SqlCommand("SPaddOrder", sqlConn);
10. cmd.Parameters.AddWithValue("@OrderID", orderID);
11. cmd.Parameters.AddWithValue("@OrderDate", orderDate);
12. cmd.Parameters.AddWithValue("@OrderTime", orderTime);
13. cmd.Parameters.AddWithValue("@StaffID", staffID);
14. cmd.Parameters.AddWithValue("@CustID", custID);
15. cmd.Parameters.AddWithValue("@RecvFName", recvFName);
16. cmd.Parameters.AddWithValue("@RecvLName", recvLName);
17. cmd.Parameters.AddWithValue("@RecvAddress", recvAddress);
18. cmd.Parameters.AddWithValue("@RecvTel", recvTel);
19. cmd.Parameters.AddWithValue("@TotalPrice", totalPrice);
20. cmd.Parameters.AddWithValue("@OrderComplete", orderComplete);
21. cmd.CommandType = CommandType.StoredProcedure;
22.
23. SqlDataAdapter da = new SqlDataAdapter(cmd);
24.
25. DataSet ds = new DataSet();
26.
27. da.Fill(ds);
28. sqlConn.Close();
29. }
