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