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