/// <summary>
/// Loads the requested object Type
/// </summary>
/// <param name="name">The name of the object type to load</param>
/// <returns>The requested object type</returns>
public static OSAEObjectType ObjectTypeLoad(string name)
{
MySqlCommand command = new MySqlCommand();
DataSet dataset = new DataSet();
try
{
command.CommandText = "SELECT object_type, object_type_description, object_type_owner, container, hide_redundant_events, base_type, object_name, system_hidden, object_type_tooltip FROM osae_v_object_type WHERE object_type=@Name";
command.Parameters.AddWithValue("@Name", name);
dataset = OSAESql.RunQuery(command);
if (dataset.Tables[0].Rows.Count > 0)
{
OSAEObjectType type = new OSAEObjectType();
type.BaseType = dataset.Tables[0].Rows[0]["base_type"].ToString();
type.Description = dataset.Tables[0].Rows[0]["object_type_description"].ToString();
type.Name = dataset.Tables[0].Rows[0]["object_type"].ToString();
type.OwnedBy = dataset.Tables[0].Rows[0]["object_name"].ToString();
type.Tooltip = dataset.Tables[0].Rows[0]["object_type_tooltip"].ToString();
type.Owner = false;
if (dataset.Tables[0].Rows[0]["object_type_owner"].ToString() == "1")
{
type.Owner = true;
}
type.SysType = false;
if (dataset.Tables[0].Rows[0]["system_hidden"].ToString() == "1")
{
type.SysType = true;
}
type.Container = false;
if (dataset.Tables[0].Rows[0]["container"].ToString() == "1")
{
type.Container = true;
}
type.HideRedundant = false;
if (dataset.Tables[0].Rows[0]["hide_redundant_events"].ToString() == "1")
{
type.HideRedundant = true;
}
return(type);
}
else
{
return(null);
}
}
catch (Exception ex)
{
Logging.GetLogger().AddToLog("API - GetObjectTypeLoad (" + name + ")error: " + ex.Message, true);
return(null);
}
}
/// <summary>
/// Loads the requested object Type
/// </summary>
/// <param name="name">The name of the object type to load</param>
/// <returns>The requested object type</returns>
public static OSAEObjectType ObjectTypeLoad(string name)
{
MySqlCommand command = new MySqlCommand();
DataSet dataset = new DataSet();
try
{
command.CommandText = "SELECT object_type, object_type_description, object_type_owner, container, hide_redundant_events, base_type, object_name, system_hidden FROM osae_v_object_type WHERE object_type=@Name";
command.Parameters.AddWithValue("@Name", name);
dataset = OSAESql.RunQuery(command);
if (dataset.Tables[0].Rows.Count > 0)
{
OSAEObjectType type = new OSAEObjectType();
type.BaseType = dataset.Tables[0].Rows[0]["base_type"].ToString();
type.Description = dataset.Tables[0].Rows[0]["object_type_description"].ToString();
type.Name = dataset.Tables[0].Rows[0]["object_type"].ToString();
type.OwnedBy = dataset.Tables[0].Rows[0]["object_name"].ToString();
type.Owner = false;
if (dataset.Tables[0].Rows[0]["object_type_owner"].ToString() == "1") type.Owner = true;
type.SysType = false;
if (dataset.Tables[0].Rows[0]["system_hidden"].ToString() == "1") type.SysType = true;
type.Container = false;
if (dataset.Tables[0].Rows[0]["container"].ToString() == "1") type.Container = true;
type.HideRedundant = false;
if (dataset.Tables[0].Rows[0]["hide_redundant_events"].ToString() == "1") type.HideRedundant = true;
return type;
}
else
{
return null;
}
}
catch (Exception ex)
{
Logging.GetLogger().AddToLog("API - GetObjectTypeLoad (" + name + ")error: " + ex.Message, true);
return null;
}
}
