public async Task Update(OuterInnerResourcePnDbContext dbContext)
{
ResourceTimeRegistration resourceTimeRegistration = dbContext.ResourceTimeRegistrations.FirstOrDefault(x => x.Id == Id);
if (resourceTimeRegistration == null)
{
throw new NullReferenceException($"Could not find area with id: {Id}");
}
resourceTimeRegistration.InnerResourceId = InnerResourceId;
resourceTimeRegistration.OuterResourceId = OuterResourceId;
resourceTimeRegistration.DoneAt = DoneAt;
resourceTimeRegistration.SDKCaseId = SDKCaseId;
resourceTimeRegistration.SDKFieldValueId = SDKFieldValueId;
resourceTimeRegistration.TimeInSeconds = TimeInSeconds;
resourceTimeRegistration.TimeInMinutes = TimeInMinutes;
resourceTimeRegistration.TimeInHours = TimeInHours;
resourceTimeRegistration.SDKSiteId = SDKSiteId;
if (dbContext.ChangeTracker.HasChanges())
{
resourceTimeRegistration.UpdatedAt = DateTime.Now;
resourceTimeRegistration.Version += 1;
dbContext.ResourceTimeRegistrationVersions.Add(MapVersions(resourceTimeRegistration));
dbContext.SaveChanges();
}
}
public ResourceTimeRegistrationService(OuterInnerResourcePnDbContext dbContext,
IEFormCoreService coreService)
{
_dbContext = dbContext;
_coreService = coreService;
_deviceUserNames = new List <KeyValuePair <int, string> >();
_outerResourceNames = new List <KeyValuePair <int, string> >();
_innerResourceNames = new List <KeyValuePair <int, string> >();
}
//public RentableItemsPnDbAnySql db;
public void GetContext(string connectionStr)
{
OuterInnerResourcePnContextFactory contextFactory = new OuterInnerResourcePnContextFactory();
DbContext = contextFactory.CreateDbContext(new[] { connectionStr });
DbContext.Database.Migrate();
DbContext.Database.EnsureCreated();
}
public OuterResourceService(OuterInnerResourcePnDbContext dbContext,
IOuterInnerResourceLocalizationService localizationService,
ILogger <OuterResourceService> logger,
IRebusService rebusService)
{
_dbContext = dbContext;
_localizationService = localizationService;
_logger = logger;
_bus = rebusService.GetBus();
}
public async Task Create(OuterInnerResourcePnDbContext dbContext)
{
CreatedAt = DateTime.Now;
UpdatedAt = DateTime.Now;
Version = 1;
WorkflowState = eForm.Infrastructure.Constants.Constants.WorkflowStates.Created;
dbContext.OuterInnerResources.Add(this);
dbContext.SaveChanges();
dbContext.OuterInnerResourceVersions.Add(MapVersions(this));
dbContext.SaveChanges();
}
public OuterInnerResourceReportService(ILogger <OuterInnerResourceReportService> logger,
OuterInnerResourcePnDbContext dbContext,
IEFormCoreService coreHelper,
IOuterInnerResourceLocalizationService outerInnerResourceLocalizationService,
IPluginDbOptions <OuterInnerResourceSettings> options,
IExcelService excelService)
{
_logger = logger;
_dbContext = dbContext;
_coreHelper = coreHelper;
_outerInnerResourceLocalizationService = outerInnerResourceLocalizationService;
_excelService = excelService;
_options = options;
}
public OuterInnerResourceSettingsService(
ILogger <OuterInnerResourceSettingsService> logger,
OuterInnerResourcePnDbContext dbContext,
IOuterInnerResourceLocalizationService outerInnerResourceLocalizationService,
IPluginDbOptions <OuterInnerResourceSettings> options,
IRebusService rebusService,
IUserService userService)
{
_logger = logger;
_dbContext = dbContext;
_outerInnerResourceLocalizationService = outerInnerResourceLocalizationService;
_options = options;
_bus = rebusService.GetBus();
_userService = userService;
}
public async Task Delete(OuterInnerResourcePnDbContext dbContext)
{
OuterInnerResource outerInnerResource = dbContext.OuterInnerResources.FirstOrDefault(x => x.Id == Id);
if (outerInnerResource == null)
{
throw new NullReferenceException($"Could not find machineArea with id: {Id}");
}
outerInnerResource.WorkflowState = eForm.Infrastructure.Constants.Constants.WorkflowStates.Removed;
if (dbContext.ChangeTracker.HasChanges())
{
outerInnerResource.UpdatedAt = DateTime.Now;
outerInnerResource.Version += 1;
dbContext.OuterInnerResourceVersions.Add(MapVersions(outerInnerResource));
dbContext.SaveChanges();
}
}
public async Task Delete(OuterInnerResourcePnDbContext dbContext)
{
ResourceTimeRegistration resourceTimeRegistration = dbContext.ResourceTimeRegistrations.FirstOrDefault(x => x.Id == Id);
if (resourceTimeRegistration == null)
{
throw new NullReferenceException($"Could not find area with id: {Id}");
}
resourceTimeRegistration.WorkflowState = eForm.Infrastructure.Constants.Constants.WorkflowStates.Removed;
if (dbContext.ChangeTracker.HasChanges())
{
resourceTimeRegistration.UpdatedAt = DateTime.Now;
resourceTimeRegistration.Version += 1;
dbContext.ResourceTimeRegistrationVersions.Add(MapVersions(resourceTimeRegistration));
dbContext.SaveChanges();
}
}
public async Task Update(OuterInnerResourcePnDbContext dbContext)
{
InnerResource innerResource = dbContext.InnerResources.FirstOrDefault(x => x.Id == Id);
if (innerResource == null)
{
throw new NullReferenceException($"Could not find Machine with id: {Id}");
}
innerResource.Name = Name;
innerResource.ExternalId = ExternalId;
if (dbContext.ChangeTracker.HasChanges())
{
innerResource.UpdatedAt = DateTime.Now;
innerResource.Version += 1;
dbContext.InnerResourceVersions.Add(MapVersions(innerResource));
dbContext.SaveChanges();
}
}
public async Task Update(OuterInnerResourcePnDbContext dbContext)
{
OuterInnerResource outerInnerResource = dbContext.OuterInnerResources.FirstOrDefault(x => x.Id == Id);
if (outerInnerResource == null)
{
throw new NullReferenceException($"Could not find machineArea with id: {Id}");
}
outerInnerResource.OuterResourceId = OuterResourceId;
outerInnerResource.InnerResourceId = InnerResourceId;
if (dbContext.ChangeTracker.HasChanges())
{
outerInnerResource.UpdatedAt = DateTime.Now;
outerInnerResource.Version += 1;
dbContext.OuterInnerResourceVersions.Add(MapVersions(outerInnerResource));
dbContext.SaveChanges();
}
}
public static void SeedData(OuterInnerResourcePnDbContext dbContext)
{
var seedData = new OuterInnerResourceConfigurationSeedData();
var configurationList = seedData.Data;
foreach (var configurationItem in configurationList)
{
if (!dbContext.PluginConfigurationValues.Any(x=>x.Name == configurationItem.Name))
{
var newConfigValue = new PluginConfigurationValue()
{
Name = configurationItem.Name,
Value = configurationItem.Value,
CreatedAt = DateTime.UtcNow,
Version = 1,
WorkflowState = Constants.WorkflowStates.Created,
CreatedByUserId = 1
};
dbContext.PluginConfigurationValues.Add(newConfigValue);
dbContext.SaveChanges();
}
}
// Seed plugin permissions
var newPermissions = OuterInnerResourcePermissionsSeedData.Data
.Where(p => dbContext.PluginPermissions.All(x => x.ClaimName != p.ClaimName))
.Select(p => new PluginPermission
{
PermissionName = p.PermissionName,
ClaimName = p.ClaimName,
CreatedAt = DateTime.UtcNow,
Version = 1,
WorkflowState = Constants.WorkflowStates.Created,
CreatedByUserId = 1
}
);
dbContext.PluginPermissions.AddRange(newPermissions);
dbContext.SaveChanges();
}
public eFormCompletedHandler(eFormCore.Core sdkCore, DbContextHelper dbContextHelper)
{
_dbContext = dbContextHelper.GetDbContext();
_sdkCore = sdkCore;
}
public OuterInnerResourceDeleteHandler(Core core, DbContextHelper dbContextHelper)
{
_core = core;
_dbContext = dbContextHelper.GetDbContext();
}
public OuterInnerResourceUpdateHandler(Core core, DbContextHelper dbContextHelper, IBus bus)
{
_core = core;
_dbContext = dbContextHelper.GetDbContext();
_bus = bus;
}
public bool Start(string sdkConnectionString, string serviceLocation)
{
Console.WriteLine("ServiceOuterInnerResourcePlugin start called");
try
{
var dbNameSection = Regex.Match(sdkConnectionString, @"(Database=\w*;)").Groups[0].Value;
var dbPrefix = Regex.Match(sdkConnectionString, @"Database=(\d*)_").Groups[1].Value;
string pluginDbName = $"Database={dbPrefix}_eform-angular-outer-inner-resource-plugin;";
string connectionString = sdkConnectionString.Replace(dbNameSection, pluginDbName);
string rabbitmqHost = connectionString.Contains("frontend") ? $"frontend-{dbPrefix}-rabbitmq" :"localhost";
if (!_coreAvailable && !_coreStatChanging)
{
_serviceLocation = serviceLocation;
_coreStatChanging = true;
if (string.IsNullOrEmpty(_serviceLocation))
{
throw new ArgumentException("serviceLocation is not allowed to be null or empty");
}
if (string.IsNullOrEmpty(connectionString))
{
throw new ArgumentException("serverConnectionString is not allowed to be null or empty");
}
//OuterInnerResourcePnContextFactory contextFactory = new OuterInnerResourcePnContextFactory();
_dbContextHelper = new DbContextHelper(connectionString);
_dbContext = _dbContextHelper.GetDbContext();//.CreateDbContext(new[] { connectionString });
//_dbContextHelper = new DbContextHelper(connectionString);
_dbContext.Database.Migrate();
_coreAvailable = true;
_coreStatChanging = false;
startSdkCoreSqlOnly(sdkConnectionString);
string temp = _dbContext.PluginConfigurationValues
.SingleOrDefault(x => x.Name == "OuterInnerResourceSettings:MaxParallelism")?.Value;
_maxParallelism = string.IsNullOrEmpty(temp) ? 1 : int.Parse(temp);
temp = _dbContext.PluginConfigurationValues
.SingleOrDefault(x => x.Name == "OuterInnerResourceSettings:NumberOfWorkers")?.Value;
_numberOfWorkers = string.IsNullOrEmpty(temp) ? 1 : int.Parse(temp);
_container = new WindsorContainer();
//_container.Register(Component.For<OuterInnerResourcePnDbContext>().Instance(_dbContext));
_container.Register(Component.For <eFormCore.Core>().Instance(_sdkCore));
_container.Register(Component.For <DbContextHelper>().Instance(_dbContextHelper));
_container.Install(
new RebusHandlerInstaller()
, new RebusInstaller(connectionString, _maxParallelism, _numberOfWorkers, "admin", "password", rabbitmqHost)
);
_bus = _container.Resolve <IBus>();
temp = _dbContext.PluginConfigurationValues
.SingleOrDefault(x => x.Name == "OuterInnerResourceSettings:ShouldCheckAllCases")?.Value;
Console.WriteLine("[DBG] ServiceOuterInnerResourcePlugin.Start: ShouldCheckAllCases set to: " + temp);
if (temp.ToLower() == "true")
{
temp = _dbContext.PluginConfigurationValues
.SingleOrDefault(x => x.Name == "OuterInnerResourceSettings:SdkeFormId")?.Value;
Console.WriteLine("[DBG] ServiceOuterInnerResourcePlugin.Start: SdkeFormId set to: " + temp);
_bus.SendLocal(new CheckAllCases(int.Parse(temp)));
}
}
Console.WriteLine("ServiceOuterInnerResourcePlugin started");
return(true);
}
catch (Exception ex)
{
Console.ForegroundColor = ConsoleColor.DarkRed;
Console.WriteLine("[ERR] ServiceOuterInnerResourcePlugin.Start: Start failed " + ex.Message);
throw ex;
}
}
public CheckAllCasesHandler(eFormCore.Core sdkCore, DbContextHelper dbContextHelper, IBus bus)
{
_dbContext = dbContextHelper.GetDbContext();
_sdkCore = sdkCore;
_bus = bus;
}
