public class FileFoldersDisplayClass
{
    public int folderID { get; set; }

    public string folderName { get; set; }

    public int? parentFolderID { get; set; }

    public int? contractorID { get; set; }

    public int? teamID { get; set; }

    public int? contractID { get; set; }

    public int? clientID { get; set; }

    public bool bureau { get; set; }

    public bool teamManager { get; set; }

    public bool staff { get; set; }

    public bool? secure { get; set; }

    public List<FileFoldersDisplayClass> childFolders { get; set; }
}

List<FileFoldersDisplayClass> ITeamsRepository.GetTopLevelFolders(int? teamID, int? clientID, int? contractorID, int staffID, bool secure)
    {
        CMS3Context _db = new CMS3Context();
        try
        {
            var childFolders = new List<FileFoldersDisplayClass>();
            var folders = from f in _db.FileFolders
                          where (((f.teamID == teamID && f.teamID != null) || (f.contractorID == contractorID && f.contractID != null) || (f.clientID == clientID && f.clientID != null)) && (f.secure ?? false == secure)) && f.parentFolderID == null
                          select new FileFoldersDisplayClass()
                          {
                              folderID = f.folderID,
                              folderName = f.folderName,
                              parentFolderID = f.parentFolderID,
                              contractorID = f.contractorID,
                              teamID = f.teamID,
                              contractID = f.contractID,
                              bureau = f.bureau,
                              teamManager = f.teamManager,
                              staff = f.staff,
                              secure = f.secure,
                              childFolders = (from cF in _db.FileFolders
                                             where cF.parentFolderID == f.folderID
                                             select new FileFoldersDisplayClass()
                                             {
                                                 folderID = f.folderID,
                                                 folderName = f.folderName,
                                                 parentFolderID = f.parentFolderID,
                                                 contractorID = f.contractorID,
                                                 teamID = f.teamID,
                                                 contractID = f.contractID,
                                                 bureau = f.bureau,
                                                 teamManager = f.teamManager,
                                                 staff = f.staff,
                                                 secure = f.secure,
                                                 childFolders = childFolders
                                             }).ToList()
                          };





            return folders.ToList();
        }
        catch(Exception e)
        {
            var d = e;
            return new List<FileFoldersDisplayClass>();
        }

    }