public void RemoveSetting() { var options = new DbContextOptionsBuilder <CacidbContext>().UseInMemoryDatabase(databaseName: "CACIDB").Options; context.Database.EnsureDeleted(); using (var dbContext = new CacidbContext(options)) { dbContext.UserRole.Add(new UserRole { UserRoleId = 1 }); dbContext.SaveChanges(); } using (var dbContext = new CacidbContext(options)) { UserRoleRepository repository = new UserRoleRepository(dbContext); var caseOne = repository.Get().FirstOrDefault(m => m.UserRoleId == 1); bool result = repository.Delete(caseOne); Assert.AreEqual(true, result); List <UserRole> cases = repository.Get().ToList(); Assert.AreEqual(0, cases.Count); } }
protected void OnChangeToAvailable() { var tmp = SelectedUsedRole; if (tmp == null) { System.Windows.MessageBox.Show("Selecteer a.u.b. een item"); return; } var userRole = GetByUserIDAndRoleID( SelectedItem.UserID, SelectedUsedRole.RoleID); if (userRole != null) { userRoleRepo.Delete(userRole.UserRoleID); AvailableRoles.Add(_selectedUsedRole); RaisePropertyChanged("AvailableRoles"); UsedRoles.Remove(_selectedUsedRole); RaisePropertyChanged("UsedRoles"); } else { System.Windows.MessageBox.Show("Onverwachte fout"); } SaveUser(); }
public async Task Delete([FromBody] UserRole input) { await CheckPermission(); var sqlR = new UserRoleRepository(); await sqlR.Delete(input.Id); sqlR.Dispose(); }
public async Task <ActionResult> Delete(long id) { await UserRoleRepository.Delete(id); var jsonModel = new JsonModel(); jsonModel.message = "删除成功!"; jsonModel.closeCurrent = false; return(Json(jsonModel)); }
public Task RemoveFromRoleAsync(TUser user, string roleName) { if (user == null) { throw new ArgumentNullException("user"); } user.Roles.RemoveAll(r => String.Equals(r, roleName, StringComparison.InvariantCultureIgnoreCase)); _userRoleRepository.Delete(user, roleName); return(Task.FromResult(0)); }
public bool DeleteRoleUser(string roleUserIdStr) { string[] roleUserIdList = roleUserIdStr.Split(','); for (int i = 0; i < roleUserIdList.Length - 1; i++) { Guid roleUserId = new Guid(roleUserIdList[i]); var RoleUser = UserRoleRepository.GetQueryable().FirstOrDefault(ur => ur.UserRoleID == roleUserId); if (RoleUser != null) { UserRoleRepository.Delete(RoleUser); UserRoleRepository.SaveChanges(); } } return(true); }
public override void ExecuteCommand(AppSession session, StringRequestInfo requestInfo) { int role_id = JsonConvert.DeserializeObject <int>(requestInfo.Body); UserRoleRepository repository = new UserRoleRepository(); int result = repository.Delete(role_id); if (result == -1) { session.Send("False"); } else { session.Send("True"); } }
public bool DeleteUserRole(string userRoleIdStr) { string[] userRoleIdList = userRoleIdStr.Split(','); for (int i = 0; i < userRoleIdList.Length - 1; i++) { Guid userRoleId = new Guid(userRoleIdList[i]); var UserRole = UserRoleRepository.GetQueryable().FirstOrDefault(ur => ur.UserRoleID == userRoleId); if (UserRole != null) { UserRoleRepository.Delete(UserRole); UserRoleRepository.SaveChanges(); } } return(true); }
public void TestGetRoles() { /* * UserRepository.Add(user); * Role role = roleRepository.getBySlug("listner"); * UserRoleRepository.Add(new UserRole { UserId = user.UserId, User = user, Role = role, RoleId = role.RoleId }); */ userRepository.Add(user); roleRepository.Add(role); userRole = new UserRole { UserId = user.UserId, User = user, Role = role, RoleId = role.RoleId }; userRoleRepository.Add(userRole); Assert.AreEqual(1, userRepository.GetRoles(user).Count); userRoleRepository.Delete(userRole); roleRepository.Delete(role); userRepository.Delete(user); }
public async Task <int> Update([FromBody] DTOUserWithRoles dtoUserRoles) { if (dtoUserRoles.Roles != null) { userRoleRepo.Delete(dtoUserRoles.User.Id); foreach (var item in dtoUserRoles.Roles) { DTOUserRole dtoUserRole = new DTOUserRole(); dtoUserRole.RoleId = item.Id; dtoUserRole.Role = item; dtoUserRole.UserId = dtoUserRoles.User.Id; dtoUserRole.User = dtoUserRoles.User; userRoleRepo.Create(dtoUserRole); } } return(await userRepo.Update(dtoUserRoles.User)); }
public async void Del_Success() { var sqlR = new UserRoleRepository(); var e = new UserRole { Name = Guid.NewGuid().ToString(), Permissions = 123 }; var id = await sqlR.Add(new UserRoleRepository.UserRoleUi { Role = e }); var results = await sqlR.GetAll(0, 10000); await sqlR.Delete(results.Data.LastOrDefault().Role.Id); var resultsAfterDel = await sqlR.GetAll(0, 10000); Assert.True(results.Data.ToArray().Length > resultsAfterDel.Data.ToArray().Length); }
private async Task RemoveRoleFromUser(UserRole userRole) { if (userRole == null) { return; } using (var uow = new UnitOfWork(Context)) { var repo = new UserRoleRepository(uow); await repo.Delete(userRole.UserRoleId); } var userRoleCache = new UserRoleCache(Cache); await userRoleCache.InvalidateUserRoleCache(userRole.UserId); //await SendRoleUpdatedEvent(userRole, false); }
public void SubmitForm(UserInputDto userInputDto, string[] roleIds, string keyValue) { User user = new User(); if (!string.IsNullOrEmpty(keyValue)) { var id = Convert.ToInt64(keyValue); string[] includePath = { "Company", "Department", "Duty", "UserRoles", "UserRoles.Role", "UserRoles.User" }; user = userRepository.Get(id, includePath); AutoMapper.Mapper.Map <UserInputDto, User>(userInputDto, user); user.LastModificationTime = DateTime.Now; userRepository.Update(user); } else { AutoMapper.Mapper.Map <UserInputDto, User>(userInputDto, user); user.Id = IdWorkerHelper.GenId64(); user.DeletedMark = false; user.CreationTime = DateTime.Now; user.CreatorUserId = 1; user.SecretKey = Md5.md5(Common.CreateNo(), 16).ToLower(); user.Password = Md5.md5(DESEncrypt.Encrypt(Md5.md5(userInputDto.Password, 32).ToLower(), user.SecretKey).ToLower(), 32).ToLower(); userRepository.Add(user); } #region 除用户所属角色,再添加用户角色 userRoleRepository.Delete(new Specification <UserRole>(p => p.UserId == Convert.ToInt64(keyValue))); List <UserRole> userRoles = new List <UserRole>(); for (var i = 0; i < roleIds.Length; i++) { var userRole = new UserRole(); userRole.UserId = user.Id; userRole.RoleId = Convert.ToInt64(roleIds[i]); userRole.DeletedMark = true; userRoles.Add(userRole); } userRoleRepository.Add(userRoles); #endregion }
public void UserRoleCRUDTest() { var context = new NoodleDbContext("NoodleDb"); IUserRoleRepository service = new UserRoleRepository(context); var ID_ = Guid.NewGuid(); var USER_GUID_ = Guid.NewGuid(); var ROLE_GUID_ = Guid.NewGuid(); var record = new UserRole { Id = ID_, UserGuid = USER_GUID_, RoleGuid = ROLE_GUID_ }; service.Create(record); record.UserGuid = Guid.NewGuid(); record.RoleGuid = Guid.NewGuid(); service.Update(record); var record2 = service.GetById(ID_); Assert.AreEqual(record.Id, record2.Id); Assert.AreEqual(record.RoleGuid, record2.RoleGuid); Assert.AreEqual(record.UserGuid, record2.UserGuid); service.Delete(record.Id); var record3 = service.GetById(ID_); Assert.IsNull(record3); }
public void Delete(int id) { UserRoleRepository.Delete(id); }
/// <summary> /// 更新基本信息 /// </summary> /// <param name="model"></param> /// <returns></returns> public OperationResult Update(UpdateUserModel model) { var entity = Users.FirstOrDefault(t => t.Id == model.Id); //entity.FullName = model.FullName; entity.Tel = model.Phone; entity.Enabled = model.Enabled; entity.ModifyId = model.ModifyId; entity.ModifyBy = model.ModifyBy; entity.ModifyTime = DateTime.Now; #region Update User Role Mapping var oldRoleIds = entity.UserRoles.Where(t => t.IsDeleted == false).Select(t => t.RoleId).ToList(); var newRoleIds = model.SelectedRoleList.ToList(); var intersectRoleIds = oldRoleIds.Intersect(newRoleIds).ToList(); // Same Ids var removeIds = oldRoleIds.Except(intersectRoleIds).ToList(); // Remove Ids var addIds = newRoleIds.Except(intersectRoleIds).ToList(); // Add Ids foreach (var removeId in removeIds) { //更新状态->物理删除0321 // var userRole = UserRoles.FirstOrDefault(t => t.UserId == model.Id && t.RoleId == removeId); //userRole.IsDeleted = true; //userRole.ModifyId = model.ModifyId; //userRole.ModifyBy = model.ModifyBy; //userRole.ModifyTime = DateTime.Now; UserRoleRepository.Delete(t => t.UserId == model.Id && t.RoleId == removeId); } foreach (var addId in addIds) { var userRole = UserRoles.FirstOrDefault(t => t.UserId == model.Id && t.RoleId == addId); // 已有该记录,更新状态 if (userRole != null) { userRole.IsDeleted = false; userRole.ModifyId = model.ModifyId; userRole.ModifyBy = model.ModifyBy; userRole.ModifyTime = DateTime.Now; UserRoleRepository.Update(userRole); } // 插入 else { entity.UserRoles.Add(new UserRole { UserId = model.Id, RoleId = addId, CreateId = model.CreateId, CreateBy = model.CreateBy, CreateTime = DateTime.Now, ModifyId = model.ModifyId, ModifyBy = model.ModifyBy, ModifyTime = DateTime.Now }); } } #endregion UserRepository.Update(entity); return(new OperationResult(OperationResultType.Success, "更新成功")); }