public static string buat_menu(int id = 1) { using (var db = new PortalBsnEntities()) { var menu = ""; // inisialisasi awal var USER_ACCESS_ID = Convert.ToInt32(System.Web.HttpContext.Current.Session["USER_ACCESS_ID"]); var hasil = db.Database.SqlQuery <SYS_MENU_PORTAL>("SELECT * FROM SYS_MENU_PORTAL WHERE MENU_PARENT_ID = 0 AND MENU_POSITION = 1 AND MENU_STATUS = 1").ToList(); foreach (var res in hasil) { var isaktif = ""; if (id == Convert.ToInt32(res.MENU_ID)) { isaktif = "active"; } var cek = punya_sub(Convert.ToInt32(res.MENU_ID)); if (cek > 0) { menu += "<li class='dropdown " + isaktif + "'>" + "<a class='dropdown-toggle limenu' data-toggle='dropdown' data-target='' href='" + res.MENU_URL + "' >" + res.MENU_NAME + "</a>" + "<ul class='dropdown-menu'>"; menu += buat_anak_menu(Convert.ToInt32(res.MENU_ID)); menu += "</ul></li>"; } else { menu += "<li class='" + isaktif + "'>" + "<a class='limenu' href='" + res.MENU_URL + "' >" + res.MENU_NAME + "</a>" + "</li>"; } } return(menu); } }
public static int punya_sub(int id) { using (var db = new PortalBsnEntities()) { var USER_ACCESS_ID = Convert.ToInt32(System.Web.HttpContext.Current.Session["USER_ACCESS_ID"]); var jml = db.Database.SqlQuery <int>("SELECT COUNT(*) FROM SYS_MENU_PORTAL WHERE MENU_PARENT_ID=" + id).SingleOrDefault(); return(jml); } }
public static string buat_menu_seinduk(int parent = 1) { using (var db = new PortalBsnEntities()) { var anakmenu = ""; string segment = "/" + HttpContext.Current.Request.RequestContext.RouteData.Values["controller"] + "/" + HttpContext.Current.Request.RequestContext.RouteData.Values["action"]; var hasil = db.Database.SqlQuery <SYS_MENU_PORTAL>("SELECT * FROM SYS_MENU_PORTAL WHERE MENU_PARENT_ID = " + parent + " AND MENU_POSITION = 1 AND MENU_STATUS = 1 AND MENU_URL ! = '" + segment + "'").ToList(); foreach (var res in hasil) { anakmenu += "<li class='list-group-item clearfix'><a href='" + res.MENU_URL + "' class='enclose'><i class='fa fa-angle-right'></i>" + res.MENU_NAME + "</a></li>"; } return(anakmenu); } }
public static string buat_anak_menu(int parent = 1) { using (var db = new PortalBsnEntities()) { var anakmenu = ""; var hasil = db.Database.SqlQuery <SYS_MENU_PORTAL>("SELECT * FROM SYS_MENU_PORTAL WHERE MENU_PARENT_ID = " + parent + " AND MENU_POSITION = 1 AND MENU_STATUS = 1").ToList(); foreach (var res in hasil) { anakmenu += "<li><a href='" + res.MENU_URL + "' class='enclose'>" + res.MENU_NAME + "</a></li>"; } return(anakmenu); } }