//List<SelectListItem>
private void FetchUserRoles(CopiosisEntities db, ViewUsersModel model)
{
List<UserModel> adminUsers = new List<UserModel>();
List<int> adminIds = new List<int>();
List<UserModel> nonAdminUsers = new List<UserModel>();
var items = db.webpages_Roles.ToList();
if (items != null)
{
foreach (var item in items)
{
if (item.RoleName == "ADMIN")
{
foreach (var user in item.users)
{
UserModel temp = new UserModel();
temp.firstName = user.firstName;
temp.lastName = user.lastName;
temp.status = user.status;
temp.userId = user.userID;
temp.userName = user.username;
if (temp.userId != WebSecurity.CurrentUserId)
{
adminIds.Add(temp.userId);
adminUsers.Add(temp);
}
}
}
else if (item.RoleName == "USER")
{
foreach (var user in item.users)
{
if (!adminIds.Contains(user.userID))
{
UserModel temp = new UserModel();
temp.firstName = user.firstName;
temp.lastName = user.lastName;
temp.status = user.status;
temp.userId = user.userID;
temp.userName = user.username;
nonAdminUsers.Add(temp);
}
}
}
} // end Foreach
} // if (items != null)
model.adminUsers = adminUsers;
model.nonadminUsers = nonAdminUsers;
}
public ActionResult ViewUsers()
{
ViewUsersModel model = new ViewUsersModel();
using (var db = new CopiosisEntities())
{
FetchUserRoles(db, model);
}
return View(model);
}