using System;
using System.Linq;
 
public class Test
{
    class Employee {
        public string EmployeeID;
        public string EmployeeName;
        public string Division;
        public string DepartmentCode;
        public string DesignationGrpCode;
    }
 
    class context {
    	public static Employee[] EMPLOYEE = new Employee[0];
    }
 
    public static void Main()
    {
        var temp = from e in context.EMPLOYEE
                   where (from f in context.EMPLOYEE
                          where f.EmployeeID == "S-1287"
                          && e.EmployeeID == f.EmployeeID
                          select f).Any()
                   select e;
 
        var result = from t in temp
                     where (from u in temp
                            where u.DesignationGrpCode == (t.Division == "CHR" ? "CorpDMGR" : "MGT")
                            && t.EmployeeID == u.EmployeeID
                            select u).Any()
                     select t;
    }
}
 

dXNpbmcgU3lzdGVtOwp1c2luZyBTeXN0ZW0uTGlucTsKCnB1YmxpYyBjbGFzcyBUZXN0CnsKICAgIGNsYXNzIEVtcGxveWVlIHsKICAgICAgICBwdWJsaWMgc3RyaW5nIEVtcGxveWVlSUQ7CiAgICAgICAgcHVibGljIHN0cmluZyBFbXBsb3llZU5hbWU7CiAgICAgICAgcHVibGljIHN0cmluZyBEaXZpc2lvbjsKICAgICAgICBwdWJsaWMgc3RyaW5nIERlcGFydG1lbnRDb2RlOwogICAgICAgIHB1YmxpYyBzdHJpbmcgRGVzaWduYXRpb25HcnBDb2RlOwogICAgfQogICAgCiAgICBjbGFzcyBjb250ZXh0IHsKICAgIAlwdWJsaWMgc3RhdGljIEVtcGxveWVlW10gRU1QTE9ZRUUgPSBuZXcgRW1wbG95ZWVbMF07CiAgICB9CgogICAgcHVibGljIHN0YXRpYyB2b2lkIE1haW4oKQogICAgewogICAgICAgIHZhciB0ZW1wID0gZnJvbSBlIGluIGNvbnRleHQuRU1QTE9ZRUUKICAgICAgICAgICAgICAgICAgIHdoZXJlIChmcm9tIGYgaW4gY29udGV4dC5FTVBMT1lFRQogICAgICAgICAgICAgICAgICAgICAgICAgIHdoZXJlIGYuRW1wbG95ZWVJRCA9PSAiUy0xMjg3IgogICAgICAgICAgICAgICAgICAgICAgICAgICYmIGUuRW1wbG95ZWVJRCA9PSBmLkVtcGxveWVlSUQKICAgICAgICAgICAgICAgICAgICAgICAgICBzZWxlY3QgZikuQW55KCkKICAgICAgICAgICAgICAgICAgIHNlbGVjdCBlOwogICAgICAgIAogICAgICAgIHZhciByZXN1bHQgPSBmcm9tIHQgaW4gdGVtcAogICAgICAgICAgICAgICAgICAgICB3aGVyZSAoZnJvbSB1IGluIHRlbXAKICAgICAgICAgICAgICAgICAgICAgICAgICAgIHdoZXJlIHUuRGVzaWduYXRpb25HcnBDb2RlID09ICh0LkRpdmlzaW9uID09ICJDSFIiID8gIkNvcnBETUdSIiA6ICJNR1QiKQogICAgICAgICAgICAgICAgICAgICAgICAgICAgJiYgdC5FbXBsb3llZUlEID09IHUuRW1wbG95ZWVJRAogICAgICAgICAgICAgICAgICAgICAgICAgICAgc2VsZWN0IHUpLkFueSgpCiAgICAgICAgICAgICAgICAgICAgIHNlbGVjdCB0OwogICAgfQp9Cg==