/// <summary> /// 删除角色菜单 /// </summary> /// <param name="roleMenu"></param> /// <returns></returns> public bool DelRoleMenu(RoleMenu roleMenu) { roleMenu = _omsAccessor.Get <RoleMenu>().Where(r => r.Isvalid && r.RoleId == roleMenu.RoleId && r.MenuId == roleMenu.MenuId).FirstOrDefault(); _omsAccessor.Delete(roleMenu); _omsAccessor.SaveChanges(); return(true); }
public void UpdateRoleMenu(RoleMenu roleMenu) { DataContext.RoleMenus.Attach(roleMenu); DataContext.Entry(roleMenu).State = EntityState.Modified; SetAuditFields(roleMenu); DataContext.SaveChanges(); }
public void DeleteRoleMenu(long roleMenuId) { RoleMenu roleMenu = GetRoleMenu(roleMenuId); DataContext.RoleMenus.Remove(roleMenu); DataContext.SaveChanges(); }
/// <summary> /// 添加 /// </summary> /// <param name="role">role.</param> public bool Add(Role role) { _coreDbContext.Role.Add(role); bool isadd = _coreDbContext.SaveChanges() > 0; if (isadd) { if (role.MenuIds != null && role.MenuIds.Count > 0) { List <RoleMenu> roleMenus = new List <RoleMenu>(); foreach (int item in role.MenuIds) { RoleMenu roleMenu = new RoleMenu { RoleId = role.Id, MenuId = item }; roleMenus.Add(roleMenu); } _coreDbContext.RoleMenu.AddRange(roleMenus); return(_coreDbContext.SaveChanges() > 0); } return(isadd); } return(false); }
public void Update(GetRoleMenuDto getRoleMenuDto) { int[] dbMenuArray = GetMenuArray(getRoleMenuDto.RoleId); int[] addArray = getRoleMenuDto.MenuArray.Except(dbMenuArray).ToArray(); int[] delArray = dbMenuArray.Except(getRoleMenuDto.MenuArray).ToArray(); foreach (var i in addArray) { RoleMenu roleMenu = new RoleMenu() { RoleId = getRoleMenuDto.RoleId, MenuId = i }; _repository.Add(roleMenu); _unitOfWork.Commit(); } foreach (var i1 in delArray) { RoleMenu roleMenu = _repository.Find(c => c.RoleId == getRoleMenuDto.RoleId && c.MenuId == i1); if (roleMenu != null) { _repository.Delete(roleMenu); _unitOfWork.Commit(); } } }
public ActionResult CreateRolePermission(int roleId, string menus) { try { // TODO: Add insert logic here var listMenus = JsonConvert.DeserializeObject <List <Menu> >(menus); db.Database.ExecuteSqlCommand("delete from RoleMenus where RoleId={0}", roleId); foreach (var menu in listMenus) { var roleMenu = new RoleMenu { RoleId = roleId, MenuId = menu.Id }; db.RoleMenus.Add(roleMenu); } db.SaveChanges(); } catch (Exception ex) { return(Json(new { IsSuccess = false, Message = ex.Message }, "text/html", JsonRequestBehavior.AllowGet)); } return(Json(new { IsSuccess = true, Message = "保存成功" }, "text/html", JsonRequestBehavior.AllowGet)); }
public JsonResult CreateRole(Role obj, string lstId) { bool isSuccess = false; obj.Id = Common.GenerateId(); if (ModelState.IsValid) { isSuccess = _RoleService.Create(obj); } if (isSuccess) { MessageReport report = new MessageReport(true, FunctionHelper.GetLocalizeDictionary("Home", "notification")["addSuccess"]); WriteLog.Write(report, GetCurrentUser.GetUser(), obj.Id, obj.RoleName, "Role"); string[] ids = lstId.Split(new Char[] { ',' }, StringSplitOptions.RemoveEmptyEntries); if (ids != null) { foreach (var item in ids) { RoleMenu objRoleMenu = new RoleMenu(); objRoleMenu.Id = Common.GenerateId(); objRoleMenu.RoleId = obj.Id; objRoleMenu.MenuId = item; _RoleMenuService.Create(objRoleMenu); } } } return(Json(isSuccess, JsonRequestBehavior.AllowGet)); }
public static int Insert(RoleMenu roleMenu) { int id = RepositoryManager.RoleMenu_Repository.Insert(roleMenu); InvalidateCache(); return(id); }
public static bool Update(RoleMenu roleMenu) { bool isExecute = RepositoryManager.RoleMenu_Repository.Update(roleMenu); InvalidateCache(); return(isExecute); }
public bool SetRoleMenu(int roleID, IEnumerable <int> addRoleMenuList, IEnumerable <int> removeRoleMenuList) { //delete from RoleMenu where RoleID=@RoleID and MenuID=@MenuID int _DeleteCount = _RoleMenuDAL.BatchDelete(a => removeRoleMenuList.Contains(a.MenuID.Value) && a.RoleID.Value == roleID); //insert into RoleMenu(RoleID, MenuID)values(@RoleID, @MenuID) List <RoleMenu> _RoleMenuList = new List <RoleMenu>(); foreach (var amp in addRoleMenuList) { var entity = new RoleMenu() { RoleID = roleID, MenuID = amp }; _RoleMenuList.Add(entity); } int _AddCount = _RoleMenuDAL.AddList(_RoleMenuList); if ((_DeleteCount + _AddCount) > 0) { return(true); } else { return(false); } }
/// <summary> /// 新增角色 /// </summary> /// <returns></returns> public async Task AddRoleAsync(AddRoleMenuDto roleDto) { if (roleDto.MenusId.Count == 0) { throw new InvalidArgumentException("请选择菜单页面"); } var roleModel = Map <AddRoleMenuDto, Role>(roleDto); var newRoleModel = await roleRespository.InsertAsync(roleModel); var newroleId = newRoleModel.Id; var rolemenus = new List <RoleMenu>(); foreach (var item in roleDto.MenusId) { var roleMenu = new RoleMenu() { RoleId = newroleId, MenuId = item }; rolemenus.Add(roleMenu); } await roleMenuRepository.InsertEntitiesAsync(rolemenus); await roleMenuRepository.UnitOfWork.SaveChangesAsync(); }
public void UpdateGuilds() { try { OldGuildConfig[] oldGuilds = GetAll <OldGuildConfig>("guild-"); if (oldGuilds != null) { foreach (OldGuildConfig og in oldGuilds) { GuildConfig ng = new GuildConfig { Id = og.Id, Prefix = og.Prefix, NewsRoles = og.NewsRoles, AllNewsRole = og.AllNewsRole, NewsChannel = og.NewsChannel, WelcomeChannel = og.WelcomeChannel, WelcomeMessage = og.WelcomeMessage, }; RoleMenu rm = ng.DefaultSelfRoleMenu; rm.Channel = og.SelfRoleMenu[0]; rm.Message = og.SelfRoleMenu[1]; rm.SelfRoles = og.SelfRoles; Remove <OldGuildConfig>(og); Save <GuildConfig>(ng); } } } catch (Exception) { Logger.LogInfo("No need to update guilds."); } }
public async Task <ActionResult <RoleMenu> > PostRoleMenu(RoleMenu roleMenu) { _context.RoleMenu.Add(roleMenu); await _context.SaveChangesAsync(); return(CreatedAtAction("GetRoleMenu", new { id = roleMenu.RoleId }, roleMenu)); }
public async Task <IActionResult> PutRoleMenu(int id, RoleMenu roleMenu) { if (id != roleMenu.RoleId) { return(BadRequest()); } _context.Entry(roleMenu).State = EntityState.Modified; try { await _context.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!RoleMenuExists(id)) { return(NotFound()); } else { throw; } } return(NoContent()); }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(RoleMenu model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update Auth_RoleMenu set "); strSql.Append("RoleId=@RoleId,"); strSql.Append("MenuId=@MenuId"); strSql.Append(" where Id=@Id"); SqlParameter[] parameters = { new SqlParameter("@RoleId", SqlDbType.Int, 4), new SqlParameter("@MenuId", SqlDbType.Int, 4), new SqlParameter("@Id", SqlDbType.Int, 4) }; parameters[0].Value = model.RoleId; parameters[1].Value = model.MenuId; parameters[2].Value = model.Id; int rows = MssqlHelper.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
public bool AddMenu(Guid roleId, List <Guid> menus) { try { this.ConnectionHandler.StartTransaction(IsolationLevel.ReadUncommitted); foreach (var menu in menus) { var roleMenu1 = new RoleMenuBO().Get(this.ConnectionHandler, roleId, menu); if (roleMenu1 == null) { var roleMenu = new RoleMenu { MenuId = menu, RoleId = roleId }; if (!new RoleMenuBO().Insert(this.ConnectionHandler, roleMenu)) { throw new Exception("خطایی در ذخیره منوی نقش وجو دارد"); } } } this.ConnectionHandler.CommitTransaction(); return(true); } catch (KnownException ex) { this.ConnectionHandler.RollBack(); Log.Save(ex.Message, LogType.ApplicationError, ex.Source, ex.StackTrace); throw new KnownException(ex.Message, ex); } catch (Exception ex) { this.ConnectionHandler.RollBack(); Log.Save(ex.Message, LogType.ApplicationError, ex.Source, ex.StackTrace); throw new KnownException(ex.Message, ex); } }
public async Task <RoleMenu> searchRoleMenuById(int id) { RoleMenuDbContext roleMenuDB = new RoleMenuDbContext(); RoleMenu model = await roleMenuDB.roleMenus.FindAsync(id); return(model); }
/// <summary> /// 更新 /// </summary> /// <returns><c>true</c>, if product was updated, <c>false</c> otherwise.</returns> /// <param name="model">model.</param> public bool Update(Role model) { _coreDbContext.Role.Attach(model); _coreDbContext.Entry(model).State = EntityState.Modified; if (model.MenuIds != null && model.MenuIds.Count > 0) { List <RoleMenu> rolemenus = _coreDbContext.RoleMenu.Where(t => t.IsDelete == false && t.RoleId == model.Id).ToList(); foreach (var item in rolemenus) { _coreDbContext.RoleMenu.Remove(item); } List <RoleMenu> roleMenus = new List <RoleMenu>(); foreach (var item in model.MenuIds) { RoleMenu roleMenu = new RoleMenu { RoleId = model.Id, MenuId = item }; roleMenus.Add(roleMenu); } _coreDbContext.RoleMenu.AddRange(roleMenus); } return(_coreDbContext.SaveChanges() > 0); }
public ActionResult CreateRoleMenu(RoleMenu roleMenu) { //if model not valid if (!ModelState.IsValid) { return(RedirectToAction("RoleAkses", "Security")); } //if exist var roleMenuInDB = _context.RoleMenus .SingleOrDefault(m => (m.RoleId == roleMenu.RoleId) && (m.MenuId == roleMenu.MenuId)); if (roleMenuInDB == null) { //add context and save _context.RoleMenus.Add(roleMenu); _context.SaveChanges(); return(RedirectToAction("RoleAkses", "Security", new { roleId = roleMenu.RoleId })); } else { var strMessage = "exist"; return(RedirectToAction("RoleAkses", "Security", new { errorMessage = strMessage })); } }
/// <summary> /// delete by id /// </summary> /// <param name="id"></param> /// <returns></returns> public async Task <Result <RoleMenu> > deleteMenuAsync(int id) { Result <RoleMenu> result = new Result <RoleMenu>(); try { RoleMenuDbContext context = new RoleMenuDbContext(); RoleMenu model = await context.roleMenus.FindAsync(id); context.roleMenus.Remove(model); int count = await context.SaveChangesAsync(); if (count == 0) { result.success = false; result.message = "This Role Do Not Include This Menu"; } } catch (Exception err) { result.success = false; result.message = err.Message; } return(result); }
//[ValidateAntiForgeryToken] public ActionResult Edit([Bind(Include = "MenuItem,Id,RoleName,MenuId,IsEnabled")] RoleMenu roleMenu) { if (ModelState.IsValid) { roleMenu.TrackingState = TrackingState.Modified; _roleMenuService.Update(roleMenu); _unitOfWork.SaveChanges(); if (Request.IsAjaxRequest()) { return(Json(new { success = true }, JsonRequestBehavior.AllowGet)); } DisplaySuccessMessage("Has update a RoleMenu record"); return(RedirectToAction("Index")); } var menuitemRepository = _unitOfWork.Repository <MenuItem>(); ViewBag.MenuId = new SelectList(menuitemRepository.Queryable(), "Id", "Title", roleMenu.MenuId); if (Request.IsAjaxRequest()) { var modelStateErrors = String.Join("", this.ModelState.Keys.SelectMany(key => this.ModelState[key].Errors.Select(n => n.ErrorMessage))); return(Json(new { success = false, err = modelStateErrors }, JsonRequestBehavior.AllowGet)); } DisplayErrorMessage(); return(View(roleMenu)); }
public void Remove(int id) { RoleMenu roleMenu = db.RoleMenus.Find(id); db.RoleMenus.Remove(roleMenu); db.SaveChanges(); }
/// <summary> /// 增加一条数据 /// </summary> public int Add(RoleMenu model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into Auth_RoleMenu("); strSql.Append("RoleId,MenuId)"); strSql.Append(" values ("); strSql.Append("@RoleId,@MenuId)"); strSql.Append(";select @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@RoleId", SqlDbType.Int, 4), new SqlParameter("@MenuId", SqlDbType.Int, 4) }; parameters[0].Value = model.RoleId; parameters[1].Value = model.MenuId; object obj = MssqlHelper.GetSingle(strSql.ToString(), parameters); if (obj == null) { return(0); } else { return(Convert.ToInt32(obj)); } }
public IActionResult RoleRelateMenu() { try { var menus = _systemMenuService.GetAll(); var role = _systemRoleService.GetAll().FirstOrDefault(); RoleMenu roleMenu = null; foreach (var item in menus) { roleMenu = new RoleMenu() { Id = Guid.NewGuid().ToString(), AddTime = DateTime.Now, IsDelete = false, SystemMenus = item, SystemRoles = role }; _roleMenuService.Add(roleMenu); } _unitOfWork.Commit(); return(Ok()); } catch (Exception ex) { throw ex; } }
public bool Update(RoleMenu RoleMenu) { bool isInsert = false; bool isUpate = false; try { db = EnterpriseLibraryContainer.Current.GetInstance <Database>(); DbCommand cmd = db.GetStoredProcCommand("RoleMenuUpdate"); db = AddParam(db, cmd, RoleMenu, isInsert); int rowAffected = db.ExecuteNonQuery(cmd); if (rowAffected > 0) { isUpate = true; } } catch (Exception ex) { throw ex; } return(isUpate); }
public JsonResult CreateRole(Role obj, string lstId) { var report = new MessageReport(); obj.Id = Common.GenerateId(); if (ModelState.IsValid) { report = _RoleService.Create(obj); } if (report.isSuccess) { string[] ids = lstId.Split(new Char[] { ',' }, StringSplitOptions.RemoveEmptyEntries); if (ids != null) { foreach (var item in ids) { RoleMenu objRoleMenu = new RoleMenu(); objRoleMenu.Id = Common.GenerateId(); objRoleMenu.RoleId = obj.Id; objRoleMenu.MenuId = item; _RoleMenuService.Create(objRoleMenu); } } } return(Json(report, JsonRequestBehavior.AllowGet)); }
public int Insert(RoleMenu RoleMenu) { int id = 0; bool isInsert = true; try { db = EnterpriseLibraryContainer.Current.GetInstance <Database>(); DbCommand cmd = db.GetStoredProcCommand("RoleMenuInsert"); db = AddParam(db, cmd, RoleMenu, isInsert); db.ExecuteNonQuery(cmd); Object obj = db.GetParameterValue(cmd, "Id"); if (obj != null) { int.TryParse(obj.ToString(), out id); } } catch (Exception ex) { throw ex; } return(id); }
public async Task <ActionResult> Create(int[] MenuId, int RoleId) { List <RoleMenu> roleMenus = new List <RoleMenu>(); if (MenuId[0] == 0) { ModelState.AddModelError("MenuId", "Bir değer girin"); return(View()); } if (MenuId != null && RoleId > 0) { for (int i = 0; i < MenuId.Length; i++) { RoleMenu roleMenu = new RoleMenu(); roleMenu.MenuId = MenuId[i]; roleMenu.RoleId = RoleId; db.RolMenus.Add(roleMenu); } await db.SaveChangesAsync(); return(RedirectToAction("Index")); } else { } ViewBag.MenuId = new SelectList(db.AllMenu, "MenuId", "MenuName", MenuId); ViewBag.RoleId = new SelectList(db.Roles, "RoleId", "RoleName", RoleId); return(View()); }
public MenuPrivilege(string pageName, RoleMenu roleMenu) { PageName = pageName; AllowAddNew = roleMenu.AllowAddNew.GetValueOrDefault(false); AllowUpdate = roleMenu.AllowUpdate.GetValueOrDefault(false); AllowDelete = roleMenu.AllowDelete.GetValueOrDefault(false); }
public RoleMenu GetRoleMenusByRoleAndMenu(int role, int item) { RoleMenu roleMenu = (from u in db.RoleMenus where u.rm_role_id == role && u.rm_menu_id == item select u).FirstOrDefault(); return(roleMenu); }
protected void CheckBox1_CheckedChanged(object sender, EventArgs e) { if (RoleID < 1) return; CheckBox cb = sender as CheckBox; if (cb == null) return; GridViewRow row = cb.BindingContainer as GridViewRow; if (row == null) return; Menu entity = Menu.Root.AllChilds[row.DataItemIndex] as Menu; if (entity == null) return; formtitle = entity.Name; // 检查权限 RoleMenu rm = RoleMenu.FindByRoleAndMenu(RoleID, entity.ID); if (cb.Checked) { // 没有权限,增加 if (rm == null) { if (!Acquire(PermissionFlags.Insert)) { WebHelper.Alert("没有添加权限!"); return; } rm = new RoleMenu(); rm.RoleID = RoleID; rm.MenuID = entity.ID; rm.PermissionFlag = PermissionFlags.All; rm.Save(); } } else { // 如果有权限,删除 if (rm != null) { if (!Acquire(PermissionFlags.Delete)) { WebHelper.Alert("没有删除权限!"); return; } rm.Delete(); } } GridView1.DataBind(); }
protected void CheckBoxList1_SelectedIndexChanged(object sender, EventArgs e) { if (RoleID < 1) return; CheckBoxList cb = sender as CheckBoxList; //只需判断cb是否为空,该角色只有“查看”权限时cb.SelectedItem为空。 //if (cb == null || cb.SelectedItem == null) return; if (cb == null) return; GridViewRow row = cb.BindingContainer as GridViewRow; if (row == null) return; Menu entity = Menu.Root.AllChilds[row.DataItemIndex] as Menu; if (entity == null) return; formtitle = entity.Name; // 检查权限 RoleMenu rm = RoleMenu.FindByRoleAndMenu(RoleID, entity.ID); // 没有权限,增加 if (rm == null) { if (!Acquire(PermissionFlags.Insert)) { WebHelper.Alert("没有添加权限!"); return; } rm = new RoleMenu(); rm.RoleID = RoleID; rm.MenuID = entity.ID; } // 遍历权限项 PermissionFlags flag = PermissionFlags.None; foreach (ListItem item in cb.Items) { if (item.Selected) flag |= (PermissionFlags)(Int32.Parse(item.Value)); } if (rm.PermissionFlag != flag) { if (!Acquire(PermissionFlags.Update)) { WebHelper.Alert("没有编辑权限!"); return; } rm.PermissionFlag = flag; rm.Save(); } GridView1.DataBind(); }