public List <Models.Clients.Client> GetAll(SearchClientParams searchClientParams)
{
var query = _context.AppUsers.AsQueryable()
.Include(x => x.Client)
.ThenInclude(x => x.MembershipPayments)
.Where(x => x.Client != null);
if (!string.IsNullOrEmpty(searchClientParams.FirstName))
{
query = query.Where(x => x.FirstName == searchClientParams.FirstName);
}
if (!string.IsNullOrEmpty(searchClientParams.LastName))
{
query = query.Where(x => x.LastName == searchClientParams.LastName);
}
List <Models.Clients.Client> clients = query
.Select(x => CalculateUserStatus(x))
.Select(x => _mapper.Map <Models.Clients.Client>(x))
.ToList();
if (searchClientParams.UserStatus != null)
{
clients = clients
.Where(x => x.Status == searchClientParams.UserStatus)
.ToList();
}
return(clients);
}
public async Task loadDataGrid()
{
var userStatus = cbUserStatus.Text;
UserStatus?status = fromString(userStatus);
SearchClientParams searchClientParams = new SearchClientParams
{
UserStatus = status,
FirstName = tbIme.Text,
LastName = tbPrezime.Text
};
_clients = await _apiService.GetAll <List <Client> >(searchClientParams);
dgvClients.DataSource = _clients;
dgvClients.Visible = true;
}
public List <Models.Clients.Client> Get([FromQuery] SearchClientParams searchClientParams)
{
_authenticationService.IsAuthorized(Request, new[] { "EMPLOYEE", "TRAINER" });
return(_clientsService.GetAll(searchClientParams));
}
