public IList<EduProgramProfileInfo> ListWithDocuments (IEnumerable<int> eduLevelIds, int? divisionId, DivisionLevel divisionLevel)
{
return OrderBy (WhereDivision (divisionId, divisionLevel, QueryEduProgramProfiles (eduLevelIds)
.Include (epp => epp.Documents)
.Include (epp => epp.Documents.Select (d => d.DocumentType))
)).ToList ();
}
public IList<EduProgramProfileInfo> ListWithEduForms (IEnumerable<int> eduLevelIds, int? divisionId, DivisionLevel divisionLevel)
{
return OrderBy (WhereDivision (divisionId, divisionLevel, QueryEduProgramProfiles (eduLevelIds)
.Include (epp => epp.EduProgramProfileForms)
.Include (epp => epp.EduProgramProfileForms.Select (eppf => eppf.EduForm))
)).ToList ();
}
public SeasonDivision(string name, Season season, DivisionLevel level, SeasonDivision parent)
{
Name = name;
Season = season;
Level = level;
Parent = parent;
if (parent != null)
{
Parent.AddChildDivision(this);
}
}
public IList <Standings> GetStandingsByDivisionLevel(DivisionLevel level)
{
var result = new List <Standings>();
Divisions.Where(d => d.Level == level).ToList().ForEach(ds =>
{
result.Add(GetStandingsByDivision(ds));
});
return(result);
}
public static SeasonScheduleRule CreateDivisionLevelRule(string name, DivisionLevel divLevel, int iterations, bool homeAndAway)
{
return(new SeasonScheduleRule()
{
RuleType = SeasonScheduleRuleType.DivisionLevel,
RuleName = name,
Iterations = iterations,
HomeAndAway = homeAndAway,
DivisionLevel = divLevel
});
}
protected IQueryable<EduProgramProfileInfo> WhereDivision (int? divisionId, DivisionLevel divisionLevel, IQueryable<EduProgramProfileInfo> eduProgramProfiles)
{
if (divisionId != null) {
if (divisionLevel == DivisionLevel.EduProgram) {
return eduProgramProfiles.Where (epp => epp.EduProgram.DivisionId == divisionId);
}
if (divisionLevel == DivisionLevel.EduProgramProfile) {
return eduProgramProfiles.Where (epp => epp.DivisionId == divisionId);
}
}
return eduProgramProfiles;
}
protected IQueryable <EduProgramProfileInfo> WhereDivision(int?divisionId, DivisionLevel divisionLevel, IQueryable <EduProgramProfileInfo> eduProgramProfiles)
{
if (divisionId != null)
{
if (divisionLevel == DivisionLevel.EduProgram)
{
return(eduProgramProfiles.Where(epp => epp.EduProgram.Divisions.Any(epd => epd.DivisionId == divisionId)));
}
if (divisionLevel == DivisionLevel.EduProgramProfile)
{
return(eduProgramProfiles.Where(epp => epp.Divisions.Any(epd => epd.DivisionId == divisionId)));
}
}
return(eduProgramProfiles);
}
public SeasonDivision(string name, Season season, DivisionLevel level, SeasonDivision parent, IList <SeasonDivision> children, IList <SeasonRanking> ranking)
{
Name = name;
Season = season;
Level = level;
Parent = parent;
if (parent != null)
{
Parent.AddChildDivision(this);
}
if (children != null)
{
Children = children;
}
if (ranking != null)
{
Ranking = ranking;
}
}
public IList <EduProgramProfileInfo> ListWithEduForms(IEnumerable <int> eduLevelIds, int?divisionId, DivisionLevel divisionLevel)
{
return(OrderBy(WhereDivision(divisionId, divisionLevel, QueryEduProgramProfiles(eduLevelIds)
.Include(epp => epp.EduProgramProfileFormYears)
.Include(epp => epp.EduProgramProfileFormYears.Select(eppfy => eppfy.Year))
.Include(epp => epp.EduProgramProfileFormYears.Select(eppfy => eppfy.EduForm))
.Include(epp => epp.EduProgramProfileFormYears.Select(eppfy => eppfy.EduVolume))
)).ToList());
}
public static IQueryable <EduProgramProfileFormYearInfo> WhereDivisionOrAll(this IQueryable <EduProgramProfileFormYearInfo> eduProgramProfileFormYears, int?divisionId, DivisionLevel divisionLevel)
{
if (divisionId != null)
{
if (divisionLevel == DivisionLevel.EduProgram)
{
return(eduProgramProfileFormYears.Where(eppfy => eppfy.EduProgramProfile.EduProgram.Divisions.Any(epd => epd.DivisionId == divisionId)));
}
if (divisionLevel == DivisionLevel.EduProgramProfile)
{
return(eduProgramProfileFormYears.Where(eppfy => eppfy.EduProgramProfile.Divisions.Any(epd => epd.DivisionId == divisionId)));
}
}
return(eduProgramProfileFormYears);
}
public static void AddDivisionRule(string parent, IList <SeasonDivisionRule> fullDivisionList, DivisionLevel level, params string[] divisionNames)
{
for (int i = 0; i < divisionNames.Length; i++)
{
var parentDivRule = fullDivisionList.Where(d => d.Name.Equals(parent)).FirstOrDefault();
var divisionRule = new SeasonDivisionRule(level, divisionNames[i], parentDivRule);
if (parentDivRule != null)
{
parentDivRule.AddChildRule(divisionRule);
}
fullDivisionList.Add(divisionRule);
}
}
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());
}
IEnumerable <EduProgramProfileFormYearInfo> GetEduVolumesForEduVolumeDirectory(int?divisionId, IEnumerable <int> eduLevelIds, DivisionLevel divisionLevel)
{
using (var modelContext = new UniversityModelContext()) {
var eduVolumes = new EduVolumeQuery(modelContext).ListByDivisionAndEduLevels(eduLevelIds, divisionId, divisionLevel);
return(eduVolumes ?? Enumerable.Empty <EduProgramProfileFormYearInfo> ());
}
}
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)
.Where(eppfy => !eppfy.Year.AdmissionIsOpen)
.WhereEduLevelsOrAll(eduLevelIds)
.WhereDivisionOrAll(divisionId, divisionLevel)
.Order()
.ToList());
}
public IList <EduProgramProfileInfo> ListWithDocuments(IEnumerable <int> eduLevelIds, int?divisionId, DivisionLevel divisionLevel)
{
return(ModelContext.Query <EduProgramProfileInfo> ()
.IncludeEduProgramAndDivisions()
.IncludeDocuments()
.IncludeEduProgramProfileFormYearsAndForms()
.WhereEduLevelsOrAll(eduLevelIds)
.WhereDivisionOrAll(divisionId, divisionLevel)
.DefaultOrder()
.ToList());
}
public SeasonDivisionRule(DivisionLevel level, string name, SeasonDivisionRule parent)
{
Level = level;
Name = name;
Parent = parent;
}
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());
}
public IList <EduProgramProfileInfo> ListWithDocuments(IEnumerable <int> eduLevelIds, int?divisionId, DivisionLevel divisionLevel)
{
return(OrderBy(WhereDivision(divisionId, divisionLevel, QueryEduProgramProfiles(eduLevelIds)
.Include(epp => epp.Documents)
.Include(epp => epp.Documents.Select(d => d.DocumentType))
)).ToList());
}
public IList <EduProgramProfileInfo> ListWithDocuments(IEnumerable <int> eduLevelIds, int?divisionId, DivisionLevel divisionLevel)
{
return(ModelContext.Query <EduProgramProfileInfo> ()
.IncludeEduProgramAndDivisions()
.Include(epp => epp.Documents)
.Include(epp => epp.Documents.Select(d => d.DocumentType))
.Include(epp => epp.EduProgramProfileFormYears.Select(eppfy => eppfy.Year))
.Include(epp => epp.EduProgramProfileFormYears.Select(eppfy => eppfy.EduForm))
.WhereEduLevelsOrAll(eduLevelIds)
.WhereDivisionOrAll(divisionId, divisionLevel)
.DefaultOrder()
.ToList());
}
