// GET: OrderManager/Details/5 public IActionResult Details(int?id) { if (id == null) { return(NotFound()); } var giohang = new OderViewModel(); List <ChiTietGioHang> ctgiohang = _context.ChiTietGioHang.Where(p => p.MaGioHang == id).ToList(); foreach (var item in ctgiohang) { OrderDetailViewModel tmp = new OrderDetailViewModel(); if (_context.ThucDon.Find(item.MaThucDon).KhuyenMai > 0) { tmp.gia = _context.ThucDon.Find(item.MaThucDon).GiaKhuyenMai; } else { tmp.gia = _context.ThucDon.Find(item.MaThucDon).Gia; } tmp.masp = item.MaThucDon; tmp.soluong = item.SoLuong; tmp.thanhtien = tmp.gia * tmp.soluong; tmp.tensp = _context.ThucDon.Find(item.MaThucDon).TenThucDon; tmp.id = item.MaCtgioHang; giohang.ctgiohangs.Add(tmp); } giohang.giohang = _context.GioHang.Find(id); if (giohang.giohang == null) { return(NotFound()); } return(View(giohang)); }
public IActionResult Index() { string day = DateTime.Now.ToString("yyyy-MM-dd");; var myDbContext = db.GioHang.Include(g => g.MaKhachHangNavigation); //string date = item.NgayDat.ToString(); //date = date.Substring(0, 10); var dshd = myDbContext.Where(p => p.NgayDat.ToString().Substring(0, 10) == day); var dshdM = myDbContext.Where(p => p.NgayDat.Value.Month == Convert.ToInt32(DateTime.Now.Month)); var dshdY = myDbContext.Where(p => p.NgayDat.Value.Year == Convert.ToInt32(DateTime.Now.Year)); double totalDay = 0; double totalMonth = 0; double totalYear = 0; int count = 0; foreach (var item in dshdM) { totalYear += Convert.ToDouble(item.TongCong); } foreach (var item in dshdM) { totalMonth += Convert.ToDouble(item.TongCong); } foreach (var item in dshd) { totalDay += Convert.ToDouble(item.TongCong); if (item.TrangThai == 0) { count++; } } ViewBag.TotalDay = totalDay; ViewBag.TotalMonth = totalMonth; ViewBag.TotalYear = totalYear; ViewBag.List = dshd; ViewBag.Count = count; var giohang = new OderViewModel(); List <OrderDetailViewModel> listorder = new List <OrderDetailViewModel>(); List <ChiTietGioHang> ctgiohang = db.ChiTietGioHang.ToList(); foreach (var item in ctgiohang) { OrderDetailViewModel tmp = new OrderDetailViewModel(); if (db.ThucDon.Find(item.MaThucDon).KhuyenMai > 0) { tmp.gia = db.ThucDon.Find(item.MaThucDon).GiaKhuyenMai; } else { tmp.gia = db.ThucDon.Find(item.MaThucDon).Gia; } tmp.masp = item.MaThucDon; tmp.soluong = item.SoLuong; tmp.thanhtien = tmp.gia * tmp.soluong; tmp.tensp = db.ThucDon.Find(item.MaThucDon).TenThucDon; tmp.id = item.MaCtgioHang; listorder.Add(tmp); //giohang.ctgiohangs.Add(tmp); } ThucDonViewModel dsThucDon = new ThucDonViewModel(db); //List<ThucDonViewModel> dsThucDon = new List<ThucDonViewModel>(); var pro = dsThucDon.GetAllData().OrderByDescending(p => p.LuotMua).Take(4); ViewBag.ProductHot = dsThucDon.GetAllData().OrderByDescending(p => p.LuotXem).Take(3); ViewBag.ListProduct = listorder; return(View()); }