protected void gridXuathang_RowDeleting(object sender, DevExpress.Web.Data.ASPxDataDeletingEventArgs e)
{
int IDPhieuXuat = Convert.ToInt32(e.Keys[0].ToString());
using (var scope = new TransactionScope())
{
try
{
var XuatKho = DBDataProvider.DB.kPhieuXuatKhacs.Where(x => x.IDPhieuXuat == IDPhieuXuat).FirstOrDefault();
if (XuatKho != null)
{
if (XuatKho.DaXoa == 0)
{
XuatKho.DaXoa = 1; // đã xóa
List <kPhieuXuatKhacChiTiet> ctXuatKho = DBDataProvider.XuatKhacKhoChiTiet(IDPhieuXuat);
foreach (var xk in ctXuatKho)
{
int IDHangHoa = Convert.ToInt32(xk.HangHoaID);
int SoLuong = Convert.ToInt32(xk.SoLuong);
var HangHoa = DBDataProvider.DB.hhHangHoas.Where(x => x.IDHangHoa == IDHangHoa).FirstOrDefault();
if (HangHoa != null)
{
#region ghi thẻ kho
kTheKho thekho = new kTheKho();
thekho.NgayNhap = DateTime.Now;
thekho.DienGiai = "Xóa phiếu xuất khác #" + XuatKho.MaPhieuXuat;
thekho.Nhap = SoLuong;
thekho.Xuat = 0;
thekho.Ton = HangHoa.hhTonKhos.Where(tk => tk.ChiNhanhID == XuatKho.ChiNhanhID).FirstOrDefault().SoLuong += SoLuong; // cộng tồn kho luôn
thekho.HangHoaID = IDHangHoa;
thekho.GiaThoiDiem = 0;
thekho.NhanVienID = Formats.IDUser();
thekho.ChiNhanhID = Formats.IDChiNhanh();
DBDataProvider.DB.kTheKhos.InsertOnSubmit(thekho);
#endregion
}
}
DBDataProvider.DB.SubmitChanges();
scope.Complete();
}
}
}
catch (Exception ex)
{
throw ex;
}
}
gridXuathang.CancelEdit();
e.Cancel = true;
gridXuathang.DataBind();
}