public ActionResult PlaceOrder(Models.Order order) { if (Session["Cart"] == null) { return(RedirectToAction("Index", "Home")); } DB.DB mydb = new DB.DB(); DB.ICustomer ic = new DB.Impl_Customer(mydb.Connection); order.custID = ic.GetCustIDByPhone(Session["Login"].ToString()); DB.DB mydb2 = new DB.DB("SQLAdmin", "admin1234"); DB.IOrder io = new DB.Impl_Order(mydb2.Connection); order.orderID = io.AddNewOrder(order.custID, order.rcptName, order.rcptPhone, order.rcptAddr, order.DTID, order.Shipping, order.orderNote); HashSet <Models.CartItem> myCart = Session["Cart"] as HashSet <Models.CartItem>; List <Dictionary <string, object> > items = new List <Dictionary <string, object> >(); foreach (Models.CartItem ii in myCart) { Dictionary <string, object> temp = new Dictionary <string, object>(); temp["proID"] = ii.ID; temp["Quantity"] = ii.Quantity; items.Add(temp); } DB.DB mydb3 = new DB.DB("SQLAdmin", "admin1234"); DB.IOrder io2 = new DB.Impl_Order(mydb3.Connection); bool finish = io2.AddCartItems(order.orderID, items); if (finish) { return(RedirectToAction("FinishOrder", new { msg = "已完成訂單!請至個人中心查看!" })); } else { return(RedirectToAction("FinishOrder", new { msg = "訂單失敗!請重新下訂貨聯絡客服!" })); } }