public virtual IOrderable[] GetChildren(CohortAggregateContainer parent) { var containers = CatalogueRepository.SelectAllWhere <CohortAggregateContainer>("SELECT CohortAggregateContainer_ChildID FROM CohortAggregateSubContainer WHERE CohortAggregateContainer_ParentID=@CohortAggregateContainer_ParentID", "CohortAggregateContainer_ChildID", new Dictionary <string, object> { { "CohortAggregateContainer_ParentID", parent.ID } }).ToArray(); var configs = CatalogueRepository.SelectAll <AggregateConfiguration>("SELECT AggregateConfiguration_ID FROM CohortAggregateContainer_AggregateConfiguration where CohortAggregateContainer_ID=" + parent.ID).OrderBy(config => config.Order).ToArray(); return(containers.Cast <IOrderable>().Union(configs).OrderBy(o => o.Order).ToArray()); }
public virtual IContainer[] GetSubContainers(IContainer container) { return (_catalogueRepository.SelectAll <AggregateFilterContainer>("SELECT AggregateFilterContainer_ChildID FROM AggregateFilterSubContainer WHERE AggregateFilterContainer_ParentID=" + container.ID, "AggregateFilterContainer_ChildID").ToArray()); }
public IEnumerable <ICatalogue> GetAllGovernedCatalogues(GovernancePeriod governancePeriod) { return(_catalogueRepository.SelectAll <Catalogue>(@"SELECT Catalogue_ID FROM GovernancePeriod_Catalogue where GovernancePeriod_ID=" + governancePeriod.ID, "Catalogue_ID")); }