public bool timKiemHS(GunaTextBox mnv, GunaTextBox ten, GunaDateTimePicker ns, GunaTextBox gt, GunaTextBox sdt, GunaTextBox eml, GunaDateTimePicker ntd, GunaTextBox mpb, /*GunaTextBox tk, GunaTextBox mk, GunaTextBox q,*/ DataGridView tdcm, DataGridView tdnn, DataGridView qtct)
{
HoSoNV_DTO nv = qlhs.timKiem(mnv.Text);
try
{
ten.Text = nv.HoTen;
ns.Value = nv.NgaySinh;
gt.Text = nv.GioiTinh;
sdt.Text = nv.SDT;
eml.Text = nv.Email;
ntd.Value = nv.NgayTD;
mpb.Text = nv.MaPB;
//tk.Text = nv.TaiKhoan;
//mk.Text = nv.MatKhau;
//q.Text = nv.Quyen;
qlhs.hienThiTDCM(tdcm, mnv.Text);
qlhs.hienThiTDNN(tdnn, mnv.Text);
qlhs.hienThiQTCT(qtct, mnv.Text);
}
catch (Exception)
{
}
if (nv.HoTen != null)
{
return(true);
}
else
{
return(false);
}
}
public void timKiemTrinhDoChuyenMon_DAO(HoSoNV_DTO nhanvien)
{
var layTT = from td in db.HOSO6s
where td.MANV == nhanvien.MaNV
select new { td.HOTEN };
foreach (var item in layTT)
{
nhanvien.HoTen = item.HOTEN;
}
}
public HoSoNV_DTO layThongTinHoSo_DAO(string txtMaNV)
{
HoSoNV_DTO nhanVien = new HoSoNV_DTO();
txtMaNV = txtMaNV.ToUpper();
var query = from q in db.HOSO6s
where q.MANV == txtMaNV
select new { q.MANV, q.HOTEN };
foreach (var item in query)
{
nhanVien.MaNV = item.MANV;
nhanVien.HoTen = item.HOTEN;
}
return(nhanVien);
}
public bool timKiemTrinhDoChuyenMon_BUS(GunaTextBox maNV, GunaLabel txtTenNV, GunaDataGridView gr)
{
HoSoNV_DTO nv = new HoSoNV_DTO
{
MaNV = maNV.Text
};
TrinhDoChuyenMon_DAO.createInstance.timKiemTrinhDoChuyenMon_DAO(nv);
txtTenNV.Text = nv.HoTen;
if (nv.HoTen == null)
{
return(false);
}
TrinhDoChuyenMon_DAO.createInstance.hienThi(gr, nv.MaNV);
return(true);
}
public bool layThongTinHoSo_BUS(GunaTextBox txtMaNV, GunaLabel lb1, GunaLabel lb2)
{
HoSoNV_DTO nhanvien = new HoSoNV_DTO();
nhanvien = QuanLyQuaTrinhCongTac_DAO.Instance.layThongTinHoSo_DAO(txtMaNV.Text);
if (nhanvien.MaNV != null)
{
lb1.Text = nhanvien.MaNV;
lb2.Text = nhanvien.HoTen;
return(true);
}
else
{
return(false);
}
}
public HoSoNV_DTO timKiem(string maNV)
{
HoSoNV_DTO nv = new HoSoNV_DTO();
IQueryable <HOSO6> query = from q in db.HOSO6s where q.MANV == maNV select q;
foreach (HOSO6 item in query)
{
nv.MaNV = maNV;
nv.HoTen = item.HOTEN;
nv.NgaySinh = Convert.ToDateTime(item.NGAYSINH);
nv.GioiTinh = item.GIOITINH;
nv.SDT = item.SODT;
nv.Email = item.EMAIL;
nv.NgayTD = Convert.ToDateTime(item.NGAYTD);
nv.MaPB = item.MAPB;
nv.TaiKhoan = item.TAIKHOAN;
nv.MatKhau = item.MATKHAU;
nv.Quyen = item.QUYEN;
}
return(nv);
}
