public async Task <None> Execute(SqlTransaction transaction, UpsertLarsSectorSubjectAreaTier2s query)
        {
            await UpsertHelper.Upsert(
                transaction,
                query.Records,
                keyPropertyNames : new[] { nameof(UpsertLarsSectorSubjectAreaTier2sRecord.SectorSubjectAreaTier2) },
                "LARS.SectorSubjectAreaTier2");

            return(new None());
        }
示例#2
0
        public async Task <None> Execute(SqlTransaction transaction, UpsertLarsAwardOrgCodes query)
        {
            await UpsertHelper.Upsert(
                transaction,
                query.Records,
                keyPropertyNames : new[] { nameof(UpsertLarsAwardOrgCodesRecord.AwardOrgCode) },
                "LARS.AwardOrgCode");

            return(new None());
        }
示例#3
0
        public async Task <None> Execute(SqlTransaction transaction, UpsertLarsStandardSectorCodes query)
        {
            await UpsertHelper.Upsert(
                transaction,
                query.Records,
                keyPropertyNames : new[] { nameof(UpsertLarsStandardSectorCodeRecord.StandardSectorCode) },
                "Pttcd.StandardSectorCodes");

            return(new None());
        }
示例#4
0
        public async Task <None> Execute(SqlTransaction transaction, UpsertLarsLearnAimRefTypes query)
        {
            await UpsertHelper.Upsert(
                transaction,
                query.Records,
                keyPropertyNames : new[] { nameof(UpsertLarsLearnAimRefTypesRecord.LearnAimRefType) },
                "LARS.LearnAimRefType");

            return(new None());
        }
        public async Task <None> Execute(SqlTransaction transaction, UpsertLarsCategories query)
        {
            await UpsertHelper.Upsert(
                transaction,
                query.Records,
                keyPropertyNames : new[] { nameof(UpsertLarsCategoriesRecord.CategoryRef) },
                "LARS.Category");

            return(new None());
        }
示例#6
0
        public async Task <None> Execute(SqlTransaction transaction, UpsertLarsLearningDeliveryCategories query)
        {
            await UpsertHelper.Upsert(
                transaction,
                query.Records,
                keyPropertyNames : new[]
            {
                nameof(UpsertLarsLearningDeliveryCategoriesRecord.CategoryRef),
                nameof(UpsertLarsLearningDeliveryCategoriesRecord.LearnAimRef),
                nameof(UpsertLarsLearningDeliveryCategoriesRecord.EffectiveFrom)
            },
                "LARS.LearningDeliveryCategory");

            return(new None());
        }