private void btnOK_Click(object sender, EventArgs e)
{
if (string.IsNullOrEmpty(txtZoneName.Text))
{
Exception ex = new Exception("Validation Exception : Please provide a new zone name!");
HandleException(ex);
}
else
{
try
{
lfa.pmgmt.data.DAO.Configuration.Zone zoneDAO = new data.DAO.Configuration.Zone();
zoneDAO.ConnectionString = _connectionString;
zoneDAO.Insert(txtZoneName.Text, DateTime.Now);
HandleInformationMesssage("Data successfully saved! Please refresh the form data!");
this.Close();
}
catch (Exception ex)
{
HandleException(ex);
}
}
}
private void btnOK_Click(object sender, EventArgs e)
{
if (string.IsNullOrEmpty(txtZoneName.Text))
{
Exception ex = new Exception("Validation Exception : Please provide a new zone name!");
HandleException(ex);
}
else
{
try
{
lfa.pmgmt.data.DAO.Configuration.Zone zoneDAO = new data.DAO.Configuration.Zone();
zoneDAO.ConnectionString = _connectionString;
zoneDAO.Insert(txtZoneName.Text, DateTime.Now);
HandleInformationMesssage("Data successfully saved! Please refresh the form data!");
this.Close();
}
catch (Exception ex)
{
HandleException(ex);
}
}
}
private void btnDelete_Click(object sender, EventArgs e)
{
if (_loadComplete)
{
switch (_currentModule)
{
case "Rules":
if (grdMain.SelectedRows.Count == 0)
{
Exception ex = new Exception("Please selected a ruleset to delete!");
HandleException(ex);
}
else
{
DeleteRuleset();
}
break;
case "LoadShed":
HandleInformationMesssage("Load shedding data can not be deleted! Data is only for control purposes!");
break;
case "Configuration":
try
{
int selectedZoneId = int.Parse(grdMain.SelectedRows[0].Cells[0].Value.ToString());
lfa.pmgmt.data.DAO.Configuration.Zone zoneDAO = new data.DAO.Configuration.Zone();
zoneDAO.ConnectionString = _connectionString;
zoneDAO.Delete(selectedZoneId);
HandleInformationMesssage("Data successfully deleted! Please refresh the data!");
}
catch (Exception ex)
{
HandleException(ex);
}
break;
case "Schedule":
try
{
int selectedScheduleId = int.Parse(grdMain.SelectedRows[0].Cells[0].Value.ToString());
lfa.pmgmt.data.DAO.Schedule.Schedule scheduleDAO = new data.DAO.Schedule.Schedule();
scheduleDAO.ConnectionString = _connectionString;
scheduleDAO.Delete(selectedScheduleId);
HandleInformationMesssage("Data successfully deleted! Please refresh the data!");
}
catch (Exception ex)
{
HandleException(ex);
}
break;
}
}
}
public bool EntireLoadShed()
{
bool hasShedAll = false;
List <lfa.pmgmt.data.DTO.BusinessRule.Load> loadList = new List <data.DTO.BusinessRule.Load>();
lfa.pmgmt.data.DAO.BusinessRule.Load loadDAO = new data.DAO.BusinessRule.Load();
loadDAO.ConnectionString = _connectionString;
loadList = loadDAO.List();
if (loadList.Count > 0)
{
int current = loadList[0].CurrentLoad;
int maxLoad = loadList[0].MaximumLoad;
if (current >= maxLoad)
{
List <lfa.pmgmt.data.DTO.Configuration.Zone> zones = new List <data.DTO.Configuration.Zone>();
lfa.pmgmt.data.DAO.Configuration.Zone zoneDAO = new data.DAO.Configuration.Zone();
zoneDAO.ConnectionString = _connectionString;
zones = zoneDAO.List();
foreach (lfa.pmgmt.data.DTO.Configuration.Zone zone in zones)
{
List <lfa.pmgmt.data.DTO.Configuration.Unit> units = new List <data.DTO.Configuration.Unit>();
lfa.pmgmt.data.DAO.Configuration.Unit unitDAO = new data.DAO.Configuration.Unit();
unitDAO.ConnectionString = _connectionString;
units = unitDAO.List(zone.Id);
foreach (lfa.pmgmt.data.DTO.Configuration.Unit unit in units)
{
List <lfa.pmgmt.data.DTO.Configuration.Device> devices = new List <data.DTO.Configuration.Device>();
lfa.pmgmt.data.DAO.Configuration.Device deviceDAO = new data.DAO.Configuration.Device();
deviceDAO.ConnectionString = _connectionString;
devices = deviceDAO.List(unit.Id);
foreach (lfa.pmgmt.data.DTO.Configuration.Device device in devices)
{
SwitchDeviceOnOff(2, device.Id, device.Id_Unit);
UpdateDeviceStatus(device.Id, 2);
}
}
}
hasShedAll = true;
}
}
return(hasShedAll);
}
public bool EntireLoadShed()
{
bool hasShedAll = false;
List<lfa.pmgmt.data.DTO.BusinessRule.Load> loadList = new List<data.DTO.BusinessRule.Load>();
lfa.pmgmt.data.DAO.BusinessRule.Load loadDAO = new data.DAO.BusinessRule.Load();
loadDAO.ConnectionString = _connectionString;
loadList = loadDAO.List();
if (loadList.Count > 0)
{
int current = loadList[0].CurrentLoad;
int maxLoad = loadList[0].MaximumLoad;
if (current >= maxLoad)
{
List<lfa.pmgmt.data.DTO.Configuration.Zone> zones = new List<data.DTO.Configuration.Zone>();
lfa.pmgmt.data.DAO.Configuration.Zone zoneDAO = new data.DAO.Configuration.Zone();
zoneDAO.ConnectionString = _connectionString;
zones = zoneDAO.List();
foreach (lfa.pmgmt.data.DTO.Configuration.Zone zone in zones)
{
List<lfa.pmgmt.data.DTO.Configuration.Unit> units = new List<data.DTO.Configuration.Unit>();
lfa.pmgmt.data.DAO.Configuration.Unit unitDAO = new data.DAO.Configuration.Unit();
unitDAO.ConnectionString = _connectionString;
units = unitDAO.List(zone.Id);
foreach (lfa.pmgmt.data.DTO.Configuration.Unit unit in units)
{
List<lfa.pmgmt.data.DTO.Configuration.Device> devices = new List<data.DTO.Configuration.Device>();
lfa.pmgmt.data.DAO.Configuration.Device deviceDAO = new data.DAO.Configuration.Device();
deviceDAO.ConnectionString = _connectionString;
devices = deviceDAO.List(unit.Id);
foreach (lfa.pmgmt.data.DTO.Configuration.Device device in devices)
{
SwitchDeviceOnOff(2, device.Id, device.Id_Unit);
UpdateDeviceStatus(device.Id, 2);
}
}
}
hasShedAll = true;
}
}
return hasShedAll;
}
private void BindRuleData()
{
dataGridView1.DataSource = null;
lfa.pmgmt.data.DAO.BusinessRule.Rule ruleDAO = new data.DAO.BusinessRule.Rule();
ruleDAO.ConnectionString = _connectionString;
List <lfa.pmgmt.data.DTO.BusinessRule.Rule> rules = new List <data.DTO.BusinessRule.Rule>();
rules = ruleDAO.List(_ruleId);
dataGridView1.Rows.Clear();
dataGridView1.DataSource = null;
dataGridView1.DataSource = rules;
foreach (DataGridViewRow row in dataGridView1.Rows)
{
string deviceOnOff = "Off";
string rule = row.Cells[1].Value.ToString();
string result = row.Cells[2].Value.ToString();
string[] ruleArray = rule.Split(".".ToCharArray());
int unitId = int.Parse(ruleArray[0].ToString());
string comparer = ruleArray[2].ToString();
string value = ruleArray[3].ToString();
string[] resultArray = result.Split(".".ToCharArray());
int deviceId = int.Parse(resultArray[1].ToString());
int status = int.Parse(resultArray[2].ToString());
if (status == 1)
{
deviceOnOff = "On";
}
lfa.pmgmt.data.DAO.Configuration.Zone zoneDAO = new data.DAO.Configuration.Zone();
zoneDAO.ConnectionString = _connectionString;
lfa.pmgmt.data.DTO.Configuration.Zone zoneItem = zoneDAO.Get(unitId);
string zoneName = zoneItem.Name;
row.Cells[1].Value = "If " + zoneName + " load is " + comparer + " " + value + " Then";
row.Cells[2].Value = "Switch " + deviceOnOff;
row.Cells[3].Value = row.Cells[3].Value;
}
dataGridView1.Columns[1].Width = 180;
dataGridView1.Columns[2].Width = 150;
}
private void BulkUpdateZones()
{
if (grdMain.Rows.Count > 0)
{
foreach (DataGridViewRow grdMainRow in grdMain.Rows)
{
lfa.pmgmt.data.DAO.Configuration.Zone zoneDOA = new data.DAO.Configuration.Zone();
zoneDOA.ConnectionString = _connectionString;
zoneDOA.Update(int.Parse(grdMainRow.Cells[0].Value.ToString()), grdMainRow.Cells[1].Value.ToString());
zoneDOA.EnableDisable(int.Parse(grdMainRow.Cells[0].Value.ToString()),
Convert.ToBoolean(grdMainRow.Cells[3].Value.ToString()));
}
}
}
public bool EntireLoadShed(int zoneId, int status)
{
bool hasShedAll = false;
List <lfa.pmgmt.data.DTO.BusinessRule.Load> loadList = new List <data.DTO.BusinessRule.Load>();
lfa.pmgmt.data.DAO.BusinessRule.Load loadDAO = new data.DAO.BusinessRule.Load();
loadDAO.ConnectionString = _connectionString;
loadList = loadDAO.List();
if (loadList.Count > 0)
{
List <lfa.pmgmt.data.DTO.Configuration.Zone> zones = new List <data.DTO.Configuration.Zone>();
lfa.pmgmt.data.DAO.Configuration.Zone zoneDAO = new data.DAO.Configuration.Zone();
zoneDAO.ConnectionString = _connectionString;
lfa.pmgmt.data.DTO.Configuration.Zone zone = zoneDAO.Get(zoneId);
List <lfa.pmgmt.data.DTO.Configuration.Unit> units = new List <data.DTO.Configuration.Unit>();
lfa.pmgmt.data.DAO.Configuration.Unit unitDAO = new data.DAO.Configuration.Unit();
unitDAO.ConnectionString = _connectionString;
units = unitDAO.List(zone.Id);
foreach (lfa.pmgmt.data.DTO.Configuration.Unit unit in units)
{
List <lfa.pmgmt.data.DTO.Configuration.Device> devices = new List <data.DTO.Configuration.Device>();
lfa.pmgmt.data.DAO.Configuration.Device deviceDAO = new data.DAO.Configuration.Device();
deviceDAO.ConnectionString = _connectionString;
devices = deviceDAO.List(unit.Id);
foreach (lfa.pmgmt.data.DTO.Configuration.Device device in devices)
{
SwitchDeviceOnOff(status, device.Id, device.Id_Unit);
UpdateDeviceStatus(device.Id, status);
}
}
hasShedAll = true;
}
return(hasShedAll);
}
private void Frm_Manage_Log_Load_1(object sender, EventArgs e)
{
_connectionString = GetConnectionString();
lfa.pmgmt.data.DAO.Configuration.Zone zoneDOA = new data.DAO.Configuration.Zone();
zoneDOA.ConnectionString = _connectionString;
List <lfa.pmgmt.data.DTO.Configuration.Zone> zoneList = zoneDOA.List();
foreach (lfa.pmgmt.data.DTO.Configuration.Zone zone in zoneList)
{
ComboItem item = new ComboItem();
item.Id = zone.Id;
item.Name = zone.Name;
comboBox1.Items.Add(item);
}
}
private void BindZonesComboBox()
{
List <lfa.pmgmt.data.DTO.Configuration.Zone> zones = new List <data.DTO.Configuration.Zone>();
lfa.pmgmt.data.DAO.Configuration.Zone zoneDAO = new data.DAO.Configuration.Zone();
zoneDAO.ConnectionString = _connectionString;
zones = zoneDAO.List();
foreach (lfa.pmgmt.data.DTO.Configuration.Zone zone in zones)
{
ComboItem item = new ComboItem();
item.Id = zone.Id;
item.Name = zone.Name;
comboBox1.Items.Add(item);
}
}
private void BindConfigurationData()
{
_loadComplete = false;
lfa.pmgmt.data.DAO.Configuration.Zone zoneDAO = new data.DAO.Configuration.Zone();
zoneDAO.ConnectionString = _connectionString;
List <lfa.pmgmt.data.DTO.Configuration.Zone> zoneList = zoneDAO.List();
btnGrdMainHeader.Text = "Zones";
grdMain.DataSource = zoneList;
btnGrdChildOneHeader.Text = "Units";
btnGrdChildTwoHeader.Text = "Devices";
_loadComplete = true;
}
private void BindRuleData()
{
dataGridView1.DataSource = null;
lfa.pmgmt.data.DAO.BusinessRule.Rule ruleDAO = new data.DAO.BusinessRule.Rule();
ruleDAO.ConnectionString = _connectionString;
List<lfa.pmgmt.data.DTO.BusinessRule.Rule> rules = new List<data.DTO.BusinessRule.Rule>();
rules = ruleDAO.List(_ruleId);
dataGridView1.Rows.Clear();
dataGridView1.DataSource = null;
dataGridView1.DataSource = rules;
foreach (DataGridViewRow row in dataGridView1.Rows)
{
string deviceOnOff = "Off";
string rule = row.Cells[1].Value.ToString();
string result = row.Cells[2].Value.ToString();
string[] ruleArray = rule.Split(".".ToCharArray());
int unitId = int.Parse(ruleArray[0].ToString());
string comparer = ruleArray[2].ToString();
string value = ruleArray[3].ToString();
string[] resultArray = result.Split(".".ToCharArray());
int deviceId = int.Parse(resultArray[1].ToString());
int status = int.Parse(resultArray[2].ToString());
if(status == 1)
{
deviceOnOff = "On";
}
lfa.pmgmt.data.DAO.Configuration.Zone zoneDAO = new data.DAO.Configuration.Zone();
zoneDAO.ConnectionString = _connectionString;
lfa.pmgmt.data.DTO.Configuration.Zone zoneItem = zoneDAO.Get(unitId);
string zoneName = zoneItem.Name;
row.Cells[1].Value = "If " + zoneName + " load is " + comparer + " " + value + " Then";
row.Cells[2].Value = "Switch " + deviceOnOff;
row.Cells[3].Value = row.Cells[3].Value;
}
dataGridView1.Columns[1].Width = 180;
dataGridView1.Columns[2].Width = 150;
}
private void btnOK_Click(object sender, EventArgs e)
{
int status = 2;
if (string.IsNullOrEmpty(textBox1.Text))
{
Exception ex = new Exception("Validation Exception : Please provide a load value!");
HandleException(ex);
}
else
{
ComboItem zone = comboBox1.SelectedItem as ComboItem;
string comparer = comboBox4.SelectedItem.ToString();
string deviceOnOff = comboBox5.SelectedItem.ToString();
switch (comparer)
{
case "Smaller Then Equal":
comparer = "<";
break;
case "Bigger Then Equal":
comparer = ">=";
break;
case "Smaller Then":
comparer = "<";
break;
case "Bigger Then":
comparer = ">";
break;
case "Equal":
comparer = "==";
break;
}
if (deviceOnOff == "Switch On")
{
status = 1;
}
string condition = zone.Id + ".1." + comparer + "." + textBox1.Text;
string result = zone.Id + ".1." + status.ToString();
lfa.pmgmt.data.DAO.BusinessRule.Rule ruleDAO = new data.DAO.BusinessRule.Rule();
ruleDAO.ConnectionString = _connectionString;
ruleDAO.Insert(_ruleId, condition, result);
int ruleId = ruleDAO.GetLastInsertedRuleId();
//if (!comboBox2.SelectedItem.ToString().ToLower().Equals("none"))
//{
lfa.pmgmt.data.DAO.BusinessRule.RuleSet rulesetDAO = new data.DAO.BusinessRule.RuleSet();
rulesetDAO.ConnectionString = _connectionString;
rulesetDAO.InsertPriority(_ruleId, ruleId, comboBox2.SelectedItem.ToString());
//}
List<lfa.pmgmt.data.DTO.BusinessRule.Rule> rules = new List<data.DTO.BusinessRule.Rule>();
rules = ruleDAO.List(_ruleId);
dataGridView1.DataSource = null;
dataGridView1.DataSource = rules;
foreach (DataGridViewRow row in dataGridView1.Rows)
{
string sdeviceOnOff = "Off";
string rule = row.Cells[1].Value.ToString();
string sresult = row.Cells[2].Value.ToString();
string[] ruleArray = rule.Split(".".ToCharArray());
int unitId = int.Parse(ruleArray[0].ToString());
string scomparer = ruleArray[2].ToString();
string value = ruleArray[3].ToString();
string[] resultArray = sresult.Split(".".ToCharArray());
int deviceId = int.Parse(resultArray[1].ToString());
int sstatus = int.Parse(resultArray[2].ToString());
if (sstatus == 1)
{
sdeviceOnOff = "On";
}
lfa.pmgmt.data.DAO.Configuration.Zone zoneDAO = new data.DAO.Configuration.Zone();
zoneDAO.ConnectionString = _connectionString;
lfa.pmgmt.data.DTO.Configuration.Zone zoneItem = zoneDAO.Get(unitId);
string zoneName = zoneItem.Name;
row.Cells[1].Value = "If " + zoneName + " load is " + scomparer + " " + value + " Then";
row.Cells[2].Value = "Switch " + sdeviceOnOff;
}
dataGridView1.Columns[1].Width = 180;
dataGridView1.Columns[2].Width = 150;
}
}
private void BindZonesComboBox()
{
List<lfa.pmgmt.data.DTO.Configuration.Zone> zones = new List<data.DTO.Configuration.Zone>();
lfa.pmgmt.data.DAO.Configuration.Zone zoneDAO = new data.DAO.Configuration.Zone();
zoneDAO.ConnectionString = _connectionString;
zones = zoneDAO.List();
foreach (lfa.pmgmt.data.DTO.Configuration.Zone zone in zones)
{
ComboItem item = new ComboItem();
item.Id = zone.Id;
item.Name = zone.Name;
comboBox1.Items.Add(item);
}
}
private void btnOK_Click(object sender, EventArgs e)
{
int status = 2;
if (string.IsNullOrEmpty(textBox1.Text))
{
Exception ex = new Exception("Validation Exception : Please provide a load value!");
HandleException(ex);
}
else
{
ComboItem zone = comboBox1.SelectedItem as ComboItem;
string comparer = comboBox4.SelectedItem.ToString();
string deviceOnOff = comboBox5.SelectedItem.ToString();
switch (comparer)
{
case "Smaller Then Equal":
comparer = "<";
break;
case "Bigger Then Equal":
comparer = ">=";
break;
case "Smaller Then":
comparer = "<";
break;
case "Bigger Then":
comparer = ">";
break;
case "Equal":
comparer = "==";
break;
}
if (deviceOnOff == "Switch On")
{
status = 1;
}
string condition = zone.Id + ".1." + comparer + "." + textBox1.Text;
string result = zone.Id + ".1." + status.ToString();
lfa.pmgmt.data.DAO.BusinessRule.Rule ruleDAO = new data.DAO.BusinessRule.Rule();
ruleDAO.ConnectionString = _connectionString;
ruleDAO.Insert(_ruleId, condition, result);
int ruleId = ruleDAO.GetLastInsertedRuleId();
//if (!comboBox2.SelectedItem.ToString().ToLower().Equals("none"))
//{
lfa.pmgmt.data.DAO.BusinessRule.RuleSet rulesetDAO = new data.DAO.BusinessRule.RuleSet();
rulesetDAO.ConnectionString = _connectionString;
rulesetDAO.InsertPriority(_ruleId, ruleId, comboBox2.SelectedItem.ToString());
//}
List <lfa.pmgmt.data.DTO.BusinessRule.Rule> rules = new List <data.DTO.BusinessRule.Rule>();
rules = ruleDAO.List(_ruleId);
dataGridView1.DataSource = null;
dataGridView1.DataSource = rules;
foreach (DataGridViewRow row in dataGridView1.Rows)
{
string sdeviceOnOff = "Off";
string rule = row.Cells[1].Value.ToString();
string sresult = row.Cells[2].Value.ToString();
string[] ruleArray = rule.Split(".".ToCharArray());
int unitId = int.Parse(ruleArray[0].ToString());
string scomparer = ruleArray[2].ToString();
string value = ruleArray[3].ToString();
string[] resultArray = sresult.Split(".".ToCharArray());
int deviceId = int.Parse(resultArray[1].ToString());
int sstatus = int.Parse(resultArray[2].ToString());
if (sstatus == 1)
{
sdeviceOnOff = "On";
}
lfa.pmgmt.data.DAO.Configuration.Zone zoneDAO = new data.DAO.Configuration.Zone();
zoneDAO.ConnectionString = _connectionString;
lfa.pmgmt.data.DTO.Configuration.Zone zoneItem = zoneDAO.Get(unitId);
string zoneName = zoneItem.Name;
row.Cells[1].Value = "If " + zoneName + " load is " + scomparer + " " + value + " Then";
row.Cells[2].Value = "Switch " + sdeviceOnOff;
}
dataGridView1.Columns[1].Width = 180;
dataGridView1.Columns[2].Width = 150;
}
}
private void Frm_Manage_Log_Load_1(object sender, EventArgs e)
{
_connectionString = GetConnectionString();
lfa.pmgmt.data.DAO.Configuration.Zone zoneDOA = new data.DAO.Configuration.Zone();
zoneDOA.ConnectionString = _connectionString;
List<lfa.pmgmt.data.DTO.Configuration.Zone> zoneList = zoneDOA.List();
foreach (lfa.pmgmt.data.DTO.Configuration.Zone zone in zoneList)
{
ComboItem item = new ComboItem();
item.Id = zone.Id;
item.Name = zone.Name;
comboBox1.Items.Add(item);
}
}
public bool EntireLoadShed(int zoneId, int status)
{
bool hasShedAll = false;
List<lfa.pmgmt.data.DTO.BusinessRule.Load> loadList = new List<data.DTO.BusinessRule.Load>();
lfa.pmgmt.data.DAO.BusinessRule.Load loadDAO = new data.DAO.BusinessRule.Load();
loadDAO.ConnectionString = _connectionString;
loadList = loadDAO.List();
if (loadList.Count > 0)
{
List<lfa.pmgmt.data.DTO.Configuration.Zone> zones = new List<data.DTO.Configuration.Zone>();
lfa.pmgmt.data.DAO.Configuration.Zone zoneDAO = new data.DAO.Configuration.Zone();
zoneDAO.ConnectionString = _connectionString;
lfa.pmgmt.data.DTO.Configuration.Zone zone = zoneDAO.Get(zoneId);
List<lfa.pmgmt.data.DTO.Configuration.Unit> units = new List<data.DTO.Configuration.Unit>();
lfa.pmgmt.data.DAO.Configuration.Unit unitDAO = new data.DAO.Configuration.Unit();
unitDAO.ConnectionString = _connectionString;
units = unitDAO.List(zone.Id);
foreach (lfa.pmgmt.data.DTO.Configuration.Unit unit in units)
{
List<lfa.pmgmt.data.DTO.Configuration.Device> devices = new List<data.DTO.Configuration.Device>();
lfa.pmgmt.data.DAO.Configuration.Device deviceDAO = new data.DAO.Configuration.Device();
deviceDAO.ConnectionString = _connectionString;
devices = deviceDAO.List(unit.Id);
foreach (lfa.pmgmt.data.DTO.Configuration.Device device in devices)
{
SwitchDeviceOnOff(status, device.Id, device.Id_Unit);
UpdateDeviceStatus(device.Id, status);
}
}
hasShedAll = true;
}
return hasShedAll;
}
private void BulkUpdateZones()
{
if (grdMain.Rows.Count > 0)
{
foreach (DataGridViewRow grdMainRow in grdMain.Rows)
{
lfa.pmgmt.data.DAO.Configuration.Zone zoneDOA = new data.DAO.Configuration.Zone();
zoneDOA.ConnectionString = _connectionString;
zoneDOA.Update(int.Parse(grdMainRow.Cells[0].Value.ToString()), grdMainRow.Cells[1].Value.ToString());
zoneDOA.EnableDisable(int.Parse(grdMainRow.Cells[0].Value.ToString()),
Convert.ToBoolean(grdMainRow.Cells[3].Value.ToString()));
}
}
}
private void btnDelete_Click(object sender, EventArgs e)
{
if (_loadComplete)
{
switch (_currentModule)
{
case "Rules":
if (grdMain.SelectedRows.Count == 0)
{
Exception ex = new Exception("Please selected a ruleset to delete!");
HandleException(ex);
}
else
{
DeleteRuleset();
}
break;
case "LoadShed":
HandleInformationMesssage("Load shedding data can not be deleted! Data is only for control purposes!");
break;
case "Configuration":
try
{
int selectedZoneId = int.Parse(grdMain.SelectedRows[0].Cells[0].Value.ToString());
lfa.pmgmt.data.DAO.Configuration.Zone zoneDAO = new data.DAO.Configuration.Zone();
zoneDAO.ConnectionString = _connectionString;
zoneDAO.Delete(selectedZoneId);
HandleInformationMesssage("Data successfully deleted! Please refresh the data!");
}
catch (Exception ex)
{
HandleException(ex);
}
break;
case "Schedule":
try
{
int selectedScheduleId = int.Parse(grdMain.SelectedRows[0].Cells[0].Value.ToString());
lfa.pmgmt.data.DAO.Schedule.Schedule scheduleDAO = new data.DAO.Schedule.Schedule();
scheduleDAO.ConnectionString = _connectionString;
scheduleDAO.Delete(selectedScheduleId);
HandleInformationMesssage("Data successfully deleted! Please refresh the data!");
}
catch (Exception ex)
{
HandleException(ex);
}
break;
}
}
}
private void BindLoadShedData()
{
_loadComplete = false;
lfa.pmgmt.data.DAO.Configuration.Zone zoneDAO = new data.DAO.Configuration.Zone();
zoneDAO.ConnectionString = _connectionString;
List<lfa.pmgmt.data.DTO.Configuration.Zone> zoneList = zoneDAO.List();
btnGrdMainHeader.Text = "Zones";
grdMain.DataSource = zoneList;
btnGrdChildOneHeader.Text = "Units";
btnGrdChildTwoHeader.Text = "Devices";
_loadComplete = true;
}
