protected void Page_Load(object sender, EventArgs e)
{
loadObjectTypes();
gvObjectTypes.DataSource = OSAESql.RunSQL("SELECT base_type, object_type, object_type_description FROM osae_v_object_type ORDER BY base_type, object_type");
gvObjectTypes.DataBind();
if (hdnSelectedPropRow.Text != "")
{
loadProperties();
}
if (hdnSelectedStateRow.Text != "")
{
loadStates();
}
if (hdnSelectedMethodRow.Text != "")
{
loadMethods();
}
if (hdnSelectedEventRow.Text != "")
{
loadEvents();
}
if (!this.IsPostBack)
{
loadDDLs();
}
}
private void loadDDLs()
{
ddlBaseType.DataSource = OSAESql.RunSQL("SELECT object_type as Text, object_type as Value FROM osae_object_type ORDER BY object_type");;
ddlBaseType.DataBind();
if (ddlBaseType.Items.Count == 0)
{
ddlBaseType.Visible = false;
}
else
{
ddlBaseType.Visible = true;
}
ddlBaseType.Items.Insert(0, new ListItem(String.Empty, String.Empty));
ddlOwnedBy.DataSource = OSAESql.RunSQL("SELECT object_name as Text, object_name as Value FROM osae_v_object where object_type_owner = 1 ORDER BY object_name");;
ddlOwnedBy.DataBind();
if (ddlOwnedBy.Items.Count == 0)
{
ddlOwnedBy.Visible = false;
}
else
{
ddlOwnedBy.Visible = true;
}
ddlOwnedBy.Items.Insert(0, new ListItem(String.Empty, String.Empty));
}
private void objectComboBox_SelectionChanged(object sender, SelectionChangedEventArgs e)
{
DataSet dataSet = OSAESql.RunSQL("SELECT state_name FROM osae_v_object_state where object_name = '" + objectComboBox.SelectedValue + "' order by state_name");
Image1StateComboBox.ItemsSource = dataSet.Tables[0].DefaultView;
Image2StateComboBox.ItemsSource = dataSet.Tables[0].DefaultView;
}
private void loadMethods()
{
txtMethodName.Text = "";
txtMethodLabel.Text = "";
txtMethodTooltip.Text = "";
gvMethods.DataSource = OSAESql.RunSQL("SELECT method_name, method_label, param_1_label, param_2_label, param_1_default, param_2_default, method_tooltip FROM osae_v_object_type_method where object_type='" + hdnSelectedObjectName.Text + "' ORDER BY method_name");
gvMethods.DataBind();
if (gvMethods.Rows.Count > 0)
{
gvMethods.SelectedIndex = 0;
try
{
hdnSelectedMethodRow.Text = gvMethods.SelectedIndex.ToString();
hdnSelectedMethodName.Text = gvMethods.DataKeys[gvMethods.SelectedIndex]["method_name"].ToString();
txtMethodName.Text = gvMethods.DataKeys[gvMethods.SelectedIndex]["method_name"].ToString();
txtMethodLabel.Text = gvMethods.DataKeys[gvMethods.SelectedIndex]["method_label"].ToString();
txtParam1Label.Text = gvMethods.DataKeys[Int32.Parse(hdnSelectedMethodRow.Text)]["param_1_label"].ToString();
txtParam2Label.Text = gvMethods.DataKeys[Int32.Parse(hdnSelectedMethodRow.Text)]["param_2_label"].ToString();
txtParam1Default.Text = gvMethods.DataKeys[Int32.Parse(hdnSelectedMethodRow.Text)]["param_1_default"].ToString();
txtParam2Default.Text = gvMethods.DataKeys[Int32.Parse(hdnSelectedMethodRow.Text)]["param_2_default"].ToString();
txtMethodTooltip.Text = gvMethods.DataKeys[gvMethods.SelectedIndex]["method_tooltip"].ToString();
}
catch (Exception ex) { }
}
}
void xmppCon_OnMessage(object sender, agsXMPP.protocol.client.Message msg)
{
try
{
// ignore empty messages (events)
if (msg.Body == null || oldMmsg == msg || msg.Type == agsXMPP.protocol.client.MessageType.error)
{
return;
}
oldMmsg = msg;
DataSet dsResults = new DataSet(); //Build a List of all Users to identify who is sending the message.
dsResults = OSAESql.RunSQL("SELECT DISTINCT(object_name) FROM osae_v_object_property WHERE property_name = 'JabberID' and property_value = '" + msg.From.Bare + "' ORDER BY object_name");
gCurrentUser = dsResults.Tables[0].Rows[0][0].ToString();
OSAEObjectPropertyManager.ObjectPropertySet(gCurrentUser, "Communication Method", "Jabber", gCurrentUser);
gCurrentAddress = msg.From.Bare;
RecognitionResult rr = oRecognizer.EmulateRecognize(msg.Body);
if (rr == null)
{
if (gDebug)
{
Log.Debug("INPUT: No Matching Pattern found!");
}
}
}
catch (Exception ex)
{ Log.Error("Error in _OnMessage!", ex); }
}
protected void ddlObjectType_SelectedIndexChanged(object sender, EventArgs e)
{
ddlObjTypeEvent.DataSource = OSAESql.RunSQL("SELECT event_label as Text, event_name as Value FROM osae_v_object_type_event WHERE object_type_id = " + ddlObjectType.SelectedValue + " ORDER BY event_label");
ddlObjTypeEvent.Items.Insert(0, new ListItem(String.Empty, String.Empty));
ddlObjTypeEvent.DataBind();
loadObjTypeEventScripts();
}
protected void ddlMethod_SelectedIndexChanged(object sender, EventArgs e)
{
DataSet ds = OSAESql.RunSQL("SELECT param_1_label, param_2_label, param_1_default, param_2_default FROM osae_v_object_type_method otm INNER JOIN osae_object oo ON oo.object_type_id = otm.object_type_id WHERE object_name = '" + hdnSelectedObjectName.Text.Replace("'", "''") + "' AND method_name = '" + ddlMethod.SelectedItem.Value + "'");
DataTable dt = ds.Tables[0];
if (dt.Rows.Count > 0)
{
if (!string.IsNullOrEmpty(dt.Rows[0]["param_1_label"].ToString()))
{
divParameters.Visible = true;
txtParam1.Text = dt.Rows[0]["param_1_default"].ToString();
txtParam2.Text = dt.Rows[0]["param_2_default"].ToString();
if (!String.IsNullOrEmpty(dt.Rows[0]["param_1_label"].ToString()))
{
lblParam1.Text = "(" + dt.Rows[0]["param_1_label"].ToString() + ")";
}
if (!String.IsNullOrEmpty(dt.Rows[0]["param_2_label"].ToString()))
{
lblParam2.Text = "(" + dt.Rows[0]["param_2_label"].ToString() + ")";
}
}
else
{
OSAEMethodManager.MethodQueueAdd(hdnSelectedObjectName.Text, ddlMethod.SelectedItem.Value, "", "", "Web UI");
lblAlert.Text = "Method successfuly executed: " + ddlMethod.SelectedItem.Text;
alert.Visible = true;
}
}
else
{
OSAEMethodManager.MethodQueueAdd(hdnSelectedObjectName.Text, ddlMethod.SelectedItem.Value, "", "", "Web UI");
lblAlert.Text = "Method successfuly executed: " + ddlMethod.SelectedItem.Text;
alert.Visible = true;
}
}
public AddControlTimerLabel(string screen, string controlName = "")
{
InitializeComponent();
currentScreen = screen;
LoadObjects();
LoadColors();
//Check if controlName was passed in, if so, goto edit mode
if (controlName != "")
{
//Let's validate the controlName and then call a Pre-Load of its properties
DataSet dsScreenControl = OSAESql.RunSQL("SELECT COUNT(object_name) FROM osae_v_object where object_name = '" + controlName + "'");
if (dsScreenControl.Tables[0].Rows[0][0].ToString() == "1")
{
// We have a hit, this is an Update call, se call the preload
sMode = "Update";
sOriginalName = controlName;
lblName.Content = controlName;
LoadCurrentScreenObject(controlName);
}
}
else
{
sMode = "Add";
}
Enable_Buttons();
}
private void cboObject_SelectionChanged(object sender, SelectionChangedEventArgs e)
{
DataSet dataSet = OSAESql.RunSQL("select property_name from osae_v_object_property where object_name='" + (sender as ComboBox).SelectedValue.ToString() + "' Union select 'State' order by property_name");
cboProperty.ItemsSource = dataSet.Tables[0].DefaultView;
lblProperty.IsEnabled = true;
cboProperty.IsEnabled = true;
}
private void GetDBSize()
{
string sql = "SELECT SUM( data_length + index_length) / 1024 / 1024 AS size FROM information_schema.TABLES WHERE table_schema = 'OSAE';";
DataSet d = OSAESql.RunSQL(sql);
decimal size = (decimal)d.Tables[0].Rows[0]["size"];
dbSize.Text = String.Format("{0:0.##}", size) + "Mb";
}
private void cboPressObject_SelectionChanged(object sender, SelectionChangedEventArgs e)
{
DataSet dataSet = OSAESql.RunSQL("SELECT method_name FROM osae_v_object_method where object_name = '" + cboPressObject.SelectedValue + "' order by method_name");
cboPressMethod.IsEnabled = true;
cboPressMethod.ItemsSource = dataSet.Tables[0].DefaultView;
txtControlName.Text = currentScreen + " - " + cboPressObject.SelectedValue + " - Click Image";
}
private void cboState1_SelectionChanged(object sender, SelectionChangedEventArgs e)
{
btnLoadS1I1.IsEnabled = true;
imgState1Img1.IsEnabled = true;
cboState2.IsEnabled = true;
DataSet dataSet = OSAESql.RunSQL("SELECT state_label, state_name FROM osae_v_object_state where object_name = '" + cboObject.SelectedValue.ToString().Replace("'", "''") + "' AND state_name !='" + cboState1.SelectedValue + "' order by state_label");
cboState2.ItemsSource = dataSet.Tables[0].DefaultView;
}
private void BindData()
{
try
{
eventLogGridView.DataSource = OSAESql.RunSQL("SELECT log_time,object_name,event_label,parameter_1,parameter_2,from_object_name FROM osae_v_event_log ORDER BY osae_v_event_log.log_time DESC LIMIT 500");
eventLogGridView.DataBind();
}
catch (Exception ex)
{ Master.Log.Error("Error retreiving event log", ex); }
}
private void BindData()
{
try
{
debugLogGridView.DataSource = OSAESql.RunSQL("SELECT log_time, entry, debug_trace FROM osae_debug_log ORDER BY log_time DESC LIMIT 500");
debugLogGridView.DataBind();
}
catch (Exception ex)
{ Master.Log.Error("Error retreiving debug log", ex); }
}
private string GetTableSize(string tableName)
{
decimal size = 0;
string sql;
DataSet d;
sql = "SELECT SUM( data_length + index_length) / 1024 / 1024 AS size FROM information_schema.TABLES WHERE table_schema = 'OSAE' AND TABLE_NAME = '" + tableName + "';";
d = OSAESql.RunSQL(sql);
size = (decimal)d.Tables[0].Rows[0]["size"];
return(String.Format("{0:0.##}", size) + "Mb");
}
/// <summary>
/// Load the objects from the DB into the combo box
/// </summary>
private void LoadObjects()
{
DataSet dataSet = OSAESql.RunSQL("SELECT object_name FROM osae_v_object WHERE object_type !='SCREEN' AND base_type != 'CONTROL' order by object_name");
cboPressObject.ItemsSource = dataSet.Tables[0].DefaultView;
cboReleaseObject.ItemsSource = dataSet.Tables[0].DefaultView;
DataSet dataSet2 = OSAESql.RunSQL("SELECT script_name FROM osae_script order by script_name");
cboPressScript.ItemsSource = dataSet2.Tables[0].DefaultView;
cboReleaseScript.ItemsSource = dataSet2.Tables[0].DefaultView;
}
private void cboObject_SelectionChanged(object sender, SelectionChangedEventArgs e)
{
DataSet dataSet = OSAESql.RunSQL("SELECT state_name FROM osae_v_object_state where object_name = '" + cboObject.SelectedValue + "' order by state_name");
cboState1.ItemsSource = dataSet.Tables[0].DefaultView;
cboState2.ItemsSource = dataSet.Tables[0].DefaultView;
DataSet dataSet2 = OSAESql.RunSQL("SELECT method_name FROM osae_v_object_method where object_name = '" + cboObject.SelectedValue + "' order by method_name");
cboSliderMethod.ItemsSource = dataSet2.Tables[0].DefaultView;
}
protected void btnUpdate_Click(object sender, EventArgs e)
{
int enabled = 0;
if (chkEnabled.Checked)
{
enabled = 1;
}
OSAEObjectManager.ObjectUpdate(gvObjects.DataKeys[Int32.Parse(hdnSelectedRow.Text)]["object_name"].ToString(), txtName.Text, txtDescr.Text, ddlType.SelectedValue, txtAddress.Text, ddlContainer.SelectedValue, enabled);
gvObjects.DataSource = OSAESql.RunSQL("SELECT object_id, container_name, object_name, object_type, state_label, state_name, last_updated, address FROM osae_v_object order by container_name, object_name");
gvObjects.DataBind();
}
protected void btnAdd_Click(object sender, EventArgs e)
{
OSAEObjectManager.ObjectAdd(txtName.Text, txtDescr.Text, ddlType.SelectedItem.Value, txtAddress.Text, ddlContainer.SelectedValue, chkEnabled.Checked);
gvObjects.DataSource = OSAESql.RunSQL("SELECT object_id, container_name, object_name, object_type, state_label, state_name, last_updated, address FROM osae_v_object order by container_name, object_name");
gvObjects.DataBind();
txtName.Text = "";
txtDescr.Text = "";
txtAddress.Text = "";
chkEnabled.Checked = false;
panelEditForm.Visible = false;
loadDDLs();
}
private void BindData()
{
try
{
methodLogGridView.DataSource = OSAESql.RunSQL("SELECT entry_time, object_name, method_name, parameter_1, parameter_2, debug_trace FROM osae_v_method_log ORDER BY entry_time DESC, method_log_id DESC LIMIT 500");
methodLogGridView.DataBind();
}
catch (Exception ex)
{
logging.AddToLog("Error retreiving method log: " + ex.Message, true);
}
}
protected void btnUpdate_Click(object sender, EventArgs e)
{
int enabled = 0;
if (chkEnabled.Checked)
{
enabled = 1;
}
OSAEObjectManager.ObjectUpdate(gvObjects.DataKeys[gvObjects.SelectedIndex]["object_name"].ToString(), txtName.Text, txtAlias.Text, txtDescr.Text, ddlType.SelectedValue, txtAddress.Text, ddlContainer.SelectedValue, enabled);
gvObjects.DataSource = OSAESql.RunSQL("SELECT object_id, container_name, object_name, object_type, state_label, state_name, DATE_FORMAT(last_updated,'%m/%d %h:%i:%s %p') as last_updated, address FROM osae_v_object order by container_name, object_name");
gvObjects.DataBind();
}
private void BindData()
{
try
{
methodLogGridView.DataSource = OSAESql.RunSQL("SELECT entry_time, osae_v_method_log.object_name, method_name, if(method_name='RUN SCRIPT', (select script_name from osae_script where script_id=parameter_1), parameter_1) as parameter_1, parameter_2, osae_object.object_name As from_object FROM osae_v_method_log join osae_object on (osae_v_method_log.from_object_id = osae_object.object_id) ORDER BY osae_v_method_log.entry_time DESC LIMIT 500");
methodLogGridView.DataBind();
}
catch (Exception ex)
{
logging.AddToLog("Error retreiving method log: " + ex.Message, true);
}
}
protected void btnAdd_Click(object sender, EventArgs e)
{
OSAEObjectManager.ObjectAdd(txtName.Text, txtAlias.Text, txtDescr.Text, ddlType.SelectedItem.Value, txtAddress.Text, ddlContainer.SelectedValue, Convert.ToInt16(txtTrustLevel.Text), chkEnabled.Checked);
gvObjects.DataSource = OSAESql.RunSQL(objectSQL);
gvObjects.DataBind();
txtName.Text = "";
txtDescr.Text = "";
txtAddress.Text = "";
chkEnabled.Checked = false;
panelEditForm.Visible = false;
loadDDLs();
}
protected void btnDelete_Click(object sender, EventArgs e)
{
OSAEObjectManager.ObjectDelete(gvObjects.DataKeys[gvObjects.SelectedIndex]["object_name"].ToString());
gvObjects.DataSource = OSAESql.RunSQL("SELECT object_id, container_name, object_name, object_type, state_label, state_name, DATE_FORMAT(last_updated,'%m/%d %h:%i:%s %p') as last_updated, address FROM osae_v_object order by container_name, object_name");
gvObjects.DataBind();
txtName.Text = "";
txtDescr.Text = "";
txtAddress.Text = "";
ddlContainer.SelectedValue = "";
ddlType.SelectedValue = "";
chkEnabled.Checked = false;
panelEditForm.Visible = false;
}
public List <string> GetSystemStates()
{
List <string> states = new List <string>();
DataSet ds = OSAESql.RunSQL("select state_name from osae_v_object_state where object_name = 'SYSTEM'");
foreach (DataRow dr in ds.Tables[0].Rows)
{
states.Add(dr["state_name"].ToString());
}
return(states);
}
private void importObject(Stream stream)
{
StreamReader reader = new StreamReader(stream);
string objSQL = "";
do
{
string sqlLine = reader.ReadLine();
objSQL += sqlLine;
} while (reader.Peek() != -1);
reader.Close();
OSAESql.RunSQL(objSQL);
}
protected void btnDelete_Click(object sender, EventArgs e)
{
OSAEObjectManager.ObjectDelete(gvObjects.DataKeys[gvObjects.SelectedIndex]["object_name"].ToString());
gvObjects.DataSource = OSAESql.RunSQL(objectSQL);
gvObjects.DataBind();
txtName.Text = "";
txtDescr.Text = "";
txtAddress.Text = "";
ddlContainer.SelectedValue = "";
ddlType.SelectedValue = "";
chkEnabled.Checked = false;
panelEditForm.Visible = false;
}
protected void Page_Load(object sender, EventArgs e)
{
gvObjects.DataSource = OSAESql.RunSQL("SELECT object_id, container_name, object_name, object_type, state_label, state_name, last_updated, address FROM osae_v_object order by container_name, object_name");
gvObjects.DataBind();
if (!this.IsPostBack)
{
loadDDLs();
}
if (hdnSelectedPropRow.Text != "")
{
loadProperties();
}
}
private void loadObjTypeEventScripts()
{
gvObjTypeScripts.DataSource = OSAESql.RunSQL("SELECT script_name, script_id, script_sequence, object_type_event_script_id FROM osae_v_object_type_event_script WHERE object_type_id = " + ddlObjectType.SelectedValue + " AND event_name = '" + ddlObjTypeEvent.SelectedValue + "' ORDER BY script_sequence ASC");
gvObjTypeScripts.DataBind();
if (gvObjTypeScripts.Rows.Count == 0)
{
pnlObjTypeEventScripts.Visible = false;
}
else
{
pnlObjTypeEventScripts.Visible = true;
}
}
protected void objectsExportButton_Click(object sender, EventArgs e)
{
DataSet d = OSAESql.RunSQL("SELECT object_id, container_name, object_name, object_type, state_name, last_updated, address FROM osae_v_object order by container_name, object_name");
MemoryStream s = new MemoryStream();
d.DataSetName = "Objects";
d.Tables[0].TableName = "Object";
d.WriteXml(s);
Response.BinaryWrite(s.ToArray());
Response.ContentType = "text/xml";
Response.AddHeader("Content-Disposition", "attachment; filename=Objects.xml");
Response.End();
}
