public RunDomainModelHandler(IRunRepository runRepository,
ISqlServerDbContext dbContext)
{
_runRepository =
runRepository ?? throw new ArgumentNullException(nameof(runRepository));
_dbContext = dbContext ?? throw new ArgumentNullException(nameof(dbContext));
}
public EmailAuditEventSettingsDomainModelHandler(IEmailAuditEventSettingsRepository emailAuditEventSettingsRepository,
ISqlServerDbContext dbContext)
{
_emailAuditEventSettingsRepository =
emailAuditEventSettingsRepository ?? throw new ArgumentNullException(nameof(emailAuditEventSettingsRepository));
_dbContext = dbContext ?? throw new ArgumentNullException(nameof(dbContext));
}
public MSTeamsAuditEventSettingsDomainModelHandler(IMSTeamsAuditEventSettingsRepository msTeamsAuditEventSettingsRepository,
ISqlServerDbContext dbContext)
{
_msTeamsAuditEventSettingsRepository =
msTeamsAuditEventSettingsRepository ?? throw new ArgumentNullException(nameof(msTeamsAuditEventSettingsRepository));
_dbContext = dbContext ?? throw new ArgumentNullException(nameof(dbContext));
}
public void Execute(ISqlServerDbContext dbContext, Expression <Func <TEntity, int> > entitySequencePropertyExpression)
{
if (dbContext == null)
{
throw new ArgumentNullException(nameof(dbContext));
}
if (!dbContext.Specific.Database.IsSqlServer())
{
return;
}
var max = dbContext.Query <TEntity>()
.Select(entitySequencePropertyExpression)
.DefaultIfEmpty()
.Max() + 1;
var schema = dbContext.Specific.Model.Relational()?.DefaultSchema;
var sequenceNameWithSchema = string.IsNullOrEmpty(schema)
? $"[{typeof(TSequence).Name}]"
: $"[{schema}].[{typeof(TSequence).Name}]";
var query = new RawSqlString($"ALTER SEQUENCE {sequenceNameWithSchema} RESTART WITH {max} NO CACHE");
dbContext.Specific.Database.ExecuteSqlCommand(query);
}
public RSSettingsDomainModelHandler(IRSSettingsRepository rsSettingsRepository,
ISqlServerDbContext dbContext)
{
_rsSettingsRepository =
rsSettingsRepository ?? throw new ArgumentNullException(nameof(rsSettingsRepository));
_dbContext = dbContext ?? throw new ArgumentNullException(nameof(dbContext));
}
public FacilityDomainModelHandler(
IFacilityRepository repository,
ISqlServerDbContext dbContext)
{
_repository = repository;
_dbContext = dbContext;
}
public ISRSettingsDomainModelHandler(IISRSettingsRepository isrSettingsRepository,
ISqlServerDbContext dbContext)
{
_isrSettingsRepository =
isrSettingsRepository ?? throw new ArgumentNullException(nameof(isrSettingsRepository));
_dbContext = dbContext ?? throw new ArgumentNullException(nameof(dbContext));
}
public BookingPositionGroupDomainModelHandler(
IBookingPositionGroupRepository repository,
ISqlServerDbContext dbContext)
{
_repository = repository;
_dbContext = dbContext;
}
public static async Task SaveChangesWithConcurrencyConflictsResolvingAsync(this ISqlServerDbContext dbContext,
CancellationToken cancellationToken = default)
{
if (dbContext is null)
{
throw new ArgumentNullException(nameof(dbContext));
}
while (true)
{
try
{
await dbContext.SaveChangesAsync(cancellationToken).ConfigureAwait(false);
break;
}
catch (DbUpdateConcurrencyException ex)
{
if (ex.Entries.Count == 0)
{
throw;
}
foreach (var entry in ex.Entries)
{
entry.State = EntityState.Detached;
}
}
}
}
public static void SaveChangesWithConcurrencyConflictsResolving(this ISqlServerDbContext dbContext)
{
if (dbContext is null)
{
throw new ArgumentNullException(nameof(dbContext));
}
while (true)
{
try
{
dbContext.SaveChanges();
break;
}
catch (DbUpdateConcurrencyException ex)
{
if (ex.Entries.Count == 0)
{
throw;
}
foreach (var entry in ex.Entries)
{
entry.State = EntityState.Detached;
}
}
}
}
public TenantProductFeatureDomainModelHandler(
ISqlServerDbContext dbContext,
IMapper mapper)
{
_dbContext = dbContext ?? throw new ArgumentNullException(nameof(dbContext));
_mapper = mapper;
}
public SponsorshipDomainModelHandler(ISponsorshipRepository sponsorshipRepository,
ISqlServerDbContext dbContext)
{
_sponsorshipRepository =
sponsorshipRepository ?? throw new ArgumentNullException(nameof(sponsorshipRepository));
_dbContext = dbContext ?? throw new ArgumentNullException(nameof(dbContext));
}
public DemographicDomainModelHandler(IDemographicRepository demographicRepository,
ISqlServerDbContext dbContext, IMapper mapper)
{
_demographicRepository =
demographicRepository ?? throw new ArgumentNullException(nameof(demographicRepository));
_dbContext = dbContext ?? throw new ArgumentNullException(nameof(dbContext));
_mapper = mapper;
}
public ProgrammeDictionaryDomainModelHandler(ISqlServerDbContext dbContext, IMapper mapper,
IProgrammeDictionaryRepository programmeDictionaryRepository)
{
_dbContext = dbContext;
_mapper = mapper;
_programmeDictionaryRepository = programmeDictionaryRepository ??
throw new ArgumentNullException(nameof(programmeDictionaryRepository));
}
public ScenarioCampaignResultDomainModelHandler(
IScenarioCampaignResultRepository repository,
ISqlServerDbContext dbContext,
IMapper mapper)
{
_repository = repository ?? throw new ArgumentNullException(nameof(repository));
_dbContext = dbContext ?? throw new ArgumentNullException(nameof(dbContext));
_mapper = mapper;
}
public RecommendationDomainModelHandler(
IRecommendationRepository repository,
ISqlServerDbContext dbContext,
IMapper mapper)
{
_repository = repository ?? throw new ArgumentNullException(nameof(repository));
_dbContext = dbContext ?? throw new ArgumentNullException(nameof(dbContext));
_mapper = mapper;
}
public UniverseDomainModelHandler(
IUniverseRepository universeRepository,
ISqlServerDbContext dbContext,
IMapper mapper)
{
_universeRepository = universeRepository ?? throw new ArgumentNullException(nameof(universeRepository));
_dbContext = dbContext ?? throw new ArgumentNullException(nameof(dbContext));
_mapper = mapper;
}
public LibrarySalesAreaPassPrioritiesDomainModelHandler(
ILibrarySalesAreaPassPrioritiesRepository librarySalesAreaPassPrioritiesRepository,
ISqlServerDbContext dbContext)
{
_librarySalesAreaPassPrioritiesRepository = librarySalesAreaPassPrioritiesRepository ??
throw new ArgumentNullException(
nameof(librarySalesAreaPassPrioritiesRepository));
_dbContext = dbContext ?? throw new ArgumentNullException(nameof(dbContext));
}
public FailureDomainModelHandler(
IFailuresRepository repository,
ISqlServerDbContext dbContext,
IMapper mapper)
{
_repository = repository;
_dbContext = dbContext;
_mapper = mapper;
}
public TenantSettingsDomainModelHandler(
ITenantSettingsRepository tenantSettingsRepository,
ISqlServerDbContext dbContext)
{
_tenantSettingsRepository = tenantSettingsRepository ??
throw new ArgumentNullException(
nameof(tenantSettingsRepository));
_dbContext = dbContext;
}
public SmoothFailureMessageDomainModelHandler(
ISmoothFailureMessageRepository smoothFailureMessageRepository,
ISqlServerDbContext dbContext,
IMapper mapper)
{
_smoothFailureMessageRepository = smoothFailureMessageRepository ?? throw new ArgumentNullException(nameof(smoothFailureMessageRepository));
_dbContext = dbContext ?? throw new ArgumentNullException(nameof(dbContext));
_mapper = mapper;
}
public SpotPlacementDomainModelHandler(
ISpotPlacementRepository spotPlacementRepository,
ISqlServerDbContext dbContext,
IMapper mapper)
{
_spotPlacementRepository = spotPlacementRepository ??
throw new ArgumentNullException(nameof(spotPlacementRepository));
_dbContext = dbContext ?? throw new ArgumentNullException(nameof(dbContext));
_mapper = mapper;
}
public ProgrammeClassificationDomainModelHandler(
IProgrammeClassificationRepository programmeClassificationRepository,
ISqlServerDbContext dbContext,
IMapper mapper)
{
_programmeClassificationRepository = programmeClassificationRepository ??
throw new ArgumentNullException(
nameof(programmeClassificationRepository));
_dbContext = dbContext;
_mapper = mapper;
}
public static void AddRange <TEntity>(this ISqlServerDbContext dbContext, TEntity[] entities,
Action <EntityCollectionActionBuilder <TEntity> > postAction, IMapper mapper) where TEntity : class
{
if (postAction == null)
{
throw new ArgumentNullException(nameof(postAction));
}
(dbContext ?? throw new ArgumentNullException(nameof(dbContext))).AddRange(
entities ?? throw new ArgumentNullException(nameof(entities)));
CreatePostAction(dbContext, postAction, new EntityCollectionActionBuilder <TEntity>(entities, mapper));
}
public RatingsScheduleRepository(
ISqlServerDbContext dbContext,
ISqlServerSalesAreaByIdCacheAccessor salesAreaByIdCache,
ISqlServerSalesAreaByNameCacheAccessor salesAreaByNameCache,
IMapper mapper
)
{
_dbContext = dbContext;
_salesAreaByIdCache = salesAreaByIdCache;
_salesAreaByNameCache = salesAreaByNameCache;
_mapper = mapper;
}
public static async Task AddRangeAsync <TEntity>(this ISqlServerDbContext dbContext, TEntity[] entities,
Action <EntityCollectionActionBuilder <TEntity> > postAction, IMapper mapper) where TEntity : class
{
if (postAction == null)
{
throw new ArgumentNullException(nameof(postAction));
}
await(dbContext ?? throw new ArgumentNullException(nameof(dbContext))).AddRangeAsync(
entities ?? throw new ArgumentNullException(nameof(entities))).ConfigureAwait(false);
CreatePostAction(dbContext, postAction, new EntityCollectionActionBuilder <TEntity>(entities, mapper));
}
private static void CreatePostAction <TBuilder>(
ISqlServerDbContext dbContext,
Action <TBuilder> postAction,
TBuilder postActionBuilder) where TBuilder : IPostActionBuilder
{
postAction(postActionBuilder);
var action = postActionBuilder.Build();
if (action != null)
{
dbContext.PostActions.Add(action);
}
}
public static TEntity Update <TEntity>(this ISqlServerDbContext dbContext, TEntity entity,
Action <EntityActionBuilder <TEntity> > postAction, IMapper mapper) where TEntity : class
{
if (postAction == null)
{
throw new ArgumentNullException(nameof(postAction));
}
var res = (dbContext ?? throw new ArgumentNullException(nameof(dbContext))).Update(entity);
CreatePostAction(dbContext, postAction, new EntityActionBuilder <TEntity>(res, mapper));
return(res);
}
public static async Task <TEntity> AddAsync <TEntity>(this ISqlServerDbContext dbContext, TEntity entity,
Action <EntityActionBuilder <TEntity> > postAction, IMapper mapper) where TEntity : class
{
if (postAction == null)
{
throw new ArgumentNullException(nameof(postAction));
}
var res = await(dbContext ?? throw new ArgumentNullException(nameof(dbContext))).AddAsync(
entity ?? throw new ArgumentNullException(nameof(entity))).ConfigureAwait(false);
CreatePostAction(dbContext, postAction, new EntityActionBuilder <TEntity>(res, mapper));
return(res);
}
public static TEntity Find <TEntity>(this ISqlServerDbContext dbContext, object[] ids, Action <FindBuilder <TEntity> > findAction)
where TEntity : class
{
if (findAction == null)
{
throw new ArgumentNullException(nameof(findAction));
}
var entity = (dbContext ?? throw new ArgumentNullException(nameof(dbContext))).Find <TEntity>(ids);
if (entity != null)
{
var builder = new FindBuilder <TEntity>(dbContext.Specific.Entry(entity));
findAction(builder);
}
return(entity);
}
