public JsonResult SaveAccess(string IdRole, string Ids_selected) { List <AccessModels> list_am = db.Access.Where(x => x.RoleId == IdRole).ToList(); if (list_am.Count > 0) { foreach (var am in list_am) { db.Access.Remove(am); } } db.SaveChanges(); if (!string.IsNullOrEmpty(Ids_selected)) { string[] ids = Ids_selected.Split(','); if (ids.Length > 0) { foreach (string id in ids) { AccessModels am = new AccessModels { Id = Guid.NewGuid(), RoleId = IdRole, WebMenuAccess = id.ToLower() }; db.Access.Add(am); } } db.SaveChanges(); } return(Json(new { status = "200" }, JsonRequestBehavior.AllowGet)); }
public List <AccessModels> GetAccessAll() { HomeController hc = new HomeController(); List <AccessModels> ul = new List <AccessModels>(); using (SqlConnection con = hc.ConnectDatabaseAuth()) { string _SQL = "select * from [access]"; using (SqlCommand cmd = new SqlCommand(_SQL, con)) { DataTable _Dt = new DataTable(); SqlDataAdapter da = new SqlDataAdapter(cmd); da.Fill(_Dt); da.Dispose(); foreach (DataRow _Item in _Dt.Rows) { AccessModels m = new AccessModels(); m.access_id = _Item["access_id"].ToString(); m.access_name = _Item["access_name"].ToString(); ul.Add(m); } } con.Close(); } return(ul); }
public JsonResult DisableMenu(string WebMenuAccess, Guid IdRole) { var data = (from a in db.Access where a.WebMenuAccess == WebMenuAccess && a.UserAccountRoles_Id == IdRole select a).Single(); AccessModels am = data; db.Access.Remove(am); db.SaveChanges(); return(Json(new { status = "200" }, JsonRequestBehavior.AllowGet)); }
public JsonResult EnableMenu(string WebMenuAccess, Guid IdRole) { AccessModels am = new AccessModels(); am.Id = Guid.NewGuid(); am.UserAccountRoles_Id = IdRole; am.UserAccountAccess_EnumId = 0; am.WebMenuAccess = WebMenuAccess; db.Access.Add(am); db.SaveChanges(); return(Json(new { status = "200" }, JsonRequestBehavior.AllowGet)); }
public JsonResult SingleAccess(string WebMenuAccess, string IdRole, string Action) { if (Action.ToLower() == "enable") { AccessModels am = new AccessModels { Id = Guid.NewGuid(), RoleId = IdRole, WebMenuAccess = WebMenuAccess.ToLower() }; db.Access.Add(am); } else { AccessModels am = db.Access.Where(x => x.RoleId == IdRole && x.WebMenuAccess == WebMenuAccess).FirstOrDefault(); db.Access.Remove(am); } db.SaveChanges(); return(Json(new { status = "200" }, JsonRequestBehavior.AllowGet)); }
public JsonResult BulkAccess(string IdRole, string ParentMenu, string Action) { var menus = (ParentMenu.ToLower() == "all") ? db.MasterMenu.ToList() : db.MasterMenu.Where(x => x.ParentMenu == ParentMenu).ToList(); if (Action.ToLower() == "enable") { foreach (var menu in menus) { var access_role = db.Access.AsNoTracking().Where(x => x.RoleId == IdRole && x.WebMenuAccess == menu.WebMenuAccess).FirstOrDefault(); if (access_role == null) { AccessModels am = new AccessModels { Id = Guid.NewGuid(), RoleId = IdRole, WebMenuAccess = menu.WebMenuAccess }; db.Access.Add(am); } } } else { foreach (var menu in menus) { AccessModels am = db.Access.Where(x => x.RoleId == IdRole && x.WebMenuAccess == menu.WebMenuAccess).FirstOrDefault(); if (am != null) { db.Access.Remove(am); } } } db.SaveChanges(); return(Json(new { status = "200" }, JsonRequestBehavior.AllowGet)); }