public object Getdata() { var Modules = db.TblModuleMasters.OrderBy(r => r.ModuleId).ThenBy(r => r.ParentModuleId).ToList(); List <ResultForMenu> lt = new List <ResultForMenu>(); foreach (var s in Modules) { ResultForMenu ddl = new ResultForMenu(); ddl.id = s.ParentModuleId; ddl.text = s.ModuleName; lt.Add(ddl); } return(lt); }
public object GetMenu() { List <ResultForMenu> lt = new List <ResultForMenu>(); long id = 0; var Modules = db.TblModuleMasters.Where(r => r.ParentModuleId == 0).ToList(); if (Modules.Count != 0) { foreach (var s in Modules) { List <ResultForSubMenu> lt2 = new List <ResultForSubMenu>(); ResultForMenu ddl = new ResultForMenu(); ddl.id = s.ModuleId; ddl.text = s.ModuleName; var menu = db.View_Sub_Menu.Where(r => r.ParentModuleId == s.ModuleId).ToList(); if (menu.Count != 0) { foreach (var Sub in menu) { ddl.state = "{ 'selected': true }"; ResultForSubMenu ddl2 = new ResultForSubMenu(); ddl2.id = Sub.ModuleId; ddl2.text = Sub.ModuleName; lt2.Add(ddl2); List <ResultForSubMenu> lt3 = new List <ResultForSubMenu>(); var Submenu = db.View_Sub_Menu.Where(r => r.ParentModuleId == Sub.ModuleId).ToList(); { if (Submenu.Count != 0) { foreach (var SubSubMenu in Submenu) { ResultForSubMenu ddl3 = new ResultForSubMenu(); ddl2.state = "{ 'selected': true }"; ddl3.id = SubSubMenu.ModuleId; ddl3.text = SubSubMenu.ModuleName; lt3.Add(ddl3); List <ResultForSubMenu> lt4 = new List <ResultForSubMenu>(); var Submenusub = db.View_Sub_Menu.Where(r => r.ParentModuleId == SubSubMenu.ModuleId).ToList(); if (Submenusub.Count != 0) { foreach (var sub2 in Submenusub) { ResultForSubMenu ddl4 = new ResultForSubMenu(); ddl3.state = "{ 'selected': true }"; ddl4.id = sub2.ModuleId; ddl4.text = sub2.ModuleName; lt4.Add(ddl4); } ddl3.children = lt4; } ddl2.children = lt3; } } } ddl.children = lt2; } } lt.Add(ddl); } } return(lt); }