public void AcceptMessage(Startup bootMessage)
{
foreach (Assembly thisAssembly in AppDomain.CurrentDomain.GetAssemblies())
{
if (thisAssembly is null || thisAssembly.IsDynamic)
{
continue;
}
foreach (string Resource in thisAssembly.GetManifestResourceNames())
{
if (Resource.Contains(ROOT_NS, StringComparison.Ordinal))
{
if (Resource.From(ROOT_NS).To(".") == STORED_PROCEDURE_FOLDER)
{
string NameSpace = Resource.From(ROOT_NS + STORED_PROCEDURE_FOLDER + ".");
string Script = string.Empty;
using (Stream? stream = thisAssembly.GetManifestResourceStream(Resource))
{
if (stream is null)
{
throw new NullReferenceException($"Manifest stream not found for resource {Resource}");
}
using StreamReader reader = new StreamReader(stream);
Script = reader.ReadToEnd();
}
StoredProcedure thisProc = new StoredProcedure(Script);
//Get the name after the room, trim the extention and then the proc name;
if (NameSpace.Count(c => c == '.') > 1)
{
NameSpace = NameSpace.ToLast(".").ToLast(".");
thisProc.RenameProcedure($"{NameSpace.Replace(".", "\\", StringComparison.OrdinalIgnoreCase)}\\{thisProc.Name}");
}
if (!thisProc.ConnectionStrings.Any())
{
thisProc.ConnectionStrings.Add(ConfigurationNames.DEFAULT_CONNECTION_STRING);
}
foreach (string ConnectionString in thisProc.ConnectionStrings)
{
string connectionString = this.ConfigurationService.GetConnectionString(ConnectionString);
//Cheap SDF hack. Should be fixed
if (!string.IsNullOrWhiteSpace(connectionString) && !connectionString.Contains(".sdf", StringComparison.OrdinalIgnoreCase))
{
DatabaseInstance di = new DatabaseInstance(connectionString);
di.ImportProcedure(thisProc);
}
}
}
else
{
throw new Exception(UNSUPPORTED_SQL_TYPE_MESSAGE);
}
}
}
}
}
