//public async Task<CourseTimeDto> GetCourseTime(int id) //{ // var a = await _courseTimeRepository.FirstOrDefaultAsync(x => x.Id == id); // return a.MapTo<CourseTimeDto>(); //throw new NotImplementedException(); //var totalcount = await _courseTimeRepository.CountAsync(x => !x.TeacherCourse.Course.SubjectProject.IsDeleted); //var query = _courseTimeRepository.GetAll().Where(x => !x.TeacherCourse.Course.SubjectProject.IsDeleted); //query = query.Where(x => x.TeacherCourse.TeacherId == id) // .OrderBy(x => x.CreationTime); /* .Skip(input.Start).Take(input.PageSize); */ //1 //var courses = await Task.FromResult(query.ToList()); //return new PagedResultOutput<CourseTimeDto>(totalcount, //1 // courses.MapTo<List<CourseTimeDto>>() //1 //); //return _courseTimeRepository.FirstOrDefault(x => x.Id == id).MapTo<CourseTimeDto>(); //} public async Task <PagedResultOutput <CourseTimeDto> > GetCourseTime(GetSSCourseTimeInput input) { var totalcount = await _courseTimeRepository.CountAsync(x => !x.TeacherCourse.Course.SubjectProject.IsDeleted); var query = _courseTimeRepository.GetAll().Where(x => !x.TeacherCourse.Course.SubjectProject.IsDeleted); query = query.Where(x => x.TeacherCourse.TeacherId == input.TeacherId) .OrderBy(x => x.CreationTime) .Skip(input.Start).Take(input.PageSize); //1 var courses = await Task.FromResult(query.ToList()); return(new PagedResultOutput <CourseTimeDto>(totalcount, //1 courses.MapTo <List <CourseTimeDto> >() //1 )); //return _courseTimeRepository.FirstOrDefault(x => x.Id == id).MapTo<CourseTimeDto>(); }
//public async Task<ListResultOutput<CourseListDto>> GetCourses(GetCoursesInput input) public async Task <PagedResultOutput <CourseListDto> > GetCourses(GetSSCourseTimeInput input) //1 { var totalcount = await _courseRepository.CountAsync(x => !x.SubjectProject.IsDeleted); //1 var query = _courseRepository.GetAll().Where(x => !x.SubjectProject.IsDeleted); if (!string.IsNullOrEmpty(input.KeyWord)) { query = query.Where(x => x.SubjectProject.Name.Contains(input.KeyWord) || x.Name.Contains(input.KeyWord) /*|| x.SubjectProjectId.Contains(input.KeyWord)*/); } //if (!string.IsNullOrEmpty(input.KeyWord)) //{ // query = query.Where(x => // x.Name.Contains(input.KeyWord)); //} if (input.SubjectProjectId.HasValue) { query = query.Where(x => x.SubjectProjectId == input.SubjectProjectId.Value); //9 } query = query.OrderBy(x => x.CreationTime) //.Take(input.PageSize).Skip(input.Start); .Skip(input.Start).Take(input.PageSize); //1 var courses = await Task.FromResult(query.ToList()); //return new ListResultOutput<CourseListDto>( // courses.MapTo<List<CourseListDto>>() return(new PagedResultOutput <CourseListDto>(totalcount, //1 courses.MapTo <List <CourseListDto> >() //1 )); }
public async Task <PagedResultOutput <CourseTimeDto> > GetTeacherCourseTables(GetSSCourseTimeInput input) { var totalcount = await _courseTimeRepository.CountAsync(x => !x.TeacherCourse.Course.SubjectProject.IsDeleted); var query = _courseTimeRepository.GetAll().Where(x => !x.TeacherCourse.Course.SubjectProject.IsDeleted); if (!string.IsNullOrEmpty(input.KeyWord)) { query = query.Where(x => x.Address.Contains(input.KeyWord) || x.TeacherCourse.Course.Name.Contains(input.KeyWord) ); } query = query.Where(x => x.TeacherCourse.TeacherId == input.TeacherId) .OrderBy(x => x.CreationTime) .Skip(input.Start).Take(input.PageSize); //1 var courses = await Task.FromResult(query.ToList()); return(new PagedResultOutput <CourseTimeDto>(totalcount, //1 courses.MapTo <List <CourseTimeDto> >() //1 )); }