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; } }