using System;

using System.Collections.Generic;

using System.Linq;  

​

public class Program

{

    public static void Main()

    {

        string env = "Test";                                            //Testparams

        List<string> tagsIncl = new List<string> { "TestServer", "TBAPPL10", "Tbappl08" };      //Testparams

        List<string> tagsExcl = new List<string> { "APPOLB" };          //Testparams

        List<Agent> agents = new List<Agent>()

        {

            new Agent { Name = "TBAPPL10", Environment = "Test", Tags=new List<string>()

                {

                    "BusinessCritical","TestServer","Tbappl10","APPEOS"

                }

            },

            new Agent { Name = "TBAPPL08", Environment = "Test", Tags=new List<string>()

                {

                    "BusinessCritical","TestServer","Tbappl08","APPOLB"

                }

            },

            new Agent { Name = "ABAPPL10", Environment = "Accept", Tags=new List<string>()

                {

                    "BusinessCritical","AcceptServer","Tbappl10","APPEOS"

                }

            },

            new Agent { Name = "ABAPPL08", Environment = "Accept", Tags=new List<string>()

                {

                    "BusinessCritical","AcceptServer","Abappl08","APPOLB"

                }

            }

        };

​

        //We select all agents that have IncludeTags but not ExcludeTags:

        HashSet<string> agentsList = new HashSet<string>(); //HashSet instead of List so we only have unique values

        foreach (Agent agent in agents)

        {

            if (!agent.Environment.Equals(env)) continue;

            foreach (string ti in tagsIncl)

                if(agent.Tags.Contains(ti, StringComparer.OrdinalIgnoreCase)) agentsList.Add(agent.Name);

            foreach (string te in tagsExcl)

                if (agent.Tags.Contains(te, StringComparer.OrdinalIgnoreCase)) agentsList.Remove(agent.Name);

        }

        //We consume the agent:

        foreach (string agent in agentsList){

            Console.WriteLine("Selected agent: "+agent);

            //Expected output: 

            //Selected agent: TBAPPL10

        }

    }

}

​

//Dummy agent table

public class Agent

{

    public string Name { set; get; }

    public string Environment { set; get; }

    public List<string> Tags { set; get; }

​

}