private void GetScheduleUnitDetailsForId(List <lfa.pmgmt.data.DTO.Schedule.Unit> scheduleUnits, int scheduleId, List <int> ruleEnabledUnits, int defaultPort, int status) { foreach (lfa.pmgmt.data.DTO.Schedule.Unit scheduleUnit in scheduleUnits) { string address = scheduleUnit.Address; lfa.pmgmt.data.DAO.Schedule.Device deviceDAO = new data.DAO.Schedule.Device(); deviceDAO.ConnectionString = _connectionString; if (!ruleEnabledUnits.Contains(scheduleUnit.Id)) { List <lfa.pmgmt.data.DTO.Schedule.Device> unitDevices = deviceDAO.List(scheduleUnit.Id, scheduleId); ArrayList parameters = new ArrayList(); parameters.Add(unitDevices); parameters.Add(defaultPort); parameters.Add(scheduleUnit); parameters.Add(status); //AsyncLoadShedUnit(parameters); Thread worker = new Thread(new ParameterizedThreadStart(AsyncLoadShedUnit)); worker.Priority = ThreadPriority.Highest; worker.Start(parameters); } } }
private void btnOK_Click(object sender, EventArgs e) { try { bool on = false; ComboItem item = comboBox1.SelectedItem as ComboItem; int selectedItem = item.Id; lfa.pmgmt.data.DAO.Schedule.Device DAO = new data.DAO.Schedule.Device(); DAO.ConnectionString = _connectionString; if (comboBox2.SelectedItem.ToString() == "On") { on = true; } DAO.Insert(selectedItem, unitId, on, scheduleId); HandleInformationMesssage("Data successfully saved! Please refresh the form data!"); this.Close(); } catch (Exception ex) { HandleException(ex); } }
private void BuldUpdateScheduleDevice() { foreach (DataGridViewRow deviceRow in grdChildTwo.Rows) { lfa.pmgmt.data.DAO.Schedule.Device deviceDAO = new data.DAO.Schedule.Device(); deviceDAO.ConnectionString = _connectionString; deviceDAO.Update(int.Parse(deviceRow.Cells[0].Value.ToString()), 0, 0, Convert.ToBoolean(deviceRow.Cells[3].Value.ToString())); } }
private void GetScheduleUnitDetails(List <lfa.pmgmt.data.DTO.Schedule.Unit> scheduleUnits, int scheduleId, int defaultPort) { foreach (lfa.pmgmt.data.DTO.Schedule.Unit scheduleUnit in scheduleUnits) { string address = scheduleUnit.Address; lfa.pmgmt.data.DAO.Schedule.Device deviceDAO = new data.DAO.Schedule.Device(); deviceDAO.ConnectionString = _connectionString; List <lfa.pmgmt.data.DTO.Schedule.Device> unitDevices = deviceDAO.ListById(scheduleUnit.Id, scheduleId); LoadShedUnit(unitDevices, defaultPort, scheduleUnit); } }
private void comboBox3_SelectedIndexChanged(object sender, EventArgs e) { ComboItem selectedItem = comboBox3.SelectedItem as ComboItem; int unitId = selectedItem.Id; dataGridView1.DataSource = null; if (unitId > -1) { lfa.pmgmt.data.DAO.Schedule.Device scheduleDeviceDAO = new data.DAO.Schedule.Device(); scheduleDeviceDAO.ConnectionString = _connectionString; List <lfa.pmgmt.data.DTO.Schedule.Device> scheduleDevices = scheduleDeviceDAO.ListById(unitId, _scheduleId); if (scheduleDevices.Count > 0) { dataGridView1.DataSource = scheduleDevices; ComboBox cmbStatus = new ComboBox(); cmbStatus.Items.Add("On"); cmbStatus.Items.Add("Off"); DataGridViewComboBoxColumn comboBoxColumn = new DataGridViewComboBoxColumn(); comboBoxColumn.Items.Add("On"); comboBoxColumn.Items.Add("Off"); dataGridView1.Columns.Add(comboBoxColumn); foreach (DataGridViewRow scheduleRow in dataGridView1.Rows) { if (Convert.ToBoolean(scheduleRow.Cells[3].Value.ToString())) { scheduleRow.Cells[4].Value = "On"; } else { scheduleRow.Cells[4].Value = "Off"; } } dataGridView1.Columns[0].Visible = false; dataGridView1.Columns[2].Visible = false; dataGridView1.Columns[3].Visible = false; dataGridView1.Columns[1].Width = 273; dataGridView1.Columns[4].Width = 100; } } }
private void button4_Click(object sender, EventArgs e) { switch (_currentModule) { case "LoadShed": HandleInformationMesssage("Load shedding data can not deleted! Data is only for control purposes!"); break; case "Configuration": try { int selectedDeviceId = int.Parse(grdChildTwo.SelectedRows[0].Cells[0].Value.ToString()); lfa.pmgmt.data.DAO.Configuration.Device deviceDAO = new data.DAO.Configuration.Device(); deviceDAO.ConnectionString = _connectionString; deviceDAO.Delete(selectedDeviceId); HandleInformationMesssage("Data successfully deleted! Please refresh the data!"); } catch (Exception ex) { HandleException(ex); } break; case "Schedule": try { int s_selectedDeviceId = int.Parse(grdChildTwo.SelectedRows[0].Cells[0].Value.ToString()); lfa.pmgmt.data.DAO.Schedule.Device scheduleDAO = new data.DAO.Schedule.Device(); scheduleDAO.ConnectionString = _connectionString; scheduleDAO.Delete(s_selectedDeviceId); HandleInformationMesssage("Data successfully deleted! Please refresh the data!"); } catch (Exception ex) { HandleException(ex); } break; } }
private void Frm_AddNew_Unit_Load_1(object sender, EventArgs e) { _connectionString = GetConnectionString(); lfa.pmgmt.data.DAO.Schedule.Device scheduleDAO = new data.DAO.Schedule.Device(); scheduleDAO.ConnectionString = _connectionString; int s_unitId = scheduleDAO.GetUnitId(unitId); lfa.pmgmt.data.DAO.Configuration.Device DAO = new data.DAO.Configuration.Device(); DAO.ConnectionString = _connectionString; List<lfa.pmgmt.data.DTO.Configuration.Device> scheduleList = DAO.List(unitId); foreach (lfa.pmgmt.data.DTO.Configuration.Device scheduleItem in scheduleList) { ComboItem item = new ComboItem(); item.Id = scheduleItem.Id; item.Name = scheduleItem.Name; comboBox1.Items.Add(item); } comboBox2.Items.Add("On"); comboBox2.Items.Add("Off"); }
private void btnOK_Click(object sender, EventArgs e) { try { bool on = false; ComboItem item = comboBox1.SelectedItem as ComboItem; int selectedItem = item.Id; lfa.pmgmt.data.DAO.Schedule.Device DAO = new data.DAO.Schedule.Device(); DAO.ConnectionString = _connectionString; if (comboBox2.SelectedItem.ToString() == "On") on = true; DAO.Insert(selectedItem,unitId, on, scheduleId); HandleInformationMesssage("Data successfully saved! Please refresh the form data!"); this.Close(); } catch (Exception ex) { HandleException(ex); } }
private void Frm_AddNew_Unit_Load_1(object sender, EventArgs e) { _connectionString = GetConnectionString(); lfa.pmgmt.data.DAO.Schedule.Device scheduleDAO = new data.DAO.Schedule.Device(); scheduleDAO.ConnectionString = _connectionString; int s_unitId = scheduleDAO.GetUnitId(unitId); lfa.pmgmt.data.DAO.Configuration.Device DAO = new data.DAO.Configuration.Device(); DAO.ConnectionString = _connectionString; List <lfa.pmgmt.data.DTO.Configuration.Device> scheduleList = DAO.List(unitId); foreach (lfa.pmgmt.data.DTO.Configuration.Device scheduleItem in scheduleList) { ComboItem item = new ComboItem(); item.Id = scheduleItem.Id; item.Name = scheduleItem.Name; comboBox1.Items.Add(item); } comboBox2.Items.Add("On"); comboBox2.Items.Add("Off"); }
private void btnOK_Click(object sender, EventArgs e) { try { #region OLD CODE //ComboItem selectedItem = comboBox1.SelectedItem as ComboItem; //int zoneId = selectedItem.Id; //bool status = false; //if (comboBox2.SelectedItem.ToString() == "On") //{ // status = true; //} //lfa.pmgmt.data.DAO.Configuration.Unit unitDAO = new data.DAO.Configuration.Unit(); //unitDAO.ConnectionString = _connectionString; //List<lfa.pmgmt.data.DTO.Configuration.Unit> units = unitDAO.List(zoneId); //foreach (lfa.pmgmt.data.DTO.Configuration.Unit unit in units) //{ // lfa.pmgmt.data.DAO.Schedule.Unit sunitDAO = new data.DAO.Schedule.Unit(); // sunitDAO.ConnectionString = _connectionString; // sunitDAO.Insert(unit.Id, _scheduleId); // lfa.pmgmt.data.DAO.Configuration.Device deviceDAO = new data.DAO.Configuration.Device(); // deviceDAO.ConnectionString = _connectionString; // List<lfa.pmgmt.data.DTO.Configuration.Device> devices = deviceDAO.List(unit.Id); // foreach (lfa.pmgmt.data.DTO.Configuration.Device device in devices) // { // lfa.pmgmt.data.DAO.Schedule.Device sdeviceDAO = new data.DAO.Schedule.Device(); // sdeviceDAO.ConnectionString = _connectionString; // sdeviceDAO.Insert(device.Id, unit.Id,status, _scheduleId); // } // lfa.pmgmt.data.DAO.Schedule.Schedule dao = new data.DAO.Schedule.Schedule(); // dao.ConnectionString = _connectionString; // dao.LinkZone(_scheduleId, zoneId); //} #endregion foreach (DataGridViewRow dataRow in dataGridView1.Rows) { lfa.pmgmt.data.DAO.Schedule.Device deviceDAO = new data.DAO.Schedule.Device(); deviceDAO.ConnectionString = _connectionString; if (dataRow.Cells[4].Value.ToString() == "Off") { deviceDAO.Update(int.Parse(dataRow.Cells[0].Value.ToString()), 0, 0, false); } else { deviceDAO.Update(int.Parse(dataRow.Cells[0].Value.ToString()), 0, 0, true); } } HandleInformationMesssage("Data successfully saved! Please refresh the form data!"); this.Close(); } catch (Exception ex) { HandleException(ex); } }
private void grdChildOne_RowEnter(object sender, DataGridViewCellEventArgs e) { if (_loadComplete) { switch (_currentModule) { case "Configuration": _loadComplete = false; DataGridViewRow selectedRow = grdChildOne.SelectedRows[0]; _selectedItemDataId = int.Parse(selectedRow.Cells[0].Value.ToString()); lfa.pmgmt.data.DAO.Configuration.Device deviceDAO = new data.DAO.Configuration.Device(); deviceDAO.ConnectionString = _connectionString; List <lfa.pmgmt.data.DTO.Configuration.Device> list = deviceDAO.List(_selectedItemDataId); grdChildTwo.DataSource = list; grdChildTwo.Columns[0].Visible = false; grdChildTwo.Columns[1].Visible = false; grdChildTwo.Columns[5].ReadOnly = true; _loadComplete = true; break; case "Schedule": _loadComplete = false; DataGridViewRow s_selectedRow = grdChildOne.SelectedRows[0]; _selectedItemDataId = int.Parse(s_selectedRow.Cells[0].Value.ToString()); int selectedSchedule = int.Parse(grdMain.SelectedRows[0].Cells[0].Value.ToString()); lfa.pmgmt.data.DAO.Schedule.Device s_deviceDAO = new data.DAO.Schedule.Device(); s_deviceDAO.ConnectionString = _connectionString; List <lfa.pmgmt.data.DTO.Schedule.Device> s_list = s_deviceDAO.ListWithSwitch(_selectedItemDataId, selectedSchedule); grdChildTwo.Columns.Clear(); grdChildTwo.DataSource = s_list; grdChildTwo.Columns[0].Visible = false; _loadComplete = true; break; case "LoadShed": _loadComplete = false; DataGridViewRow ls_selectedRow = grdChildOne.SelectedRows[0]; _selectedItemDataId = int.Parse(ls_selectedRow.Cells[0].Value.ToString()); lfa.pmgmt.data.DAO.Configuration.Device ls_deviceDAO = new data.DAO.Configuration.Device(); ls_deviceDAO.ConnectionString = _connectionString; List <lfa.pmgmt.data.DTO.Configuration.LoadShedDevice> ls_list = ls_deviceDAO.ListLoadShed(_selectedItemDataId); grdChildTwo.Columns.Clear(); grdChildTwo.DataSource = ls_list; grdChildTwo.Columns[0].Visible = false; grdChildTwo.Columns[2].Visible = false; grdChildTwo.Columns[3].Visible = false; grdChildTwo.Columns[4].Visible = false; ComboBox cmbStatus = new ComboBox(); cmbStatus.Items.Add("On"); cmbStatus.Items.Add("Off"); DataGridViewComboBoxColumn comboBoxColumn = new DataGridViewComboBoxColumn(); comboBoxColumn.Items.Add("On"); comboBoxColumn.Items.Add("Off"); grdChildTwo.Columns.Add(comboBoxColumn); foreach (DataGridViewRow dgvRow in grdChildTwo.Rows) { dgvRow.Cells[5].Value = dgvRow.Cells[4].Value; } btnLoadShed.Visible = true; _loadComplete = true; break; } } }
private void GetScheduleUnitDetails(List<lfa.pmgmt.data.DTO.Schedule.Unit> scheduleUnits, int scheduleId, int defaultPort, int status) { foreach (lfa.pmgmt.data.DTO.Schedule.Unit scheduleUnit in scheduleUnits) { string address = scheduleUnit.Address; lfa.pmgmt.data.DAO.Schedule.Device deviceDAO = new data.DAO.Schedule.Device(); deviceDAO.ConnectionString = _connectionString; List<lfa.pmgmt.data.DTO.Schedule.Device> unitDevices = deviceDAO.ListById(scheduleUnit.Id, scheduleId); ArrayList parameters = new ArrayList(); parameters.Add(unitDevices); parameters.Add(defaultPort); parameters.Add(scheduleUnit); parameters.Add(status); //AsyncLoadShedUnit(parameters); Thread worker = new Thread(new ParameterizedThreadStart(AsyncLoadShedUnit)); worker.Start(parameters); } }
private void grdChildOne_RowEnter(object sender, DataGridViewCellEventArgs e) { if (_loadComplete) { switch (_currentModule) { case "Configuration": _loadComplete = false; DataGridViewRow selectedRow = grdChildOne.SelectedRows[0]; _selectedItemDataId = int.Parse(selectedRow.Cells[0].Value.ToString()); lfa.pmgmt.data.DAO.Configuration.Device deviceDAO = new data.DAO.Configuration.Device(); deviceDAO.ConnectionString = _connectionString; List<lfa.pmgmt.data.DTO.Configuration.Device> list = deviceDAO.List(_selectedItemDataId); grdChildTwo.DataSource = list; grdChildTwo.Columns[0].Visible = false; grdChildTwo.Columns[1].Visible = false; grdChildTwo.Columns[5].ReadOnly = true; _loadComplete = true; break; case "Schedule": _loadComplete = false; DataGridViewRow s_selectedRow = grdChildOne.SelectedRows[0]; _selectedItemDataId = int.Parse(s_selectedRow.Cells[0].Value.ToString()); int selectedSchedule = int.Parse(grdMain.SelectedRows[0].Cells[0].Value.ToString()); lfa.pmgmt.data.DAO.Schedule.Device s_deviceDAO = new data.DAO.Schedule.Device(); s_deviceDAO.ConnectionString = _connectionString; List<lfa.pmgmt.data.DTO.Schedule.Device> s_list = s_deviceDAO.ListWithSwitch(_selectedItemDataId,selectedSchedule); grdChildTwo.Columns.Clear(); grdChildTwo.DataSource = s_list; grdChildTwo.Columns[0].Visible = false; _loadComplete = true; break; case "LoadShed": _loadComplete = false; DataGridViewRow ls_selectedRow = grdChildOne.SelectedRows[0]; _selectedItemDataId = int.Parse(ls_selectedRow.Cells[0].Value.ToString()); lfa.pmgmt.data.DAO.Configuration.Device ls_deviceDAO = new data.DAO.Configuration.Device(); ls_deviceDAO.ConnectionString = _connectionString; List<lfa.pmgmt.data.DTO.Configuration.LoadShedDevice> ls_list = ls_deviceDAO.ListLoadShed(_selectedItemDataId); grdChildTwo.Columns.Clear(); grdChildTwo.DataSource = ls_list; grdChildTwo.Columns[0].Visible = false; grdChildTwo.Columns[2].Visible = false; grdChildTwo.Columns[3].Visible = false; grdChildTwo.Columns[4].Visible = false; ComboBox cmbStatus = new ComboBox(); cmbStatus.Items.Add("On"); cmbStatus.Items.Add("Off"); DataGridViewComboBoxColumn comboBoxColumn = new DataGridViewComboBoxColumn(); comboBoxColumn.Items.Add("On"); comboBoxColumn.Items.Add("Off"); grdChildTwo.Columns.Add(comboBoxColumn); foreach(DataGridViewRow dgvRow in grdChildTwo.Rows) { dgvRow.Cells[5].Value = dgvRow.Cells[4].Value; } btnLoadShed.Visible = true; _loadComplete = true; break; } } }
private void btnOK_Click(object sender, EventArgs e) { try { ComboItem selectedItem = comboBox1.SelectedItem as ComboItem; int zoneId = selectedItem.Id; bool status = false; lfa.pmgmt.data.DAO.Configuration.Unit unitDAO = new data.DAO.Configuration.Unit(); unitDAO.ConnectionString = _connectionString; List <lfa.pmgmt.data.DTO.Configuration.Unit> units = unitDAO.List(zoneId); foreach (lfa.pmgmt.data.DTO.Configuration.Unit unit in units) { lfa.pmgmt.data.DAO.Schedule.Unit sunitDAO = new data.DAO.Schedule.Unit(); sunitDAO.ConnectionString = _connectionString; sunitDAO.Insert(unit.Id, _scheduleId); lfa.pmgmt.data.DAO.Configuration.Device deviceDAO = new data.DAO.Configuration.Device(); deviceDAO.ConnectionString = _connectionString; List <lfa.pmgmt.data.DTO.Configuration.Device> devices = deviceDAO.List(unit.Id); foreach (lfa.pmgmt.data.DTO.Configuration.Device device in devices) { lfa.pmgmt.data.DAO.Schedule.Device sdeviceDAO = new data.DAO.Schedule.Device(); sdeviceDAO.ConnectionString = _connectionString; sdeviceDAO.Insert(device.Id, unit.Id, status, _scheduleId); } lfa.pmgmt.data.DAO.Schedule.Schedule dao = new data.DAO.Schedule.Schedule(); dao.ConnectionString = _connectionString; dao.LinkZone(_scheduleId, zoneId); } bool switch1On = checkBox1.Checked; bool switch2On = checkBox2.Checked; bool switch3On = checkBox3.Checked; bool switch4On = checkBox4.Checked; bool switch5On = checkBox5.Checked; bool switch6On = checkBox6.Checked; bool switch7On = checkBox7.Checked; bool switch8On = checkBox8.Checked; lfa.pmgmt.data.DAO.Schedule.Unit unitDAO2 = new data.DAO.Schedule.Unit(); unitDAO2.ConnectionString = _connectionString; List <lfa.pmgmt.data.DTO.Schedule.Unit> unitList = unitDAO2.ListWithZone(_scheduleId); foreach (lfa.pmgmt.data.DTO.Schedule.Unit unit in unitList) { if (unit.Id_Zone == zoneId) { lfa.pmgmt.data.DAO.Schedule.Device deviceDAO = new data.DAO.Schedule.Device(); deviceDAO.ConnectionString = _connectionString; List <lfa.pmgmt.data.DTO.Schedule.Device> deviceList = deviceDAO.ListWithDeviceId(unit.Id, _scheduleId); foreach (lfa.pmgmt.data.DTO.Schedule.Device device in deviceList) { lfa.pmgmt.data.DAO.Configuration.Device configDeviceDAO = new data.DAO.Configuration.Device(); configDeviceDAO.ConnectionString = _connectionString; lfa.pmgmt.data.DTO.Configuration.Device configDevice = configDeviceDAO.Get(device.DeviceId); switch (configDevice.Switch) { case "Switch 1": deviceDAO.Update(device.Id, 0, 0, switch1On); break; case "Switch 2": deviceDAO.Update(device.Id, 0, 0, switch2On); break; case "Switch 3": deviceDAO.Update(device.Id, 0, 0, switch3On); break; case "Switch 4": deviceDAO.Update(device.Id, 0, 0, switch4On); break; case "Switch 5": deviceDAO.Update(device.Id, 0, 0, switch5On); break; case "Switch 6": deviceDAO.Update(device.Id, 0, 0, switch6On); break; case "Switch 7": deviceDAO.Update(device.Id, 0, 0, switch7On); break; case "Switch 8": deviceDAO.Update(device.Id, 0, 0, switch8On); break; } } } } HandleInformationMesssage("Data successfully saved! Please refresh the form data!"); this.Close(); } catch (Exception ex) { HandleException(ex); } }
private void comboBox1_SelectedIndexChanged(object sender, EventArgs e) { ComboItem selectedItem = comboBox1.SelectedItem as ComboItem; int zoneId = selectedItem.Id; lfa.pmgmt.data.DAO.Schedule.Unit unitDAO = new data.DAO.Schedule.Unit(); unitDAO.ConnectionString = _connectionString; List <lfa.pmgmt.data.DTO.Schedule.Unit> unitList = unitDAO.ListWithZone(_scheduleId); lfa.pmgmt.data.DAO.Schedule.Device deviceDAO = new data.DAO.Schedule.Device(); deviceDAO.ConnectionString = _connectionString; foreach (lfa.pmgmt.data.DTO.Schedule.Unit unit in unitList) { if (unit.Id_Zone == zoneId) { List <lfa.pmgmt.data.DTO.Schedule.Device> deviceList = deviceDAO.ListWithDeviceId(unit.Id, _scheduleId); foreach (lfa.pmgmt.data.DTO.Schedule.Device device in deviceList) { lfa.pmgmt.data.DAO.Configuration.Device configDeviceDAO = new data.DAO.Configuration.Device(); configDeviceDAO.ConnectionString = _connectionString; lfa.pmgmt.data.DTO.Configuration.Device configDevice = configDeviceDAO.Get(device.DeviceId); switch (configDevice.Switch) { case "Switch 1": checkBox1.Checked = device.DeviceOn; break; case "Switch 2": checkBox2.Checked = device.DeviceOn; break; case "Switch 3": checkBox3.Checked = device.DeviceOn; break; case "Switch 4": checkBox4.Checked = device.DeviceOn; break; case "Switch 5": checkBox5.Checked = device.DeviceOn; break; case "Switch 6": checkBox6.Checked = device.DeviceOn; break; case "Switch 7": checkBox7.Checked = device.DeviceOn; break; case "Switch 8": checkBox8.Checked = device.DeviceOn; break; } } } } }
private void GetScheduleUnitDetailsForId(List<lfa.pmgmt.data.DTO.Schedule.Unit> scheduleUnits, int scheduleId, List<int> ruleEnabledUnits, int defaultPort, int status) { foreach (lfa.pmgmt.data.DTO.Schedule.Unit scheduleUnit in scheduleUnits) { string address = scheduleUnit.Address; lfa.pmgmt.data.DAO.Schedule.Device deviceDAO = new data.DAO.Schedule.Device(); deviceDAO.ConnectionString = _connectionString; if (!ruleEnabledUnits.Contains(scheduleUnit.Id)) { List<lfa.pmgmt.data.DTO.Schedule.Device> unitDevices = deviceDAO.List(scheduleUnit.Id, scheduleId); ArrayList parameters = new ArrayList(); parameters.Add(unitDevices); parameters.Add(defaultPort); parameters.Add(scheduleUnit); parameters.Add(status); Thread worker = new Thread(new ParameterizedThreadStart(AsyncLoadShedUnit)); worker.IsBackground = true; worker.Start(parameters); } } }
private void BuldUpdateScheduleDevice() { foreach (DataGridViewRow deviceRow in grdChildTwo.Rows) { lfa.pmgmt.data.DAO.Schedule.Device deviceDAO = new data.DAO.Schedule.Device(); deviceDAO.ConnectionString = _connectionString; deviceDAO.Update(int.Parse(deviceRow.Cells[0].Value.ToString()), 0, 0, Convert.ToBoolean(deviceRow.Cells[3].Value.ToString())); } }
private void button4_Click(object sender, EventArgs e) { switch (_currentModule) { case "LoadShed": HandleInformationMesssage("Load shedding data can not deleted! Data is only for control purposes!"); break; case "Configuration": try { int selectedDeviceId = int.Parse(grdChildTwo.SelectedRows[0].Cells[0].Value.ToString()); lfa.pmgmt.data.DAO.Configuration.Device deviceDAO = new data.DAO.Configuration.Device(); deviceDAO.ConnectionString = _connectionString; deviceDAO.Delete(selectedDeviceId); HandleInformationMesssage("Data successfully deleted! Please refresh the data!"); } catch (Exception ex) { HandleException(ex); } break; case "Schedule": try { int s_selectedDeviceId = int.Parse(grdChildTwo.SelectedRows[0].Cells[0].Value.ToString()); lfa.pmgmt.data.DAO.Schedule.Device scheduleDAO = new data.DAO.Schedule.Device(); scheduleDAO.ConnectionString = _connectionString; scheduleDAO.Delete(s_selectedDeviceId); HandleInformationMesssage("Data successfully deleted! Please refresh the data!"); } catch (Exception ex) { HandleException(ex); } break; } }
private void comboBox3_SelectedIndexChanged(object sender, EventArgs e) { ComboItem selectedItem = comboBox3.SelectedItem as ComboItem; int unitId = selectedItem.Id; dataGridView1.DataSource = null; if (unitId > -1) { lfa.pmgmt.data.DAO.Schedule.Device scheduleDeviceDAO = new data.DAO.Schedule.Device(); scheduleDeviceDAO.ConnectionString = _connectionString; List<lfa.pmgmt.data.DTO.Schedule.Device> scheduleDevices = scheduleDeviceDAO.ListById(unitId, _scheduleId); if (scheduleDevices.Count > 0) { dataGridView1.DataSource = scheduleDevices; ComboBox cmbStatus = new ComboBox(); cmbStatus.Items.Add("On"); cmbStatus.Items.Add("Off"); DataGridViewComboBoxColumn comboBoxColumn = new DataGridViewComboBoxColumn(); comboBoxColumn.Items.Add("On"); comboBoxColumn.Items.Add("Off"); dataGridView1.Columns.Add(comboBoxColumn); foreach (DataGridViewRow scheduleRow in dataGridView1.Rows) { if (Convert.ToBoolean(scheduleRow.Cells[3].Value.ToString())) { scheduleRow.Cells[4].Value = "On"; } else { scheduleRow.Cells[4].Value = "Off"; } } dataGridView1.Columns[0].Visible = false; dataGridView1.Columns[2].Visible = false; dataGridView1.Columns[3].Visible = false; dataGridView1.Columns[1].Width = 273; dataGridView1.Columns[4].Width = 100; } } }
private void btnOK_Click(object sender, EventArgs e) { try { ComboItem selectedItem = comboBox1.SelectedItem as ComboItem; int zoneId = selectedItem.Id; bool status = false; lfa.pmgmt.data.DAO.Configuration.Unit unitDAO = new data.DAO.Configuration.Unit(); unitDAO.ConnectionString = _connectionString; List<lfa.pmgmt.data.DTO.Configuration.Unit> units = unitDAO.List(zoneId); foreach (lfa.pmgmt.data.DTO.Configuration.Unit unit in units) { lfa.pmgmt.data.DAO.Schedule.Unit sunitDAO = new data.DAO.Schedule.Unit(); sunitDAO.ConnectionString = _connectionString; sunitDAO.Insert(unit.Id, _scheduleId); lfa.pmgmt.data.DAO.Configuration.Device deviceDAO = new data.DAO.Configuration.Device(); deviceDAO.ConnectionString = _connectionString; List<lfa.pmgmt.data.DTO.Configuration.Device> devices = deviceDAO.List(unit.Id); foreach (lfa.pmgmt.data.DTO.Configuration.Device device in devices) { lfa.pmgmt.data.DAO.Schedule.Device sdeviceDAO = new data.DAO.Schedule.Device(); sdeviceDAO.ConnectionString = _connectionString; sdeviceDAO.Insert(device.Id, unit.Id, status, _scheduleId); } lfa.pmgmt.data.DAO.Schedule.Schedule dao = new data.DAO.Schedule.Schedule(); dao.ConnectionString = _connectionString; dao.LinkZone(_scheduleId, zoneId); } bool switch1On = checkBox1.Checked; bool switch2On = checkBox2.Checked; bool switch3On = checkBox3.Checked; bool switch4On = checkBox4.Checked; bool switch5On = checkBox5.Checked; bool switch6On = checkBox6.Checked; bool switch7On = checkBox7.Checked; bool switch8On = checkBox8.Checked; lfa.pmgmt.data.DAO.Schedule.Unit unitDAO2 = new data.DAO.Schedule.Unit(); unitDAO2.ConnectionString = _connectionString; List<lfa.pmgmt.data.DTO.Schedule.Unit> unitList = unitDAO2.ListWithZone(_scheduleId); foreach (lfa.pmgmt.data.DTO.Schedule.Unit unit in unitList) { if (unit.Id_Zone == zoneId) { lfa.pmgmt.data.DAO.Schedule.Device deviceDAO = new data.DAO.Schedule.Device(); deviceDAO.ConnectionString = _connectionString; List<lfa.pmgmt.data.DTO.Schedule.Device> deviceList = deviceDAO.ListWithDeviceId(unit.Id, _scheduleId); foreach (lfa.pmgmt.data.DTO.Schedule.Device device in deviceList) { lfa.pmgmt.data.DAO.Configuration.Device configDeviceDAO = new data.DAO.Configuration.Device(); configDeviceDAO.ConnectionString = _connectionString; lfa.pmgmt.data.DTO.Configuration.Device configDevice = configDeviceDAO.Get(device.DeviceId); switch (configDevice.Switch) { case "Switch 1": deviceDAO.Update(device.Id, 0, 0, switch1On); break; case "Switch 2": deviceDAO.Update(device.Id, 0, 0, switch2On); break; case "Switch 3": deviceDAO.Update(device.Id, 0, 0, switch3On); break; case "Switch 4": deviceDAO.Update(device.Id, 0, 0, switch4On); break; case "Switch 5": deviceDAO.Update(device.Id, 0, 0, switch5On); break; case "Switch 6": deviceDAO.Update(device.Id, 0, 0, switch6On); break; case "Switch 7": deviceDAO.Update(device.Id, 0, 0, switch7On); break; case "Switch 8": deviceDAO.Update(device.Id, 0, 0, switch8On); break; } } } } HandleInformationMesssage("Data successfully saved! Please refresh the form data!"); this.Close(); } catch (Exception ex) { HandleException(ex); } }
private void GetScheduleUnitDetailsForId(List<lfa.pmgmt.data.DTO.Schedule.Unit> scheduleUnits, int scheduleId, List<int> ruleEnabledUnits, int defaultPort) { foreach (lfa.pmgmt.data.DTO.Schedule.Unit scheduleUnit in scheduleUnits) { string address = scheduleUnit.Address; lfa.pmgmt.data.DAO.Schedule.Device deviceDAO = new data.DAO.Schedule.Device(); deviceDAO.ConnectionString = _connectionString; if (!ruleEnabledUnits.Contains(scheduleUnit.Id)) { List<lfa.pmgmt.data.DTO.Schedule.Device> unitDevices = deviceDAO.List(scheduleUnit.Id, scheduleId); LoadShedUnit(unitDevices, defaultPort,scheduleUnit); } } }
private void btnOK_Click(object sender, EventArgs e) { try { #region OLD CODE //ComboItem selectedItem = comboBox1.SelectedItem as ComboItem; //int zoneId = selectedItem.Id; //bool status = false; //if (comboBox2.SelectedItem.ToString() == "On") //{ // status = true; //} //lfa.pmgmt.data.DAO.Configuration.Unit unitDAO = new data.DAO.Configuration.Unit(); //unitDAO.ConnectionString = _connectionString; //List<lfa.pmgmt.data.DTO.Configuration.Unit> units = unitDAO.List(zoneId); //foreach (lfa.pmgmt.data.DTO.Configuration.Unit unit in units) //{ // lfa.pmgmt.data.DAO.Schedule.Unit sunitDAO = new data.DAO.Schedule.Unit(); // sunitDAO.ConnectionString = _connectionString; // sunitDAO.Insert(unit.Id, _scheduleId); // lfa.pmgmt.data.DAO.Configuration.Device deviceDAO = new data.DAO.Configuration.Device(); // deviceDAO.ConnectionString = _connectionString; // List<lfa.pmgmt.data.DTO.Configuration.Device> devices = deviceDAO.List(unit.Id); // foreach (lfa.pmgmt.data.DTO.Configuration.Device device in devices) // { // lfa.pmgmt.data.DAO.Schedule.Device sdeviceDAO = new data.DAO.Schedule.Device(); // sdeviceDAO.ConnectionString = _connectionString; // sdeviceDAO.Insert(device.Id, unit.Id,status, _scheduleId); // } // lfa.pmgmt.data.DAO.Schedule.Schedule dao = new data.DAO.Schedule.Schedule(); // dao.ConnectionString = _connectionString; // dao.LinkZone(_scheduleId, zoneId); //} #endregion foreach (DataGridViewRow dataRow in dataGridView1.Rows) { lfa.pmgmt.data.DAO.Schedule.Device deviceDAO = new data.DAO.Schedule.Device(); deviceDAO.ConnectionString = _connectionString; if (dataRow.Cells[4].Value.ToString() == "Off") { deviceDAO.Update(int.Parse(dataRow.Cells[0].Value.ToString()), 0, 0, false); } else { deviceDAO.Update(int.Parse(dataRow.Cells[0].Value.ToString()), 0, 0, true); } } HandleInformationMesssage("Data successfully saved! Please refresh the form data!"); this.Close(); } catch (Exception ex) { HandleException(ex); } }
private void comboBox1_SelectedIndexChanged(object sender, EventArgs e) { ComboItem selectedItem = comboBox1.SelectedItem as ComboItem; int zoneId = selectedItem.Id; lfa.pmgmt.data.DAO.Schedule.Unit unitDAO = new data.DAO.Schedule.Unit(); unitDAO.ConnectionString = _connectionString; List<lfa.pmgmt.data.DTO.Schedule.Unit> unitList = unitDAO.ListWithZone(_scheduleId); lfa.pmgmt.data.DAO.Schedule.Device deviceDAO = new data.DAO.Schedule.Device(); deviceDAO.ConnectionString = _connectionString; foreach (lfa.pmgmt.data.DTO.Schedule.Unit unit in unitList) { if (unit.Id_Zone == zoneId) { List<lfa.pmgmt.data.DTO.Schedule.Device> deviceList = deviceDAO.ListWithDeviceId(unit.Id, _scheduleId); foreach (lfa.pmgmt.data.DTO.Schedule.Device device in deviceList) { lfa.pmgmt.data.DAO.Configuration.Device configDeviceDAO = new data.DAO.Configuration.Device(); configDeviceDAO.ConnectionString = _connectionString; lfa.pmgmt.data.DTO.Configuration.Device configDevice = configDeviceDAO.Get(device.DeviceId); switch (configDevice.Switch) { case "Switch 1": checkBox1.Checked = device.DeviceOn; break; case "Switch 2": checkBox2.Checked = device.DeviceOn; break; case "Switch 3": checkBox3.Checked = device.DeviceOn; break; case "Switch 4": checkBox4.Checked = device.DeviceOn; break; case "Switch 5": checkBox5.Checked = device.DeviceOn; break; case "Switch 6": checkBox6.Checked = device.DeviceOn; break; case "Switch 7": checkBox7.Checked = device.DeviceOn; break; case "Switch 8": checkBox8.Checked = device.DeviceOn; break; } } } } }