using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using EMIS.DataLogic.Repositories;
using EMIS.ViewModel.Students;
using System.Linq.Expressions;
using EMIS.Entities;

namespace EMIS.DataLogic.Common.Students
{ 
    public class StudentExperienceDAL
    {
        public StudentExperienceRepository StudentExperienceRepository { get; set; }

        public IQueryable<StudentExperienceView> GetStudentExperienceViewQueryable(Expression<Func<CF_StudentExperience, bool>> exp)
        {
            var query = (from experience in StudentExperienceRepository.GetList(exp) 
                         orderby experience.StartYear descending, experience.StartMonth descending
                         select new StudentExperienceView 
                         {
                             StudentExperienceID = experience.StudentExperienceID,
                             UserID = experience.UserID,
                             StartYear = experience.StartYear,
                             StartMonth = experience.StartMonth,
                             EndYear = experience.EndYear,
                             EndMonth = experience.EndMonth,
                             Experience = experience.Experience,
                         }
                );

            return query;
        }
    }
}