//GET Delete public async Task <IActionResult> Delete(int?ma) { if (ma == null) { return(NotFound()); } var danhsachSP = (IEnumerable <SanPham>)(from p in _db.SanPhams join a in _db.CT_DonHangs on p.MaSP equals a.MaSP where a.DonHang.MaDH == ma select p).Include("MatHang").Include("NhaCungCap"); foreach (var item in danhsachSP) { item.SoLuong = (from p in _db.SanPhams join a in _db.CT_DonHangs on p.MaSP equals a.MaSP where a.DonHang.MaDH == ma && a.MaSP == item.MaSP select a.SoLuong).FirstOrDefault(); } CTDonHangViewModel objVM = new CTDonHangViewModel() { DonHang = _db.DonHangs.Include(a => a.NhanVien).Where(a => a.MaDH == ma).FirstOrDefault(), NhanViens = _db.NhanViens.ToList(), SanPhams = danhsachSP.ToList() }; return(View(objVM)); }
public async Task <IActionResult> Edit(int ma, CTDonHangViewModel objVM) { if (ModelState.IsValid) { objVM.DonHang.NgayNhanHang = objVM.DonHang.NgayNhanHang .AddHours(objVM.DonHang.GioNhanHang.Hour) .AddMinutes(objVM.DonHang.GioNhanHang.Minute); var donHangFromDb = _db.DonHangs.Where(a => a.MaDH == objVM.DonHang.MaDH).FirstOrDefault(); donHangFromDb.TenKH = objVM.DonHang.TenKH; donHangFromDb.SoDienThoai = objVM.DonHang.SoDienThoai; donHangFromDb.DiaChiKH = objVM.DonHang.DiaChiKH; donHangFromDb.NgayNhanHang = objVM.DonHang.NgayNhanHang; donHangFromDb.TrangThai = objVM.DonHang.TrangThai; if (User.IsInRole(SD.QuanLi)) { donHangFromDb.MaNV = objVM.DonHang.MaNV; } _db.SaveChanges(); return(RedirectToAction(nameof(Index))); } return(View(objVM)); }