コード例 #1
0
        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();
        }
コード例 #2
0
        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();
        }
コード例 #3
0
        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();
        }
コード例 #4
0
 public void Dispose()
 {
     db?.Dispose();
 }