Хочу перечислить оценки команды менеджера ⇐ C#

[Anonymous]

В следующем запросе на основе пользователя я получаю данные пользователя, а затем способен получить информацию о оценке. < /p>
List users = Context.UserInfoes.Where(ui => ui.UserInfoManager.IdUser == idUser && ui.IsCurrent && !ui.IsDeleted).ToList();

foreach(UserInfo info in users)
{
List employeeAppraisals = Context.Appraisals.Where(a => a.UserInfo.UserInfoManager.IdUser == idUser && a.UserInfo.IdUser == info.IdUser).OrderByDescending(a => a.AppraisalInformation.AppraisalDate).ToList();
}
< /code>
Но мне нужно реализовать тот же сценарий на основе имени менеджера ниже, который необходимо изменить.IQueryable usersQuery = Context.Users;

if (!string.IsNullOrEmpty(searchManager))
{
searchManager = searchManager.ToLower();
searchTerms = searchManager.Split(' ').ToList();

usersQuery = usersQuery.Where(u => searchTerms.Any(searchTerm => u.Firstname.ToLower().Contains(searchTerm) || u.Lastname.ToLower().Contains(searchTerm)));
}

IQueryable appraisalsQuery = Context.Appraisals.Join(usersQuery, a => a.UserInfo.IdUser, u => u.Id, (a, u) => a).Where(
a => a.AppraisalInformation.AppraisalYear == filters.Year && a.UserInfo.IsDeleted == deleted
).OrderByDescending(a => a.AppraisalInformation.AppraisalDate);

User class:

public partial class User
{
[System.Diagnostics.CodeAnalysis.SuppressMessage("Microsoft.Usage", "CA2214:DoNotCallOverridableMethodsInConstructors")]
public User()
{
this.UserInfoes = new HashSet();
this.UsersHRs = new HashSet();
this.UsersEmployees = new HashSet();
}

public int Id { get; set; }
public string Login { get; set; }
public string Firstname { get; set; }
public string Lastname { get; set; }
public string Email { get; set; }
public Nullable CompanyStartDate { get; set; }
public Nullable IsAdmin { get; set; }
public Nullable IsDRH { get; set; }
public System.DateTime CreationDate { get; set; }
public Nullable ModificationDate { get; set; }

[System.Diagnostics.CodeAnalysis.SuppressMessage("Microsoft.Usage", "CA2227:CollectionPropertiesShouldBeReadOnly")]
public virtual ICollection UserInfoes { get; set; }

[System.Diagnostics.CodeAnalysis.SuppressMessage("Microsoft.Usage", "CA2227:CollectionPropertiesShouldBeReadOnly")]
public virtual ICollection UsersHRs { get; set; }

[System.Diagnostics.CodeAnalysis.SuppressMessage("Microsoft.Usage", "CA2227:CollectionPropertiesShouldBeReadOnly")]
public virtual ICollection UsersEmployees { get; set; }
}

Appraisal class :
< /code>
Общественная частичная оценка классов
{
nsystem.diagnostics.codeanalysis.suppressmessage("microsoft.usage "," Ca2214: donotcalloverridablemothodsintructors ")]
public int Id { get; set; }
public int IdUserInfo { get; set; }
public System.DateTime CreationDate { get; set; }
public bool EmployeeValidation { get; set; }
public bool ManagerValidation { get; set; }
public System.DateTime ModificationDate { get; set; }
public bool Closed { get; set; }
public Nullable DraftValidationDate { get; set; }
public Nullable DraftValidationNotifDate { get; set; }
public Nullable ManagerValidationDate { get; set; }
public Nullable ManagerValidationNotifDate { get; set; }
public Nullable EmployeeValidationDate { get; set; }
public Nullable EmployeeValidationNotifDate { get; set; }
public Nullable FinaleValidationDate { get; set; }

public virtual UserInfo UserInfo { get; set; }
public virtual AppraisalAnnexeFr AppraisalAnnexeFr { get; set; }
public virtual AppraisalDevelopment AppraisalDevelopment { get; set; }
public virtual AppraisalGoal AppraisalGoal { get; set; }
public virtual AppraisalInformation AppraisalInformation { get; set; }
public virtual AppraisalSecurity AppraisalSecurity { get; set; }
public virtual AppraisalSynthesis AppraisalSynthesi { get; set; }
public virtual AppraisalVeoliaValue AppraisalVeoliaValue { get; set; }

[System.Diagnostics.CodeAnalysis.SuppressMessage("Microsoft.Usage", "CA2227:CollectionPropertiesShouldBeReadOnly")]
public virtual ICollection Files { get; set; }
public virtual ProfessionnalCareerExchange ProfessionnalCareerExchange { get; set; }
public virtual ProfessionnalDevelopment ProfessionnalDevelopment { get; set; }
public virtual ProfessionnalSynthesis ProfessionnalSynthesi { get; set; }
}


Подробнее здесь: https://stackoverflow.com/questions/642 ... ger-s-team