protected void gridNhaphang_RowDeleting(object sender, DevExpress.Web.Data.ASPxDataDeletingEventArgs e) { int IDChuyenKho = Convert.ToInt32(e.Keys[0].ToString()); using (var scope = new TransactionScope()) { try { var ChuyenKho = DBDataProvider.DB.kChuyenKhos.Where(x => x.IDPhieuChuyen == IDChuyenKho).FirstOrDefault(); if (ChuyenKho != null) { ChuyenKho.DaXoa = 1; List <kChuyenKhoChiTiet> chitiet = DBDataProvider.ChuyenKhoChiTiet(IDChuyenKho); foreach (var nk in chitiet) { int IDHangHoa = Convert.ToInt32(nk.HangHoaID); int SoLuong = Convert.ToInt32(nk.SoLuong); var HangHoa = DBDataProvider.DB.hhHangHoas.Where(x => x.IDHangHoa == IDHangHoa).FirstOrDefault(); if (HangHoa != null) { // trừ kho chuyển #region ghi thẻ kho trừ kTheKho thekho = new kTheKho(); thekho.NgayNhap = DateTime.Now; thekho.DienGiai = "Xóa phiếu chuyển kho #" + ChuyenKho.MaPhieu; thekho.Nhap = SoLuong; thekho.Xuat = 0; thekho.GiaThoiDiem = 0; thekho.ChiNhanhID = ChuyenKho.ChiNhanhChuyenID; thekho.Ton = HangHoa.hhTonKhos.Where(s => s.ChiNhanhID == ChuyenKho.ChiNhanhChuyenID).FirstOrDefault().SoLuong += SoLuong; thekho.HangHoaID = IDHangHoa; thekho.NhanVienID = Formats.IDUser(); DBDataProvider.DB.kTheKhos.InsertOnSubmit(thekho); #endregion // cộng kho nhận #region ghi thẻ kho kTheKho thekho1 = new kTheKho(); thekho1.NgayNhap = DateTime.Now; thekho1.DienGiai = "Xóa phiếu chuyển kho #" + ChuyenKho.MaPhieu; thekho1.Nhap = 0; thekho1.Xuat = SoLuong; thekho1.GiaThoiDiem = 0; thekho1.ChiNhanhID = ChuyenKho.ChiNhanhNhanID; thekho1.Ton = HangHoa.hhTonKhos.Where(s => s.ChiNhanhID == ChuyenKho.ChiNhanhNhanID).FirstOrDefault().SoLuong -= SoLuong; thekho1.HangHoaID = IDHangHoa; thekho1.NhanVienID = Formats.IDUser(); DBDataProvider.DB.kTheKhos.InsertOnSubmit(thekho1); #endregion } } DBDataProvider.DB.SubmitChanges(); scope.Complete(); } } catch (Exception ex) { throw ex; } } gridNhaphang.CancelEdit(); e.Cancel = true; gridNhaphang.DataBind(); }