public bool xoaCTXL(CT_XULYVIPHAM ct)
{
CT_XULYVIPHAM _ct = qltv.CT_XULYVIPHAMs.Where(c => c.MaChiTietXuLyViPham == ct.MaChiTietXuLyViPham).FirstOrDefault();
if (_ct != null)
{
try
{
qltv.CT_XULYVIPHAMs.DeleteOnSubmit(_ct);
qltv.SubmitChanges();
return(true);
}
catch (Exception ex) { return(false); }
}
return(false);
}
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);
}
private void QLP_VP_btnXoaCT_Click(object sender, EventArgs e)
{
CT_XULYVIPHAM ct_pxl = new CT_XULYVIPHAM();
ct_pxl.MaChiTietXuLyViPham = int.Parse(QLP_VP_dgvDSCTPhieuXLVP.CurrentRow.Cells[0].Value.ToString());
ct_pxl.MaXuLyViPham = int.Parse(QLP_VP_dgvDSCTPhieuXLVP.CurrentRow.Cells[1].Value.ToString());
DialogResult rs = MessageBox.Show("Bạn có chắc muốn xóa mã phiếu xử lý " + ct_pxl.MaXuLyViPham, "Thông báo", MessageBoxButtons.YesNo, MessageBoxIcon.Question);
if (rs == DialogResult.Yes)
{
if (qlvp.xoaCTXL(ct_pxl))
{
MessageBox.Show("Xóa thành công !");
load_dgvCTXLTheoPXL(int.Parse(ct_pxl.MaXuLyViPham.ToString()));
load_dgvDSPhieuXLVP();
}
else
{
MessageBox.Show("Xóa thất bại !");
}
}
}
private void QLMT_TDG_btnXacNhanTra_Click(object sender, EventArgs e)
{
//luu phieu tra
//cap nha phieu muon ( neu tra du thi tinh trang = true, tinh trang chi tiet = true
List <CT_PHIEUTRA> lstCTPT = new List <CT_PHIEUTRA>();
List <LOAIVIPHAM> lstLoaivp = new List <LOAIVIPHAM>();
List <CT_XULYVIPHAM> lstCTXL = new List <CT_XULYVIPHAM>();
string[] tienbt = QLMT_TDG_lblTongtien.Text.Split(' ');
manv = Frm_Main.username;
int sltra = QLMT_TDG_dgvCT_TLTra.Rows.Count - 1;
DateTime ngaytra = DateTime.Now;
int mapm = int.Parse(QLMT_TDG_dgvDSTLTra.CurrentRow.Cells[1].Value.ToString());
//lvp.MaLoaiViPham = QLMT_T_cboLoaiVP.SelectedIndex;
if (QLMT_TDG_dgvCT_TLTra.Rows.Count - 1 > 0)
{
for (int i = 0; i < QLMT_TDG_dgvCT_TLTra.Rows.Count - 1; i++)
{
CT_PHIEUTRA _ct = new CT_PHIEUTRA();
_ct.MaVach = QLMT_TDG_dgvCT_TLTra.Rows[i].Cells[0].Value.ToString();
_ct.MaPhieuMuon = int.Parse(QLMT_TDG_dgvCT_TLTra.Rows[i].Cells[1].Value.ToString());
lstCTPT.Add(_ct);
}
}
if (QLMT_TDG_dgvCT_Vipham.Rows.Count - 1 > 0)
{
for (int i = 0; i < QLMT_TDG_dgvCT_Vipham.Rows.Count - 1; i++)
{
CT_XULYVIPHAM ctxl = new CT_XULYVIPHAM();
ctxl.MaVach = QLMT_TDG_dgvCT_Vipham.Rows[i].Cells[1].Value.ToString();
ctxl.MaLoaiViPham = int.Parse(QLMT_TDG_dgvCT_Vipham.Rows[i].Cells[4].Value.ToString());
ctxl.TienBoiThuong = float.Parse(QLMT_TDG_dgvCT_Vipham.Rows[i].Cells[3].Value.ToString());
lstCTXL.Add(ctxl);
}
}
// lấy ds loại vi phạm và ds tiền bồi thường
bool phicoc;
if (QLMT_TDG_chkTraTienCoc.Checked)
{
phicoc = true;
}
else
{
phicoc = false;
}
if (QLMT_TDG_dgvCT_TLTra.RowCount - 1 > 0)
{
if (qlt.luuPhieuTra(mapm, int.Parse(manv.ToString()), ngaytra, sltra, phicoc, QLMT_TDG_lblTienCoc.Text, lstCTPT))
{
// luu phieu xu ly neu co
if (QLMT_TDG_dgvCT_Vipham.Rows.Count - 1 > 0)
{
qlt.luuPhieuXLVP(ngaytra, float.Parse(QLMT_TDG_lblTongTienBT.Text), lstCTXL, int.Parse(manv));
mathetv = "";
}
MessageBox.Show("Quá trình trả thành công ! ");
}
}
else
{
MessageBox.Show("Quá trình trả thất bại !");
}
//luu chi tiet phieu nhap
//reset dgv
QLMT_TDG_dgvDSTLTra.DataSource = null;
QLMT_TDG_dgvDSTLTra.Refresh();
QLMT_TDG_dgvCT_Vipham.DataSource = null;
QLMT_TDG_dgvCT_Vipham.Refresh();
QLMT_TDG_dgvCT_TLTra.DataSource = null;
QLMT_TDG_dgvCT_TLTra.Refresh();
QLMT_TDG_txtTimMaDG.Text = "";
QLMT_TDG_txtTimMaDG.Focus();
QLMT_TDG_lblMaThe.Text = "";
QLMT_TDG_lblTienCoc.Text = "";
QLMT_TDG_lblTTThe.Text = "";
QLMT_TDG_lblHoTen.Text = "";
QLMT_TDG_lblEmail.Text = "";
QLMT_TDG_lblSDT.Text = "";
QLMT_TDG_txtMV.Text = "";
QLMT_TDG_txtMV.Enabled = false;
QLMT_TDG_txtTenNV.Text = "";
QLMT_TDG_txtTenNV.Enabled = false;
QLMT_TDG_txtGiaTL.Text = "";
QLMT_TDG_txtGiaTL.Enabled = false;
QLMT_TDG_lblTongtien.Text = "";
QLMT_TDG_lblTongTienBT.Text = "";
QLMT_TDG_btnXacNhanTra.Enabled = false;
QLMT_TDG_btnTinhTien.Enabled = false;
QLMT_TDG_btnXoa.Enabled = false;
QLMT_TDG_btnChon.Enabled = false;
QLMT_TDG_btnHuyChon.Enabled = false;
QLMT_TDG_btnXacNhanVP.Enabled = false;
QLMT_TDG_txtSoNgayVP.ResetText();
////QLMT_TDG_chkTraTienCoc.Checked = false;
}
