static void Main(string[] args)
{
using (var context = new LohasContext())
{
context.Systems_SiteMap.Add(new Systems_SiteMap
{
ID = Guid.NewGuid(),
Title = "Forms",
Description = "Forms",
ParentID = Guid.Empty
});
context.Systems_SiteMap.Add(new Systems_SiteMap
{
ID = Guid.NewGuid(),
Title = "Charts",
Description = "Charts",
ParentID = Guid.Empty
});
context.Systems_SiteMap.Add(new Systems_SiteMap
{
ID = Guid.NewGuid(),
Title = "Tables",
Description = "Tables",
ParentID = Guid.Empty
});
context.Systems_SiteMap.Add(new Systems_SiteMap
{
ID = Guid.NewGuid(),
Title = "Bootstrap Elements",
Description = "Bootstrap Elements",
ParentID = Guid.Empty
});
context.Systems_SiteMap.Add(new Systems_SiteMap
{
ID = Guid.NewGuid(),
Title = "Bootstrap Grid",
Description = "Bootstrap Grid",
ParentID = Guid.Empty
});
context.Systems_SiteMap.Add(new Systems_SiteMap
{
ID = Guid.NewGuid(),
Title = "Dropdown",
Description = "Dropdown",
ParentID = Guid.Empty
});
context.SaveChanges();
}
Console.ReadLine();
}
public override SiteMapNodeCollection GetChildNodes(SiteMapNode node)
{
lock (this)
{
using (var context = new LohasContext())
{
var maps = context.Systems_SiteMap.Where(p=>p.ParentID.ToString()==node.Key).OrderBy(p => p.ID).ToList();
foreach (var item in maps)
{
AddNode(CreateSiteMapFromRow(item), node);
}
}
// return _root;
}
return base.GetChildNodes(node);
}
public override SiteMapNode BuildSiteMap()
{
lock (this)
{
if (_root != null)
return _root;
using (var context=new LohasContext())
{
var maps = context.Systems_SiteMap.OrderBy(p => p.ID).ToList();
foreach (var item in maps)
{
if (item.Equals(maps.First()))
{
if(item.ParentID==Guid.Empty)
_root = CreateSiteMapFromRow(item);
AddNode(_root, null);
}
else
{
SiteMapNode node = CreateSiteMapFromRow(item);
AddNode(node, GetParentNodeFromNode(item));
}
}
}
return _root;
}
}
