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;
}
