public OSAEObject(string name, string description, string type, string address, string container, int enabled)
{
Name = name;
Type = type;
Address = address;
Container = container;
Enabled = enabled;
Description = description;
State = new ObjectState();
}
/// <summary>
/// Returns a ObjectState object
/// </summary>
/// <param name="ObjectName"></param>
/// <returns></returns>
public ObjectState GetObjectStateValue(string ObjectName)
{
DataSet dataset = new DataSet();
ObjectState state = new ObjectState();
try
{
using (MySqlCommand command = new MySqlCommand())
{
command.CommandText = "SELECT state_label, coalesce(time_in_state, 0) as time_in_state FROM osae_v_object WHERE object_name=@ObjectName";
command.Parameters.AddWithValue("@ObjectName", ObjectName);
dataset = RunQuery(command);
}
if (dataset.Tables[0].Rows.Count > 0)
{
state.Value = dataset.Tables[0].Rows[0]["state_label"].ToString();
state.TimeInState = Convert.ToInt64(dataset.Tables[0].Rows[0]["time_in_state"]);
return state;
}
else
{
AddToLog("API - GetObjectStateValue error: Object does not exist | ObjectName: " + ObjectName, true);
return null;
}
}
catch (Exception ex)
{
AddToLog("API - GetObjectStateValue error: " + ex.Message + " | ObjectName: " + ObjectName, true);
return null;
}
finally
{
dataset.Dispose();
}
}
public OSAEObject()
{
State = new ObjectState();
}
public OSAEObject()
{
State = new ObjectState();
}
