public ActionResult Home()
{
//
List <int> RoleId = (List <int>)Session["RoleID"];
int roleid = RoleId[0];
if (roleid == 1)
{
var Query = (from t in db.Menus where t.IsAccountMenu.Value == false && t.RoleID == null orderby t.MenuOrder select t).ToList();
Session["Menu"] = Query;
ViewBag.UserName = SourceMastersModel.GetUserFullName(Convert.ToInt32(Session["UserId"].ToString()), Session["UserType"].ToString());
return(View());
}
else
{
//List<Menu> Query2 = new List<Menu>();
var Query = (from t in db.Menus join t1 in db.MenuAccessLevels on t.MenuID equals t1.MenuID where t1.RoleID == roleid && t.IsAccountMenu.Value == false orderby t.MenuOrder select t).ToList();
var Query1 = (from t in db.Menus join t1 in db.MenuAccessLevels on t.MenuID equals t1.ParentID where t1.RoleID == roleid && t.ParentID == 0 && t.IsAccountMenu.Value == false orderby t.MenuOrder select t).ToList();
var Query2 = (from t in db.Menus join t1 in db.MenuAccessLevels on t.MenuID equals t1.ParentID where t1.RoleID == roleid && t.IsAccountMenu.Value == false orderby t.MenuOrder select t).ToList();
if (Query2 != null)
{
foreach (Menu q in Query1)
{
var query3 = Query.Where(cc => cc.MenuID == q.MenuID).FirstOrDefault();
if (query3 == null)
{
Query2.Add(q);
}
}
}
if (Query1 != null)
{
foreach (Menu q in Query1)
{
var query3 = Query.Where(cc => cc.MenuID == q.MenuID).FirstOrDefault();
if (query3 == null)
{
Query.Add(q);
}
}
}
Session["Menu"] = Query;
ViewBag.UserName = SourceMastersModel.GetUserFullName(Convert.ToInt32(Session["UserId"].ToString()), Session["UserType"].ToString());
return(View());
}
}
public ActionResult Home()
{
//var Query = (from t in db.Menus where t.IsAccountMenu.Value == false orderby t.MenuOrder select t).ToList();
var Query = (from t in db.Menus join t1 in db.MenuAccessLevels on t.MenuID equals t1.MenuID where t1.RoleID == 14 && t.IsAccountMenu.Value == false orderby t.MenuOrder select t).ToList();
var Query1 = (from t in db.Menus join t1 in db.MenuAccessLevels on t.MenuID equals t1.ParentID where t1.RoleID == 14 && t.IsAccountMenu.Value == false orderby t.MenuOrder select t).ToList();
foreach (Menu q in Query)
{
Query1.Add(q);
}
Session["Menu"] = Query1;
ViewBag.UserName = SourceMastersModel.GetUserFullName(Convert.ToInt32(Session["UserId"].ToString()), Session["UserType"].ToString());
return(View());
}
public ActionResult Home()
{
var Query = (from t in db.Menus join t1 in db.MenuAccessLevels on t.MenuID equals t1.MenuID where t1.RoleID == 13 && t.IsAccountMenu.Value == false orderby t.MenuOrder select t).ToList();
var Query1 = (from t in db.Menus join t1 in db.MenuAccessLevels on t.MenuID equals t1.ParentID where t1.RoleID == 13 && t.IsAccountMenu.Value == false orderby t.MenuOrder select t).ToList();
foreach (Menu q in Query)
{
Query1.Add(q);
}
//List<MenuVM> Query = (
// from a in db.Menus
// from b in db.MenuAccessLevels
// .Where(bb => bb.MenuID == a.MenuID)
// from c in db.MenuAccessLevels
// .Where(cc => cc.ParentID == a.MenuID)
// where b.RoleID == 13 && c.RoleID == 13
// select new MenuVM { MenuID = a.MenuID, Title = a.Title, Link = a.Link, ParentID = a.ParentID, Ordering = a.Ordering, SubLevel = a.SubLevel, RoleID = a.RoleID , CreatedBy =a.CreatedBy, CreatedOn =a.CreatedOn, ModifiedBy =a.ModifiedBy, ModifiedOn=a.ModifiedOn,
// IsActive=a.IsActive,
// imgclass =a.imgclass,
// PermissionRequired=a.PermissionRequired,
// MenuOrder=a.MenuOrder,
// IsAccountMenu=a.IsAccountMenu
// }).ToList();
//select new
//{
// ss=t.
// First_Name = d.First_Name
//}
ViewBag.UserName = SourceMastersModel.GetUserFullName(Convert.ToInt32(Session["UserId"].ToString()), Session["UserType"].ToString());
Session["Menu"] = Query1;
return(View());
}
