public PagedList <DeliveryListItemDto> ShipmentFilterPage(DeliveryListOptions options)
{
var queryable = _context.Documents
.AsNoTracking();
queryable = queryable.Where(d => d.DocumentType.Code == "OG");
if (options.FromLocationId != 0)
{
queryable = queryable.Where(d => d.LocationId == options.FromLocationId);
}
if (options.IsClosed != null)
{
queryable = queryable.Where(d => d.IsClosed == options.IsClosed);
}
return(queryable
.OrderByDescending(d => d.DocumentDate)
.Select(d => new DeliveryListItemDto
{
DeliveryNoteId = d.Id,
DeliveryNo = d.DocumentNo,
ToLocationName = "Muud hankijad",
FromLocationName = d.Location.Name,
DeliveryDate = d.DocumentDate,
StatusName = d.IsClosed ? "Suletud" : "Avatud"
})
.GetPagedList(options.CurrentPage, options.PageSize));
}
public PagedList <LocationDeliveryListItemDto> ReceiptFilterPage(DeliveryListOptions options)
{
var queryable = _context.Documents
.AsNoTracking()
.Where(d => d.DocumentType.Code == "VL");
if (options.ToLocationId != 0)
{
queryable = queryable.Where(d => d.LocationId == options.ToLocationId);
}
if (options.FromLocationId != 0)
{
queryable = queryable.Where(d => d.ToFromLocationId == options.FromLocationId);
}
else if (options.FromLocationTypeId != 0)
{
queryable = queryable.Where(d => d.ToFromLocation.LocationTypeId == options.FromLocationTypeId);
}
if (options.IsClosed != null)
{
queryable = queryable.Where(d => d.IsClosed == options.IsClosed);
}
return(queryable
.OrderByDescending(d => d.DocumentDate)
.Select(d => new LocationDeliveryListItemDto
{
DocumentId = d.Id,
DocumentNo = d.DocumentNo,
ToLocationName = d.Location.Name,
FromLocationName = d.ToFromLocation.Name,
DocumentDate = d.DocumentDate,
StatusName = d.IsClosed ? "Suletud" : "Avatud"
})
.GetPagedList(options.CurrentPage, options.PageSize));
}