public async Task <FilterResultModel <CustomerViewModel> > Handle(GetCustomersListQuery request, CancellationToken cancellationToken) { var sortBy = request.SortBy.Trim() != "" ? request.SortBy : "CustomerName"; var sortDirection = (request.SortDirection.ToUpper() == "DESCENDING") ? true : false; FilterResultModel <CustomerViewModel> result = new FilterResultModel <CustomerViewModel> (); var customer = _database.Customer .Select(CustomerViewModel.Projection) .Select(DynamicQueryHelper.GenerateSelectedColumns <CustomerViewModel> (request.SelectedColumns)) .AsQueryable(); if (request.Filter.Count() > 0) { customer = customer .Where(DynamicQueryHelper .BuildWhere <CustomerViewModel> (request.Filter)).AsQueryable(); } result.Count = customer.Count(); var PageSize = (request.PageSize == 0) ? result.Count : request.PageSize; var PageNumber = (request.PageSize == 0) ? 1 : request.PageNumber; result.Items = customer.OrderBy(sortBy, sortDirection) .Skip(PageNumber - 1) .Take(PageSize) .ToList(); return(result); }
public async Task <List <Core.Domain.Customers.Customer> > Handle(GetCustomersListQuery request, CancellationToken cancellationToken) { using (var dbFactory = _dbContextScopeFactory.Create()) { var db = dbFactory.DbContexts.Get <SmartFleetObjectContext>(); return(await db.Customers.ToListAsync(cancellationToken).ConfigureAwait(false)); } }
public async Task ShouldReturnAllCustomers() { var query = new GetCustomersListQuery(_context); var result = await query.Execute(); Assert.Equal(3, result.Count()); }
public void SetUp() { _mocker = new AutoMoqer(); _customer = Customer.Create(Id, Name); _customers = new List <Customer>() { _customer }; _mocker.GetMock <ICustomerRepository>() .Setup(p => p.GetAll()) .Returns(_customers.AsQueryable()); _query = _mocker.Create <GetCustomersListQuery>(); }
public async Task <IActionResult> SearchCustomers(GetCustomersListQuery model) { return(PartialView("_CustomersList", await _mediator.Send(model))); }
public async Task <ActionResult <FilterResultModel <CustomerViewModel> > > GetCustomersList([FromBody] GetCustomersListQuery query) { var customers = await _Mediator.Send(query); return(Ok(customers)); }
public async Task <List <CustomerDTO> > Handle(GetCustomersListQuery request, CancellationToken cancellationToken) { return(_mapper.Map <List <CustomerDTO> >(await _repository.GetAll())); }