public List <UserRoleItem> GetUserRoles(User user) { var parameters = new List <DbQueryParameter>() { new DbQueryParameter("InsCode", user.InsCode), new DbQueryParameter("UserId", user.Id) }; List <UserRoleItem> userRoleItems = new List <UserRoleItem>(); var result = SqlDbManager.Instance().ExecuteProcedureDataSets(UserSpHelper.GetUserRolesSpName(), parameters, SqlDbManager.SqlConnectionMode.QUERYBOOK); if (result != null) { if (result.Tables.Count > 0 && result.Tables[0].Rows.Count > 0) { foreach (DataRow item in result.Tables[0].Rows) { UserRoleItem userRoleItem = new UserRoleItem { RoleName = item["RoleName"].ToString() }; userRoleItems.Add(userRoleItem); } } } return(userRoleItems); }
protected void btnSave_ServerClick(object sender, EventArgs e) { string strUserName = txt_UserName.Value.Trim(); string strNickName = txt_NickName.Value.Trim(); string strPassword = txt_Password.Value.Trim(); string strPasswordSecond = txt_PasswordSecond.Value.Trim(); if ("" == strUserName || "" == strNickName || "" == strPassword || "" == strPasswordSecond) return; if(UserItem.ExistUser(strUserName)) { PageUtil.PageAlert(this.Page, "该用户名已存在!"); return; } if (!strPassword.Equals(strPasswordSecond)) { PageUtil.PageAlert(this.Page, "密码和确认密码不一致!"); return; } if (lb_RoleSelect.Items.Count == 0) { PageUtil.PageAlert(this.Page, "请选择角色!"); return; } UserItem addItem = new UserItem(); addItem.UserName = strUserName; addItem.NickName = strNickName; addItem.Password = Util.MD5Encrypt(strPassword); addItem.Gender = rb_GenderMale.Checked ? "男" : "女"; string strTel = txt_Tel.Value.Trim(); if ("" != strTel) addItem.Tel = txt_Tel.Value.Trim(); string strEmail = txt_Email.Value.Trim(); if ("" != strEmail) addItem.Email = txt_Email.Value.Trim(); int nNewId = UserItem.Save(addItem); if (nNewId <= 0) return; UserRoleItem[] alUserRoles = UserRoleItem.GetUserRoles(nNewId); Hashtable htExistRoles = new Hashtable(); if (null != alUserRoles) { foreach (UserRoleItem item in alUserRoles) htExistRoles[item.RoleItemId + ""] = 1; } foreach (ListItem item in lb_RoleSelect.Items) { if (htExistRoles.ContainsKey(item.Value)) continue; UserRoleItem addUserRole = new UserRoleItem(); addUserRole.RoleItemId = int.Parse(item.Value); addUserRole.UserItemId = nNewId; UserRoleItem.Save(addUserRole); } PageUtil.PageAlert(this.Page, "保存成功!"); }
public async Task AddUserRoleAsync(UserRoleDto dto) { foreach (var item in dto.RoleIds) { var userRole = new UserRoleItem { UserId = dto.UserId, RoleId = item, }; await _userRoleDbSet.AddAsync(userRole); } }
/// <summary> /// Get the list of the users with their roles /// </summary> /// <param name="Pattern"></param> /// <param name="StartAt"></param> /// <param name="PageSize"></param> /// <returns></returns> public DisplayUsersViewModel GetDisplayUsersViewModel(string Pattern, int StartAt, int PageSize) { DisplayUsersViewModel model = new DisplayUsersViewModel(); try { List <RoleItem> AllRolesList = _aspNetRoleRepo.List().Select(a => new RoleItem { RoleId = a.Id, RoleName = a.Name }).ToList(); model.Pattern = Pattern; model.PageSize = PageSize; model.StartAt = StartAt; if (Pattern == null) { Pattern = ""; } Pattern = Pattern.ToLower(); var Users = new List <AspNetUser>(); if (String.IsNullOrWhiteSpace(Pattern) && StartAt >= 0 && PageSize >= 0) { var FullUsersList = _aspNetUserRepo.List().ToList(); model.Count = FullUsersList.Count; Users = FullUsersList.OrderByDescending(e => e.Id).Skip(StartAt).Take(PageSize).ToList(); } else { Users = _aspNetUserRepo.List().ToList(); } foreach (var user in Users) { UserRoleItem userRolItem = TransformAspNetUserIntoUserRoleItem(user, AllRolesList); if (userRolItem != null) { model.UserRolesList.Add(userRolItem); } } if (!String.IsNullOrWhiteSpace(Pattern) && StartAt >= 0 && PageSize >= 0) { IEnumerable <UserRoleItem> resultIEnumerable = model.UserRolesList as IEnumerable <UserRoleItem>; resultIEnumerable = resultIEnumerable.Where(a => Commons.FormaterHelper.GetFormatStringForDateDisplay(a.DateLastConnection).ToLower().Contains(Pattern) || (a.UserRolesList.ToList().Where(r => r.RoleName.ToLower().Contains(Pattern.ToLower())).Any()) || (a.UserFirstNameDecrypt != null && a.UserFirstNameDecrypt.Contains(Pattern)) || a.UserLastNameDecrypt.Contains(Pattern) || (a.UserNameDecrypt != null && a.UserNameDecrypt.Contains(Pattern))); model.Count = resultIEnumerable.ToList().Count; model.UserRolesList = resultIEnumerable.OrderByDescending(a => a.UserFirstNameDecrypt).OrderByDescending(a => a.UserLastNameDecrypt).Skip(StartAt).Take(PageSize).ToList(); } } catch (Exception e) { Commons.Logger.GenerateError(e, System.Reflection.MethodBase.GetCurrentMethod().DeclaringType, "Pattern = " + Pattern); } return(model); }
public ActionResult _DisplayUsersModifications(string UserIdentityId) { UserRoleItem Model = new UserRoleItem(); try { Model.UseridentityId = UserIdentityId; Model = _userRoleService.GetUserRolesByUseridentityId(UserIdentityId); } catch (Exception e) { Commons.Logger.GenerateError(e, System.Reflection.MethodBase.GetCurrentMethod().DeclaringType, "UserIdentityId = " + UserIdentityId); return(Content("ERROR")); } return(PartialView(Model)); }
public UserRoleItem TransformAspNetUserIntoUserRoleItem(AspNetUser aspnetUser, List <RoleItem> AllRolesList) { UserRoleItem model = new UserRoleItem(); try { if (aspnetUser != null) { var user = aspnetUser.Users.FirstOrDefault(); model.DateLastConnection = user.DateLastConnection.ToLocalTime(); model.UserId = user.Id; model.UseridentityId = aspnetUser.Id; model.UserFirstNameDecrypt = user.FirstName; model.UserLastNameDecrypt = user.LastName; model.UserNameDecrypt = user.AspNetUser.UserName; model.UserRolesList = aspnetUser.AspNetRoles.ToList().Select(a => new RoleItem { RoleId = a.Id, RoleName = a.Name }).ToList(); List <RoleItem> UserNotInRoleList = new List <RoleItem>(); foreach (RoleItem role in AllRolesList) { string strRole = role.RoleName; if (!model.UserRolesList.Where(a => a.RoleName == strRole).Any()) { RoleItem roleItemn = new RoleItem(); roleItemn.RoleName = strRole; roleItemn.RoleId = role.RoleId; UserNotInRoleList.Add(roleItemn); } } model.UserNotInRoleList = UserNotInRoleList; } else { return(null); } } catch (Exception e) { Commons.Logger.GenerateError(e, System.Reflection.MethodBase.GetCurrentMethod().DeclaringType, "UserIdentityId = " + aspnetUser.Id); } return(model); }
public ActionResult Create(string id) { try { using (var db = new StoreContext()) { this.OrganizeViewBugs(); var item = new UserRoleItem(); item.UserId = id; return(View("UserRoleTemplate", item)); } } catch (Exception ex) { return(HttpNotFound(ex.Message)); } }
public ActionResult EditForm(int?id) { var obj = new UserRoleItem(); var list = userRoleRepository.GetListForTree <object>(); if (id.HasValue) { obj = userRoleRepository.GetItemById <UserRoleItem>(id.Value); } return(Json(new { data = obj, list = list }, JsonRequestBehavior.AllowGet)); }
public ActionResult Create(UserRoleItem userRole) { try { if (ModelState.IsValid) { var userManager = new UserManager <ApplicationUser>(new UserStore <ApplicationUser>(context)); ApplicationUser applicationUser = userManager.FindById(userRole.UserId); IdentityRole role = context.Roles.Where(p => p.Id == userRole.RoleId).First(); userManager.AddToRole(applicationUser.Id, role.Name); context.SaveChanges(); } return(Json("1", JsonRequestBehavior.AllowGet)); } catch (Exception ex) { return(Json(ex.Message, JsonRequestBehavior.AllowGet)); } }
public List <UserRoleItem> GetUserRoleItems(User user) { using (SipEntegrasyonContext db = new SipEntegrasyonContext()) { //var result = from ur in db.UserRoleMappings // join r in db.Roles // on ur.UserId equals user.Id // where ur.UserId == user.Id // select new UserRoleItem { RoleName = r.Name }; var result = new List <UserRoleItem>(); var roleMappings = db.UserRoleMappings.Where(x => x.UserId == user.Id); foreach (var roleMapping in roleMappings) { UserRoleItem roleItem = new UserRoleItem(); var rolename = db.Roles.Where(x => x.Id == roleMapping.RoleId); roleItem.RoleName = rolename.FirstOrDefault().Name; result.Add(roleItem); } return(result.ToList()); } }
/// <summary> /// Get the user roles informations for one user /// </summary> /// <param name="UserIdentity"></param> /// <returns></returns> public UserRoleItem GetUserRolesByUseridentityId(string UserIdentity) { UserRoleItem model = new UserRoleItem(); try { var aspNetuser = _aspNetUserRepo.FindAllBy(u => u.Id == UserIdentity).FirstOrDefault(); if (aspNetuser != null) { List <RoleItem> AllRolesList = _aspNetRoleRepo.List().Select(a => new RoleItem { RoleId = a.Id, RoleName = a.Name }).ToList(); model = TransformAspNetUserIntoUserRoleItem(aspNetuser, AllRolesList); } } catch (Exception e) { Commons.Logger.GenerateError(e, System.Reflection.MethodBase.GetCurrentMethod().DeclaringType, "UserIdentity = " + UserIdentity); } return(model); }
public ApiResponse Index([FromQuery] Query query, [FromHeader] Header header) { if (query.Pagination) { var userRolesRepo = this.userRoleApplication.GetList(query.Page, query.PerPage); int count = this.userRoleApplication.Count(query.Search); decimal pageInCount = ((decimal)count) / query.PerPage; PaginationModel paginate = (new PaginationModel() { TotalPage = (int)Math.Ceiling(pageInCount), Page = query.Page, PerPage = query.PerPage, Data = UserRoleItem.MapRepo(userRolesRepo), Total = count }); return(new ApiResponsePagination(HttpStatusCode.OK, paginate)); } else { var userRolesRepo = this.userRoleApplication.GetList(query.Page, query.PerPage); return(new ApiResponseDataList(HttpStatusCode.OK, userRolesRepo, userRolesRepo.Count)); } }
private List<RoleItem> CopyRoleItems(URM.RoleItemCollection<URM.Role, URM.RoleItem> urmRoles) { List<RoleItem> roles = new List<RoleItem>(); foreach (URM.RoleItem urmRoleItem in urmRoles) { //TODO: check if this can be refactored to something simpler since UserItem and GroupItem have the same properties. if (urmRoleItem is URM.UserItem) { URM.UserItem urmUserItem = (URM.UserItem)urmRoleItem; UserRoleItem uri = new UserRoleItem(); uri.ExtraData = urmUserItem.ExtraData; uri.Name = urmUserItem.Name; roles.Add(uri); } else if (urmRoleItem is URM.GroupItem) { URM.GroupItem urmGroupItem = (URM.GroupItem)urmRoleItem; GroupRoleItem gri = new GroupRoleItem(); gri.ExtraData = urmGroupItem.ExtraData; gri.Name = urmGroupItem.Name; roles.Add(gri); } else { throw new NotSupportedException("SmartObject RoleItems aren't supported."); } } return roles; }