public static void Initialize()
{
FtpTrace.AddListener(new NLog.NLogTraceListener());
Logger.Info("Engines initializing");
ConnectionStringSettings connectionStringPrimary = ConfigurationManager.ConnectionStrings["tasConnectionString"];
ConnectionStringSettings connectionStringSecondary = ConfigurationManager.ConnectionStrings["tasConnectionStringSecondary"];
Database = DatabaseProviderLoader.LoadDatabaseProvider();
Logger.Debug("Connecting to database");
Database.Open(connectionStringPrimary?.ConnectionString, connectionStringSecondary?.ConnectionString);
_servers = Database.LoadServers <CasparServer>();
_servers.ForEach(s =>
{
s.ChannelsSer.ForEach(c => c.Owner = s);
s.RecordersSer.ForEach(r => r.SetOwner(s));
});
var authenticationService = new AuthenticationService(Database.Load <User>(), Database.Load <Group>());
Engines = Database.LoadEngines <Engine>(ulong.Parse(ConfigurationManager.AppSettings["Instance"]));
foreach (var e in Engines)
{
e.Initialize(_servers, authenticationService);
}
Logger.Debug("Engines initialized");
}
public ConfigFileViewmodel(Model.ConfigFile configFile)
: base(configFile, typeof(ConfigFileView), $"Config file ({configFile.FileName})")
{
_db = DatabaseProviderLoader.LoadDatabaseProvider();
CommandEditConnectionString = new UICommand {
ExecuteDelegate = _editConnectionString
};
CommandEditConnectionStringSecondary = new UICommand {
ExecuteDelegate = _editConnectionStringSecondary
};
CommandTestConnectivity = new UICommand {
ExecuteDelegate = _testConnectivity, CanExecuteDelegate = o => !string.IsNullOrWhiteSpace(tasConnectionString)
};
CommandTestConnectivitySecodary = new UICommand {
ExecuteDelegate = _testConnectivitySecondary, CanExecuteDelegate = o => !string.IsNullOrWhiteSpace(tasConnectionStringSecondary) && _isConnectionStringSecondary
};
CommandCreateDatabase = new UICommand {
ExecuteDelegate = _createDatabase, CanExecuteDelegate = o => !string.IsNullOrWhiteSpace(tasConnectionString)
};
CommandCloneDatabase = new UICommand {
ExecuteDelegate = _clonePrimaryDatabase, CanExecuteDelegate = o => !(string.IsNullOrWhiteSpace(tasConnectionString) || string.IsNullOrWhiteSpace(tasConnectionStringSecondary))
};
Load(Model.appSettings);
Load(Model.connectionStrings);
_isConnectionStringSecondary = !string.IsNullOrWhiteSpace(tasConnectionStringSecondary);
}
public Engines(string connectionStringPrimary, string connectionStringSecondary)
{
ConnectionStringPrimary = connectionStringPrimary;
ConnectionStringSecondary = connectionStringSecondary;
_db = DatabaseProviderLoader.LoadDatabaseProvider();
_db.Open(connectionStringPrimary, connectionStringSecondary);
ArchiveDirectories = new ArchiveDirectories(_db);
try
{
_db.Open();
EngineList = _db.DbLoadEngines <Engine>();
Servers = _db.DbLoadServers <CasparServer>();
Servers.ForEach(s =>
{
s.Channels.ForEach(c => c.Owner = s);
s.Recorders.ForEach(r => r.Owner = s);
});
EngineList.ForEach(e =>
{
e.IsNew = false;
e.Servers = Servers;
e.ArchiveDirectories = ArchiveDirectories;
});
}
finally
{
_db.Close();
}
}
public PlayoutServers(string connectionStringPrimary, string connectionStringSecondary)
{
_db = DatabaseProviderLoader.LoadDatabaseProvider();
_db.Open(connectionStringPrimary, connectionStringSecondary);
Servers = _db.LoadServers <CasparServer>();
Servers.ForEach(s =>
{
s.IsNew = false;
s.Channels.ForEach(c => c.Owner = s);
s.Recorders.ForEach(r => r.Owner = s);
});
}
/// <summary> /// Paraméter létrehozása /// </summary> public static IDbDataParameter CreateDataParameter <T>(DatabaseEngine databaseEngine, string parameterName, T parameterValue) => DatabaseProviderLoader.CreateParameter <T>(databaseEngine, parameterName, parameterValue);
public bool CreateEmptyDatabase()
{
return(DatabaseProviderLoader.LoadDatabaseProvider().CreateEmptyDatabase(ConnectionString, Collation));
}
