protected void FillReportsTree() { var currentLanguage = LanguageUtil.GetLanguage(); var allEntitiesLp = (from n in DataContext.LP_Categories where n.DateDeleted == null && (n.Language == currentLanguage || n.Language == null || n.Language == "") select n).ToLookup(n => n.ParentID); var entitiesList = CategoryUtil.GetAllCategories(null, allEntitiesLp).ToList(); CategoryUtil.Sort(entitiesList); var categories = (from n in entitiesList where n.DateDeleted == null orderby n.OrderIndex, n.Number, n.DateCreated select new ParentChildEntity { ID = n.ID, ParentID = n.ParentID, Type = "Category", Name = n.Name }).ToList(); var reports = (from n in DataContext.LP_Reports where n.DateDeleted == null && (n.Language == currentLanguage || n.Language == null || n.Language == "") select new ParentChildEntity { ID = n.ID, ParentID = n.CategoryID, Type = "Report", Name = n.Name }).ToList(); var itemsSet = new HashSet <ParentChildEntity>(); itemsSet.UnionWith(categories); itemsSet.UnionWith(reports); var itemsLp = itemsSet.ToLookup(n => n.ParentID); var parents = itemsSet.Where(n => n.ParentID == null); foreach (var entity in parents) { var node = new TreeNode { Text = GetEntityText(entity), Value = Convert.ToString(entity.ID), ShowCheckBox = (entity.Type == "Report") }; FillNode(node, entity.ID, itemsLp); tvReports.Nodes.Add(node); } tvReports.CollapseAll(); }
protected void FillDataGrid() { var converter = new CategoryEntityModelConverter(DataContext); var allEntitiesLp = DataContext.LP_Categories.Where(n => n.DateDeleted == null).ToLookup(n => n.ParentID); var entitiesList = CategoryUtil.GetAllCategories(null, allEntitiesLp).ToList(); CategoryUtil.Sort(entitiesList); var models = entitiesList.Select(n => converter.Convert(n)).ToList(); var categoriesModel = new CategoriesModel { List = models }; categoriesControl.Model = categoriesModel; }
protected void FillCategories() { var currentLanguage = LanguageUtil.GetLanguage(); var converter = new CategoryEntityModelConverter(DataContext); var allEntitiesLp = (from n in DataContext.LP_Categories where n.DateDeleted == null && (n.Language == currentLanguage || n.Language == null || n.Language == "") select n).ToLookup(n => n.ParentID); var entitiesList = CategoryUtil.GetAllCategories(null, allEntitiesLp).ToList(); CategoryUtil.Sort(entitiesList); var models = entitiesList.Select(n => converter.Convert(n)).ToList(); var categoriesModel = new CategoriesModel { List = models }; categoriesControl.Model = categoriesModel; }