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)); }