public async Task <ActionResult <IEnumerable <Model.AuthUser> > > Get([FromQuery] Model.SearchRequest.AuthUserSearchRequest search) { var authUsers = _context.AuthUser .Include(u => u.Role) .ToList(); #region search if (search != null) { if (search.qrCode != null) { authUsers = authUsers.Where(au => au.QrCode == search.qrCode).ToList(); } if (search.FirstName != null) { authUsers = authUsers.Where(au => au.FirstName.ToLower().StartsWith(search.FirstName.ToLower())).ToList(); } if (search.LastName != null) { authUsers = authUsers.Where(au => au.LastName.ToLower().StartsWith(search.LastName.ToLower())).ToList(); } if (search.UserName != null) { authUsers = authUsers.Where(au => au.UserName.ToLower().StartsWith(search.UserName.ToLower())).ToList(); } if (search.RoleId != null) { if (search.RoleId != 0) { authUsers = authUsers.Where(au => au.RoleId == search.RoleId).ToList(); } } //search throught groups... } #endregion search var result = _mapper.Map <List <Model.AuthUser> >(authUsers); return(result); }
async void loadDataGridView() { var search = new Model.SearchRequest.AuthUserSearchRequest() { FirstName = txtFirstName.Text, LastName = txtLastName.Text, UserName = txtUserName.Text, }; //if combobox did not load making sure its result is 0 if (cbType.Items.Count > 0) { search.RoleId = (int)cbType.SelectedValue; } else { search.RoleId = 0; } var users = await apiService_user.Get <List <Model.AuthUser> >(search); dgvUsers.DataSource = users; }