private void QLP_VP_btnXoa_Click(object sender, EventArgs e)
{
PHIEUXULYVIPHAM pxl = new PHIEUXULYVIPHAM();
pxl.MaXuLyViPham = int.Parse(QLP_VP_dgvDSPhieuXLVP.CurrentRow.Cells[0].Value.ToString());
DialogResult rs = MessageBox.Show("Bạn có chắc muốn xóa mã phiếu xử lý " + pxl.MaXuLyViPham.ToString(), "Thông báo", MessageBoxButtons.YesNo, MessageBoxIcon.Question);
if (rs == DialogResult.Yes)
{
if (qlvp.xoaPXL(pxl))
{
MessageBox.Show("Xóa thành công !");
load_dgvDSPhieuXLVP();
load_dgvCTXLTheoPXL(pxl.MaXuLyViPham);
}
else
{
MessageBox.Show("Xóa thất bại !");
}
}
}
public bool luuPhieuXLVP(DateTime ngaylap, float tongtien, List <CT_XULYVIPHAM> lstCTVP, int manv)
{
PHIEUTRA mapt = qltv.PHIEUTRAs.Where(n => n.TinhTrangXoa == false).OrderByDescending(x => x.MaPhieuTra).First();
PHIEUXULYVIPHAM pxlvp = qltv.PHIEUXULYVIPHAMs.Where(l => l.MaPhieuTra == mapt.MaPhieuTra).FirstOrDefault();
if (pxlvp == null)
{
try
{
PHIEUXULYVIPHAM pxl = new PHIEUXULYVIPHAM();
pxl.MaPhieuTra = mapt.MaPhieuTra;
pxl.NgayLap = ngaylap;
pxl.MaNhanVien = manv;
pxl.TongTienBoiThuong = tongtien;
pxl.TinhTrangXoa = false;
qltv.PHIEUXULYVIPHAMs.InsertOnSubmit(pxl);
qltv.SubmitChanges();
for (int i = 0; i < lstCTVP.Count(); i++)
{
PHIEUXULYVIPHAM pxl_fi = qltv.PHIEUXULYVIPHAMs.Where(p => p.MaPhieuTra == pxl.MaPhieuTra && p.TinhTrangXoa == false).OrderByDescending(s => s.MaXuLyViPham).First();
//CT_XULYVIPHAM ct = qltv.CT_XULYVIPHAMs.Where(c => c.MaXuLyViPham == pxl_fi.MaXuLyViPham).FirstOrDefault();
CT_XULYVIPHAM ctxl = new CT_XULYVIPHAM();
ctxl.MaXuLyViPham = pxl_fi.MaXuLyViPham;
ctxl.MaLoaiViPham = lstCTVP[i].MaLoaiViPham;
ctxl.TienBoiThuong = lstCTVP[i].TienBoiThuong;
ctxl.MaVach = lstCTVP[i].MaVach;
ctxl.TinhTrangXoa = false;
qltv.CT_XULYVIPHAMs.InsertOnSubmit(ctxl);
qltv.SubmitChanges();
}
return(true);
}
catch (Exception ex)
{
return(false);
}
}
return(false);
}
public bool xoaPXL(PHIEUXULYVIPHAM pxl)
{
PHIEUXULYVIPHAM pxlvp = qltv.PHIEUXULYVIPHAMs.Where(p => p.MaXuLyViPham == pxl.MaXuLyViPham).FirstOrDefault();
if (pxlvp != null)
{
try
{
List <CT_XULYVIPHAM> lstCTXL = qltv.CT_XULYVIPHAMs.Where(x => x.MaXuLyViPham == pxlvp.MaXuLyViPham).ToList();
foreach (CT_XULYVIPHAM _ctxl in lstCTXL)
{
qltv.CT_XULYVIPHAMs.DeleteOnSubmit(_ctxl);
qltv.SubmitChanges();
}
qltv.PHIEUXULYVIPHAMs.DeleteOnSubmit(pxlvp);
qltv.SubmitChanges();
return(true);
}
catch (Exception ex) { return(false); }
}
return(false);
}
