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