private IList <NameItem> GetEmployeeList(int?exceptId) { IList <EmployeeModel> employees; using (HumanResourceEntities db = new HumanResourceEntities()) { employees = (from b in db.Employees where (exceptId == null || exceptId != b.Id) && b.EndDate == null // проверяем, что сотрудник не уволился select new EmployeeModel { Id = b.Id, Surname = b.Surname, Name = b.Name, Patronymic = b.Patronymic }).OrderBy(e => e.Surname).ThenBy(e => e.Name).ToList(); } IList <NameItem> list = new List <NameItem>(); list.Insert(0, new NameItem() { Id = null, Name = string.Empty }); foreach (var m in employees) { list.Add(new NameItem() { Id = m.Id, Name = EmployeeModel.GetDisplayName(m.Surname, m.Name, m.Patronymic) }); } return(list); }