public static void GetRecursorWithDapper(Models.Project.ProjectModel pm)
{
var dapperRepo = new BlueMine.Data.Dapper.CRUD();
System.Collections.Generic.List <Db.T_projects> projects = dapperRepo.GetProjects();
pm.GenericTree = new BlueMine.Data.GenericRecursor <Db.T_projects, long?>(
projects
, x => x.parent_id
, x => x.id
);
// pm.GenericTree.AddSort(SortTerm<Db.T_projects>.Create(x => x.id));
// pm.GenericTree.AddSort(SortTerm<Db.T_projects>.Create(x => x.id, SortDirection.Descending));
//pm.GenericTree.AddSort(
// SortTerm<Db.T_projects>.Create(x => x.name)
// , SortTerm<Db.T_projects>.Create(x => x.created_on)
// , SortTerm<Db.T_projects>.Create(x => x.id)
// , SortTerm<Db.T_projects>.Create(x => x.parent_id)
//);
// pm.GenericTree.AddSort(x => x.name, SortDirection.Ascending);
// pm.GenericTree.AddSort(x => x.created_on, SortDirection.Ascending);
// pm.GenericTree.AddSort(x => x.id, SortDirection.Ascending);
// pm.GenericTree.AddSort(x => x.parent_id, SortDirection.Ascending);
pm.GenericTree.AddSort(x => x.name);
// @Html.DisplayFor((from prop in Model where prop.parent_id != null select prop), "T_projects")
// @Html.DisplayForModel()
// @Html.EditorForModel()
}
public IActionResult Index()
{
// Non-generic tree
Models.Project.ProjectModelFactory fac = new ProjectModelFactory(this.m_repo);
Models.Project.ProjectModel pm = fac.Create(null);
return(View(pm));
} // End Action Index
public static void GetProjectTreeWithDapper(Models.Project.ProjectModel pm)
{
var dapperRepo = new BlueMine.Data.Dapper.CRUD();
System.Collections.Generic.List <Db.T_projects> projects =
dapperRepo.GetProjects();
pm.ProjectTree = new Models.Project.ProjectRecursor(projects);
}
