public List <OSAEObject> GetAllObjects()
{
MySqlCommand command = new MySqlCommand("SELECT object_name, object_description, object_type_description, container_name, state_label, last_updated, address, enabled, time_in_state, base_type FROM osae_v_object");
DataSet ds = osae.RunQuery(command);
List <OSAEObject> objs = new List <OSAEObject>();
OSAEObject obj;
foreach (DataRow dr in ds.Tables[0].Rows)
{
obj = new OSAEObject(dr["object_name"].ToString(), dr["object_description"].ToString(), dr["object_type_description"].ToString(), dr["address"].ToString(), dr["container_name"].ToString(), Int32.Parse(dr["enabled"].ToString()));
obj.LastUpd = dr["last_updated"].ToString();
obj.State.Value = dr["state_label"].ToString();
obj.State.TimeInState = long.Parse(dr["time_in_state"].ToString());
obj.BaseType = dr["base_type"].ToString();
objs.Add(obj);
}
return(objs);
}
/// <summary>
/// Add an entry to the degug table
/// </summary>
/// <param name="entry">String to add to the debug table</param>
public void DebugLogAdd(string entry)
{
try
{
using (MySqlCommand command = new MySqlCommand())
{
OSAE osae = new OSAE(string.Empty);
command.CommandText = "CALL osae_sp_debug_log_add (@Entry,@Process)";
command.Parameters.AddWithValue("@Entry", entry);
command.Parameters.AddWithValue("@Process", callingProcess);
osae.RunQuery(command);
}
}
catch
{
// Not a lot we can do if it fails here
}
}
/// <summary>
/// Deletes everything from the event_log table
/// </summary>
public void EventLogClear()
{
using (MySqlCommand command = new MySqlCommand())
{
command.CommandText = "CALL osae_sp_event_log_clear";
try
{
OSAE osae = new OSAE(string.Empty);
osae.RunQuery(command);
}
catch (Exception ex)
{
AddToLog("API - EventLogClear error: " + command.CommandText + " - error: " + ex.Message, true);
}
}
}
/// <summary>
/// Add an entry to the event log table
/// </summary>
/// <param name="objectName">Object Name</param>
/// <param name="eventName">Event Name</param>
public void EventLogAdd(string objectName, string eventName, string parameter1 = null, string parameter2 = null)
{
using (MySqlCommand command = new MySqlCommand())
{
OSAE osae = new OSAE(string.Empty);
command.CommandText = "CALL osae_sp_event_log_add (@ObjectName, @EventName, @FromObject, @DebugInfo, @Param1, @Param2)";
command.Parameters.AddWithValue("@ObjectName", objectName);
command.Parameters.AddWithValue("@EventName", eventName);
command.Parameters.AddWithValue("@FromObject", osae.GetPluginName(callingProcess, Common.ComputerName));
command.Parameters.AddWithValue("@DebugInfo", null);
command.Parameters.AddWithValue("@Param1", parameter1);
command.Parameters.AddWithValue("@Param2", parameter2);
try
{
osae.RunQuery(command);
}
catch (Exception ex)
{
AddToLog("API - EventLogAdd error: " + command.CommandText + " - error: " + ex.Message, true);
}
}
}
public static bool InstallPlugin(string PluginPackagePath, ref string ErrorText)
{
OSAE osae = new OSAE("Plugin Installer");
Logging logging = new Logging("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)
{
logging.AddToLog("Error running sql script: " + s + " | " + ex.Message, true);
}
}
System.IO.Directory.Move(tempfolder, exePath + "/Plugins/" + 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 + "/Plugins/" + pluginFolder, "*.x64");
foreach (string str in x64files)
{
string destFile = System.IO.Path.Combine(exePath + "/Plugins/" + 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 + "/Plugins/" + pluginFolder, "*.x64");
foreach (string str in delfiles)
System.IO.File.Delete(str);
logging.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)
{
logging.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;
}