public IEnumerable <EduProgramProfileFormYearInfo> ListByDivisionAndEduLevels(IEnumerable <int> eduLevelIds,
                                                                               int?divisionId,
                                                                               DivisionLevel divisionLevel)
 {
     return(ModelContext.Query <EduProgramProfileFormYearInfo> ()
            .IncludeEduProgramProfileWithEduProgramAndDivisions()
            .Include2(eppfy => eppfy.EduForm)
            .Include2(eppfy => eppfy.Contingent)
            .Include2(eppfy => eppfy.Year)
            .WhereEduLevelsOrAll(eduLevelIds)
            .WhereDivisionOrAll(divisionId, divisionLevel)
            .DefaultOrder()
            .ThenByDescending(ev => ev.Year != null ? ev.Year.Year : int.MaxValue)
            .ToList());
 }
Example #2
0
 public IEnumerable <EduProgramProfileFormYearInfo> ListByDivisionAndEduLevels(IEnumerable <int> eduLevelIds,
                                                                               int?divisionId,
                                                                               DivisionLevel divisionLevel)
 {
     return(ModelContext.Query <EduProgramProfileFormYearInfo> ()
            .Include(eppfy => eppfy.EduProgramProfile)
            .Include(eppfy => eppfy.EduProgramProfile.EduLevel)
            .Include(eppfy => eppfy.EduProgramProfile.EduProgram)
            .Include(eppfy => eppfy.EduForm)
            .Include(eppfy => eppfy.Contingent)
            .Include(eppfy => eppfy.Year)
            .WhereEduLevelsOrAll(eduLevelIds)
            .WhereDivisionOrAll(divisionId, divisionLevel)
            .DefaultOrder()
            .ToList());
 }
 public IEnumerable <EduProgramProfileFormYearInfo> ListByDivisionAndEduLevels(IEnumerable <int> eduLevelIds,
                                                                               int?divisionId,
                                                                               DivisionLevel divisionLevel)
 {
     return(ModelContext.Query <EduProgramProfileFormYearInfo> ()
            .IncludeEduProgramProfileWithEduProgram()
            .Include2(eppfy => eppfy.EduForm)
            .Include2(eppfy => eppfy.EduVolume)
            .Include2(eppfy => eppfy.Year)
            .Where(eppfy => eppfy.Year != null)
            .Where(eppfy => !eppfy.Year.AdmissionIsOpen)
            .WhereEduLevelsOrAll(eduLevelIds)
            .WhereDivisionOrAll(divisionId, divisionLevel)
            .DefaultOrder()
            .ThenByDescending(eppfy => eppfy.Year.Year)
            .ToList());
 }