public DataTable GetNV(QuanLyNhanVienEntities add)
{
DataTable dt = null;
dt = addDAO.GetNV(add);
return(dt);
}
public DataTable GetThemNVBUS(QuanLyNhanVienEntities add)
{
DataTable dt = null;
dt = addDAO.GetThemNVDAO(add);
return(dt);
}
public DataTable GetTKNV(QuanLyNhanVienEntities tim)
{
DataTable dt = null;
dt = timDAO.GetTKNV(tim);
return(dt);
}
public DataTable GetThemNVDAO(QuanLyNhanVienEntities add)
{
string sql = "insert into QuanLyNhanVien /*('ten','ngaysinh','gioitinh','thuongtru','tamtru','cmnd','ngaycap','noicap','email','bophan','ngayvao','sdt')*/ values ('" + add.MaNV + "','" + add.Ten + "','" + add.NgaySinh + "','" + add.GioiTinh + "','" + add.ThuongTru + "','" + add.TamTru + "','" + add.Cmnd + "','" + add.NgayCap + "','" + add.NoiCap + "','" + add.Email + "','" + add.BoPhan + "','" + add.NgayVao + "','" + add.SDT + "')";
return(getDataTable(sql));
}
public DataTable GetTKNV(QuanLyNhanVienEntities manv)
{
string sql = "select * from QuanLyNhanVien where MaNV='" + manv.MaNV + "'";
return(getDataTable(sql));
}