Exemple #1
0
 public Domain.Models.TlRoute Build(EnumAwardingOrganisation awardingOrganisation)
 {
     if (awardingOrganisation == EnumAwardingOrganisation.Ncfe)
     {
         return(new Domain.Models.TlRoute
         {
             Name = "Education and Childcare",
             CreatedBy = Constants.CreatedByUser,
             CreatedOn = Constants.CreatedOn,
             ModifiedBy = Constants.ModifiedByUser,
             ModifiedOn = Constants.ModifiedOn
         });
     }
     else if (awardingOrganisation == EnumAwardingOrganisation.Pearson)
     {
         return(new Domain.Models.TlRoute
         {
             Name = "Construction",
             CreatedBy = Constants.CreatedByUser,
             CreatedOn = Constants.CreatedOn,
             ModifiedBy = Constants.ModifiedByUser,
             ModifiedOn = Constants.ModifiedOn
         });
     }
     else
     {
         return(null);
     }
 }
 public Domain.Models.TlAwardingOrganisation Build(EnumAwardingOrganisation awardingOrganisation)
 {
     if (awardingOrganisation == EnumAwardingOrganisation.Pearson)
     {
         return(new Domain.Models.TlAwardingOrganisation
         {
             UkPrn = 10011881,
             DisplayName = "Pearson",
             Name = "Pearson",
             IsActive = true,
             CreatedBy = Constants.CreatedByUser,
             CreatedOn = Constants.CreatedOn,
             ModifiedBy = Constants.ModifiedByUser,
             ModifiedOn = Constants.ModifiedOn
         });
     }
     else if (awardingOrganisation == EnumAwardingOrganisation.Ncfe)
     {
         return(new Domain.Models.TlAwardingOrganisation
         {
             UkPrn = 10009696,
             DisplayName = "Ncfe",
             Name = "Ncfe",
             IsActive = true,
             CreatedBy = Constants.CreatedByUser,
             CreatedOn = Constants.CreatedOn,
             ModifiedBy = Constants.ModifiedByUser,
             ModifiedOn = Constants.ModifiedOn
         });
     }
     else
     {
         return(null);
     }
 }
        public void SeedTestData(EnumAwardingOrganisation awardingOrganisation = EnumAwardingOrganisation.Pearson)
        {
            AssessmentSeries = AssessmentSeriesDataProvider.CreateAssessmentSeriesList(DbContext, null, true);
            TlProviders      = ProviderDataProvider.CreateTlProviders(DbContext).ToList();
            var tlAwardingOrganisation = TlevelDataProvider.CreateTlAwardingOrganisation(DbContext, awardingOrganisation);
            var routes   = TlevelDataProvider.CreateTlRoutes(DbContext, awardingOrganisation);
            var pathways = TlevelDataProvider.CreateTlPathways(DbContext, awardingOrganisation, routes);

            TlSpecialisms = TlevelDataProvider.CreateTlSpecialisms(DbContext, awardingOrganisation, pathways.First());

            var tqAwardingOrganisations = TlevelDataProvider.CreateTqAwardingOrganisations(DbContext, awardingOrganisation, tlAwardingOrganisation, pathways);

            DbContext.SaveChanges();

            TqProviders = new List <TqProvider>();
            foreach (var tqAwardingOrganisation in tqAwardingOrganisations)
            {
                foreach (var tlProvider in TlProviders)
                {
                    TqProviders.Add(ProviderDataProvider.CreateTqProvider(DbContext, tqAwardingOrganisation, tlProvider));
                }
            }

            DbContext.SaveChanges();
        }
Exemple #4
0
        protected override void SeedTestData(EnumAwardingOrganisation awardingOrganisation = EnumAwardingOrganisation.Pearson, bool seedMultipleProviders = false)
        {
            TlAwardingOrganisation = TlevelDataProvider.CreateTlAwardingOrganisation(DbContext, awardingOrganisation);
            var routes = TlevelDataProvider.CreateTlRoutes(DbContext, awardingOrganisation);

            _tlPathways = TlevelDataProvider.CreateTlPathways(DbContext, awardingOrganisation, routes);

            foreach (var pathway in _tlPathways)
            {
                TlevelDataProvider.CreateTlSpecialisms(DbContext, awardingOrganisation, pathway);
            }

            var tqAwardingOrganisations = TlevelDataProvider.CreateTqAwardingOrganisations(DbContext, awardingOrganisation, TlAwardingOrganisation, _tlPathways);

            TqProviders = new List <TqProvider>();
            TlProviders = ProviderDataProvider.CreateTlProviders(DbContext).ToList();

            var tlProvider = TlProviders.FirstOrDefault();

            foreach (var tqAwardingOrganisation in tqAwardingOrganisations)
            {
                TqProviders.Add(ProviderDataProvider.CreateTqProvider(DbContext, tqAwardingOrganisation, tlProvider));
            }

            DbContext.SaveChangesAsync();
        }
Exemple #5
0
 public TlPathway Build(EnumAwardingOrganisation awardingOrganisation, TlRoute tlRoute = null)
 {
     if (awardingOrganisation == EnumAwardingOrganisation.Pearson)
     {
         return(new TlPathway
         {
             TlevelTitle = "T Level in Design, Surveying and Planning for Construction",
             Name = "Design, Surveying and Planning",
             LarId = "10123456",
             TlRoute = tlRoute ?? new TlRouteBuilder().Build(awardingOrganisation),
             CreatedBy = Constants.CreatedByUser,
             CreatedOn = Constants.CreatedOn,
             ModifiedBy = Constants.ModifiedByUser,
             ModifiedOn = Constants.ModifiedOn
         });
     }
     else if (awardingOrganisation == EnumAwardingOrganisation.Ncfe)
     {
         return(new TlPathway
         {
             TlevelTitle = "T Level in Education and Childcare",
             Name = "Education",
             LarId = "10123457",
             TlRoute = tlRoute ?? new TlRouteBuilder().Build(awardingOrganisation),
             CreatedBy = Constants.CreatedByUser,
             CreatedOn = Constants.CreatedOn,
             ModifiedBy = Constants.ModifiedByUser,
             ModifiedOn = Constants.ModifiedOn
         });
     }
     else
     {
         return(null);
     }
 }
        public void SeedTestData(EnumAwardingOrganisation awardingOrganisation = EnumAwardingOrganisation.Pearson)
        {
            AssessmentSeries = AssessmentSeriesDataProvider.CreateAssessmentSeriesList(DbContext, null, true);
            TlProviders      = ProviderDataProvider.CreateTlProviders(DbContext).ToList();
            var tlAwardingOrganisation = TlevelDataProvider.CreateTlAwardingOrganisation(DbContext, awardingOrganisation);
            var routes   = TlevelDataProvider.CreateTlRoutes(DbContext, awardingOrganisation);
            var pathways = TlevelDataProvider.CreateTlPathways(DbContext, awardingOrganisation, routes);

            TlSpecialisms = TlevelDataProvider.CreateTlSpecialisms(DbContext, awardingOrganisation, pathways.First());
            TlLookup      = TlLookupDataProvider.CreateTlLookupList(DbContext);

            var tqAwardingOrganisations = TlevelDataProvider.CreateTqAwardingOrganisations(DbContext, awardingOrganisation, tlAwardingOrganisation, pathways);

            DbContext.SaveChanges();

            PathwayComponentGrades = TlLookup.Where(x => x.Category.Equals(LookupCategory.PathwayComponentGrade.ToString(), StringComparison.InvariantCultureIgnoreCase)).ToList();
            TqProviders            = new List <TqProvider>();
            foreach (var tqAwardingOrganisation in tqAwardingOrganisations)
            {
                foreach (var tlProvider in TlProviders)
                {
                    TqProviders.Add(ProviderDataProvider.CreateTqProvider(DbContext, tqAwardingOrganisation, tlProvider));
                }
            }

            DbContext.SaveChanges();
        }
Exemple #7
0
 protected virtual void SeedTlevelTestData(EnumAwardingOrganisation awardingOrganisation = EnumAwardingOrganisation.Ncfe)
 {
     _tlAwardingOrganisation = TlevelDataProvider.CreateTlAwardingOrganisation(DbContext, awardingOrganisation);
     _route                  = TlevelDataProvider.CreateTlRoute(DbContext, awardingOrganisation);
     _pathway                = TlevelDataProvider.CreateTlPathway(DbContext, awardingOrganisation, _route);
     _specialisms            = TlevelDataProvider.CreateTlSpecialisms(DbContext, awardingOrganisation, _pathway);
     _tqAwardingOrganisation = TlevelDataProvider.CreateTqAwardingOrganisation(DbContext, _pathway, _tlAwardingOrganisation);
     DbContext.SaveChangesAsync();
 }
Exemple #8
0
 protected virtual void SeedTestData(EnumAwardingOrganisation awardingOrganisation = EnumAwardingOrganisation.Pearson, bool seedMultipleProviders = false)
 {
     TlAwardingOrganisation = TlevelDataProvider.CreateTlAwardingOrganisation(DbContext, awardingOrganisation);
     Route                  = TlevelDataProvider.CreateTlRoute(DbContext, awardingOrganisation);
     Pathway                = TlevelDataProvider.CreateTlPathway(DbContext, awardingOrganisation, Route);
     Specialisms            = TlevelDataProvider.CreateTlSpecialisms(DbContext, awardingOrganisation, Pathway);
     TqAwardingOrganisation = TlevelDataProvider.CreateTqAwardingOrganisation(DbContext, Pathway, TlAwardingOrganisation);
     TlProvider             = ProviderDataProvider.CreateTlProvider(DbContext);
     TqProvider             = ProviderDataProvider.CreateTqProvider(DbContext, TqAwardingOrganisation, TlProvider);
     AssessmentSeries       = AssessmentSeriesDataProvider.CreateAssessmentSeriesList(DbContext, null, true);
     DbContext.SaveChangesAsync();
 }
        protected override void SeedTestData(EnumAwardingOrganisation awardingOrganisation = EnumAwardingOrganisation.Pearson, bool seedMultipleProviders = false)
        {
            TlAwardingOrganisation = TlevelDataProvider.CreateTlAwardingOrganisation(DbContext, awardingOrganisation);
            Route       = TlevelDataProvider.CreateTlRoute(DbContext, awardingOrganisation);
            Pathway     = TlevelDataProvider.CreateTlPathway(DbContext, awardingOrganisation, Route);
            Specialisms = TlevelDataProvider.CreateTlSpecialisms(DbContext, awardingOrganisation, Pathway);
            var tqAwardingOrganisation = TlevelDataProvider.CreateTqAwardingOrganisation(DbContext, Pathway, TlAwardingOrganisation);

            TlProvider = ProviderDataProvider.CreateTlProvider(DbContext);
            TqProvider = ProviderDataProvider.CreateTqProvider(DbContext, tqAwardingOrganisation, TlProvider);
            DbContext.SaveChangesAsync();
        }
Exemple #10
0
 protected virtual void SeedTestData(EnumAwardingOrganisation awardingOrganisation = EnumAwardingOrganisation.Pearson, bool seedMultipleProviders = false)
 {
     TlAwardingOrganisation = TlevelDataProvider.CreateTlAwardingOrganisation(DbContext, awardingOrganisation);
     Route                  = TlevelDataProvider.CreateTlRoute(DbContext, awardingOrganisation);
     Pathway                = TlevelDataProvider.CreateTlPathway(DbContext, awardingOrganisation, Route);
     Specialism             = TlevelDataProvider.CreateTlSpecialisms(DbContext, awardingOrganisation, Pathway).First();
     TqAwardingOrganisation = TlevelDataProvider.CreateTqAwardingOrganisation(DbContext, Pathway, TlAwardingOrganisation);
     TlProvider             = ProviderDataProvider.CreateTlProvider(DbContext);
     TqProvider             = ProviderDataProvider.CreateTqProvider(DbContext, TqAwardingOrganisation, TlProvider);
     AssessmentSeries       = AssessmentSeriesDataProvider.CreateAssessmentSeriesList(DbContext, null, true);
     TlLookup               = TlLookupDataProvider.CreateTlLookupList(DbContext, null, true);
     PathwayComponentGrades = TlLookup.Where(x => x.Category.Equals(LookupCategory.PathwayComponentGrade.ToString(), StringComparison.InvariantCultureIgnoreCase)).ToList();
     DbContext.SaveChangesAsync();
 }
        protected override void SeedTestData(EnumAwardingOrganisation awardingOrganisation = EnumAwardingOrganisation.Pearson, bool seedMultipleProviders = false)
        {
            TlAwardingOrganisation = TlevelDataProvider.CreateTlAwardingOrganisation(DbContext, awardingOrganisation);
            Route       = TlevelDataProvider.CreateTlRoute(DbContext, awardingOrganisation);
            Pathway     = TlevelDataProvider.CreateTlPathway(DbContext, awardingOrganisation, Route);
            Specialisms = TlevelDataProvider.CreateTlSpecialisms(DbContext, awardingOrganisation, Pathway);
            var tqAwardingOrganisation = TlevelDataProvider.CreateTqAwardingOrganisation(DbContext, Pathway, TlAwardingOrganisation);

            TqProviders = new List <TqProvider>();
            TlProviders = ProviderDataProvider.CreateTlProviders(DbContext).ToList();

            foreach (var tlProvider in TlProviders)
            {
                TqProviders.Add(ProviderDataProvider.CreateTqProvider(DbContext, tqAwardingOrganisation, tlProvider));
            }
            AssessmentSeries = AssessmentSeriesDataProvider.CreateAssessmentSeriesList(DbContext, null, true);
            DbContext.SaveChangesAsync();
        }
        protected virtual void SeedTestData(EnumAwardingOrganisation awardingOrganisation = EnumAwardingOrganisation.Pearson, bool seedMultipleProviders = false)
        {
            TlAwardingOrganisation = TlevelDataProvider.CreateTlAwardingOrganisation(DbContext, awardingOrganisation);
            Route                  = TlevelDataProvider.CreateTlRoute(DbContext, awardingOrganisation);
            Pathway                = TlevelDataProvider.CreateTlPathway(DbContext, awardingOrganisation, Route);
            Specialism             = TlevelDataProvider.CreateTlSpecialisms(DbContext, awardingOrganisation, Pathway).First();
            TqAwardingOrganisation = TlevelDataProvider.CreateTqAwardingOrganisation(DbContext, Pathway, TlAwardingOrganisation);
            TlProviders            = ProviderDataProvider.CreateTlProviders(DbContext);
            TqProvider             = ProviderDataProvider.CreateTqProvider(DbContext, TqAwardingOrganisation, TlProviders.First());
            AssessmentSeries       = AssessmentSeriesDataProvider.CreateAssessmentSeriesList(DbContext, null, true);
            TlLookup               = TlLookupDataProvider.CreateTlLookupList(DbContext, null, true);

            foreach (var provider in TlProviders)
            {
                TlProviderAddressDataProvider.CreateTlProviderAddress(DbContext, new TlProviderAddressBuilder().Build(provider));
            }

            DbContext.SaveChangesAsync();
        }
Exemple #13
0
        public TqAwardingOrganisation Build(EnumAwardingOrganisation awardingOrganisation, bool addDefaultNavigationData = true)
        {
            var tlAwardingOrganisation = addDefaultNavigationData ? new TlAwardingOrganisationBuilder().Build(awardingOrganisation) : null;
            var route   = addDefaultNavigationData ? new TlRouteBuilder().Build(awardingOrganisation) : null;
            var pathway = addDefaultNavigationData ? new TlPathwayBuilder().Build(awardingOrganisation) : null;

            return(new TqAwardingOrganisation
            {
                TlAwardingOrganisatonId = tlAwardingOrganisation.Id,
                TlAwardingOrganisaton = tlAwardingOrganisation,
                TlPathwayId = pathway.Id,
                TlPathway = pathway,
                ReviewStatus = 1,
                CreatedBy = Constants.CreatedByUser,
                CreatedOn = Constants.CreatedOn,
                ModifiedBy = Constants.ModifiedByUser,
                ModifiedOn = Constants.ModifiedOn
            });
        }
Exemple #14
0
        public IList <TqAwardingOrganisation> BuildList(EnumAwardingOrganisation awardingOrganisation, TlAwardingOrganisation tlAwardingOrganisation = null, IList <TlPathway> tlPathways = null, TlevelReviewStatus tlevelReviewStatus = TlevelReviewStatus.AwaitingConfirmation)
        {
            var results       = new List <TqAwardingOrganisation>();
            var tlAwardingOrg = tlAwardingOrganisation ?? new TlAwardingOrganisationBuilder().Build(awardingOrganisation);
            var pathways      = tlPathways ?? new TlPathwayBuilder().BuildList(awardingOrganisation);

            foreach (var pathway in pathways)
            {
                results.Add(new TqAwardingOrganisation
                {
                    TlAwardingOrganisatonId = tlAwardingOrg.Id,
                    TlAwardingOrganisaton   = tlAwardingOrg,
                    TlPathwayId             = pathway.Id,
                    TlPathway    = pathway,
                    ReviewStatus = (int)tlevelReviewStatus,
                    CreatedBy    = Constants.CreatedByUser,
                    CreatedOn    = Constants.CreatedOn,
                    ModifiedBy   = Constants.ModifiedByUser,
                    ModifiedOn   = Constants.ModifiedOn
                });
            }
            return(results);
        }
Exemple #15
0
        public IList <TqAwardingOrganisation> BuildList(EnumAwardingOrganisation awardingOrganisation, bool addDefaultNavigationData = true)
        {
            var results = new List <TqAwardingOrganisation>();
            var tlAwardingOrganisation = addDefaultNavigationData ? new TlAwardingOrganisationBuilder().Build(awardingOrganisation) : null;
            var pathways = new TlPathwayBuilder().BuildList(awardingOrganisation);

            foreach (var pathway in pathways)
            {
                results.Add(new TqAwardingOrganisation
                {
                    TlAwardingOrganisatonId = tlAwardingOrganisation.Id,
                    TlAwardingOrganisaton   = tlAwardingOrganisation,
                    TlPathwayId             = pathway.Id,
                    TlPathway    = pathway,
                    ReviewStatus = 1,
                    CreatedBy    = Constants.CreatedByUser,
                    CreatedOn    = Constants.CreatedOn,
                    ModifiedBy   = Constants.ModifiedByUser,
                    ModifiedOn   = Constants.ModifiedOn
                });
            }
            return(results);
        }
Exemple #16
0
        public IList <Domain.Models.TlSpecialism> BuildList(EnumAwardingOrganisation awardingOrganisation, Domain.Models.TlPathway tlPathway = null)
        {
            var pathway = tlPathway ?? new TlPathwayBuilder().Build(awardingOrganisation);
            var results = new List <Domain.Models.TlSpecialism>();

            if (awardingOrganisation == EnumAwardingOrganisation.Ncfe)
            {
                results = new List <Domain.Models.TlSpecialism>
                {
                    new Domain.Models.TlSpecialism
                    {
                        Name        = "Early years education and childcare",
                        LarId       = "10123456",
                        TlPathwayId = pathway.Id,
                        TlPathway   = pathway,
                        CreatedBy   = Constants.CreatedByUser,
                        CreatedOn   = Constants.CreatedOn,
                        ModifiedBy  = Constants.ModifiedByUser,
                        ModifiedOn  = Constants.ModifiedOn
                    },
                    new Domain.Models.TlSpecialism
                    {
                        Name        = "Assisting teaching",
                        LarId       = "10123457",
                        TlPathwayId = pathway.Id,
                        TlPathway   = pathway,
                        CreatedBy   = Constants.CreatedByUser,
                        CreatedOn   = Constants.CreatedOn,
                        ModifiedBy  = Constants.ModifiedByUser,
                        ModifiedOn  = Constants.ModifiedOn
                    },
                    new Domain.Models.TlSpecialism
                    {
                        Name        = "Supporting and mentoring students in further and higher education",
                        LarId       = "10123458",
                        TlPathwayId = pathway.Id,
                        TlPathway   = pathway,
                        CreatedBy   = Constants.CreatedByUser,
                        CreatedOn   = Constants.CreatedOn,
                        ModifiedBy  = Constants.ModifiedByUser,
                        ModifiedOn  = Constants.ModifiedOn
                    }
                };
            }
            else if (awardingOrganisation == EnumAwardingOrganisation.Pearson)
            {
                results = new List <Domain.Models.TlSpecialism>
                {
                    new Domain.Models.TlSpecialism
                    {
                        Name        = "Surveying and design for construction and the built environment",
                        LarId       = "10123456",
                        TlPathwayId = pathway.Id,
                        TlPathway   = pathway,
                        CreatedBy   = Constants.CreatedByUser,
                        CreatedOn   = Constants.CreatedOn,
                        ModifiedBy  = Constants.ModifiedByUser,
                        ModifiedOn  = Constants.ModifiedOn
                    },
                    new Domain.Models.TlSpecialism
                    {
                        Name        = "Civil Engineering",
                        LarId       = "10123457",
                        TlPathwayId = pathway.Id,
                        TlPathway   = pathway,
                        CreatedBy   = Constants.CreatedByUser,
                        CreatedOn   = Constants.CreatedOn,
                        ModifiedBy  = Constants.ModifiedByUser,
                        ModifiedOn  = Constants.ModifiedOn
                    },
                    new Domain.Models.TlSpecialism
                    {
                        Name        = "Building services design",
                        LarId       = "10123458",
                        TlPathwayId = pathway.Id,
                        TlPathway   = pathway,
                        CreatedBy   = Constants.CreatedByUser,
                        CreatedOn   = Constants.CreatedOn,
                        ModifiedBy  = Constants.ModifiedByUser,
                        ModifiedOn  = Constants.ModifiedOn
                    },
                    new Domain.Models.TlSpecialism
                    {
                        Name        = "Hazardous materials analysis and surveying",
                        LarId       = "10123459",
                        TlPathwayId = pathway.Id,
                        TlPathway   = pathway,
                        CreatedBy   = Constants.CreatedByUser,
                        CreatedOn   = Constants.CreatedOn,
                        ModifiedBy  = Constants.ModifiedByUser,
                        ModifiedOn  = Constants.ModifiedOn
                    }
                };
            }
            return(results);
        }
        public static TlPathway CreateTlPathway(ResultsAndCertificationDbContext _dbContext, EnumAwardingOrganisation awardingOrganisation, TlRoute tlRoute, bool addToDbContext = true)
        {
            if (tlRoute == null)
            {
                tlRoute = new TlRouteBuilder().Build(awardingOrganisation);
            }

            var tlPathway = new TlPathwayBuilder().Build(awardingOrganisation, tlRoute);

            if (addToDbContext)
            {
                _dbContext.Add(tlPathway);
            }
            return(tlPathway);
        }
        public static TlPathway CreateTlPathway(ResultsAndCertificationDbContext _dbContext, EnumAwardingOrganisation awardingOrganisation, TlRoute tlRoute, string larId, string tlevelTitle, string pathwayName, bool addToDbContext = true)
        {
            if (tlRoute == null)
            {
                tlRoute = new TlRouteBuilder().Build(awardingOrganisation);
            }

            var tlPathway = new TlPathway
            {
                TlRouteId   = tlRoute.Id,
                LarId       = larId,
                TlevelTitle = tlevelTitle,
                Name        = pathwayName,
                TlRoute     = tlRoute
            };

            if (addToDbContext)
            {
                _dbContext.Add(tlPathway);
            }
            return(tlPathway);
        }
Exemple #19
0
 protected virtual void SeedTestData(EnumAwardingOrganisation awardingOrganisation, bool isAoActive, bool seedTqAo, List <(long ukprn, bool isProviderActive, bool seedTqProvider)> providerTestCriteria)
        public static IList <TlPathway> CreateTlPathways(ResultsAndCertificationDbContext _dbContext, EnumAwardingOrganisation awardingOrganisation, IList <TlRoute> tlRoutes = null, bool addToDbContext = true)
        {
            var routes     = tlRoutes ?? new TlRouteBuilder().BuildList(awardingOrganisation);
            var tlPathways = new TlPathwayBuilder().BuildList(awardingOrganisation, routes);

            if (addToDbContext && tlPathways != null)
            {
                foreach (var tlPathway in tlPathways)
                {
                    _dbContext.Add(tlPathway);
                }
            }
            return(tlPathways);
        }
        public static IList <TlSpecialism> CreateTlSpecialisms(ResultsAndCertificationDbContext _dbContext, EnumAwardingOrganisation awardingOrganisation, TlPathway tlPathway, bool addToDbContext = true)
        {
            var tlSpecialisms = new TlSpecialismBuilder().BuildList(awardingOrganisation, tlPathway);

            if (addToDbContext && tlSpecialisms != null)
            {
                _dbContext.AddRange(tlSpecialisms);
            }
            return(tlSpecialisms);
        }
Exemple #22
0
        public IList <TlPathway> BuildList(EnumAwardingOrganisation awardingOrganisation, IList <TlRoute> tlRoutes = null)
        {
            var results = new List <TlPathway>();
            var routes  = tlRoutes ?? new TlRouteBuilder().BuildList(awardingOrganisation);

            if (awardingOrganisation == EnumAwardingOrganisation.Pearson)
            {
                foreach (var route in routes)
                {
                    if (route.Name == EnumExtensions.GetDisplayName(EnumTlRoute.Construction))
                    {
                        results.Add(new TlPathway
                        {
                            TlevelTitle = "T Level in Design, Surveying and Planning for Construction",
                            Name        = "Design, Surveying and Planning",
                            LarId       = "10123456",
                            TlRouteId   = route.Id,
                            TlRoute     = route,
                            CreatedBy   = Constants.CreatedByUser,
                            CreatedOn   = Constants.CreatedOn,
                            ModifiedBy  = Constants.ModifiedByUser,
                            ModifiedOn  = Constants.ModifiedOn
                        });
                    }
                    else if (route.Name == EnumExtensions.GetDisplayName(EnumTlRoute.Digital))
                    {
                        results.Add(new TlPathway
                        {
                            TlevelTitle = "T Level in Digital Production, Design and Development",
                            Name        = "Digital Production, Design and Development",
                            LarId       = "10123468",
                            TlRouteId   = route.Id,
                            TlRoute     = route,
                            CreatedBy   = Constants.CreatedByUser,
                            CreatedOn   = Constants.CreatedOn,
                            ModifiedBy  = Constants.ModifiedByUser,
                            ModifiedOn  = Constants.ModifiedOn
                        });
                    }
                }
                return(results);
            }
            else if (awardingOrganisation == EnumAwardingOrganisation.Ncfe)
            {
                foreach (var route in routes)
                {
                    if (route.Name == EnumExtensions.GetDisplayName(EnumTlRoute.EducationAndChildcare))
                    {
                        results.Add(new TlPathway
                        {
                            TlevelTitle = "T Level in Education and Childcare",
                            Name        = "Education",
                            LarId       = "10123457",
                            TlRouteId   = route.Id,
                            TlRoute     = route,
                            CreatedBy   = Constants.CreatedByUser,
                            CreatedOn   = Constants.CreatedOn,
                            ModifiedBy  = Constants.ModifiedByUser,
                            ModifiedOn  = Constants.ModifiedOn
                        });
                    }
                    else if (route.Name == EnumExtensions.GetDisplayName(EnumTlRoute.Digital))
                    {
                        results.Add(new TlPathway
                        {
                            TlevelTitle = "T Level in Digital Support and Services",
                            Name        = "Digital Support Services",
                            LarId       = "10623456",
                            TlRouteId   = route.Id,
                            TlRoute     = route,
                            CreatedBy   = Constants.CreatedByUser,
                            CreatedOn   = Constants.CreatedOn,
                            ModifiedBy  = Constants.ModifiedByUser,
                            ModifiedOn  = Constants.ModifiedOn
                        });

                        results.Add(new TlPathway
                        {
                            TlevelTitle = "T Level in Digital Business Services",
                            Name        = "Digital Business Services",
                            LarId       = "10723456",
                            TlRouteId   = route.Id,
                            TlRoute     = route,
                            CreatedBy   = Constants.CreatedByUser,
                            CreatedOn   = Constants.CreatedOn,
                            ModifiedBy  = Constants.ModifiedByUser,
                            ModifiedOn  = Constants.ModifiedOn
                        });
                    }
                }
                return(results);
            }
            else
            {
                return(null);
            }
        }
        public static TqAwardingOrganisation CreateTqAwardingOrganisation(ResultsAndCertificationDbContext _dbContext, EnumAwardingOrganisation awardingOrganisation, bool addToDbContext = true)
        {
            var tqAwardingOrganisation = new TqAwardingOrganisationBuilder().Build(awardingOrganisation);

            if (addToDbContext && tqAwardingOrganisation != null)
            {
                _dbContext.Add(tqAwardingOrganisation);
            }
            return(tqAwardingOrganisation);
        }
        public static TlAwardingOrganisation CreateTlAwardingOrganisation(ResultsAndCertificationDbContext _dbContext, TlAwardingOrganisation tlAwardingOrganisation, EnumAwardingOrganisation awardingOrganisation, bool addToDbContext = true)
        {
            if (tlAwardingOrganisation == null)
            {
                tlAwardingOrganisation = new TlAwardingOrganisationBuilder().Build(awardingOrganisation);
            }

            if (addToDbContext)
            {
                _dbContext.Add(tlAwardingOrganisation);
            }
            return(tlAwardingOrganisation);
        }
        public static IList <TqAwardingOrganisation> CreateTqAwardingOrganisations(ResultsAndCertificationDbContext _dbContext, EnumAwardingOrganisation awardingOrganisation, TlAwardingOrganisation tlAwardingOrganisation, IList <TlPathway> tlPathways, TlevelReviewStatus reviewStatus = TlevelReviewStatus.AwaitingConfirmation, bool addToDbContext = true)
        {
            var tqAwardingOrganisations = new TqAwardingOrganisationBuilder().BuildList(awardingOrganisation, tlAwardingOrganisation, tlPathways, reviewStatus);

            if (addToDbContext && tqAwardingOrganisations != null)
            {
                foreach (var tqAwardingOrganisation in tqAwardingOrganisations)
                {
                    _dbContext.Add(tqAwardingOrganisation);
                }
            }
            return(tqAwardingOrganisations);
        }
        public static TlRoute CreateTlRoute(ResultsAndCertificationDbContext _dbContext, EnumAwardingOrganisation awardingOrganisation, bool addToDbContext = true)
        {
            var tlRoute = new TlRouteBuilder().Build(awardingOrganisation);

            if (addToDbContext)
            {
                _dbContext.Add(tlRoute);
            }
            return(tlRoute);
        }
        public static IList <TlRoute> CreateTlRoutes(ResultsAndCertificationDbContext _dbContext, EnumAwardingOrganisation awardingOrganisation, bool addToDbContext = true)
        {
            var tlRoutes = new TlRouteBuilder().BuildList(awardingOrganisation);

            if (addToDbContext && tlRoutes != null)
            {
                foreach (var tlRoute in tlRoutes)
                {
                    _dbContext.Add(tlRoute);
                }
            }
            return(tlRoutes);
        }