public void CreateOrderDetail(OrderDetail orderDetail) { OrderDetailDAO orderDetailDAO = new OrderDetailDAO(); orderDetailDAO.CreateOrderDetail(orderDetail); }
public ActionResult Confirm() { bool errorQuantity = false; ProductDAO dao = new ProductDAO(); CartItem c = (CartItem)Session["CART"]; string[,] listErrorQuantity = new string[c.Cart.Count, 1]; for (int i = 0; i < c.Cart.Count; i++) { int quantityAtCart = c.Cart[i].Quantity; int quantityInDatabase = dao.GetProductQuantity(c.Cart[i].Product.ID); if (quantityAtCart > quantityInDatabase) { listErrorQuantity.SetValue("Max : " + quantityInDatabase, i, 0); errorQuantity = true; } } if (errorQuantity == false) { for (int i = 0; i < c.Cart.Count; i++) { dao.UpdateQuantitty(c.Cart[i].Product.ID, c.Cart[i].Quantity); } float totalPrice = float.Parse(Request["TotalPrice"]); CustomerDAO daoCus = new CustomerDAO(); CustomerDTO cus = (CustomerDTO)Session["CUSTOMER"]; bool result = daoCus.CheckOut(totalPrice, cus.Username); //check point and maybe update rank string newRank = ""; float point = daoCus.GetPointOfCus(cus.Username); string currentRank = cus.Rank; if (currentRank == null) { currentRank = ""; } if (point >= 500 && point < 2000 && currentRank.Equals("bronze") == false) { newRank = "bronze"; daoCus.UpdateRank(cus.Username, newRank); ViewBag.Congrats = "Congratulations!!! Your rank is Bronze now. Thank you for choosing our service."; } if (point >= 2000 && point < 5000 && currentRank.Equals("silver") == false) { newRank = "silver"; daoCus.UpdateRank(cus.Username, newRank); ViewBag.Congrats = "Congratulations!!! Your rank is Silver now. Thank you for choosing our service."; } if (point >= 5000 && point < 15000 && currentRank.Equals("gold") == false) { newRank = "gold"; daoCus.UpdateRank(cus.Username, newRank); ViewBag.Congrats = "Congratulations!!! Your rank is Gold now. Thank you for choosing our service."; } if (point >= 15000 && currentRank.Equals("platinum") == false) { newRank = "platinum"; daoCus.UpdateRank(cus.Username, newRank); ViewBag.Congrats = "Congratulations!!! Your rank is Platinum now. Thank you for choosing our service."; } //when checkout done if (result) { // create order DateTime createDate = DateTime.Now; string cusID = cus.Username; int state = 0;// start order float discount = 0; if (Session["Discount"] != null) // neu moi mua lan dau thi ko co discount { discount = (float)Session["Discount"]; } BillDTO order = new BillDTO(createDate, cusID, state, totalPrice, discount); BillDAO daoOrder = new BillDAO(); bool resultOrder = daoOrder.CreateOrder(order);// create order if (resultOrder) { OrderDetailDAO daoOrderDetail = new OrderDetailDAO(); int orderID = daoOrder.GetOrderID(); // get orderID has created for (int i = 0; i < c.Cart.Count; i++) { OrderDetailDTO orderDetail = new OrderDetailDTO(orderID, c.Cart[i].Product.ID, c.Cart[i].Quantity, c.Cart[i].Product.Price, c.Cart[i].Product.NameProduct); daoOrderDetail.CreateOrderDetail(orderDetail); } Session.Remove("CART"); Session.Remove("txtSearchValue"); } } } else { ViewBag.ErrorQuantity = listErrorQuantity; return(View("ViewCart")); } return(View("ViewOrdercomplete")); }