public List <ExpenseDto> GetExpensesByPage(GetExpensesByPageDto dto)
{
return(ctx.Expenses.
Skip((dto.PageNo - 1) * AdminSettings.Block).
Take(AdminSettings.Block).
Where(p => dto.UserId == null || p.UserId == dto.UserId).
Include(p => p.Categories).ThenInclude(p => p.StoreCategory).
Select(p => DtoBuilder.CreateExpenseDto(p)).
ToList());
}
public GetExpensesByPageResultDto Execute(GetExpensesByPageDto dto)
{
GetExpensesByPageResultDto result = new GetExpensesByPageResultDto {
Status = true, Page = new PageDto {
PageNo = dto.PageNo
}
};
List <ExpenseDto> lst = unit.Expense.GetExpensesByPage(dto);
result.Object = lst;
result.Page.Total = unit.Expense.GetExpensesByPageCount(dto);
result.Page.CurrentCount = lst.Count;
return(result);
}
public int GetExpensesByPageCount(GetExpensesByPageDto dto)
{
return(ctx.Expenses.
Where(p => dto.UserId == null || p.UserId == dto.UserId).
Count());
}
public ActionResult <GetExpensesByPageResultDto> GetExpensesByPage([FromQuery] GetExpensesByPageDto dto)
{
return(getExpensesByPage.Execute(dto));
}
