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;
}
