public void XacNhanHuyDonHang(int mahd) { var dbContext = new shopContext(); var hoadon = (from hd in dbContext.Hoadon where hd.HoaDonId == mahd select hd).ToList(); //lay chi tiet hoa don cua hoa don xac nhan huy var cthd = (from ct in dbContext.Chitiethoadon where ct.HoaDonId == mahd select ct).ToList(); //xoa chi tiet hoa don foreach (var item in cthd) { var ct = dbContext.Chitiethoadon.First(a => a.ChiTietHoaDonId == item.ChiTietHoaDonId); dbContext.Chitiethoadon.Remove(ct); dbContext.SaveChanges(); } //xoa hoa don var hdon = dbContext.Hoadon.First(a => a.HoaDonId == hoadon[0].HoaDonId); dbContext.Hoadon.Remove(hdon); dbContext.SaveChanges(); dbContext.Dispose(); }
public void YeuCauHuyDonHang(int mahd) { var dbContext = new shopContext(); var hoadon = dbContext.Hoadon.First(a => a.HoaDonId == mahd); hoadon.TrangThai = "Yêu cầu hủy"; dbContext.SaveChanges(); dbContext.Dispose(); }
public void XacNhanNhanHang(int mahd) { var dbContext = new shopContext(); var hoadon = dbContext.Hoadon.First(a => a.HoaDonId == mahd); hoadon.TrangThai = "Đã nhận hàng"; hoadon.NgayGiao = DateTime.Now; dbContext.SaveChanges(); dbContext.Dispose(); }
public void Dispose() { db?.Dispose(); }