public ActionResult BuyingHistoryPartial() { if (Session["LogedUserID"] == null) { return RedirectToAction("Login", "User"); } int Id_User = int.Parse((Session["LogedUserID"]).ToString()); List<Order> lstOrder = db.Orders.Where(n => n.Id_User == Id_User).ToList(); List<DiscInBuyingHistory> lstDiscInBH = new List<DiscInBuyingHistory>(); if(lstOrder.Count == 0) { ViewBag.Null = "Bạn chưa mua hàng nên không có lịch sử."; return PartialView(); } foreach(var item in lstOrder) { List<Detail_Order> lstDetailOrder = db.Detail_Order.Where(n => n.Id_Order == item.Id).ToList(); foreach(var item2 in lstDetailOrder) { DiscInBuyingHistory discInBH = new DiscInBuyingHistory((int)item2.Id_Disc, (DateTime)item.Date, (int)item.Status); discInBH.Number = (int)item2.Quantity; lstDiscInBH.Add(discInBH); } } return PartialView(lstDiscInBH); }
public List<DiscInBuyingHistory> GetDiscUnpaidBills() { int Id_User = int.Parse((Session["LogedUserID"]).ToString()); List<Order> lstOrder = db.Orders.Where(n => n.Id_User == Id_User && n.IsPaid == 0).ToList(); List<DiscInBuyingHistory> lstDiscInBH = new List<DiscInBuyingHistory>(); List<Direct_Payment_Method> lstDPM = new List<Direct_Payment_Method>(); foreach (var item in lstOrder) { List<Detail_Order> lstDetailOrder = db.Detail_Order.Where(n => n.Id_Order == item.Id).ToList(); foreach (var item2 in lstDetailOrder) { DiscInBuyingHistory discInBH = new DiscInBuyingHistory((int)item2.Id_Disc, (DateTime)item.Date, (int)item.Status); discInBH.Number = (int)item2.Quantity; discInBH.Id_Order = (int)item.Id; lstDiscInBH.Add(discInBH); } Direct_Payment_Method DPM = db.Direct_Payment_Method.SingleOrDefault(n => n.Id_Order == item.Id); lstDPM.Add(DPM); } ViewData["lstOrder"] = lstOrder; ViewData["lstDPM"] = lstDPM; return lstDiscInBH; }