//public ActionResult Index() //{ // List<MenuRoleVM> m = new List<MenuRoleVM>(); // var query = (from t in db.MenuAccessLevels join t1 in db.RoleMasters on t.RoleID equals t1.RoleID join t2 in db.Menus on t.MenuID equals t2.MenuID select new MenuRoleVM { Name = t1.RoleName, Title = t2.Title, MenuAccessID = t.MenuAccessID }).ToList(); //} public ActionResult Create(int id = 0) { var Query = (from t in db.Menus where t.IsAccountMenu.Value == false orderby t.MenuOrder select t).ToList(); var query = (from t in db.RoleMasters where t.RoleID == 1 select t.RoleID).ToList(); Session["AllRoleID"] = query; Session["MenuAll"] = Query; ViewBag.Menu = db.Menus.ToList(); ViewBag.Roles = db.RoleMasters.Where(cc => cc.RoleName != "Admin").ToList(); MenuRoleVM vm = new MenuRoleVM(); vm.RoleId = id; return(View(vm)); }
public ActionResult Create(MenuRoleVM v) { MenuAccessLevel a = new MenuAccessLevel(); if (ModelState.IsValid) { a.MenuID = v.MenuID; a.RoleID = v.RoleId; db.MenuAccessLevels.Add(a); db.SaveChanges(); TempData["SuccessMsg"] = "You have successfully added Menu Role Assigment."; return(RedirectToAction("Index")); } return(View()); }
public ActionResult Edit(MenuRoleVM v) { MenuAccessLevel a = new MenuAccessLevel(); if (ModelState.IsValid) { a.MenuAccessID = v.MenuAccessID; a.MenuID = v.MenuID; a.RoleID = v.RoleId; db.Entry(a).State = EntityState.Modified; db.SaveChanges(); TempData["SuccessMsg"] = "You have successfully Updated Menu Role Assigment."; return(RedirectToAction("Index")); } return(View()); }
public ActionResult Edit(int id = 0) { MenuRoleVM objViewmodel = (from t in entity.MenuAccessLevels where t.MenuAccessID == id select new MenuRoleVM { RoleId = t.RoleID, MenuID = t.MenuID, MenuAccessID = t.MenuAccessID // MenuAccessID = Convert.ToInt32(t1.Id), }).FirstOrDefault(); MenuAccessLevel obj = entity.MenuAccessLevels.Find(id); ViewBag.Menu = new SelectList(entity.Menus.Where(d => d.IsAccountMenu == false).ToList(), "MenuID", "Title"); ViewBag.Role = new SelectList(entity.RoleMasters, "RoleID", "RoleName"); return(View(objViewmodel)); }
public ActionResult Edit(int id) { ViewBag.Menu = db.Menus.ToList(); ViewBag.Roles = db.RoleMasters.ToList(); MenuAccessLevel a = db.MenuAccessLevels.Find(id); MenuRoleVM v = new MenuRoleVM(); if (a == null) { return(HttpNotFound()); } else { v.MenuAccessID = a.MenuAccessID; v.MenuID = a.MenuID; v.RoleId = a.RoleID; } return(View(v)); }
public ActionResult Index(MenuRoleVM model) { MenuAccessLevel obj = new MenuAccessLevel(); obj.RoleID = model.RoleId; obj.MenuID = model.MenuID; obj.CreatedOn = DateTime.Now; obj.CreatedBy = Convert.ToString(Session["UserName"]); obj.ParentID = model.ParentID; obj.IsActive = 1; obj.ModifiedBy = Convert.ToString(Session["UserName"]); obj.ModifiedOn = DateTime.Now; obj.IsView = true; obj.IsAdd = true; obj.IsDelete = true; obj.IsModify = true; obj.Isprint = true; entity.MenuAccessLevels.Add(obj); entity.SaveChanges(); var ChildMenus = entity.Menus.Where(d => d.ParentID == model.MenuID && d.IsAccountMenu == false).ToList(); foreach (var item in ChildMenus) { var data = entity.MenuAccessLevels.Where(d => d.MenuID == item.MenuID && d.RoleID == model.RoleId).FirstOrDefault(); if (data == null) { data = new MenuAccessLevel(); data.MenuID = item.MenuID; data.ParentID = item.ParentID; data.RoleID = model.RoleId; data.CreatedOn = DateTime.Now; data.CreatedBy = Convert.ToString(Session["UserName"]); data.IsActive = 1; data.ModifiedBy = Convert.ToString(Session["UserName"]); data.ModifiedOn = DateTime.Now; data.IsView = true; data.IsAdd = true; data.IsDelete = true; data.IsModify = true; data.Isprint = true; entity.MenuAccessLevels.Add(data); entity.SaveChanges(); var secondchilds = entity.Menus.Where(d => d.ParentID == item.MenuID && d.IsAccountMenu == false).ToList(); foreach (var childs in secondchilds) { var data1 = entity.MenuAccessLevels.Where(d => d.MenuID == childs.MenuID && d.RoleID == model.RoleId).FirstOrDefault(); if (data1 == null) { data1 = new MenuAccessLevel(); data1.MenuID = childs.MenuID; data1.ParentID = childs.ParentID; data1.RoleID = model.RoleId; data1.CreatedOn = DateTime.Now; data1.CreatedBy = Convert.ToString(Session["UserName"]); data1.IsActive = 1; data1.ModifiedBy = Convert.ToString(Session["UserName"]); data1.ModifiedOn = DateTime.Now; data1.IsView = true; data1.IsAdd = true; data1.IsDelete = true; data1.IsModify = true; data1.Isprint = true; entity.MenuAccessLevels.Add(data1); entity.SaveChanges(); } } } } ViewBag.SuccessMsg = "You have successfully added Menu Role List."; return(RedirectToAction("List")); }