public bool xoaPhieuTra(PHIEUTRA xpt)
{
PHIEUTRA pt = qltv.PHIEUTRAs.Where(t => t.MaPhieuTra == xpt.MaPhieuTra).FirstOrDefault();
if (pt != null)
{
try {
List <CT_PHIEUTRA> lstCTPT = qltv.CT_PHIEUTRAs.Where(t => t.MaPhieuTra == pt.MaPhieuTra).ToList();
foreach (CT_PHIEUTRA _ctpt in lstCTPT)
{
PHIEUMUON _pm = qltv.PHIEUMUONs.Where(m => m.MaPhieuMuon == _ctpt.MaPhieuMuon).FirstOrDefault();
List <CT_PHIEUMUON> lstCTPM = qltv.CT_PHIEUMUONs.Where(ct => ct.MaPhieuMuon == _pm.MaPhieuMuon && ct.MaVach == _ctpt.MaVach).ToList();
foreach (CT_PHIEUMUON _ctpm in lstCTPM)
{
if (_ctpm.TinhTrangTraCT == true)
{
_ctpm.TinhTrangTraCT = false;
}
}
_pm.TinhTrangTra = false;
qltv.CT_PHIEUTRAs.DeleteOnSubmit(_ctpt);
qltv.SubmitChanges();
}
qltv.PHIEUTRAs.DeleteOnSubmit(pt);
qltv.SubmitChanges();
return(true);
}
catch (Exception ex) {
return(false);
}
}
return(false);
}
public bool xoaCTPT(CT_PHIEUTRA ct)
{
CT_PHIEUTRA _ct = qltv.CT_PHIEUTRAs.Where(c => c.MaChiTietPhieuTra == ct.MaChiTietPhieuTra).FirstOrDefault();
if (_ct != null)
{
PHIEUTRA _pt = qltv.PHIEUTRAs.Where(t => t.MaPhieuTra == _ct.MaPhieuTra).FirstOrDefault();
try
{
_pt.SoLuongSachTra = _pt.SoLuongSachTra - 1;
qltv.CT_PHIEUTRAs.DeleteOnSubmit(_ct);
qltv.SubmitChanges();
PHIEUMUON _pm = qltv.PHIEUMUONs.Where(m => m.MaPhieuMuon == _ct.MaPhieuMuon).FirstOrDefault();
if (_pm != null)
{
CT_PHIEUMUON _ctpm = qltv.CT_PHIEUMUONs.Where(t => t.MaVach == _ct.MaVach && t.MaPhieuMuon == _pm.MaPhieuMuon).FirstOrDefault();
_ctpm.TinhTrangTraCT = false;
_pm.TinhTrangTra = false;
qltv.SubmitChanges();
}
return(true);
}
catch (Exception ex) { return(false); }
}
return(false);
}
public bool luuPhieuTra(int mapm, int manv, DateTime ngaytra, int sltra, bool tiencoc, string tiencocdg, List <CT_PHIEUTRA> lstCTPT)
{
PHIEUTRA pt = new PHIEUTRA();
try
{
//pt.MaPhieuMuon = mapm;
pt.MaNhanVien = manv;
pt.NgayLap = ngaytra;
pt.SoLuongSachTra = sltra;
pt.TinhTrangXoa = false;
qltv.PHIEUTRAs.InsertOnSubmit(pt);
qltv.SubmitChanges();
PHIEUTRA mapt = qltv.PHIEUTRAs.Where(n => n.TinhTrangXoa == false).OrderByDescending(x => x.MaPhieuTra).First();
foreach (CT_PHIEUTRA ctpt in lstCTPT)
{
CT_PHIEUTRA _ctpt = new CT_PHIEUTRA();
_ctpt.MaPhieuTra = mapt.MaPhieuTra;
_ctpt.MaPhieuMuon = ctpt.MaPhieuMuon;
_ctpt.MaVach = ctpt.MaVach;
_ctpt.TinhTrangXoa = false;
CT_PHIEUMUON _ctpm = qltv.CT_PHIEUMUONs.Where(m => m.MaPhieuMuon == ctpt.MaPhieuMuon && m.MaVach == ctpt.MaVach).FirstOrDefault();
if (_ctpm.TinhTrangTraCT == false)
{
_ctpm.TinhTrangTraCT = true;
}
if (updateTinhTrangPM(ctpt.MaPhieuMuon.ToString()))
{
if (tiencoc == true)
{
PHIEUMUON _pm = qltv.PHIEUMUONs.Where(m => m.MaPhieuMuon == ctpt.MaPhieuMuon).FirstOrDefault();
_pm.PhiCoc = 0;
tiencocdg = _pm.PhiCoc.ToString();
}
}
qltv.CT_PHIEUTRAs.InsertOnSubmit(_ctpt);
qltv.SubmitChanges();
}
return(true);
}
catch (Exception ex)
{
return(false);
}
}
private void QLP_T_btnXoa_Click(object sender, EventArgs e)
{
PHIEUTRA pt = new PHIEUTRA();
pt.MaPhieuTra = int.Parse(QLP_T_dgvDSPT.CurrentRow.Cells[0].Value.ToString());
DialogResult rs = MessageBox.Show("Bạn có chắc muốn xóa mã phiếu trả" + pt.MaPhieuTra.ToString(), "Thông báo", MessageBoxButtons.YesNo, MessageBoxIcon.Question);
if (rs == DialogResult.Yes)
{
if (qlpt.xoaPhieuTra(pt))
{
MessageBox.Show("Xóa thành công !");
load_dgvDSPT();
loadCTPTTheoPT(pt.MaPhieuTra);
}
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);
}
