public PluginPermissionsManager GetPermissionsManager(string connectionString)
{
WorkOrderPnContextFactory contextFactory = new WorkOrderPnContextFactory();
WorkOrderPnDbContext context = contextFactory.CreateDbContext(new[] { connectionString });
return(new PluginPermissionsManager(context));
}
public void SeedDatabase(string connectionString)
{
// Get DbContext
WorkOrderPnContextFactory contextFactory = new WorkOrderPnContextFactory();
using WorkOrderPnDbContext context = contextFactory.CreateDbContext(new[] { connectionString });
// Seed configuration
WorkOrdersPluginSeed.SeedData(context);
}
private void GetContext(string connectionStr)
{
WorkOrderPnContextFactory contextFactory = new WorkOrderPnContextFactory();
DbContext = contextFactory.CreateDbContext(new[] { connectionStr });
DbContext.Database.Migrate();
DbContext.Database.EnsureCreated();
}
public void AddPluginConfig(IConfigurationBuilder builder, string connectionString)
{
WorkOrdersConfigurationSeedData seedData = new WorkOrdersConfigurationSeedData();
WorkOrderPnContextFactory contextFactory = new WorkOrderPnContextFactory();
builder.AddPluginConfiguration(
connectionString,
seedData,
contextFactory);
}
public void ConfigureDbContext(IServiceCollection services, string connectionString)
{
_connectionString = connectionString;
services.AddDbContext <WorkOrderPnDbContext>(o => o.UseMySql(connectionString, new MariaDbServerVersion(
new Version(10, 4, 0)), mySqlOptionsAction: builder =>
{
builder.EnableRetryOnFailure();
builder.MigrationsAssembly(PluginAssembly().FullName);
}));
WorkOrderPnContextFactory contextFactory = new WorkOrderPnContextFactory();
WorkOrderPnDbContext context = contextFactory.CreateDbContext(new[] { connectionString });
context.Database.Migrate();
// Seed database
SeedDatabase(connectionString);
}
public WorkOrderPnDbContext GetDbContext()
{
WorkOrderPnContextFactory contextFactory = new WorkOrderPnContextFactory();
return(contextFactory.CreateDbContext(new[] { ConnectionString }));
}
public bool Start(string sdkConnectionString, string serviceLocation)
{
Console.WriteLine("ServiceWorkOrdersPlugin start called");
try
{
string dbNameSection;
string dbPrefix;
if (sdkConnectionString.ToLower().Contains("convert zero datetime"))
{
dbNameSection = Regex.Match(sdkConnectionString, @"(Database=\w*;)").Groups[0].Value;
dbPrefix = Regex.Match(sdkConnectionString, @"Database=(\d*)_").Groups[1].Value;
}
else
{
dbNameSection = Regex.Match(sdkConnectionString, @"(Initial Catalog=\w*;)").Groups[0].Value;
dbPrefix = Regex.Match(sdkConnectionString, @"Initial Catalog=(\d*)_").Groups[1].Value;
}
string pluginDbName = $"Initial Catalog={dbPrefix}_eform-angular-work-orders-plugin;";
string connectionString = sdkConnectionString.Replace(dbNameSection, pluginDbName);
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");
}
WorkOrderPnContextFactory contextFactory = new WorkOrderPnContextFactory();
_dbContext = contextFactory.CreateDbContext(new[] { connectionString });
_dbContext.Database.Migrate();
_dbContextHelper = new DbContextHelper(connectionString);
_coreAvailable = true;
_coreStatChanging = false;
StartSdkCoreSqlOnly(sdkConnectionString);
string temp = _dbContext.PluginConfigurationValues
.SingleOrDefault(x => x.Name == "WorkOrdersBaseSettings:MaxParallelism")?.Value;
_maxParallelism = string.IsNullOrEmpty(temp) ? 1 : int.Parse(temp);
temp = _dbContext.PluginConfigurationValues
.SingleOrDefault(x => x.Name == "WorkOrdersBaseSettings:NumberOfWorkers")?.Value;
_numberOfWorkers = string.IsNullOrEmpty(temp) ? 1 : int.Parse(temp);
_container = new WindsorContainer();
_container.Register(Component.For <IWindsorContainer>().Instance(_container));
_container.Register(Component.For <DbContextHelper>().Instance(_dbContextHelper));
_container.Register(Component.For <eFormCore.Core>().Instance(_sdkCore));
_container.Install(
new RebusHandlerInstaller()
, new RebusInstaller(connectionString, _maxParallelism, _numberOfWorkers)
);
_bus = _container.Resolve <IBus>();
}
Console.WriteLine("WorkOrdersPlugin started");
return(true);
}
catch (Exception ex)
{
Console.ForegroundColor = ConsoleColor.DarkRed;
Console.WriteLine("Start failed " + ex.Message);
throw;
}
}
