public static List <NhanVienDTO> TimNhanVienTheoChucVu(string chucvu) { SqlDataReader reader = DataProvider.TimNhanVienTheoChucVu("TimNhanVienTheoChucVu", chucvu); List <NhanVienDTO> lnv = new List <NhanVienDTO>(); try { if (reader != null) { while (reader.Read()) { NhanVienDTO nv = new NhanVienDTO(); nv.MaNV = reader.GetString(0); nv.HoTen = reader.GetString(1); nv.NgaySinh = reader.GetDateTime(2); nv.NgayVaoLam = reader.GetDateTime(3); nv.SDT = reader.GetString(4); nv.DiaChi = reader.GetString(5); nv.ChucVu = reader.GetString(6); nv.CMND = reader.GetString(7); nv.Anh = (byte[])reader.GetValue(8); lnv.Add(nv); } reader.Close(); } } catch { } return(lnv); }