public async Task <Tasks[]> GetAllTasksAsync(int userId, StatusTaskType status, bool includeRemarks = false)
{
IQueryable <Tasks> query = _context.Tasks;
if (includeRemarks)
{
query = query
.Include(r => r.TaskRemarks);
}
query = query.OrderBy(t => t.CreationDate)
.Where(t => t.UserId == userId && t.Status == status);
return(await query.ToArrayAsync());
}
public async Task <Tasks[]> GetAllTasksAsyncByTitle(int userId, StatusTaskType status, string title, bool includeRemarks = false)
{
IQueryable <Tasks> query = _context.Tasks;
if (includeRemarks)
{
query = query
.Include(r => r.TaskRemarks);
}
query = query.OrderBy(t => t.CreationDate)
.Where(t => t.UserId == userId &&
t.Status == status &&
(t.Title.Contains(title) || t.Description.Contains(title)));
return(await query.ToArrayAsync());
}
