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; }