Example #1
0
        public async Task <QueryResult <Curriculum> > GetCurriculums(CurriculumQuery queryObj)
        {
            var result = new QueryResult <Curriculum>();

            var query = SchedulingDbContext
                        .Curriculums
                        .AsQueryable();

            query = query.ApplyCurriculumFiltering(queryObj);

            result.TotalItems = await query.CountAsync();

            result.Items = await query.ToListAsync();

            return(result);
        }
        public static IQueryable <Curriculum> ApplyCurriculumFiltering(this IQueryable <Curriculum> query, CurriculumQuery queryObj)
        {
            if (queryObj.DepartmentId.HasValue)
            {
                query = query.Where(c => c.DepartmentId == queryObj.DepartmentId);
            }

            return(query);
        }