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());
}
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());
}
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());
}
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());
}
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());
}