Exemplo n.º 1
0
        public void Delete(int id)
        {
            var entity = _dbContext.Find <FacilityEntity>(id);

            if (entity != null)
            {
                _dbContext.Remove(entity);
            }
        }
Exemplo n.º 2
0
        public void Delete(Guid id)
        {
            var entity = _dbContext.Find <BreakEntity>(id);

            if (entity != null)
            {
                _dbContext.Remove(entity);
            }
        }
Exemplo n.º 3
0
        public void Delete(Guid uid)
        {
            var entity = _dbContext.Find <Entities.Tenant.Clash>(uid);

            if (entity != null)
            {
                _dbContext.Remove(entity);
            }
        }
Exemplo n.º 4
0
        public void Delete(int id)
        {
            var entity = _dbContext.Find <Entities.Tenant.DeliveryCappingGroup>(id);

            if (entity != null)
            {
                _dbContext.Remove(entity);
            }
        }
Exemplo n.º 5
0
        public void Delete(int id)
        {
            var entity = _dbContext.Find <Entities.Tenant.LengthFactor>(id);

            if (entity != null)
            {
                _dbContext.Remove(entity);
            }
        }
Exemplo n.º 6
0
        public void Update(FlexibilityLevel item)
        {
            var entity = _dbContext.Find <Entities.Tenant.FlexibilityLevel>(item.Id);

            if (entity != null)
            {
                _mapper.Map(item, entity);
                _dbContext.Update(entity, post => post.MapTo(item), _mapper);
            }
        }
Exemplo n.º 7
0
        public void Update(AutopilotRule item)
        {
            var entity = _dbContext.Find <Entities.Tenant.AutopilotRule>(item.Id);

            if (entity != null)
            {
                _mapper.Map(item, entity);
                _dbContext.Update(entity, post => post.MapTo(item), _mapper);
            }
        }
        public void Update(BRSConfigurationTemplate item)
        {
            var entity = _dbContext.Find <Entities.Tenant.BRS.BRSConfigurationTemplate>(new object[] { item.Id }, find => find.IncludeCollection(x => x.KPIConfigurations));

            if (entity is null)
            {
                return;
            }

            _mapper.Map(item, entity);
            _dbContext.Update(entity, post => post.MapTo(item), _mapper);
        }
Exemplo n.º 9
0
        public void Add(Channel channel)
        {
            var entity = _dbContext.Find <Entities.Tenant.Channel>(channel.Id);

            if (entity == null)
            {
                _dbContext.Add(_mapper.Map <Entities.Tenant.Channel>(channel), post => post.MapTo(channel), _mapper);
            }
            else
            {
                _mapper.Map(channel, entity);
                _dbContext.Update(entity, post => post.MapTo(channel), _mapper);
            }
        }
Exemplo n.º 10
0
        public void Delete(int id)
        {
            var entity = _dbContext.Find <Entities.Tenant.SpotPlacement>(id);

            if (entity != null)
            {
                _dbContext.Remove(entity);
            }
        }
Exemplo n.º 11
0
        public void Delete(int id)
        {
            var entity = _dbContext.Find <BookingPositionGroupEntity>(id);

            if (entity != null)
            {
                _dbContext.Remove(entity);
            }
        }
Exemplo n.º 12
0
        public EfficiencySettings UpdateDefault(EfficiencySettings settings)
        {
            var settingsToSave = settings.Id == default ?
                                 GetDefault().FulfillFrom(settings) : settings;
            var entity = _dbContext.Find <Entities.Tenant.EfficiencySettings>(settingsToSave.Id);

            _mapper.Map(settingsToSave, entity);
            _dbContext.Update(entity, post => post.MapTo(settingsToSave), _mapper);
            return(settingsToSave);
        }
Exemplo n.º 13
0
 public void Delete(int id)
 {
     if (_scheduleCache.TryGetValue(id, out var entity))
     {
         _ = _scheduleCache.Remove(entity.Id);
         _dbContext.Remove(entity);
     }
     else
     {
         entity = _dbContext.Find <ScheduleEntity>(id);
         if (entity != null)
         {
             _dbContext.Remove(entity);
         }
     }
 }
Exemplo n.º 14
0
        public void Update(ISRSettings isrSettings)
        {
            if (isrSettings == null)
            {
                throw new ArgumentNullException(nameof(isrSettings));
            }

            var entity = _dbContext.Find <ISRSettingsEntity>(new object[] { isrSettings.Id },
                                                             post =>
            {
                _ = post.IncludeCollection(e => e.DemographicsSettings);
            });

            if (entity != null)
            {
                _ = _mapper.Map(isrSettings, entity, opts => opts.UseEntityCache(_salesAreaByNameCache));
                _ = _dbContext.Update(entity,
                                      post => post.MapTo(isrSettings, opts => opts.UseEntityCache(_salesAreaByIdCache)), _mapper);
            }
        }
Exemplo n.º 15
0
 public InventoryLockType Get(int id) => _mapper.Map <InventoryLockType>(_dbContext.Find <Entities.Tenant.InventoryStatuses.InventoryLockType>(id));
        public void Execute(Guid salesAreaId)
        {
            var salesArea = _dbContext.Find <SalesArea>(salesAreaId);

            if (salesArea is null)
            {
                throw new InvalidOperationException($"SalesArea with id {salesAreaId} was not found");
            }

            (Guid[] notStartedRunIds, int[] notStartedPassIds) = GetNotStartedRunPassIds();

            var breaksToDelete = GatherBreaks(salesArea);

            var clashDiffsToDelete = GatherClashDifferences(salesArea);

            (List <Restriction> restrictionsToDelete,
             List <RestrictionSalesArea> restrictionSalesAreasToDelete) = GatherRestrictions(salesArea);

            var inventoryLocksToDelete = GatherInventoryLocks(salesArea);

            var librarySalesAreaPassPrioritiesToDelete = GatherLibrarySalesAreaPassPriorities(salesArea);

            var isrSettingsToDelete = GatherIsrSettings(salesArea);

            var rsSettingsToDelete = GatherRsSettings(salesArea);

            var breakExclusionsToDelete = GatherBreakExclusions(salesArea, notStartedPassIds);

            var passSalesAreaPrioritiesToDelete = GatherPassSalesAreaPriorities(salesArea, notStartedPassIds);

            (List <PassRatingPoint> passRatingPointsToDelete,
             List <PassRatingPoint> passRatingPointsToUpdate) = GatherPassRatingPoints(salesArea, notStartedPassIds);

            var ratingsPredictionSchedulesToDelete = GatherRatingsPredictionSchedules(salesArea);

            var runSalesAreaPrioritiesToDelete = GatherRunSalesAreaPriorities(salesArea, notStartedRunIds);

            var programmesToDelete = GatherProgrammes(salesArea);

            var salesAreaDemographicsToDelete = GatherSalesAreaDemos(salesArea);

            var schedulesToDelete = GatherSchedules(salesArea);

            var universesToDelete = GatherUniverses(salesArea);

            (List <SponsorshipItem> sponsorshipItemsToDelete,
             List <SponsorshipItem> sponsorshipItemsToUpdate) = GatherSponsorshipItems(salesArea);

            (List <SpotBookingRule> spotBookingRulesToDelete,
             List <SpotBookingRuleSalesArea> spotBookingRuleSalesAreasToDelete) = GatherSpotBookingRules(salesArea);

            var spotsToDelete = GatherSpots(salesArea);

            var totalRatingsToDelete = GatherTotalRatings(salesArea);

            var transaction = _dbContext.Specific.Database.BeginTransaction();

            try
            {
                _dbContext.BulkInsertEngine.BulkDelete(breaksToDelete);
                _dbContext.BulkInsertEngine.BulkDelete(clashDiffsToDelete);
                _dbContext.BulkInsertEngine.BulkDelete(restrictionsToDelete);
                _dbContext.BulkInsertEngine.BulkDelete(restrictionSalesAreasToDelete);
                _dbContext.BulkInsertEngine.BulkDelete(inventoryLocksToDelete);
                _dbContext.BulkInsertEngine.BulkDelete(librarySalesAreaPassPrioritiesToDelete);
                _dbContext.BulkInsertEngine.BulkDelete(isrSettingsToDelete);
                _dbContext.BulkInsertEngine.BulkDelete(rsSettingsToDelete);
                _dbContext.BulkInsertEngine.BulkDelete(breakExclusionsToDelete);
                _dbContext.BulkInsertEngine.BulkDelete(passSalesAreaPrioritiesToDelete);
                _dbContext.RemoveRange(passRatingPointsToDelete.ToArray());
                _dbContext.BulkInsertEngine.BulkDelete(ratingsPredictionSchedulesToDelete);
                _dbContext.BulkInsertEngine.BulkDelete(runSalesAreaPrioritiesToDelete);
                _dbContext.BulkInsertEngine.BulkDelete(programmesToDelete);
                _dbContext.BulkInsertEngine.BulkDelete(salesAreaDemographicsToDelete);
                _dbContext.BulkInsertEngine.BulkDelete(schedulesToDelete);
                _dbContext.BulkInsertEngine.BulkDelete(universesToDelete);
                _dbContext.BulkInsertEngine.BulkDelete(sponsorshipItemsToDelete);
                _dbContext.BulkInsertEngine.BulkDelete(spotBookingRulesToDelete);
                _dbContext.BulkInsertEngine.BulkDelete(spotBookingRuleSalesAreasToDelete);
                _dbContext.BulkInsertEngine.BulkDelete(spotsToDelete);
                _dbContext.BulkInsertEngine.BulkDelete(totalRatingsToDelete);

                _dbContext.BulkInsertEngine.BulkUpdate(passRatingPointsToUpdate);
                _dbContext.BulkInsertEngine.BulkUpdate(sponsorshipItemsToUpdate);

                _dbContext.Remove(salesArea);

                _dbContext.SaveChanges();

                transaction.Commit();
            }
            catch
            {
                transaction.Rollback();
                throw;
            }
            finally
            {
                transaction.Dispose();
            }
        }
Exemplo n.º 17
0
 public Domain.Shared.SalesAreas.SalesArea Find(Guid id) =>
 _mapper.Map <Domain.Shared.SalesAreas.SalesArea>(_dbContext.Find <Entities.Tenant.SalesAreas.SalesArea>(new object[] { id },
                                                                                                         find => find.IncludeCollection(sa => sa.ChannelGroups).IncludeCollection(sa => sa.Holidays)));
Exemplo n.º 18
0
 public TotalRating Get(int id) => _mapper.Map <TotalRating>(_dbContext.Find <TotalRatingEntity>(id),
                                                             opts => opts.UseEntityCache(_salesAreaByIdCache));
Exemplo n.º 19
0
 public StandardDayPartGroup Get(int id) =>
 _mapper.Map <StandardDayPartGroup>(_dbContext.Find <StandardDayPartGroupEntity>(new object[] { id },
                                                                                 find => find.IncludeCollection(x => x.Splits)),
                                    opts => opts.UseEntityCache(_salesAreaByIdCache));
Exemplo n.º 20
0
 public ProgrammeDictionary Find(int id) =>
 _mapper.Map <ProgrammeDictionary>(_dbContext.Find <Entities.Tenant.ProgrammeDictionary>(id));
Exemplo n.º 21
0
 public Universe Find(Guid id) =>
 _mapper.Map <Universe>(_dbContext.Find <Entities.Tenant.Universe>(id),
                        opts => opts.UseEntityCache(_salesAreaByIdCache));
Exemplo n.º 22
0
 public InventoryLock Get(int id) => _mapper.Map <InventoryLock>(_dbContext.Find <Entities.Tenant.InventoryStatuses.InventoryLock>(id), opts => opts.UseEntityCache(_salesAreaByIdCache));
Exemplo n.º 23
0
 public BookingPosition Get(int id) => _mapper.Map <BookingPosition>(_dbContext.Find <BookingPositionEntity>(id));
Exemplo n.º 24
0
 public void Delete(int id)
 {
     _dbContext.Remove(_dbContext.Find <PassEntity>(id));
 }
 public ProgrammeCategoryHierarchy Get(int id) => _mapper.Map <ProgrammeCategoryHierarchy>(_dbContext.Find <Entities.Tenant.ProgrammeCategoryHierarchy>(id));
Exemplo n.º 26
0
 private RunTypeEntity GetEntity(int id) => _dbContext.Find <RunTypeEntity>(id);
Exemplo n.º 27
0
 public IndexType Find(int id) => _mapper.Map <IndexType>(_dbContext.Find <Entities.Tenant.IndexType>(id), opts => opts.UseEntityCache(_salesAreaByIdCache));
Exemplo n.º 28
0
 public SpotBookingRule Get(int id) =>
 _mapper.Map <SpotBookingRule>(_dbContext.Find <SpotBookingRuleEntity>(new object[] { id },
                                                                       post => post.IncludeCollection(e => e.SalesAreas)), opts => opts.UseEntityCache(_salesAreaByIdCache));
 public AWSInstanceConfiguration Get(int id)
 {
     return(_mapper.Map <AWSInstanceConfiguration>(_dbContext.Find <Entities.Tenant.AWSInstanceConfiguration>(id)));
 }
Exemplo n.º 30
0
 public ClearanceCode Find(int id) =>
 _mapper.Map <ClearanceCode>(_dbContext.Find <Entities.Tenant.ClearanceCode>(id));