public static OSAERecurringSchedule GetRecurringSchedule(string name)
{
try
{
using (MySqlCommand command = new MySqlCommand())
{
DataSet dataset = new DataSet();
OSAEScreenControl ctrl = new OSAEScreenControl();
command.CommandText = "SELECT schedule_name, parameter_1, parameter_2, recurring_time, monday, tuesday, wednesday, thursday, friday, saturday, sunday, interval_unit, recurring_minutes," +
"recurring_day, recurring_date, script_name, method_name, object_name, active " +
"FROM osae.osae_v_schedule_recurring WHERE schedule_name=@Name";
command.Parameters.AddWithValue("@Name", name);
dataset = OSAESql.RunQuery(command);
if (dataset.Tables[0].Rows.Count > 0)
{
OSAERecurringSchedule schedule = new OSAERecurringSchedule();
schedule.Name = name;
schedule.Param1 = dataset.Tables[0].Rows[0]["parameter_1"].ToString();
schedule.Param2 = dataset.Tables[0].Rows[0]["parameter_2"].ToString();
schedule.Time = dataset.Tables[0].Rows[0]["recurring_time"].ToString();
schedule.Monday = dataset.Tables[0].Rows[0]["monday"].ToString();
schedule.Tuesday = dataset.Tables[0].Rows[0]["tuesday"].ToString();
schedule.Wednesday = dataset.Tables[0].Rows[0]["wednesday"].ToString();
schedule.Thursday = dataset.Tables[0].Rows[0]["thursday"].ToString();
schedule.Friday = dataset.Tables[0].Rows[0]["friday"].ToString();
schedule.Saturday = dataset.Tables[0].Rows[0]["saturday"].ToString();
schedule.Sunday = dataset.Tables[0].Rows[0]["sunday"].ToString();
schedule.Interval = dataset.Tables[0].Rows[0]["interval_unit"].ToString();
schedule.Minutes = dataset.Tables[0].Rows[0]["recurring_minutes"].ToString();
schedule.MonthDay = dataset.Tables[0].Rows[0]["recurring_day"].ToString();
schedule.Date = dataset.Tables[0].Rows[0]["recurring_date"].ToString();
schedule.Script = dataset.Tables[0].Rows[0]["script_name"].ToString();
schedule.Method = dataset.Tables[0].Rows[0]["method_name"].ToString();
schedule.Object = dataset.Tables[0].Rows[0]["object_name"].ToString();
schedule.Active = dataset.Tables[0].Rows[0]["active"].ToString();
return(schedule);
}
}
return(null);
}
catch (Exception ex)
{
Logging.GetLogger().AddToLog("API - GetRecurringScedule error: " + ex.Message, true);
return(null);
}
}
public static OSAERecurringSchedule GetRecurringSchedule(string name)
{
try
{
using (MySqlCommand command = new MySqlCommand())
{
DataSet dataset = new DataSet();
OSAEScreenControl ctrl = new OSAEScreenControl();
command.CommandText = "SELECT schedule_name, parameter_1, parameter_2, recurring_time, monday, tuesday, wednesday, thursday, friday, saturday, sunday, interval_unit, recurring_minutes," +
"recurring_day, recurring_date, script_name, method_name, object_name " +
"FROM osae.osae_v_schedule_recurring WHERE schedule_name=@Name";
command.Parameters.AddWithValue("@Name", name);
dataset = OSAESql.RunQuery(command);
if (dataset.Tables[0].Rows.Count > 0)
{
OSAERecurringSchedule schedule = new OSAERecurringSchedule();
schedule.Name = name;
schedule.Param1 = dataset.Tables[0].Rows[0]["parameter_1"].ToString();
schedule.Param2 = dataset.Tables[0].Rows[0]["parameter_2"].ToString();
schedule.Time = dataset.Tables[0].Rows[0]["recurring_time"].ToString();
schedule.Monday = dataset.Tables[0].Rows[0]["monday"].ToString();
schedule.Tuesday = dataset.Tables[0].Rows[0]["tuesday"].ToString();
schedule.Wednesday = dataset.Tables[0].Rows[0]["wednesday"].ToString();
schedule.Thursday = dataset.Tables[0].Rows[0]["thursday"].ToString();
schedule.Friday = dataset.Tables[0].Rows[0]["friday"].ToString();
schedule.Saturday = dataset.Tables[0].Rows[0]["saturday"].ToString();
schedule.Sunday = dataset.Tables[0].Rows[0]["sunday"].ToString();
schedule.Interval = dataset.Tables[0].Rows[0]["interval_unit"].ToString();
schedule.Minutes = dataset.Tables[0].Rows[0]["recurring_minutes"].ToString();
schedule.MonthDay = dataset.Tables[0].Rows[0]["recurring_day"].ToString();
schedule.Date = dataset.Tables[0].Rows[0]["recurring_date"].ToString();
schedule.Script = dataset.Tables[0].Rows[0]["script_name"].ToString();
schedule.Method = dataset.Tables[0].Rows[0]["method_name"].ToString();
schedule.Object = dataset.Tables[0].Rows[0]["object_name"].ToString();
return schedule;
}
}
return null;
}
catch (Exception ex)
{
Logging.GetLogger().AddToLog("API - GetRecurringScedule error: " + ex.Message, true);
return null;
}
}
public static List<OSAEScreenControl> GetScreenControls(string screenName)
{
List<OSAEScreenControl> controls = new List<OSAEScreenControl>();
try
{
using (MySqlCommand command = new MySqlCommand())
{
DataSet dataset = new DataSet();
OSAEScreenControl ctrl = new OSAEScreenControl();
command.CommandText = "SELECT object_name, control_name, control_type, state_name, last_updated, coalesce(property_last_updated,NOW()) as property_last_updated, coalesce(time_in_state, 0) as time_in_state FROM osae_v_screen_object WHERE screen_name=@ScreenName AND control_enabled = 1";
command.Parameters.AddWithValue("@ScreenName", screenName);
dataset = OSAESql.RunQuery(command);
if (dataset.Tables[0].Rows.Count > 0)
{
foreach (DataRow dr in dataset.Tables[0].Rows)
{
ctrl = new OSAEScreenControl();
ctrl.ObjectState = dr["state_name"].ToString();
ctrl.TimeInState = Convert.ToInt64(dr["time_in_state"]).ToString();
ctrl.ControlName = dr["control_name"].ToString();
ctrl.ControlType = dr["control_type"].ToString();
ctrl.LastUpdated = DateTime.Parse(dr["last_updated"].ToString());
ctrl.PropertyLastUpdated = DateTime.Parse(dr["property_last_updated"].ToString());
ctrl.ObjectName = dr["object_name"].ToString();
controls.Add(ctrl);
}
return controls;
}
}
return controls;
}
catch (Exception ex)
{
Logging.GetLogger().AddToLog("API - GetObjectsByBaseType error: " + ex.Message, true);
return controls;
}
}
public static List <OSAEScreenControl> GetScreenControls(string screenName)
{
List <OSAEScreenControl> controls = new List <OSAEScreenControl>();
try
{
using (MySqlCommand command = new MySqlCommand())
{
DataSet dataset = new DataSet();
OSAEScreenControl ctrl = new OSAEScreenControl();
command.CommandText = "SELECT object_name, control_name, control_type, state_name, last_updated, coalesce(property_last_updated,NOW()) as property_last_updated, coalesce(time_in_state, 0) as time_in_state FROM osae_v_screen_object WHERE screen_name=@ScreenName AND control_enabled = 1";
command.Parameters.AddWithValue("@ScreenName", screenName);
dataset = OSAESql.RunQuery(command);
if (dataset.Tables[0].Rows.Count > 0)
{
foreach (DataRow dr in dataset.Tables[0].Rows)
{
ctrl = new OSAEScreenControl();
ctrl.ObjectState = dr["state_name"].ToString();
ctrl.TimeInState = Convert.ToInt64(dr["time_in_state"]).ToString();
ctrl.ControlName = dr["control_name"].ToString();
ctrl.ControlType = dr["control_type"].ToString();
ctrl.LastUpdated = DateTime.Parse(dr["last_updated"].ToString());
ctrl.PropertyLastUpdated = DateTime.Parse(dr["property_last_updated"].ToString());
ctrl.ObjectName = dr["object_name"].ToString();
controls.Add(ctrl);
}
return(controls);
}
}
return(controls);
}
catch (Exception ex)
{
Logging.GetLogger().AddToLog("API - GetObjectsByBaseType error: " + ex.Message, true);
return(controls);
}
}
public List<OSAEScreenControl> GetScreenControls(string screenName)
{
MySqlCommand command = new MySqlCommand();
DataSet dataset = new DataSet();
OSAEScreenControl ctrl = new OSAEScreenControl();
List<OSAEScreenControl> controls = new List<OSAEScreenControl>();
try
{
command.CommandText = "SELECT object_name, control_name, control_type, state_name, last_updated, coalesce(time_in_state, 0) as time_in_state FROM osae_v_screen_object WHERE screen_name=@ScreenName";
command.Parameters.AddWithValue("@ScreenName", screenName);
dataset = RunQuery(command);
if (dataset.Tables[0].Rows.Count > 0)
{
foreach (DataRow dr in dataset.Tables[0].Rows)
{
ctrl = new OSAEScreenControl();
ctrl.Object_State = dr["state_name"].ToString();
ctrl.Object_State_Time = Convert.ToInt64(dr["time_in_state"]).ToString();
ctrl.Control_Name = dr["control_name"].ToString();
ctrl.Control_Type = dr["control_type"].ToString();
ctrl.Object_Last_Updated = dr["last_updated"].ToString();
ctrl.Object_Name = dr["object_name"].ToString();
controls.Add(ctrl);
}
return controls;
}
return controls;
}
catch (Exception ex)
{
AddToLog("API - GetObjectsByBaseType error: " + ex.Message, true);
return controls;
}
}
