Пример #1
0
        //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>();
        }
Пример #2
0
        //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
                                                         ));
        }
Пример #3
0
        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
                                                         ));
        }