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