public Task <FilterResultModel <CustomerListViewModel> > Handle(GetCustomerListQuery request, CancellationToken cancellationToken)
{
var sortBy = request.SortBy.Trim() != "" ? request.SortBy : "FullName";
var sortDirection = (request.SortDirection.ToUpper() == "DESCENDING") ? false : true;
FilterResultModel <CustomerListViewModel> result = new FilterResultModel <CustomerListViewModel> ();
var customer = _database.Customer
.Select(CustomerListViewModel.Projection)
.Select(DynamicQueryHelper.GenerateSelectedColumns <CustomerListViewModel> (request.SelectedColumns))
.AsQueryable();
if (request.Filter.Count() > 0)
{
customer = customer
.Where(DynamicQueryHelper
.BuildWhere <CustomerListViewModel> (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(Task.FromResult <FilterResultModel <CustomerListViewModel> > (result));
}
public async Task ShouldReturnAllCustomers()
{
var options = new DbContextOptionsBuilder <NorthwindContext>()
.UseInMemoryDatabase()
.Options;
var context = new NorthwindContext(options);
context.Customers.AddRange(new [] {
new Customer {
CustomerId = "ADAM", CompanyName = "Adam Cogan"
},
new Customer {
CustomerId = "JASON", CompanyName = "Jason Taylor"
},
new Customer {
CustomerId = "BREND", CompanyName = "Brendan Richards"
},
});
context.SaveChanges();
var query = new GetCustomerListQuery(context);
var result = await query.Execute();
Assert.Equal(3, result.Count());
}
// [Authorize(Roles = Claims.Admin)]
public async Task <IActionResult> SearchFullCustDetails(GetCustomerListQuery query)
{
query.Offset = query.Limit * (query.CurrentPage - 1);
//return View(await _custManager.GetCustomerList(query));
var result = await _custManager.GetCustomerList(query);
return(View(result));
}
public IActionResult SearchCustToActivate(GetCustomerListQuery query)
{
query.Offset = query.Limit * (query.CurrentPage - 1);
//return View(await _custManager.GetCustomerList(query));
var result = _custManager.GetCustomerAndLoanList(query);
return(View(result));
}
public async Task ShouldReturnAllCustomers()
{
var query = new GetCustomerListQuery(_context);
var result = await query.Execute();
Assert.Equal(3, result.Count());
}
public Task <List <CustomerListModel> > Handle(GetCustomerListQuery request, CancellationToken cancellationToken)
{
return(_context.Customers.Select(c =>
new CustomerListModel
{
Id = c.CustomerId,
Name = c.CompanyName
}).ToListAsync(cancellationToken));
}
public Task <List <CustomerListVM> > Handle(GetCustomerListQuery request, CancellationToken cancellationToken)
{
var list = _context.Customers.Select(entity =>
new CustomerListVM()
{
CompanyName = entity.CompanyName,
NatureOfBusiness = entity.NatureOfBusiness,
CompanyStatus = "hard-coded status",
CompanyType = "hard-coded type"
}
).ToList();
return(Task.FromResult(list));
}
public Task <List <CustomerListModel> > Handle(GetCustomerListQuery request, CancellationToken cancellationToken)
{
return(_context.Customers.Select(c =>
new CustomerListModel
{
Id = c.CustomerId,
Title = c.Title,
Name = c.FirstName + " " + c.LastName,
Address = c.Address,
PostalCode = c.PostalCode,
Country = c.Country,
City = c.City,
Phone = c.Phone,
Region = c.Region,
DateOfBirth = c.DateOfBirth
}).ToListAsync(cancellationToken));
}
public async Task <IEnumerable <CustomerDetail> > Handle(GetCustomerListQuery request, CancellationToken cancellationToken)
{
var resource = CustomerRepository.GetAll();
if (resource == null)
{
throw new KeyNotFoundException("Record not found.");
}
return(resource.Select(x => new CustomerDetail()
{
CustomerId = x.CustomerId,
FirstName = x.FirstName,
LastName = x.LastName,
DateofBirth = x.DateofBirth
}));
}
public async Task<List<CustomerListModel>> Handle(GetCustomerListQuery request, CancellationToken cancellationToken)
{
var allCusotmers = (await _customerRepository.ListAllAsync()).OrderBy(x => x.CustomerName);
return _mapper.Map<List<CustomerListModel>>(allCusotmers);
}
public async Task <IActionResult> SearchWithdraw(GetCustomerListQuery query)
{
query.Offset = query.Limit * (query.CurrentPage - 1);
return(View(await _custManager.GetCustomerList(query)));
}
//////////////////////////////////////////////////////////////////////////////////////
//[Authorize(Policy = Claims.User)]
//public async Task<IActionResult> ActivateLoan(GetCustomerListQuery query)
//{
// //query.Offset = query.Limit * (query.CurrentPage - 1);
// ////return View(await _custManager.GetCustomerList(query));
// var result = await _custManager.GetCustomerList(query);
// return View();
//}
public async Task <IActionResult> TransactionDetails(GetCustomerListQuery query)
{
query.Offset = query.Limit * (query.CurrentPage - 1);
return(View(await _custManager.GetCustomerList(query)));
}
public async Task <ActionResult <FilterResultModel <CustomerListViewModel> > > GetAllCustomers([FromBody] GetCustomerListQuery query)
{
var Customers = await _Mediator.Send(query);
return(StatusCode(200, Customers));
}
public async Task <IActionResult> Search(GetCustomerListQuery query)
{
query.Offset = query.Limit * (query.CurrentPage - 1);
return(View(await Mediator.Send(query)));
}
