//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));
}
