private SearchStatementModel PrepareSearchStatement(GridCommand command, UserSearchModel searchModel) { string whereStatement = string.Empty; IList <object> param = new List <object>(); HqlStatementHelper.AddLikeStatement("Code", searchModel.Code, HqlStatementHelper.LikeMatchMode.Start, "u", ref whereStatement, param); HqlStatementHelper.AddLikeStatement("FirstName", searchModel.FirstName, HqlStatementHelper.LikeMatchMode.Start, "u", ref whereStatement, param); HqlStatementHelper.AddLikeStatement("LastName", searchModel.LastName, HqlStatementHelper.LikeMatchMode.Start, "u", ref whereStatement, param); HqlStatementHelper.AddEqStatement("IsActive", searchModel.IsActive, "u", ref whereStatement, param); if (command.SortDescriptors.Count > 0) { if (command.SortDescriptors[0].Member == "LanguageDescription") { command.SortDescriptors[0].Member = "Language"; } } string sortingStatement = HqlStatementHelper.GetSortingStatement(command.SortDescriptors); SearchStatementModel searchStatementModel = new SearchStatementModel(); searchStatementModel.SelectCountStatement = selectCountStatement; searchStatementModel.SelectStatement = selectStatement; searchStatementModel.WhereStatement = whereStatement; searchStatementModel.SortingStatement = sortingStatement; searchStatementModel.Parameters = param.ToArray <object>(); return(searchStatementModel); }
public ActionResult List(GridCommand command, UserSearchModel searchModel) { SearchCacheModel searchCacheModel = this.ProcessSearchModel(command, searchModel); ViewBag.PageSize = base.ProcessPageSize(command.PageSize); return(View()); }
public IActionResult Grid(UserSearchModel model) { model = InitializeModel(model); var result = _employeeApiClient.GetUsers(model).Result; return(PartialView(result)); }
/// <summary> /// 取得使用者列表 /// </summary> /// <param name="searchModel"></param> /// <param name="pagination"></param> /// <returns></returns> public async Task <JsonResult> GetUserList(UserSearchModel searchModel, PaginationViewModel pagination) { ResWithPaginationViewModel res = new ResWithPaginationViewModel(); try { var result = await _userService.GetUserList(searchModel, pagination); res.Data = result.Data; res.Pagination = result.Pagination; res.MinDateTime = result.MinDateTime; res.MaxDateTime = result.MaxDateTime; res.Success = true; res.Message = "取得權限管理列表成功"; res.HttpStatusCode = System.Net.HttpStatusCode.OK; //await _backOperationService.CreateBackOperation(CurrendUserid, OperationName + "查詢", CurrendUserIp); } catch { res.Success = false; res.Message = "與伺服器連線發生錯誤"; res.HttpStatusCode = System.Net.HttpStatusCode.InternalServerError; } res.ResponseTime = DateTime.Now.ToString("yyyy-MM-dd hh:mm:ss"); return(Json(res, JsonRequestBehavior.AllowGet)); }
public User Find(UserSearchModel user) { var builder = Builders <User> .Filter; var filter = builder.Or(builder.Eq(m => m.UserCode, user.UserCode), builder.Eq(m => m.WxOpenId, user.WxOpenId)); return(_mongoHelper.Find(filter)); }
/// <summary> /// Prepare user search model /// </summary> /// <param name="searchModel">User search model</param> /// <returns>User search model</returns> public virtual UserSearchModel PrepareUserSearchModel(UserSearchModel searchModel) { if (searchModel == null) { throw new ArgumentNullException(nameof(searchModel)); } searchModel.UsernamesEnabled = _userSettings.UsernamesEnabled; searchModel.AvatarEnabled = _userSettings.AllowUsersToUploadAvatars; searchModel.DateOfBirthEnabled = _userSettings.DateOfBirthEnabled; searchModel.CompanyEnabled = _userSettings.CompanyEnabled; searchModel.PhoneEnabled = _userSettings.PhoneEnabled; searchModel.ZipPostalCodeEnabled = _userSettings.ZipPostalCodeEnabled; //search registered users by default var registeredRole = _userService.GetUserRoleBySystemName(NopUserDefaults.RegisteredRoleName); if (registeredRole != null) { searchModel.SelectedUserRoleIds.Add(registeredRole.Id); } //prepare available user roles _aclSupportedModelFactory.PrepareModelUserRoles(searchModel); //prepare page parameters searchModel.SetGridPageSize(); return(searchModel); }
public UserSearchModel GetSearchForm(UsersSettings settings) { var model = new UserSearchModel(); var userData = settings.UserData; model.EnableBtnList = new BsSelectList <YesNoEnum?>(); model.EnableBtnList.ItemsFromEnum(typeof(YesNoEnum)); model.EnableBtnList.SelectedValues = YesNoEnum.All; model.RoleBtnList = new BsSelectList <UserRoles?>(); if (userData.IsDoctor) { model.RoleBtnList.ItemsFromEnum(typeof(UserRoles), UserRoles.Admin); } else { model.RoleBtnList.ItemsFromEnum(typeof(UserRoles)); } model.RoleBtnList.SelectedValues = UserRoles.All; model.GenderBtnList = new BsSelectList <GenderEnum?>(); model.GenderBtnList.ItemsFromEnum(typeof(GenderEnum)); model.GenderBtnList.SelectedValues = GenderEnum.Both; return(model); }
public ActionResult InitDataTable(UserSearchModel model) { var query = _userService.GetAllUser(model.UserName, model.Email, model.Phone, model.SelectedRoles, model.iDisplayStart / model.iDisplayLength, model.iDisplayLength); var filterResult = query.Select(t => new UserListModel { Id = t.Id, UserName = t.UserName, Email = t.Email, Phone = t.Phone, Active = t.Active, RegisterDate = WebHelper.ConvertToUserTime(t.RegisterDate) }); int sortId = model.iDisplayStart + 1; var result = from t in filterResult select new[] { t.Id.ToString(), sortId++.ToString(), t.UserName, t.Email, t.Phone.ToString(), t.RegisterDate.ToString(), t.Active.ToString(), t.Id.ToString() }; return(DataTableJsonResult(model.sEcho, model.iDisplayStart, query.TotalCount, query.TotalCount, result)); }
public ActionResult Index(UserSearchModel search) { try { var users = _userService.GetUsers(1, _webHelper.ExcelSheetMaxRows, search.WarehouseId, (search.UserId == null) ? 0 : search.UserId.Value); var table = new DataTable(); table.Columns.Add(_resourceManager.GetString("User.Name")); table.Columns.Add(_resourceManager.GetString("User.FullName")); table.Columns.Add(_resourceManager.GetString("User.Warehouse")); table.Columns.Add(_resourceManager.GetString("User.Role")); foreach (var user in users) { table.Rows.Add(new object[] { user.UserName, user.FullName, user.Warehouse.WarehouseName, user.Role.Name, }); } var excelData = _exportManager.ExportExcelFromDataTable(table, "Users", null); return(File(excelData, FileContentType.EXCEL, "Users.xlsx")); } catch (Exception ex) { ErrorNotification(_resourceManager.GetString("Error" + ex.Message)); return(Redirect(Request.RawUrl)); } }
public ActionResult SearchUsers(string request, string university, string faculty, string city, int?course, int?minage, int?maxage, int?minrating, int?maxrating) { List <UserModel> users = _unitOfWork.Users.SearchUsers(request, university, faculty, city, course, minage, maxage, minrating, maxrating); _searchUser = _unitOfWork.Users.UpdateUserSearch(request, university, faculty, city, course, minage, maxage, minrating, maxrating); ViewBag.UserSearch = _searchUser; UserModel user = Session["CurrentUser"] as UserModel; ViewBag.CurrentUser = user; ViewBag.Users = users; List <CityModel> cities = _unitOfWork.Cities.GetCities(); ViewBag.Cities = cities; List <UniversityModel> universities = _unitOfWork.Universities.GetUniversities(); ViewBag.Universities = universities; List <UniversityFacultyModel> faculties = universities.ElementAt(0).Faculties; ViewBag.Faculties = faculties; return(View("All")); }
private UserDto GetUserForDetails(int userId, bool loadManager) { var userSearchModel = new UserSearchModel { PageSize = int.MaxValue, SortColumn = "Name" }; var user = _employeeApiClient.GetUser(userId).Result; if (loadManager) { var managers = _employeeApiClient.GetUsers(userSearchModel).Result.UserSearchResult.Where(x => x.Id != userId).ToList(); user.ManagerSelectList = SelectedListHelper.GetSelectListForManager(managers, user.ManagerId?.ToString()); } var linkedUserApplicationIds = user.Applications.Select(x => x.ApplicationId).ToList(); var userGroupSearch = new UserGroupSearchModel { PageSize = int.MaxValue, SortColumn = "Name" }; userGroupSearch = _employeeApiClient.GetUserGroups(userGroupSearch).Result; user.UserGroupSelectList = SelectedListHelper.GetSelectListForUserGroup(userGroupSearch.UserGroupSearchResult, user.UserGroupId?.ToString()); var searchWebApplication = new WebApplicationSearchModel { PageSize = int.MaxValue, SortColumn = "Name", SortDirection = "Asc" }; searchWebApplication = _employeeApiClient.GetWebApplications(searchWebApplication).Result; user.ApplicationSelectList = SelectedListHelper.GetApplicationTaskSelectList(searchWebApplication.WebApplicationSearchResult, linkedUserApplicationIds); user.LinkedUserApplicationIds = linkedUserApplicationIds.Select(x => x.ToString()).ToList(); return(user); }
public HttpResponseMessage GetNearByUser([FromBody] UserSearchModel model) { try { LogRequest(model); if (!ModelState.IsValid) { return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ModelState)); } List <SearchedUser> searchedUsers = new NeeoSearch().FindUserByName(model.UId, model.SearchText, model.Latitude, model.Longitude, model.IsCurrentLocation); return(Request.CreateResponse(HttpStatusCode.OK, new { SearchedUsers = searchedUsers })); } catch (ApplicationException applicationException) { return(Request.CreateErrorResponse((HttpStatusCode)Convert.ToInt16(applicationException.Message), NeeoDictionaries.HttpStatusCodeDescriptionMapper[Convert.ToInt16(applicationException.Message)])); } catch (Exception exception) { Logger.LogManager.CurrentInstance.ErrorLogger.LogError(System.Reflection.MethodBase.GetCurrentMethod().GetType(), exception.Message, exception); return(Request.CreateResponse(HttpStatusCode.InternalServerError)); } }
public IActionResult UsersList([FromQuery] UserSearchModel searchModel) { var negate = searchModel.RoleIds == null; searchModel.RoleIds = searchModel.RoleIds ?? new int[] { _roleService.FirstOrDefault(x => x.SystemName == SystemRoleNames.Visitor)?.Id ?? 0 }; var users = _userService.GetUsers(searchModel.SearchPhrase, searchModel.RoleIds, null, SortOrder.Ascending, searchModel.Current, searchModel.RowCount, out int totalMatches, negate); //convert to model var userModels = users.Select(x => { var userModel = _modelMapper.Map <UserModel>(x); userModel.Roles = x.Roles?.Select(y => _modelMapper.Map <RoleModel>(y)).ToList(); return(userModel); }).ToList(); var roles = _roleService.Get(x => true); var roleModels = roles.Select(x => _modelMapper.Map <RoleModel>(x)).ToList(); return(R.Success.With("users", userModels) .With("roles", roleModels) .WithGridResponse(totalMatches, searchModel.Current, searchModel.RowCount) .Result); }
public async Task <PagedModel <SysUserDto> > SearchUsers(UserSearchModel searchModel) { Expression <Func <SysUser, bool> > whereCondition = x => x.Status > 0; if (!string.IsNullOrWhiteSpace(searchModel.Account)) { whereCondition = whereCondition.And(x => x.Account.Contains(searchModel.Account)); } if (!string.IsNullOrWhiteSpace(searchModel.Name)) { whereCondition = whereCondition.And(x => x.Name.Contains(searchModel.Name)); } var pagedModel = await _userRepository.PagedAsync(searchModel.PageIndex, searchModel.PageSize, whereCondition, x => x.ID); var result = _mapper.Map <PagedModel <SysUserDto> >(pagedModel); if (result.Count > 0) { var depts = await _deptRepository.SelectAsync(x => true); var roles = await _roleRepository.SelectAsync(x => true); foreach (var user in result.Data) { user.DeptName = depts.FirstOrDefault(x => x.ID == user.DeptId)?.FullName; var roleIds = string.IsNullOrWhiteSpace(user.RoleId) ? new List <long>() : user.RoleId.Split(',', StringSplitOptions.RemoveEmptyEntries).Select(x => long.Parse(x)); user.RoleName = string.Join(',', roles.Where(x => roleIds.Contains(x.ID)).Select(x => x.Name)); } } return(result); }
public virtual IActionResult UserList(UserSearchModel searchModel) { //prepare model var model = _userModelFactory.PrepareUserListModel(searchModel); return(Json(model)); }
private string GetFilterStringForGetUsersWithTasks(UserSearchModel searchModel) { var filterString = string.Empty; if (searchModel != null) { if (searchModel.ApplicationId > 0) { filterString = ODataFilterConstant.Filter + $"Applications/any(ap: ap/ApplicationId eq {searchModel.ApplicationId})"; } else if (searchModel.Id > 0) { filterString = ODataFilterConstant.Filter + $"Id eq {searchModel.Id}"; } if (!string.IsNullOrWhiteSpace(searchModel.FilterText)) { if (!string.IsNullOrWhiteSpace(filterString)) { filterString += $" and contains(Name,'{searchModel.FilterText}') eq true"; } else { filterString = ODataFilterConstant.Filter + $"contains(Name,'{searchModel.FilterText}') eq true"; } } filterString += ODataFilterConstant.Expand + $"{ nameof(UserDto.Tasks)}($expand=Task,TaskType)"; AddPageSizeNumberAndSortingInFilterString(searchModel, ref filterString); } return(filterString); }
public JsonResult GetUsers(UserSearchModel searchModel) { var result = new ResponseResult(); try { var userService = new UserService(); if (userService.SearchEnabled(LoginUser.UserId, searchModel)) { var pager = new UserService().GetUsers(searchModel); // 在线用户 var onlienUsers = PKBag.OnlineUserRecorder.GetUserList(); foreach (var user in pager.Items) { user.IsOnline = onlienUsers.Where(u => u.UserName == user.UserName).Any(); } result.Data = pager; } else { result.Data = new PagerResult <User>(); } } catch (Exception ex) { result.Success = false; result.Message = MessageConst.System_Error; _logger.Info(ex); } return(Json(result)); }
private void UpdateUsersGrid(UserSearchModel search = null) { dgvUsers.Rows.Clear(); var query = _context.Users.Where(u => u.Deleted == false); if (search != null) { if (!string.IsNullOrEmpty(search.LastName)) { query = query.Where(u => u.LastName.Contains(search.LastName)); } if (!string.IsNullOrEmpty(search.FirstName)) { query = query.Where(u => u.FirstName.Contains(search.FirstName)); } } foreach (var item in query) { var pathTmp = Path.Combine(Directory.GetCurrentDirectory(), "images", item.Image); if (File.Exists(pathTmp)) { var imageBytes = File.ReadAllBytes(pathTmp); using (MemoryStream ms = new MemoryStream(imageBytes)) { dgvUsers.Rows.Add(new object[] { item.Id, item.FirstName, item.LastName, Image.FromStream(ms), item.MobilePhoneNumber, item.DateRegistered, item.LastLoginDate, item.Email }); } } } }
//show ra table nhân viên public ActionResult List(UserSearchModel searchModel) { var pagedList = UserSevice.Search(searchModel.TenNV, searchModel.TaiKhoan, searchModel.SoDT, searchModel.ChucVu, searchModel.PageIndex); pagedList.SearchModel = searchModel; return(PartialView("_List", pagedList)); }
/// <summary> /// Prepare user search model /// </summary> /// <param name="searchModel">User search model</param> /// <returns>User search model</returns> public virtual UserSearchModel PrepareUserSearchModel(UserSearchModel searchModel) { if (searchModel == null) { throw new ArgumentNullException(nameof(searchModel)); } //search registered users by default searchModel.SelectedUserRoleIds.Add((int)Role.User); //prepare available user roles var availableRoles = new[] { Role.User, Role.Admin }; searchModel.AvailableUserRoles = availableRoles.Select(role => new SelectListItem { Text = role.ToString(), Value = ((int)role).ToString(), Selected = searchModel.SelectedUserRoleIds.Contains((int)role) }).ToList(); //prepare page parameters searchModel.SetGridPageSize(); return(searchModel); }
/// <summary> /// Searches the user. /// </summary> /// <param name="model">The model.</param> /// <returns></returns> public async Task <List <UserSearchViewModel> > SearchUser(UserSearchModel model) { const string defaultSort = "Name ASC"; var sortType = model.IsSortDesc ? "DESC" : "ASC"; var sortField = ValidateUtils.IsNullOrEmpty(model.SortField) ? defaultSort : $"{model.SortField} {sortType}"; var query = _userProfileRepository.GetManyAsNoTracking(x => ValidateUtils.IsNullOrEmpty(model.Name) || x.FirstName.ToUpper().Contains(model.Name.ToUpper()) && ValidateUtils.IsNullOrEmpty(model.Name) || x.LastName.ToUpper().Contains(model.Name.ToUpper()) && ValidateUtils.IsNullOrEmpty(model.Phone) || x.Phone.Equals(model.Name) && ValidateUtils.IsNullOrEmpty(model.Email) || x.Email.ToUpper().Contains(model.Email.ToUpper())) .Select(x => new UserSearchViewModel { Address = x.Address, UserId = x.UserProfileId, Email = x.Email, Name = $"{x.FirstName} {x.LastName}" }); var result = query.Skip((model.Page - 1) * model.PageSize) .Take(model.PageSize); return(result.ToList()); }
public async Task <ActionResult <List <UserModel> > > Users([FromQuery] UserSearchModel model) { var users = _userManager.Users; if (model.Text is not null or "") { users = users.Where(u => u.Email.Contains(model.Text) || u.UserName.Contains(model.Text)); } if (model.Page > 1) { users = users.Skip((model.Page - 1) * MaxPageSize); } // pagination var usersList = await users .OrderBy(u => u.Id) .Take(MaxPageSize) .ToListAsync(); // query everything and return it var final = new List <UserModel>(); foreach (var user in usersList) { final.Add(new() { Id = user.Id, Email = user.Email, UserName = user.UserName, Roles = await _userManager.GetRolesAsync(user) }); } return(final); }
public async Task <IActionResult> ApplicationUserGrid(UserSearchModel model) { model = InitializeUserModel(model, model.ApplicationId); var result = await _employeeFacadeApiClient.GetUsers(model); return(PartialView(result)); }
public async Task <List <SelectListItem> > GetUserSelectList(List <int> listRoleId = null) { try { var userSelectList = new List <SelectListItem>(); var model = new UserSearchModel { RoleIds = listRoleId, PageSize = -1 }; var req = new BaseRequest <UserSearchModel>(model); var url = _apiServer.AQIdentityAdminApi.GetCurrentServer() + _adminPortalApiUrl.IdentityAdminAPI.SearchAccounts; var res = await _aPIExcute.PostData <PagedListClientModel <UserViewModel>, UserSearchModel>(url, HttpMethodEnum.POST, null, req, Token); if (res.IsSuccessStatusCode) { var listUser = res.ResponseData; userSelectList = listUser.Data.Select(x => new SelectListItem(x.GetFullName(), x.UserId)).ToList(); return(userSelectList); } return(userSelectList); } catch { throw; } }
public JsonResult GetOnlineUsers(UserSearchModel searchModel) { var result = new ResponseResult(); try { var skip = (searchModel.PageIndex - 1) * searchModel.PageSize; var onlienUsers = searchModel.UserType > 0 ? PKBag.OnlineUserRecorder.GetUserList().Where(u => u.UserDegree == searchModel.UserType).OrderBy(u => u.UserName).Skip(skip).Take(searchModel.PageSize).ToList() : PKBag.OnlineUserRecorder.GetUserList().OrderBy(u => u.UserName).Skip(skip).Take(searchModel.PageSize).ToList(); //var userNames = onlienUsers.Select(u => u.UserName).ToList(); //var users = new UserService().GetUsers(userNames); var pager = new PagerResult <App.Core.OnlineStat.OnlineUser>(); pager.Items = onlienUsers; pager.RowCount = PKBag.OnlineUserRecorder.GetUserList().Count; pager.PageCount = pager.RowCount % searchModel.PageSize == 0 ? pager.RowCount / searchModel.PageSize : pager.RowCount / searchModel.PageSize + 1; result.Data = pager; } catch (Exception ex) { result.Success = false; result.Message = MessageConst.System_Error; _logger.Info(ex); } return(Json(result)); }
public IEnumerable <UserModel> SearchUser(UserSearchModel search, out int count) { IQueryable <UserEntity> userMatched; if (string.IsNullOrEmpty(search.Keyword)) { userMatched = dbContext.Users; } else { userMatched = dbContext.Users.Where( u => u.Username.ToLower().Contains(search.Keyword.ToLower()) || u.FullName.ToLower().Contains(search.Keyword.ToLower()) || u.Phone.ToLower().Contains(search.Keyword.ToLower()) || u.Email.ToLower().Contains(search.Keyword.ToLower()) ); } count = userMatched.Count(); return(userMatched.OrderBy(u => u.Username) .Skip((search.Page - 1) * search.RowPerPage) .Take(search.RowPerPage) .Select(u => new UserModel { Username = u.Username, FullName = u.FullName, Phone = u.Phone, Email = u.Email, })); }
public async Task <IActionResult> Search([FromQuery] string q = "") { if (q == null) { q = ""; } UserSearchModel model = new UserSearchModel(); model.SearchString = q; IQueryable <User> searchQuery = Db.Users; bool orderDescending = true; foreach (string sub in q.Split(' ', StringSplitOptions.RemoveEmptyEntries)) { if (sub.StartsWith("order:")) { string order = sub.Substring("order:".Length); if (Regex.IsMatch(order, ".*asc.*")) { orderDescending = false; } } else if (sub.StartsWith("role:")) { string role = sub.Substring("role:".Length); searchQuery = searchQuery.Where(x => x.Role.Name.Contains(role, StringComparison.InvariantCultureIgnoreCase)); } else if (sub.StartsWith("!role:")) { string role = sub.Substring("!role:".Length); searchQuery = searchQuery.Where(x => !x.Role.Name.Contains(role, StringComparison.InvariantCultureIgnoreCase)); } else if (sub.StartsWith("!")) { searchQuery = searchQuery.Where(x => !x.FullName.Contains(sub.Substring(1), StringComparison.InvariantCultureIgnoreCase) && !x.Username.Contains(sub.Substring(1), StringComparison.InvariantCultureIgnoreCase)); } else { searchQuery = searchQuery.Where(x => x.FullName.Contains(sub, StringComparison.InvariantCultureIgnoreCase) || x.Username.Contains(sub, StringComparison.InvariantCultureIgnoreCase)); } } if (orderDescending) { searchQuery = searchQuery.OrderByDescending(x => x.Id); } else { searchQuery = searchQuery.OrderBy(x => x.Id); } model.FoundUsers = await searchQuery .ToArrayAsync(); return(View(model)); }
public void UpdateUsersGrid(UserSearchModel search = null) { dataGridViewUsers.Rows.Clear(); var query = context.Users.Where(u => u.Deleted == false); if (search != null) { if (!string.IsNullOrEmpty(search.LastName)) { query = query.Where(u => u.LastName.Contains(search.LastName)); } if (!string.IsNullOrEmpty(search.FirstName)) { query = query.Where(u => u.FirstName.Contains(search.FirstName)); } } foreach (var item in query) { try { //if (!item.Deleted) //{ //var pathTmp = Path.Combine(Directory.GetCurrentDirectory(), "user_images", item.UserImage); if (item.ToString() != "") { DataGridViewColumn column = dataGridViewUsers.Columns[8]; column.AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill; ((DataGridViewImageColumn)dataGridViewUsers.Columns[8]).ImageLayout = DataGridViewImageCellLayout.Stretch; int k = 0; using (MemoryStream ms = new MemoryStream(item.UserImage)) { try { dataGridViewUsers.Rows.Add(new object[] { item.Id, item.FirstName, item.LastName, item.MobilePhoneNumber, item.DateRegistered, item.LastLoginDate, item.Deleted, item.Email, Image.FromStream(ms) }); dataGridViewUsers.Rows[k++].Height = 50; dataGridViewUsers.Rows[k].Height = 50; } catch (Exception) { dataGridViewUsers.Rows.Add(new object[] { item.Id, item.FirstName, item.LastName, item.MobilePhoneNumber, item.DateRegistered, item.LastLoginDate, item.Email, item.Deleted }); dataGridViewUsers.Rows[k++].Height = 50; } } } else { dataGridViewUsers.Rows.Add(new object[] { item.Id, item.FirstName, item.LastName, item.MobilePhoneNumber, item.DateRegistered, item.LastLoginDate, item.Email, item.Deleted }); } } catch (Exception) { } } }
/// <summary> /// Get user by filter /// </summary> /// <param name="searchModel"></param> /// <returns></returns> public List <Vw_Core_User> SearchUser(UserSearchModel searchModel) { using (var db = _connectionFactory.Open()) { //Filter user by customer type return(db.Select <Vw_Core_User>().Where(u => (searchModel.Status == -1 || u.Status == searchModel.Status)).ToList()); } }
public ActionResult Users(UserSearchModel model, string orderBy, int page = 1) { var users = _userService.SearchUsers(model); var sortedUsers = GetSortedUsers(users, orderBy); var userViewModel = CreateUserViewModel(sortedUsers, page); return(View(userViewModel)); }
public ActionResult ManagerLookup() { var userSearchModel = new UserSearchModel(); return PartialView("ManagerLookup", userSearchModel); }
public IEnumerable<UserViewModel> SearchUsers(UserSearchModel searchModel, string userId) { var usersDb = _userRepository.GetUsers(userId).ToList(); var userList = ModelConverters.ToUserViewModelList(usersDb); var result = new List<UserViewModel>(); if (string.IsNullOrEmpty(searchModel.Country) == false) { result.AddRange(userList.Where(m => m.Country != null && m.Country.ToLower().Contains(searchModel.Country.ToLower()))); } if (string.IsNullOrEmpty(searchModel.City) == false) { result.AddRange(userList.Where(m => m.City != null && m.City.ToLower().Contains(searchModel.City.ToLower()))); } if (string.IsNullOrEmpty(searchModel.Genres) == false) { result.AddRange(userList.Where(m => m.BestGenres != null && m.BestGenres.ToLower().Contains(searchModel.Genres.ToLower()))); } if (string.IsNullOrEmpty(searchModel.Atrists) == false) { result.AddRange( userList.Where(m => m.BestVocalist != null && m.BestVocalist.ToLower().Contains(searchModel.Atrists.ToLower()) || m.BestForeignArtist != null && m.BestForeignArtist.ToLower().Contains(searchModel.Atrists.ToLower()) || m.BestNativeArtist != null && m.BestNativeArtist.ToLower().Contains(searchModel.Atrists.ToLower())) ); } if (string.IsNullOrEmpty(searchModel.FirstName) == false) { result.AddRange(userList.Where(m => m.FirstName != null && m.FirstName.ToLower().Contains(searchModel.FirstName.ToLower()))); } if (string.IsNullOrEmpty(searchModel.LastName) == false) { result.AddRange(userList.Where(m => m.LastName != null && m.LastName.ToLower().Contains(searchModel.LastName.ToLower()))); } if (searchModel.BirthDate.HasValue) { result.AddRange(userList.Where(m => m.BirthDate.Date == searchModel.BirthDate.Value.Date)); } return result; }
public IActionResult Search(UserSearchModel model) { return Json(_userDomain.GetAll().ToPaginated(model)); }
public ActionResult Search(UserSearchModel model) { model.Search(); return View(model); }
public ActionResult ManagerLookup(UserSearchModel userSearchModel) { userSearchModel.Search(); return PartialView("ManagerLookup", userSearchModel); }
public ActionResult Search() { var model = new UserSearchModel(); return View(model); }
// public ActionResult UserLookup() // { // var userSearchModel = new UserSearchModel(); // return PartialView("UserLookup", userSearchModel); // } public ActionResult UserLookup(string idName, string valueName) { var userSearchModel = new UserSearchModel { LookupInputId = idName, LookupInputIdValue = valueName }; return PartialView("UserLookup", userSearchModel); }