public List <Models.Trainers.Trainer> GetAll(SearchTrainerParams searchTrainerParams) { var query = _context.AppUsers.AsQueryable() .Include(x => x.Trainer) .Where(x => x.Trainer != null); if (searchTrainerParams.UserStatus != null) { Database.UserStatus userStatus = (Database.UserStatus)(int) searchTrainerParams.UserStatus; query = query.Where(x => x.Status == userStatus); } if (!string.IsNullOrEmpty(searchTrainerParams.FirstName)) { query = query.Where(x => x.FirstName == searchTrainerParams.FirstName); } if (!string.IsNullOrEmpty(searchTrainerParams.LastName)) { query = query.Where(x => x.LastName == searchTrainerParams.LastName); } List <Models.Trainers.Trainer> trainers = query .Select(x => _mapper.Map <Models.Trainers.Trainer>(x)) .ToList(); return(trainers); }
public async Task loadDataGrid() { var userStatus = cbUserStatus.Text; UserStatus?status = fromString(userStatus); SearchTrainerParams searchTrainerParams = new SearchTrainerParams { UserStatus = status, FirstName = tbIme.Text, LastName = tbPrezime.Text }; _trainers = await _apiService.GetAll <List <Trainer> >(searchTrainerParams); dgvTrainers.DataSource = _trainers; dgvTrainers.Visible = true; }
public List <Models.Trainers.Trainer> Get([FromQuery] SearchTrainerParams searchTrainerParams) { _authenticationService.IsAuthorized(Request, new[] { "EMPLOYEE", "TRAINER", "CLIENT" }); return(_trainersService.GetAll(searchTrainerParams)); }