static public void Del(string strPhieuNhapID) { dbControl = new QlShop(); PhieuNhap DelItem = dbControl.PhieuNhaps.SingleOrDefault(p => p.PhieuNhapID == strPhieuNhapID); if (DelItem != null) { //lay danh sach san pham cua don hang List <PhieuNhapChiTiet> ListSanPham = new List <PhieuNhapChiTiet>(); ListSanPham = (from p in dbControl.PhieuNhapChiTiets where p.PhieuNhapID == strPhieuNhapID select p).ToList <PhieuNhapChiTiet>(); using (TransactionScope scope = new TransactionScope()) { //foreach (PhieuNhapChiTiet item in ListSanPham) //{ // //cap nhat lai ton kho khi xoa // SanPhamController.CapNhatTonKho(item.SanPhamID, item.SoLuong); //} //cap nhat lai con no khach hang va tien hang if (DelItem.NhaCungCapID != null) { NhaCungCapControlller.CapNhatCongNo_NhapHang(DelItem.NhaCungCapID, 0 - DelItem.ConNo, 0 - DelItem.TienHang); } dbControl.PhieuNhaps.Remove(DelItem); dbControl.PhieuNhapChiTiets.RemoveRange(ListSanPham); dbControl.SaveChanges(); scope.Complete(); } } }
static public void Add(PhieuNhap item, List <PhieuNhapChiTiet> items) { dbControl = new QlShop(); using (TransactionScope scope = new TransactionScope()) { dbControl.PhieuNhaps.Add(item); dbControl.PhieuNhapChiTiets.AddRange(items); //cap nhat so luong ton kho //foreach (PhieuNhapChiTiet PhieuNhapItem in items) //{ // SanPhamController.CapNhatTonKho(PhieuNhapItem.SanPhamID, 0 - PhieuNhapItem.SoLuong); //} //cap nha cong no va tong tien hang if (item.NhaCungCapID != null) { NhaCungCapControlller.CapNhatCongNo_NhapHang(item.NhaCungCapID, item.ConNo, item.TienHang); } dbControl.SaveChanges(); scope.Complete(); } }