public async Task <PagedResultOutput <StudentSubjectProjectDto> > GetCredits(GetCreditsInput input) //1 { var totalcount = await _studentSubjectTimeRepository.CountAsync(x => !x.SubjectProject.IsDeleted); //1 var query = _studentSubjectTimeRepository.GetAll().Where(x => !x.SubjectProject.IsDeleted); if (!string.IsNullOrEmpty(input.KeyWord)) { query = query.Where(x => x.SubjectProject.Name.Contains(input.KeyWord) || x.Student.Name.Contains(input.KeyWord) /*|| x.SubjectProjectId.Contains(input.KeyWord)*/); } query = query.OrderBy(x => x.StudentId) .ThenBy(x => x.CreationTime) .Skip(input.Start).Take(input.PageSize); //1 var courses = await Task.FromResult(query.ToList()); return(new PagedResultOutput <StudentSubjectProjectDto>(totalcount, courses.MapTo <List <StudentSubjectProjectDto> >() )); }
public async Task <PagedResultOutput <StudentSubjectProjectDto> > GetSelfCredits(GetCreditsInput input) { var totalcount = await _studentSubjectTimeRepository.CountAsync(x => !x.SubjectProject.IsDeleted && x.StudentId == (AbpSession.UserId ?? 0)); //1 var query = _studentSubjectTimeRepository.GetAll().Where(x => !x.SubjectProject.IsDeleted); query = query.Where(x => x.StudentId == (AbpSession.UserId ?? 0)); query = query.OrderBy(x => x.StudentId) .ThenBy(x => x.CreationTime) .Skip(input.Start).Take(input.PageSize); //1 var courses = await Task.FromResult(query.ToList()); return(new PagedResultOutput <StudentSubjectProjectDto>(totalcount, //1 courses.MapTo <List <StudentSubjectProjectDto> >() //1 )); }