public List <ListUserViewModel> GetAllResult()
{
var result = (from qes in surveyDBContext.Questions
join res in surveyDBContext.Results
on qes.Q_Id equals res.Q_Id
group new { res.SelectedAnswer }
by new { qes.Q_Text } into grp
orderby grp.Key.Q_Text
select new
{
QText = grp.Key.Q_Text,
Answer = grp.Select(x => x.SelectedAnswer)
}).ToList();
var model = new List <ListUserViewModel>();
foreach (var res in result)
{
ListUserViewModel surveyViewModel = new ListUserViewModel
{
QText = res.QText,
SelectedAnswer = res.Answer.ToList()
};
model.Add(surveyViewModel);
}
return(model);
}
public ActionResult Index()
{
var listUser = new List <ListUserViewModel>();
foreach (var user in UserManager.Users.OrderByDescending(u => u.CreatedDate).ToList())
{
var roles = UserManager.GetRoles(user.Id);
if (roles.Any(r => r.Contains(RoleNames.Root)))
{
continue;
}
var u = new ListUserViewModel
{
User = user,
Roles = roles
};
listUser.Add(u);
}
var model = new ListUserWithRolesViewModel
{
ListUser = listUser,
Roles = RoleManager.Roles.Where(r => r.Name != RoleNames.Root).ToList()
};
return(View(model));
}
public ActionResult ListUser(String Nombre, Int32?p)
{
var ListUserViewModel = new ListUserViewModel();
ListUserViewModel.CargarDatos(CargarDatosContext(), p, Nombre);
return(View(ListUserViewModel));
}
// GET: User
public ActionResult ListUser(Int32?p)
{
var vm = new ListUserViewModel();
vm.Fill(CargarDatosContext(), p);
return(View(vm));
}
public ActionResult Index()
{
var usersAndRoles = new Dictionary <int, string>();
var adminRoleId = roleService.GetOneByPredicate(r => r.Name == "admin").Id;
var moderRoleId = roleService.GetOneByPredicate(r => r.Name == "moder").Id;
var userRoleId = roleService.GetOneByPredicate(r => r.Name == "user").Id;
usersAndRoles.Add(moderRoleId, "moder");
usersAndRoles.Add(userRoleId, "user");
var users = userService.GetAllByPredicate(u => u.RoleId != adminRoleId);
var model = new ListUserViewModel();
model.Users = new List <UserViewModel>();
foreach (var user in users)
{
var userViewModel = user.ToUserViewModel();
string role = null;
usersAndRoles.TryGetValue(user.RoleId, out role);
if (role == null)
{
role = string.Empty;
}
userViewModel.Role = role;
model.Users.Add(userViewModel);
}
ViewBag.users = model;
return(View());
}
public async Task <IActionResult> GetAllUser(string id)
{
var user = _userManager.FindByIdAsync(id);
bool Isadmin = false;
if (user.Result != null)
{
Isadmin = await _userManager.IsInRoleAsync(user.Result, "Administrators");
}
if (Isadmin)
{
IEnumerable <ApplicationUser> listUserInRoleManager = await _userManager.GetUsersInRoleAsync("Managers");
IEnumerable <ApplicationUser> listUserInRoleUser = await _userManager.GetUsersInRoleAsync("Users");
ListUserViewModel listUser = new ListUserViewModel()
{
listUserInRoleManager = listUserInRoleManager,
listUserInRoleUser = listUserInRoleUser
};
ViewBag.idAdmin = id;
return(View(listUser));
}
//List<ApplicationUser> listUser = _userManager.Users.ToList();
//var user = _userManager.FindByNameAsync("alice");
//user.Result.IsEnabled = true;
//await _userManager.AddToRoleAsync(user.Result, "Users");
//await _userManager.UpdateAsync(user.Result);
return(Redirect("http://localhost:5002"));
}
public async Task <IActionResult> Edit(string id)
{
IActionResult result;
var user = await _userManager.Users
.Where(u => u.Id == id)
.FirstOrDefaultAsync();
if (user != null)
{
var roles = await _userManager.GetRolesAsync(user);
var userViewModel = new ListUserViewModel
{
Id = user.Id,
Email = user.Email,
FirstName = user.FirstName,
LastName = user.LastName,
Role = string.Join(',', roles),
RoleItems = _roleConfig.GetRoles()
};
result = View(userViewModel);
}
else
{
result = View("NotFound");
}
return(result);
}
public async Task <IActionResult> Delete(string id)
{
IActionResult result = null;
var user = await _userManager.Users
.Where(u => u.Id == id)
.FirstOrDefaultAsync();
if (user != null)
{
var listUserViewModel = new ListUserViewModel
{
Id = id,
Email = user.Email,
FirstName = user.FirstName,
LastName = user.LastName
};
var userRoles = await _userManager.GetRolesAsync(user);
var userRole = userRoles.FirstOrDefault();
if (userRole != null)
{
listUserViewModel.Role = userRole;
}
result = View(listUserViewModel);
}
else
{
result = View("NotFound");
}
return(result);
}
public List <ListUserViewModel> ListUsers()
{
var listUsers = (from user in surveyDBContext.Users
join project in surveyDBContext.ProjectInstances
on user.project_Id equals project.Project_Id
select new
{
Name = user.Email,
Project = project.ProjectName,
UserId = user.Id
}).ToList();
var model = new List <ListUserViewModel>();
foreach (var user in listUsers)
{
ListUserViewModel listUserViewModel = new ListUserViewModel
{
Email = user.Name,
ProjectInstance = user.Project,
Id = user.UserId
};
model.Add(listUserViewModel);
}
return(model);
}
public ActionResult Index(Int32 page = 1, String status = null, String role = null)
{
Int32 itemsPerPage = 4;
ListUserViewModel obj = new ListUserViewModel();
obj.Fill(page, itemsPerPage, status, role);
return(View(obj));
}
public ActionResult ListUser()
{
var users = db.Users.ToList();
var viewModel = new ListUserViewModel {
Users = users
};
return(View(viewModel));
}
//
// GET: /Manage/ListUsers
public ActionResult ListUsers()
{
var userList = UserManager.Users.ToList();
List <ListUserViewModel> modelList = new List <ListUserViewModel>();
foreach (var u in userList)
{
var modelObject = new ListUserViewModel(u);
modelList.Add(modelObject);
}
return(View(modelList.OrderBy(o => o.UserRoles)));
}
public ActionResult UserList()
{
BzureUser[] users = Actor.Public.AsUserManager().GetAllUsers();
ListUserViewModel ViewModel = new ListUserViewModel()
{
MasterViewModel = this.MasterViewModel,
Title = "用户列表",
Users = users,
Url = Url.RouteUrl("SecurityApp_User", new { action = "DeleteUser" })
};
return(Result(ViewModel));
}
public IActionResult ListUser()
{
var viewModel = new ListUserViewModel();
viewModel.Users = DbContext.Users
.Select(u => new ListUserViewModel.ListUser
{
Id = u.Id,
Email = u.Email,
UserName = u.UserName
}).ToList();
return(View(viewModel));
}
//
//GET: /Manage/ViewDetails/32432
public ActionResult ViewDetails(string id)
{
var db = new ApplicationDbContext();
try
{
var user = db.Users.First(u => u.Id == id);
var model = new ListUserViewModel(user);
return(View(model));
}
catch
{
return(RedirectToAction("ListUsers"));
}
}
public IActionResult All(string name)
{
var viewModel = new ListUserViewModel();
if (string.IsNullOrWhiteSpace(name))
{
viewModel.Users = _userManager.Users.ToList();
}
else
{
viewModel.Users = _userManager.Users
.Where(u => u.UserName.Contains(name))
.ToList();
}
return(View(viewModel));
}
public ActionResult ChoiceMerchantList()
{
var model = new ListUserViewModel();
var key = Request.QueryString["skeys"] ?? "";
var _sort = Request.QueryString["s_sort"] ?? "0";
model.CurrentPage = Convert.ToInt32(Request.QueryString["curr"] ?? "1");
model.PageSize = Convert.ToInt32(Request.QueryString["psize"] ?? "10");
int pageCount;
var sort = Convert.ToInt32(_sort);
string stype = !string.IsNullOrEmpty(Request["stype"]) ? Request["stype"] : "";
//string dept = System.Configuration.ConfigurationManager.AppSettings["RoleID"];
var lstWhere = new List <string>();
lstWhere.Add(string.Format("u_state={0}", 1));
///lstWhere.Add(string.Format(" u_role_id ={0}", ""+dept+"" ));
if (!string.IsNullOrEmpty(stype))
{
if (!string.IsNullOrEmpty(key))
{
if (stype == "1")
{
lstWhere.Add(string.Format("u_loginname like '%{0}%'", key));
}
if (stype == "2")
{
lstWhere.Add(string.Format("u_realname like '%{0}%'", key));
}
}
}
var where = lstWhere.Count > 0 ? string.Format(" WHERE {0}", string.Join(" AND ", lstWhere)) : "";
var strSql = string.Format("SELECT * FROM jmp_locuser {0}", where);
var strOrderBy = string.Format(" ORDER BY u_id {0}", sort == 0 ? "" : "DESC");
var lst = new JMP.BLL.BllCommonQuery().GetLists <JMP.MDL.jmp_locuser>(strSql, strOrderBy, model.CurrentPage, model.PageSize, out pageCount);
model.PageCount = pageCount;
if (lst != null && lst.Count > 0)
{
model.Users = lst;
}
model.ButtonsTags = GetVoidHtml();
ViewBag.stype = stype;
model.MerchantSearchModel.Sort = sort;
model.MerchantSearchModel.SearchKey = key;
return(View(model));
}
public IActionResult Create([FromBody] ListUserViewModel userDto)
{
// map dto to entity
var user = _mapper.Map <ListUserViewModel>(userDto);
try
{
// save
_userProvider.AddUser(user);
return(Ok(user.ID));
}
catch (Exception ex)
{
// return error message if there was an exception
return(BadRequest(new { message = ex.Message }));
}
}
public static string GenerateToken(ListUserViewModel user)
{
var tokenHandler = new JwtSecurityTokenHandler();
var key = Encoding.ASCII.GetBytes(Settings.Secret);
var tokenDescriptor = new SecurityTokenDescriptor
{
Subject = new ClaimsIdentity(new Claim[]
{
new Claim(ClaimTypes.Name, user.Id.ToString()),
new Claim(ClaimTypes.Role, user.Role.ToString())
}),
Expires = DateTime.UtcNow.AddDays(30),
SigningCredentials = new SigningCredentials(new SymmetricSecurityKey(key), SecurityAlgorithms.HmacSha256Signature)
};
var token = tokenHandler.CreateToken(tokenDescriptor);
return(tokenHandler.WriteToken(token));
}
//
// GET: /Account/User
public ActionResult Users()
{
var test = User.Identity.GetUserId();
var users = context.Users.ToList();
var model = new List <ListUserViewModel>();
foreach (var user in users)
{
var temp = new ListUserViewModel();
string str = "";
foreach (var role in UserManager.GetRoles(user.Id))
{
str = (str == "") ? role.ToString() : str + " - " + role.ToString();
}
temp.roles = str;
temp.users = user;
model.Add(temp);
}
return(View(model));
}
public async Task <IActionResult> Index(KeywordPagedQuery input)
{
var queryable = _userManager.Users;
if (!string.IsNullOrWhiteSpace(input.Q))
{
queryable = queryable.Where(
u => $"{u.Email}".Contains(input.Q) ||
$"{u.UserName}".Contains(input.Q) ||
$"{u.PhoneNumber}".Contains(input.Q) ||
// Comment: 如果不拼接成字符串报空引用错, Lewis Zou, 2018-12-10
$"{u.FamilyName}{u.GivenName}".Contains(input.Q) ||
$"{u.GivenName}{u.FamilyName}".Contains(input.Q)
);
}
var queryResult = await queryable.OrderBy(x => x.CreationTime).AsNoTracking()
.ToPagedListAsync(input.GetPage(), input.GetSize());
var userItemViewModels = new List <ListUserItemViewModel>();
foreach (var user in queryResult)
{
var dto = _mapper.Map <ListUserItemViewModel>(user);
dto.IsLockedOut = await _userManager.IsLockedOutAsync(user);
//TODO: 需要优化成一次查询
dto.Roles = string.Join("; ", await _userManager.GetRolesAsync(user));
userItemViewModels.Add(dto);
}
var pagedList = new StaticPagedList <ListUserItemViewModel>(userItemViewModels, queryResult.PageNumber,
queryResult.PageSize, queryResult.TotalItemCount);
var viewModel = new ListUserViewModel {
Users = pagedList, Keyword = input.Q
};
return(View(viewModel));
}
//
// GET: /Manage/ManageLogins
public virtual ActionResult ManageLogins(ManageMessageId?message)
{
var users = UserManager.Users.ToList();
var roles = new List <string>();
foreach (var user in users)
{
string str = "";
foreach (var role in UserManager.GetRoles(user.Id))
{
str = (str == "") ? role.ToString() : str + " - " + role.ToString();
}
roles.Add(str);
}
var model = new ListUserViewModel()
{
users = users.ToList(),
roles = roles.ToList()
};
return(View(model));
}
// GET: Employee
public ActionResult ListUser()
{
var listUser = _unitOfWork.UserRepositry.GetAllUsersWithProjectsAndTasksAndRolesAndFinanicalWithFilesWithPayments();
var roles = new List <string>();
// get all names of role for user ...
//i use this method because there is a role id inside user , not role name
foreach (var user in listUser)
{
string str = "";
foreach (var role in UserManager.GetRoles(user.Id))
{
str = (str == "") ? role.ToString() : str + " - " + role.ToString();
}
roles.Add(str);
}
var model = new ListUserViewModel()
{
Users = listUser,
RolesNames = roles.ToList()
};
return(View(model));
}
// GET: Agent
public ActionResult Index()
{
bool userLoggedin = (System.Web.HttpContext.Current.User != null) && System.Web.HttpContext.Current.User.Identity.IsAuthenticated;
if (userLoggedin)
{
var userid = System.Web.HttpContext.Current.User.Identity.GetUserId();
var roles = UserManager.GetRoles(userid).FirstOrDefault();
//if (roles != "SuperAdmin")
//{
// return RedirectToAction("Index", "CustomerRegistration");
//}
}
else
{
return(RedirectToAction("Index", "Agent"));
}
string url = HttpContext.Request.Url.Authority;
// Authority "localhost:49873" string
var branchList = InsuranceContext.Branches.All();
var query = "select Customer. * , AspNetUsers.Email, AgentLogo.LogoPath from Customer ";
query += " join AspNetUsers on Customer.UserID = AspNetUsers.Id ";
query += " join AspNetUserRoles on AspNetUserRoles.UserId = AspNetUsers.Id left join AgentLogo on Customer.Id = AgentLogo.CustomerId ";
query += " where AspNetUserRoles.RoleId ='" + _agent + "' and (IsActive is null or IsActive=1) order by Customer.Id desc ";
// var user1 = InsuranceContext.Query(query).Select
var user = InsuranceContext.Query(query).Select(x => new CustomerModel()
{
CustomerId = x.CustomerId,
UserID = x.UserID,
FirstName = x.FirstName,
LastName = x.LastName,
AddressLine1 = x.AddressLine1,
AddressLine2 = x.AddressLine2,
City = x.City,
NationalIdentificationNumber = x.NationalIdentificationNumber,
Zipcode = x.Zipcode,
Country = x.Country,
DateOfBirth = x.DateOfBirth,
Gender = x.Gender,
IsWelcomeNoteSent = x.IsWelcomeNoteSent,
IsPolicyDocSent = x.IsPolicyDocSent,
IsLicenseDiskNeeded = x.IsLicenseDiskNeeded,
IsOTPConfirmed = x.IsOTPConfirmed == null,
CreatedBy = x.CreatedBy,
ModifiedOn = x.ModifiedOn,
ModifiedBy = x.ModifiedBy,
IsActive = x.IsActive == null ? false : Convert.ToBoolean(x.IsActive),
CountryCode = x.Countrycode,
PhoneNumber = x.PhoneNumber,
IsCustomEmail = x.IsCustomEmail == null ? false : Convert.ToBoolean(x.IsCustomEmail),
EmailAddress = x.Email,
AgentLogo = x.LogoPath,
AgentWhatsapp = x.AgentWhatsapp,
// CompanyName = x.CompanyName,
// CompanyEmail = x.CompanyEmail,
// CompanyAddress = x.CompanyAddress,
// CompanyPhone = x.CompanyPhone,
// CompanyCity = x.CompanyCity,
// CompanyBusinessId = x.CompanyBusinessId,
// IsCorporate = x.IsCorporate,
// BranchId = x.BranchId,
// ALMId = x.ALMId,
Id = x.Id,
CreatedOn = x.CreatedOn,
Branch = GetAgentBranch(x.AgentBranch, branchList),
}).ToList();
ListUserViewModel lstUserModel = new ListUserViewModel();
lstUserModel.ListUsers = user;
return(View(lstUserModel));
}
public ListUserPage()
{
InitializeComponent();
BindingContext = new ListUserViewModel();
}
// GET: AgentStaff
public ActionResult Index()
{
int loggedCustomerId = 0;
bool userLoggedin = (System.Web.HttpContext.Current.User != null) && System.Web.HttpContext.Current.User.Identity.IsAuthenticated;
if (userLoggedin)
{
var userid = System.Web.HttpContext.Current.User.Identity.GetUserId();
var _customerData = InsuranceContext.Customers.All(where : $"UserId ='{userid}'").FirstOrDefault();
if (_customerData != null)
{
loggedCustomerId = _customerData.Id;
}
// var roles = UserManager.GetRoles(userid).FirstOrDefault();
//if (roles != "SuperAdmin")
//{
// return RedirectToAction("Index", "CustomerRegistration");
//}
}
else
{
return(RedirectToAction("Index", "Agent"));
}
var branchList = InsuranceContext.Branches.All();
var query = "select Customer. *, AspNetUsers.Email from Customer ";
query += " join AspNetUsers on Customer.UserID = AspNetUsers.Id ";
query += " join AspNetUserRoles on AspNetUserRoles.UserId = AspNetUsers.Id ";
query += " where AspNetUserRoles.RoleId ='" + _staff + "' and CreatedBy=" + loggedCustomerId + " and (IsActive is null or IsActive=1) ";
// var user1 = InsuranceContext.Query(query).Select
var user = InsuranceContext.Query(query).Select(x => new CustomerModel()
{
CustomerId = x.CustomerId,
UserID = x.UserID,
FirstName = x.FirstName,
LastName = x.LastName,
AddressLine1 = x.AddressLine1,
AddressLine2 = x.AddressLine2,
City = x.City,
NationalIdentificationNumber = x.NationalIdentificationNumber,
Zipcode = x.Zipcode,
Country = x.Country,
DateOfBirth = x.DateOfBirth,
Gender = x.Gender,
IsWelcomeNoteSent = x.IsWelcomeNoteSent,
IsPolicyDocSent = x.IsPolicyDocSent,
IsLicenseDiskNeeded = x.IsLicenseDiskNeeded,
IsOTPConfirmed = x.IsOTPConfirmed == null,
CreatedBy = x.CreatedBy,
ModifiedOn = x.ModifiedOn,
ModifiedBy = x.ModifiedBy,
IsActive = x.IsActive == null ? false : Convert.ToBoolean(x.IsActive),
CountryCode = x.Countrycode,
PhoneNumber = x.PhoneNumber,
IsCustomEmail = x.IsCustomEmail == null ? false : Convert.ToBoolean(x.IsCustomEmail),
EmailAddress = x.Email,
// CompanyName = x.CompanyName,
// CompanyEmail = x.CompanyEmail,
// CompanyAddress = x.CompanyAddress,
// CompanyPhone = x.CompanyPhone,
// CompanyCity = x.CompanyCity,
// CompanyBusinessId = x.CompanyBusinessId,
// IsCorporate = x.IsCorporate,
// BranchId = x.BranchId,
// ALMId = x.ALMId,
Id = x.Id,
CreatedOn = x.CreatedOn,
Branch = branchList.FirstOrDefault(c => c.Id == x.BranchId) == null ? "" : branchList.FirstOrDefault(c => c.Id == x.BranchId).BranchName
}).ToList();
List <CustomerModel> ListUserViewModel = new List <CustomerModel>();
ListUserViewModel lstUserModel = new ListUserViewModel();
lstUserModel.ListUsers = user;
return(View(lstUserModel));
}
public ListUserPage(User user)
{
InitializeComponent();
Model = new ListUserViewModel(user);
DataContext = Model;
}
private void Refresh_Click(object sender, RoutedEventArgs e)
{
Model = new ListUserViewModel(Model.User);
DataContext = Model;
}
public async Task <IActionResult> Edit(string id, ListUserViewModel model)
{
IActionResult result = null;
if (ModelState.IsValid)
{
var user = await _userManager.Users
.Where(u => u.Id == id)
.FirstOrDefaultAsync();
if (user != null)
{
user.Email = model.Email;
user.UserName = model.Email;
var updateUser = await _userManager.UpdateAsync(user);
if (updateUser.Succeeded)
{
var userRoles = await _userManager.GetRolesAsync(user);
var userRole = userRoles.FirstOrDefault();
if (!model.Role.Equals(userRole, StringComparison.OrdinalIgnoreCase))
{
var removeUserFromRole = await _userManager.RemoveFromRoleAsync(user, userRole);
if (removeUserFromRole.Succeeded)
{
var addUserToRole = await _userManager.AddToRoleAsync(user, model.Role);
if (addUserToRole.Succeeded)
{
result = RedirectToAction("Index", "User");
}
else
{
AddModelErrors(addUserToRole.Errors);
}
}
else
{
AddModelErrors(removeUserFromRole.Errors);
}
}
else
{
result = RedirectToAction("Index", "User");
}
}
else
{
AddModelErrors(updateUser.Errors);
}
}
else
{
result = View("NotFound");
}
}
if (result == null)
{
model.RoleItems = _roleConfig.GetRoles();
result = View(model);
}
return(result);
}
