public static ICollection <FrameworkQualification> GetQualification(MetaDataBag bag, AppSettings appSettings)
{
var frameworkQualifications = new List <FrameworkQualification>();
if (!File.Exists(appSettings.QualificationsFilePath))
{
bag.Frameworks = FilterFrameworks(bag.Frameworks);
bag.Fundings =
bag.Fundings.Where(
x => x.FundingCategory.Equals("app_act_cost", StringComparison.CurrentCultureIgnoreCase))
.ToList();
bag.LearningDeliveries =
bag.LearningDeliveries.Where(x => !x.EffectiveTo.HasValue || x.EffectiveTo.Value > DateTime.Now)
.ToList();
bag.Fundings =
bag.Fundings.Where(x => !x.EffectiveTo.HasValue || x.EffectiveTo.Value > DateTime.Now)
.ToList();
var timer = Stopwatch.StartNew();
var count = 0;
var total = bag.Frameworks.Count;
foreach (var framework in bag.Frameworks)
{
Console.WriteLine($"Getting qualification for framework {++count} / {total}");
var frameworkAims = bag.FrameworkAims.Where(x => x.FworkCode.Equals(framework.FworkCode) &&
x.ProgType.Equals(framework.ProgType) &&
x.PwayCode.Equals(framework.PwayCode)).ToList();
var qualifications =
(from aim in frameworkAims
join comp in bag.FrameworkComponentTypes on aim.FrameworkComponentType equals
comp.FrameworkComponentType
join ld in bag.LearningDeliveries on aim.LearnAimRef equals ld.LearnAimRef
select new FrameworkQualification
{
LearnAimRef = aim.LearnAimRef,
ProgType = aim.ProgType,
Title = ld.LearnAimRefTitle.Replace("(QCF)", string.Empty).Trim(),
CompetenceType = comp.FrameworkComponentType,
CompetenceDescription = comp.FrameworkComponentTypeDesc
}).ToList();
frameworkQualifications.AddRange(qualifications);
}
Console.WriteLine($"Time taken to find qualifications: {timer.Elapsed.ToString("g")}");
FileSerializer.SerializeCollectionToFile(appSettings.QualificationsFilePath, frameworkQualifications);
}
else
{
frameworkQualifications =
FileSerializer.DeserializeCollectionFromFile <FrameworkQualification>(
appSettings.QualificationsFilePath).ToList();
}
return(frameworkQualifications);
}