private IQueryable <OrderEntry> _filterQuery(GetOrderEntryRequest request)
{
var orderQuery = _context.Order.Where(w => w._DeletedFlag != true);
var orderEntriesQuery = _context.OrderEntry.Where(w => w._DeletedFlag != true);
if (!string.IsNullOrEmpty(request.OrderName))
{
var orderId = orderQuery.Where(p => p.OrderName.ToLower() == request.OrderName.ToLower()).SingleOrDefault().Id;
orderEntriesQuery = _context.OrderEntry.Where(p => p.OrderId != null &&
p.OrderId == orderId);
}
if (!string.IsNullOrEmpty(request.Total))
{
orderEntriesQuery = _context.OrderEntry.Where(p => p.Price == Double.Parse(request.Total));
}
if (!string.IsNullOrEmpty(request.StartDate))
{
orderEntriesQuery = _context.OrderEntry.Where(p => p._CreatedDate >= Convert.ToDateTime(request.StartDate) &&
p._CreatedDate <= Convert.ToDateTime(request.EndDate));
}
orderEntriesQuery = orderEntriesQuery.OrderByDescending(o => o.CreatedBy);
return(orderEntriesQuery);
}
public ListResponse <OrderEntry> GetOrderEntry(GetOrderEntryRequest request)
{
var orderEntries = _filterQuery(request);
var displayData = orderEntries.Skip((request.Page - 1) * request.PageSize).Take(request.PageSize).ToList();
return(new ListResponse <OrderEntry>()
{
TotalItems = displayData.Count,
Data = displayData
});
}
public ListResponse <OrderEntry> GetOrderEntry([FromBody] GetOrderEntryRequest request)
{
return(_OrderEntryApplicationService.GetOrderEntry(request));
}
