public ActionResult Edit(int id) { var pevm = CreateViewModel<PermissionEditViewModel>(); StringBuilder result = new StringBuilder(); var check_date = new DateTime(DateTime.Now.Year, DateTime.Now.Month, DateTime.Now.Day); var rolelist = _roleRepository.FindAll().Where(x => !x.IsDeleted && x.Active == true && (x.RoleTypeId == 1 || x.RoleTypeId == 3)).ToList().Select(x => x.Id); var useridrolewise = _userRoleRepository.FindAll().Where(x => !x.IsDeleted && rolelist.Contains(x.RoleId) && x.ValidTo >= check_date && x.ValidFrom <= check_date).ToList().Select(x => x.UserId); List<User> UserList = _userRepository.FindAll(x => x.Active == true && x.IsDeleted == false && useridrolewise.Contains(x.Id)).OrderBy(x => x.FirstName).ToList(); foreach (var obj in UserList) { var usrrole = ""; if (obj.UserRoles.Count > 0) { var rolel = obj.UserRoles.Where(x => !x.IsDeleted && x.UserId == obj.Id && DateTime.Now >= x.ValidFrom && DateTime.Now <= x.ValidTo).FirstOrDefault(); if (usrrole != null) { usrrole = rolel.Role.Name; } } //var roleid = _userRoleRepository.FindAll().Where(x => !x.IsDeleted && x.UserId == obj.Id && x.ValidFrom <= DateTime.Now && x.ValidTo >= DateTime.Now).Select(x => x.RoleId).FirstOrDefault(); //var rolename = _roleRepository.FindAll().Where(x => !x.IsDeleted && x.Id == Convert.ToInt32(roleid)).Select(x => x.Name).FirstOrDefault(); obj.FirstName = "Full Name: " + obj.FirstName.Trim() + " " + obj.LastName.Trim() + ", Role Name: " + usrrole.Trim(); } pevm.UserList = new SelectList(UserList, "Id", "FirstName", pevm.User.Id); Mapper.Map(_userPermissionGroupRepository.FindById(id), pevm.Permission); return PartialView(pevm); }
public bool UpdateUser(UserInfoManagementInDTO user, Guid userInfoId) { try { var currentUser = _userInfoRepository.FindByID(user.UserInfoId ?? Guid.Empty); if (currentUser == null) { return(false); } var emailExists = _userInfoRepository.FindAll().Any(x => x.Email.ToLower() == user.Email.ToLower() && user.UserInfoId != currentUser.UserInfoId); if (emailExists) { return(false); } currentUser.Address = user.Address; currentUser.EntityId = user.CompanyId; currentUser.ContactNo = user.ContactNo; currentUser.Country = user.Country; currentUser.Email = user.Email; currentUser.FirstName = user.FirstName; currentUser.LastName = user.LastName; currentUser.Position = user.Position; currentUser.Status = user.Status; currentUser.Timezone = user.Timezone; currentUser.ModifiedOn = Localization.GetUTCDateNow(); currentUser.ModifiedBy = userInfoId; _userInfoRepository.Update(currentUser); var exisitingMappedRoles = _userRoleRepository.FindAll().Where(x => x.UserId == currentUser.UserInfoId); foreach (var existingMappedRole in exisitingMappedRoles) { _userRoleRepository.Remove(existingMappedRole.UserRoleId); } foreach (var mappedRole in user.RoleMappingItems) { var userRole = new UserRole(); userRole.UserId = currentUser.UserInfoId; userRole.RoleId = mappedRole.RoleId; userRole.CreatedBy = userInfoId; userRole.CreatedOn = Localization.GetUTCDateNow(); userRole.ModifiedBy = userInfoId; userRole.ModifiedOn = Localization.GetUTCDateNow(); _userRoleRepository.Add(userRole, true); } } catch (Exception ex) { throw new Exception(ex.Message); } return(true); }
public async Task <UserRole> GetUserRoleAsync() { var result = _userRoleRepo.FindAll(x => x.DeleteFlag != DeleteFlg.Delete).ToList(); if (result.Count > 0) { return(result[0]); } return(null); }
public async Task <object> GetAllUserInfo() { var appsettings = _configuration.GetSection("AppSettings").Get <Appsettings>(); var DMRSystemCode = appsettings.SystemCode; using var client = new HttpClient(); var response = await client.GetAsync($"{appsettings.API_AUTH_URL}Users/GetUserBySystemID/{DMRSystemCode}"); var data = await response.Content.ReadAsStringAsync(); var users = JsonConvert.DeserializeObject <List <UserDto> >(data); var userRole = await _repoUserRole.FindAll().Include(x => x.Role).ToListAsync(); var buildingUser = await _repoBuildingUser.FindAll().Include(x => x.Building).ToListAsync(); var result = new List <UserDto>(); foreach (var x in users) { var userRoleItem = userRole.FirstOrDefault(a => a.UserID == x.ID); var buildingUserItem = buildingUser.FirstOrDefault(a => a.UserID == x.ID); result.Add(new UserDto { ID = x.ID, Username = x.Username, Password = x.Password, EmployeeID = x.EmployeeID, Email = x.Email, PasswordSalt = x.PasswordSalt, PasswordHash = x.PasswordHash, IsLock = userRoleItem != null ? userRoleItem.IsLock : false, SystemID = DMRSystemCode, UserRoleID = userRoleItem != null ? userRoleItem.RoleID : 0, BuildingUserID = buildingUserItem != null ? buildingUserItem.BuildingID : 0, Role = userRoleItem != null ? userRoleItem.Role.Name : "#N/A", Building = buildingUserItem != null ? buildingUserItem.Building.Name : "#N/A", }); } return(result); }
public async Task <List <UserRoleDto> > GetAllAsync() { return(await _userRoleRepository.FindAll().ProjectTo <UserRoleDto>(_configMapper).ToListAsync()); }