/// <summary>
/// Deletes everything from the event_log table
/// </summary>
public static void EventLogClear()
{
using (MySqlCommand command = new MySqlCommand())
{
command.CommandText = "CALL osae_sp_event_log_clear";
try
{
OSAESql.RunQuery(command);
}
catch (Exception ex)
{
throw ex;
}
}
}
public static DataSet LoadSources()
{
using (MySqlCommand command = new MySqlCommand())
{
command.CommandText = "SELECT DISTINCT Logger FROM osae_log";
try
{
return(OSAESql.RunQuery(command));
}
catch (Exception ex)
{
throw ex;
}
}
}
public static DataSet Load(bool info, bool debug, bool error, string source)
{
using (MySqlCommand command = new MySqlCommand())
{
command.CommandText = "CALL osae_sp_server_log_get (@pinfo, @pdebug, @perror, @psource)";
command.Parameters.AddWithValue("@pinfo", info);
command.Parameters.AddWithValue("@pdebug", debug);
command.Parameters.AddWithValue("@perror", error);
command.Parameters.AddWithValue("@psource", source);
try
{ return(OSAESql.RunQuery(command)); }
catch (Exception ex)
{ throw ex; }
}
}
public void DebugLogAdd(string entry)
{
try
{
using (MySqlCommand command = new MySqlCommand())
{
command.CommandText = "CALL osae_sp_debug_log_add (@Entry,@Process)";
command.Parameters.AddWithValue("@Entry", entry);
command.Parameters.AddWithValue("@Process", logSource.ToString());
OSAESql.RunQuery(command);
}
}
catch
{
// Not a lot we can do if it fails here
}
}
public OSAEObjectCollection 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 = OSAESql.RunQuery(command);
OSAEObjectCollection objs = new OSAEObjectCollection();
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);
}
public DataSet ExecuteSQL(string sql)
{
MySqlCommand command = new MySqlCommand(sql);
return(OSAESql.RunQuery(command));
}
