public static List <NhanVienDTO> TimNhanVienTheoMaNV(string manv) { SqlDataReader reader = DataProvider.TimNhanVienTheoMaNV("TimNhanVienTheoMaNV", manv); List <NhanVienDTO> lnv = new List <NhanVienDTO>(); try { 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); } } catch { if (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(); return(lnv); }