private async Task <UserAdminVM> GetUserVM(string id, string userName)
{
UserAdminVM userVM = null;
using (var idContext = new OzzIdentityDbContext())
{
var user = string.IsNullOrEmpty(id) ?
await idContext.Users.FirstOrDefaultAsync(u => u.UserName.Equals(userName)):
await idContext.Users.FirstOrDefaultAsync(u => u.Id.Equals(id));
if (user == null)
{
return(null);
}
userVM = new UserAdminVM(user);
}
await SetViewModelRoles(userVM);
return(userVM);
}
// GET: Admin/Users
public async Task <ActionResult> Index(QueryParameters qParams)
{
using (var idContext = new OzzIdentityDbContext())
{
IQueryable <OzzUser> query = idContext.Users.OrderBy(u => u.UserName);
if (!string.IsNullOrEmpty(qParams.SearchString))
{
query = from a in query
where
a.UserName.Contains(qParams.SearchString) |
a.FirstName.Contains(qParams.SearchString) |
a.LastName.Contains(qParams.SearchString)
select a;
}
qParams.TotalCount = await query.CountAsync();
query = query
.OrderBy(u => u.UserName)
.ThenBy(u => u.FirstName)
.ThenBy(u => u.LastName)
.ThenBy(u => u.Id)
.Skip(qParams.Skip)
.Take(qParams.PageSize);
PutPagerInViewBag(qParams);
var users = qParams.TotalCount > 0 ? await query.ToListAsync() : new List <OzzUser>();
var usersVM = new List <UserAdminVM>();
foreach (var user in users)
{
var userVM = new UserAdminVM(user);
await SetViewModelRoles(userVM);
usersVM.Add(userVM);
}
return(View(usersVM));
}
}
public OzzUserStore(OzzIdentityDbContext dbContext)
: base(dbContext)
{
}
