public static bool InstallPlugin(string PluginPackagePath, ref string ErrorText)
{
OSAE.OSAE osae = new OSAE.OSAE("Plugin Installer");
string exePath = Path.GetDirectoryName(Application.ExecutablePath);
if (Directory.Exists(exePath + "/tempDir/"))
{
Directory.Delete(exePath + "/tempDir/", true);
}
PluginDescription desc = new PluginDescription();
string tempfolder = exePath + "/tempDir/";
string zipFileName = Path.GetFullPath(PluginPackagePath);
string DescPath = null;
bool NoError = true;
FastZip fastZip = new FastZip();
//try
//{
fastZip.ExtractZip(zipFileName, tempfolder, null);
// find all included plugin descriptions and install the plugins
List<string> osapdFiles = new List<string>();
List<string> sqlFiles = new List<string>();
string[] pluginFile = Directory.GetFiles(tempfolder, "*.osapd", SearchOption.TopDirectoryOnly);
osapdFiles.AddRange(pluginFile);
string[] sqlFile = Directory.GetFiles(tempfolder, "*.sql", SearchOption.TopDirectoryOnly);
sqlFiles.AddRange(sqlFile);
if (osapdFiles.Count == 0)
{
MessageBox.Show("No plugin description files found.");
return false;
}
if (osapdFiles.Count > 1)
{
MessageBox.Show("More than one plugin description file found.");
return false;
}
if (osapdFiles.Count == 1)
{
DescPath = osapdFiles[0];
}
if (!string.IsNullOrEmpty(DescPath))
{
desc.Deserialize(DescPath);
//NoError = desc.VerifyInstall(ref ErrorText);
//uninstall previous plugin and delete the folder
bool u = UninstallPlugin(desc);
// get the plugin folder path
string pluginFolder = desc.Path;
if (!string.IsNullOrEmpty(pluginFolder)) //only extract valid plugins
{
//Directory.CreateDirectory(exePath + "/Plugins/" + pluginFolder);
string[] files = System.IO.Directory.GetFiles(tempfolder);
// Copy the files and overwrite destination files if they already exist.
//foreach (string s in files)
//{
// string fileName = System.IO.Path.GetFileName(s);
// if (desc.AdditionalAssemblies.Contains(fileName))
// {
// string destFile = System.IO.Path.Combine(exePath + "/", fileName);
// System.IO.File.Copy(s, destFile, true);
// }
//}
string ConnectionString = string.Format("Uid={0};Pwd={1};Server={2};Port={3};Database={4};allow user variables=true",
osae.DBUsername, osae.DBPassword, osae.DBConnection, osae.DBPort, osae.DBName);
MySql.Data.MySqlClient.MySqlConnection connection = new MySql.Data.MySqlClient.MySqlConnection(ConnectionString);
connection.Open();
foreach (string s in sqlFile)
{
try
{
MySql.Data.MySqlClient.MySqlScript script = new MySql.Data.MySqlClient.MySqlScript(connection,File.ReadAllText(s));
script.Execute();
}
catch (Exception ex)
{
osae.AddToLog("Error running sql script: " + s + " | " + ex.Message, true);
}
}
System.IO.Directory.Move(tempfolder, exePath + "/AddIns/" + pluginFolder);
//Check if we are running a x64 bit architecture (This is a silly way to do it since I am not sure if every 64 bit machine has this directory...)
bool is64bit = Environment.Is64BitOperatingSystem;
//Do a check for any x64 assemblies, and prompt the user to install them if they are running a 64 bit machine
if (is64bit && (desc.x64Assemblies.Count > 0))
{
/* x64 assemblies generally have the same name as their x32 counterparts when referenced by the OSA app
* however they are packaged as "filename.ext.x64" so we will replace the 32bit file which is installed by
* default with the 64bit versioin with the same filename.ext
*/
if (MessageBox.Show(
"You are running an x64 architecture and this plugin has specific assemblies built for 64bit machines." +
" It is highly recommended that you install the 64bit versions to ensure proper compatibility",
"Install 64bit Assemblies?", MessageBoxButtons.YesNo) == DialogResult.Yes)
{
//Install the 64bit assemblies over the 32 bit ones...
string[] x64files = System.IO.Directory.GetFiles(exePath + "/AddIns/" + pluginFolder, "*.x64");
foreach (string str in x64files)
{
string destFile = System.IO.Path.Combine(exePath + "/AddIns/" + pluginFolder + "/", System.IO.Path.GetFileNameWithoutExtension(str));
//Copy it to the new destination overwriting the old file if it exists
System.IO.File.Copy(str, destFile, true);
}
}
}
//Delete all the files with .x64 extensions since they aren't needed anymore
string[] delfiles = System.IO.Directory.GetFiles(exePath + "/AddIns/" + pluginFolder, "*.x64");
foreach (string str in delfiles)
System.IO.File.Delete(str);
osae.AddToLog("Sending message to service to load plugin.", true);
using (MySql.Data.MySqlClient.MySqlCommand command = new MySql.Data.MySqlClient.MySqlCommand())
{
command.CommandText = "CALL osae_sp_method_queue_add (@pobject,@pmethod,@pparameter1,@pparameter2,@pfromobject,@pdebuginfo);";
command.Parameters.AddWithValue("@pobject", "SERVICE-" + osae.ComputerName);
command.Parameters.AddWithValue("@pmethod", "LOAD PLUGIN");
command.Parameters.AddWithValue("@pparameter1", "");
command.Parameters.AddWithValue("@pparameter2", "");
command.Parameters.AddWithValue("@pfromobject", "");
command.Parameters.AddWithValue("@pdebuginfo", "");
try
{
osae.RunQuery(command);
}
catch (Exception ex)
{
osae.AddToLog("Error adding LOAD PLUGIN method: " + command.CommandText + " - error: " + ex.Message, true);
}
}
}
}
//}
//catch (Exception ex)
//{
// MessageBox.Show("catch: " + ex.Message);
// return false;
//}
if (Directory.Exists(exePath + "/tempDir/"))
{
deleteFolder(exePath + "/tempDir/");
}
osae.MethodQueueAdd("SERVICE-" + osae.ComputerName, "RELOAD PLUGINS", "", "");
return NoError;
}
public static bool InstallPlugin(string PluginPackagePath, ref string ErrorText)
{
OSAE.OSAE osae = new OSAE.OSAE("Plugin Installer");
string exePath = Path.GetDirectoryName(Application.ExecutablePath);
if (Directory.Exists(exePath + "/tempDir/"))
{
Directory.Delete(exePath + "/tempDir/", true);
}
PluginDescription desc = new PluginDescription();
string tempfolder = exePath + "/tempDir/";
string zipFileName = Path.GetFullPath(PluginPackagePath);
string DescPath = null;
bool NoError = true;
FastZip fastZip = new FastZip();
//try
//{
fastZip.ExtractZip(zipFileName, tempfolder, null);
// find all included plugin descriptions and install the plugins
List <string> osapdFiles = new List <string>();
List <string> sqlFiles = new List <string>();
string[] pluginFile = Directory.GetFiles(tempfolder, "*.osapd", SearchOption.TopDirectoryOnly);
osapdFiles.AddRange(pluginFile);
string[] sqlFile = Directory.GetFiles(tempfolder, "*.sql", SearchOption.TopDirectoryOnly);
sqlFiles.AddRange(sqlFile);
if (osapdFiles.Count == 0)
{
MessageBox.Show("No plugin description files found.");
return(false);
}
if (osapdFiles.Count > 1)
{
MessageBox.Show("More than one plugin description file found.");
return(false);
}
if (osapdFiles.Count == 1)
{
DescPath = osapdFiles[0];
}
if (!string.IsNullOrEmpty(DescPath))
{
desc.Deserialize(DescPath);
//NoError = desc.VerifyInstall(ref ErrorText);
//uninstall previous plugin and delete the folder
bool u = UninstallPlugin(desc);
// get the plugin folder path
string pluginFolder = desc.Path;
if (!string.IsNullOrEmpty(pluginFolder)) //only extract valid plugins
{
//Directory.CreateDirectory(exePath + "/Plugins/" + pluginFolder);
string[] files = System.IO.Directory.GetFiles(tempfolder);
// Copy the files and overwrite destination files if they already exist.
//foreach (string s in files)
//{
// string fileName = System.IO.Path.GetFileName(s);
// if (desc.AdditionalAssemblies.Contains(fileName))
// {
// string destFile = System.IO.Path.Combine(exePath + "/", fileName);
// System.IO.File.Copy(s, destFile, true);
// }
//}
string ConnectionString = string.Format("Uid={0};Pwd={1};Server={2};Port={3};Database={4};allow user variables=true",
osae.DBUsername, osae.DBPassword, osae.DBConnection, osae.DBPort, osae.DBName);
MySql.Data.MySqlClient.MySqlConnection connection = new MySql.Data.MySqlClient.MySqlConnection(ConnectionString);
connection.Open();
foreach (string s in sqlFile)
{
try
{
MySql.Data.MySqlClient.MySqlScript script = new MySql.Data.MySqlClient.MySqlScript(connection, File.ReadAllText(s));
script.Execute();
}
catch (Exception ex)
{
osae.AddToLog("Error running sql script: " + s + " | " + ex.Message, true);
}
}
System.IO.Directory.Move(tempfolder, exePath + "/AddIns/" + pluginFolder);
//Check if we are running a x64 bit architecture (This is a silly way to do it since I am not sure if every 64 bit machine has this directory...)
bool is64bit = Environment.Is64BitOperatingSystem;
//Do a check for any x64 assemblies, and prompt the user to install them if they are running a 64 bit machine
if (is64bit && (desc.x64Assemblies.Count > 0))
{
/* x64 assemblies generally have the same name as their x32 counterparts when referenced by the OSA app
* however they are packaged as "filename.ext.x64" so we will replace the 32bit file which is installed by
* default with the 64bit versioin with the same filename.ext
*/
if (MessageBox.Show(
"You are running an x64 architecture and this plugin has specific assemblies built for 64bit machines." +
" It is highly recommended that you install the 64bit versions to ensure proper compatibility",
"Install 64bit Assemblies?", MessageBoxButtons.YesNo) == DialogResult.Yes)
{
//Install the 64bit assemblies over the 32 bit ones...
string[] x64files = System.IO.Directory.GetFiles(exePath + "/AddIns/" + pluginFolder, "*.x64");
foreach (string str in x64files)
{
string destFile = System.IO.Path.Combine(exePath + "/AddIns/" + pluginFolder + "/", System.IO.Path.GetFileNameWithoutExtension(str));
//Copy it to the new destination overwriting the old file if it exists
System.IO.File.Copy(str, destFile, true);
}
}
}
//Delete all the files with .x64 extensions since they aren't needed anymore
string[] delfiles = System.IO.Directory.GetFiles(exePath + "/AddIns/" + pluginFolder, "*.x64");
foreach (string str in delfiles)
{
System.IO.File.Delete(str);
}
osae.AddToLog("Sending message to service to load plugin.", true);
using (MySql.Data.MySqlClient.MySqlCommand command = new MySql.Data.MySqlClient.MySqlCommand())
{
command.CommandText = "CALL osae_sp_method_queue_add (@pobject,@pmethod,@pparameter1,@pparameter2,@pfromobject,@pdebuginfo);";
command.Parameters.AddWithValue("@pobject", "SERVICE-" + osae.ComputerName);
command.Parameters.AddWithValue("@pmethod", "LOAD PLUGIN");
command.Parameters.AddWithValue("@pparameter1", "");
command.Parameters.AddWithValue("@pparameter2", "");
command.Parameters.AddWithValue("@pfromobject", "");
command.Parameters.AddWithValue("@pdebuginfo", "");
try
{
osae.RunQuery(command);
}
catch (Exception ex)
{
osae.AddToLog("Error adding LOAD PLUGIN method: " + command.CommandText + " - error: " + ex.Message, true);
}
}
}
}
//}
//catch (Exception ex)
//{
// MessageBox.Show("catch: " + ex.Message);
// return false;
//}
if (Directory.Exists(exePath + "/tempDir/"))
{
deleteFolder(exePath + "/tempDir/");
}
osae.MethodQueueAdd("SERVICE-" + osae.ComputerName, "RELOAD PLUGINS", "", "");
return(NoError);
}