public ExpenseDto GetExpenseById(GetExpenseByIdDto dto) { return(ctx.Expenses. Where(p => p.Id == dto.Id.ToGuid()). Include(p => p.Categories).ThenInclude(p => p.StoreCategory). Select(p => DtoBuilder.CreateExpenseDto(p)). FirstOrDefault()); }
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()); }