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