using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using EMISOnline.DataLogic.Repositories;

namespace EMISOnline.DataLogic.CourseworkMgr
{
    public class TeacherScoreDAL
    {
        public TeacherScoreRepository teacherScoreRepository { get; set; }

        public TeacherScoreRepository getRepository()
        {
            return teacherScoreRepository;
        }

        public IQueryable<Entities.ER_TeacherScore> StudentScoreList(Guid TeacherID, Guid SchoolyearID)
        {

            var DataUnitWork = teacherScoreRepository.UnitOfWork;

            var Tslist = DataUnitWork.ER_TeacherScore.Where(w => w.SchoolyearID == SchoolyearID);

            return Tslist;
        }

        public IQueryable<Entities.V_StudentEducationMissionClass> getStudentClassListbySChoolYear(Guid TeacherID, Guid SchoolyearID)
        {
            var DataUnitWork = teacherScoreRepository.UnitOfWork;

            var list = DataUnitWork.V_StudentEducationMissionClass.Where(w => w.SchoolyearID == SchoolyearID && w.TeacherID == TeacherID);
            return list;
        }


    }
}