// GET: Order_Search public ActionResult Index() { string Customer_Email = ""; try { Customer_Email = Request.Cookies["cookie"]["Account"].ToString(); Service.SQLGetCustomerOrder SGCO = new Service.SQLGetCustomerOrder(); Service.SQLGetShowBook SGSB = new Service.SQLGetShowBook(); List <Model.CustomerOrder> Data = new List <Model.CustomerOrder>(); List <Model.ShowBook> Data2 = new List <Model.ShowBook>(); List <List <Model.ShowBook> > test = new List <List <Model.ShowBook> >(); Data = SGCO.Get_Customer_Order("", Customer_Email); for (int i = 0; i < Data.Count; i++) { Data2 = SGSB.ShowBook(Data[i].Order_ID.ToString()); test.Add(Data2); } ViewBag.result = Data; if (Data.Count < 1) { return(RedirectToAction("none", "Order_Search")); } ViewBag.Book = test; }catch (Exception e) { return(RedirectToAction("RedirectToLogin", "Login")); } return(View()); }
// GET: DataShow public ActionResult Index(string Order_ID) { int Total = 0; Model.CustomerData Customer_Data = new Model.CustomerData(); List <Model.CustomerOrder> Customer_Order = new List <Model.CustomerOrder>(); List <Model.ShowBook> Book_Data = new List <Model.ShowBook>(); Service.SQLCustomerData SCD = new Service.SQLCustomerData(); Service.SQLGetCustomerOrder SGCO = new Service.SQLGetCustomerOrder(); Service.SQLGetShowBook SGSB = new Service.SQLGetShowBook(); Customer_Data = SCD.getData(Request.Cookies["cookie"]["Account"].ToString()); Customer_Order = SGCO.Get_Customer_Order(Order_ID, Customer_Data.Customer_Email); Book_Data = SGSB.ShowBook(Customer_Order[0].Order_ID.ToString()); ViewBag.Customer_Data = Customer_Data; ViewBag.Customer_Order = Customer_Order; for (int i = 0; i < Book_Data.Count; i++) { Total += int.Parse(Book_Data[i].Book_Price) * int.Parse(Book_Data[i].Order_Quantity); } ViewBag.Book_Data = Book_Data; ViewBag.Price_Total = Total; Service.SQLDeleteShoppingCart SDSC = new Service.SQLDeleteShoppingCart(); SDSC.Delete_Cart(); return(View()); }