JW/EMISOnline/EMISOnline.DataLogic/Student/CoursematerialDAL.cs

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using Bowin.Common.Linq;
using EMISOnline.Entities;
using EMISOnline.DataLogic.Repositories;
using EMISOnline.ViewModel.SystemView;
using System.Linq.Expressions;

namespace EMISOnline.DataLogic.Student
{
    public class CoursematerialDAL
    {
        public StudentRepository StudentRepository { get; set; }
        public SchoolyearRepository SchoolyearRepository { get; set; }
        public ExecutablePlanRepository ExecutablePlanRepository { get; set; }
        public ClassmajorRepository ClassmajorRepository { get; set; }
        public GrademajorRepository GrademajorRepository { get; set; }
        public CoursematerialRepository CoursematerialRepository { get; set; }
        public CourseChapterRepository CourseChapterRepository { get; set; }
        public CourseVideoRepository CourseVideoRepository { get; set; }
        public CourseStudyStatusRepository CourseStudyStatusRepository { get; set; }
        public StudentEducationMissionClassRepository studentEducationMissionClassRepository { get; set; }
        public ScoreRuleRepository scoreRuleRepository { get; set; }
        public CourseChapter_VideoRepository CourseChapter_VideoRepository { get; set; }
        public TeacherScoreRepository teacherScoreRepository { get; set; }
        public LoginCountRepository loginCountRepository { get; set; }

        public IQueryable<V_StudentEducationMissionClass> GetSutdentCoursematerial(Expression<Func<V_StudentEducationMissionClass, bool>> stuExpression)
        {
            
             var query = from semc in studentEducationMissionClassRepository.GetList(stuExpression)
             select semc;

             return query;
        }

        public List<EM_CourseChapter> GetCourseChapterByCoursematerialID(Guid CoursematerialID)
        {
            var query = from c in CourseChapterRepository.Entities
                        where c.CoursematerialID == CoursematerialID
                        select c;

            return query.OrderBy(x => x.ParentCourseChapterID).ThenBy(x => x.OrderID).ToList();
        }

        public IQueryable<EM_CourseVideo> GetCourseVideo(Guid CourseChapterID)
        {
            var query = from c in CourseVideoRepository.Entities
                        join ccv in CourseChapter_VideoRepository.Entities on c.CourseVideoID equals ccv.CourseVideoID
                        where ccv.CourseChapterID == CourseChapterID
                        select c;

            return query;
        }

        public IQueryable<EM_CourseVideo> GetCourseVideoByCoursematerialID(Guid CoursematerialID)
        {
            var query = from c in CourseVideoRepository.Entities
                        join ccv in CourseChapter_VideoRepository.Entities on c.CourseVideoID equals ccv.CourseVideoID
                        join b in CourseChapterRepository.Entities on ccv.CourseChapterID equals b.CourseChapterID
                        where b.CoursematerialID == CoursematerialID
                        select c;

            return query;
        }

        public ER_ScoreRule GetScoreRule()
        {
            return scoreRuleRepository.Entities.FirstOrDefault();
        }

        
             
    }
}