Compare object with an array with another array

Question

I have a model Group:

public class GroupModel
{
    [Key]
    public int GroupModelId { get; set; }

    [Required]
    [MaxLength(50)]
    [DataType(DataType.Text)]
    public string GroupName { get; set; }

    [Required]
    public virtual ICollection<FocusArea> FocusAreas { get; set; }

    ...

And a model Focus:

public class FocusArea
{
    public int FocusAreaId { get; set; }
    public FocusEnum Focus { get; set; }

    public List<ApplicationUser> ApplicationUser { get; set;  }

    public virtual ICollection<GroupModel> GroupModel { get; set; }


public enum FocusEnum
{
    Psych,
    Medical,
    LivingWith
}

Group and Focus has a many-to-many relationship. My Controller is receiving:

public ActionResult GroupSearch(string[] focusSelected) // Values possible are Pysch, Medical and LivingWith
{
    List<GroupModel> groups;

    ...

Problem: I want to select the groups that have all the focus that are inside the focusSelected array.

What I've tried:

groups = groups.Where(t => t.FocusAreas.Where(x => focusSelected.Contains(x.Focus))).ToList()).ToList();

Obviously not working. Does anyone have another idea?

Hossein Narimani Rad · Accepted Answer · 2015-10-12 17:53:17Z

1

This may help you

 var result = groups.Where(g => g.FocusAreas.All(f => focusSelected
              .Any(fs => (FocusEnum)Enum.Parse(typeof(FocusEnum), fs, true) == f.Focus)));

answered Oct 12, 2015 at 17:53

Hossein Narimani Rad

32.7k19 gold badges92 silver badges121 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

pwas · Accepted Answer · 2015-10-12 17:56:00Z

0

Where needs a delegate / expression that returns bool. In your sample - you are putting Where inside Where, where Where returns collection. Changing inner Where to All should do the trick:

var allSelParsed = focusSelected.Select(s => (FocusEnum)Enum.Parse(typeof(FocusEnum), s)
                                .ToList();
groups = groups.Where(gr => allSelParsed.All(selected => 
                                                gr.FocusAreas.Any(fc => 
                                                                    fc.Focus == selected)))
               .ToList();

edited Oct 12, 2015 at 17:56

answered Oct 12, 2015 at 17:50

pwas

3,39123 silver badges45 bronze badges

Comments

Arghya C · Accepted Answer · 2015-10-12 17:56:06Z

0

This should give you expected result

var result = groups.Where(g => 
                      focusSelected.All(fs => 
                          g.FocusAreas.Any(fa => fa.ToString() == fs)));

answered Oct 12, 2015 at 17:56

Arghya C

10.1k4 gold badges51 silver badges70 bronze badges

Collectives™ on Stack Overflow

Compare object with an array with another array

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related