private void oRecognizer_SpeechRecognized(object sender, System.Speech.Recognition.SpeechRecognizedEventArgs e) { DataSet dsResults = new DataSet(); String sPattern = ""; try { if ((e.Result.Text == gWakePhrase) & (gVRMuted == true)) { gVRMuted = false; lblStatus.Content = "I am awake"; } else if ((e.Result.Text == gSleepPhrase) & (gVRMuted == false)) { gVRMuted = true; lblStatus.Content = "I am sleeping"; } // gSpeechPlugin; String temp = OSAEApi.GetObjectPropertyValue(gSpeechPlugin, "Speaking").Value.ToString().ToLower(); if (temp.ToLower() == "true") { try { AddToLog("Ignored Speech because TTS was talking."); } catch (Exception ex) { } } else { if ((gVRMuted == false) || (e.Result.Text == gSleepPhrase) || (e.Result.Text == gSleepPhrase)) { try { string sText = OSAEApi.MatchPattern(e.Result.Text); OSAEApi.MethodQueueAdd("Script Processor", "NAMED SCRIPT", sText, ""); AddToLog("Heard: " + e.Result.Text + ", Ran: " + sText); } catch (Exception ex) { } } } } catch (Exception ex) { AddToLog("Error in _SpeechRecognized: " + ex.Message); } }
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; }
private void State_Image_MouseLeftButtonDown(object sender, MouseEventArgs e) { Image iImage = (Image)sender; MySqlCommand CMD = new MySqlCommand(); CMD.Connection = CN; CMD.CommandType = CommandType.Text; //outputStatus = DirectCast(sender, PictureBox).Tag foreach (ScreenObject dso in aScreenObject) { if (dso.Object_Name == iImage.Tag) { if (dso.Object_State == "ON") { CMD.CommandText = "SELECT COUNT(*) FROM osae_v_object_method WHERE object_name='" + dso.Object_Name + "' AND method_name='OFF'"; try { CN.Open(); Int32 iResults = Convert.ToInt32(CMD.ExecuteScalar()); CN.Close(); if (iResults > 0) { OSAEApi.MethodQueueAdd(dso.Object_Name, "OFF", "", ""); } else { OSAEApi.ObjectStateSet(dso.Object_Name, "OFF"); } } catch (Exception ex) { MessageBox.Show("Error ClickControlStateImage: " + ex.Message); CN.Close(); } } else { CMD.CommandText = "SELECT COUNT(*) FROM osae_v_object_method WHERE object_name='" + dso.Object_Name + "' AND method_name='ON'"; try { CN.Open(); Int32 iResults = Convert.ToInt32(CMD.ExecuteScalar()); CN.Close(); if (iResults > 0) { OSAEApi.MethodQueueAdd(dso.Object_Name, "ON", "", ""); } else { OSAEApi.ObjectStateSet(dso.Object_Name, "ON"); } } catch (Exception ex) { MessageBox.Show("Error ClickControlStateImage: " + ex.Message); CN.Close(); } } } } }
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); }