Check in different recursive lists for duplicate entries

Question

I have a relation many to many between project and teams. Also Team and Employees have many to many relation. So according to my scenario only Teams can be assigned to projects and not directly Employees. I am trying to fetch one Employee's Projects. So I am doing this by first fetching teams of employees and then projects of those individual teams. I am doing this in this way:

var employee = _employeeService.GetById((int)id);
employeeProfileViewModel = Mapper.Map<Employee, EmployeeProfileViewModel>(employee);
employeeProfileViewModel.Projects= employee.Teams.Select(t => t.Projects.ToList());
var x = employee.Teams.ToList();
var projects= x.Select(item => item.Projects).ToList();
employeeProfileViewModel.Projects = projects;

So I am getting a list which has further list projects. I am populating this in my view in this way.

foreach (var item in Model.Projects)
{
    foreach (var project in item)
    {
        <div class="list-item">

            <div class="projectId" value="@project.Id" hidden>@ViewBag.EmployeeId</div>
            <div class="list-text-name">
                <h4 class="list-text">Project Name: @project.Name</h4>
            </div>
            <div class="container">
                <div class="list-text-name col-md-4 left">
                    Teams Assigned: @project.Teams.Count;
                    @foreach (var team in project.Teams)
                    {
                        <p>@team.Name</p>
                    }
                </div>
                <div class="col-md-5 left">
                    <div>
                        Start Date: @project.StartDate
                    </div>
                    <div>
                        End Date: @project.EndDate

                    </div>
                </div>
            </div>
            <div class="list-controls">
                <a class="widget-icon widget-icon-circle ViewProject"><span class="icon-upload-alt" title="submit task"></span></a>
                <a href="#" class="widget-icon widget-icon-circle"><span class="icon-pushpin"></span></a>
                <a href="#" class="widget-icon widget-icon-circle"><span class="icon-remove"></span></a>
            </div>
        </div>
    }
}

The problem which i am facing is that if one project is assigned to multiple teams and the same employee is part of those more then one team. The same project prints out more than one time. I am stuck at this place that how i remove duplicate entries of projects but i need to show all the teams assigned to that project. Is there any better way of accomplishing the same scenario or please suggest me some tweaks in my code to accomplish this. Thanks.

Jeroen van Langen · Accepted Answer · 2017-08-01T09:25:32.897

2

You're looking for the SelectMany()

employeeProfileViewModel.Projects = employee.Teams
    .SelectMany(team => team.Projects)
    .Distinct();

The problem with something like var projects= x.Select(item => item.Projects).Distinct() is that it tries to distinct a "list of list of projects" instead a "list of projects". The SelectMany flattens the list of list to a single list, which can be distincted..

edited Aug 01 '17 at 09:25

answered Aug 01 '17 at 07:50

Jeroen van Langen

21,446
3
42
57

Thanks Man. I am really stupid. I didn't thought about such a simple thing. but thanks again. – Muhammad Aug 01 '17 at 08:04

score 0 · Answer 2 · answered Aug 01 '17 at 06:59

0

Yep. With LINQ, it's as easy as

employeeProfileViewModel.Projects = projects.Distinct();

answered Aug 01 '17 at 06:59

John Wu

50,556
8
44
80

Check in different recursive lists for duplicate entries

2 Answers2