private void lstSeasonalMetrics_SelectedIndexChanged(object sender, EventArgs e)
{
try
{
if (lstSeasonalMetrics.Items.Count == 0)
{
return;
}
if (!isRefrest)
{
return;
}
if (_seasonalMetric != null)
{
for (int i = 0; i < _lstSMetrics.Count; i++)
{
if (_lstSMetrics[i].SeasonalMetricID == _seasonalMetric.SeasonalMetricID)
{
_lstSMetrics[i] = updateSeasonalMetric(_seasonalMetric);
break;
}
}
}
ListItem lt = (lstSeasonalMetrics.SelectedIndex < 0 ? lstSeasonalMetrics.Items[lstSeasonalMetrics.Items.Count - 1] : lstSeasonalMetrics.Items[lstSeasonalMetrics.SelectedIndex]) as ListItem;
_seasonalMetric = (from p in _lstSMetrics where p.SeasonalMetricID.ToString() == lt.ID select p).ToList()[0];
txtSeasonMetricName.Text = _seasonalMetric.SeasonalMetricName;
_lstSMSeasons = _seasonalMetric.Seasons;
lstSeasonalMetricSeasons.Items.Clear();
if (_seasonalMetric.Seasons != null)
{
_seasonalMetric.Seasons.Sort((x, y) => x.StartDay < y.StartDay ? -1 : 0);
for (int i = 1; i <= _seasonalMetric.Seasons.Count; i++)
{
lstSeasonalMetricSeasons.Items.Add(new ListItem(_seasonalMetric.Seasons[i - 1].SeasonalMetricSeasonID.ToString(), "Season " + i));
}
if (lstSeasonalMetricSeasons.Items.Count > 0)
{
lstSeasonalMetricSeasons.SelectedIndex = lstSeasonalMetricSeasons.Items.Count - 1;
}
}
if (lstSeasonalMetricSeasons.Items.Count <= 0)
{
dtpStartTime.Value = new DateTime(2011, 1, 1);
dtpEndTime.Value = new DateTime(2011, 12, 31);
dtpStartTime.Enabled = false;
dtpEndTime.Enabled = false;
btnDeleteSeasonalMetricSeason.Enabled = false;
}
}
catch (Exception ex)
{
Logger.LogError(ex.Message);
}
}
private void btnDelete_Click(object sender, EventArgs e)
{
if (lstSeasonalMetrics.SelectedItem == null)
{
return;
}
FireBirdHelperBase fb = new ESILFireBirdHelper();
string commandText = string.Empty;
try
{
if (lstSeasonalMetrics.Items.Count == 0)
{
MessageBox.Show("There is no seasonal metric to delete."); return;
}
commandText = "select MonitorID from MonitorEntries where SeasonalMetricID=" + _seasonalMetric.SeasonalMetricID + "";
object obj = fb.ExecuteScalar(CommonClass.Connection, CommandType.Text, commandText);
if (obj != null)
{
MessageBox.Show("This seasonal metric is used in 'Monitor Datasets'. Please delete monitor datasets that use this seasonal metric first.");
return;
}
DialogResult rtn = MessageBox.Show("All Seasons associated with this seasonal metric will be deleted. Are you sure you want to delete this seasonal metric?", "", MessageBoxButtons.OKCancel);
if (rtn == DialogResult.OK)
{
for (int i = 0; i < _lstSMetrics.Count; i++)
{
if (_lstSMetrics[i].SeasonalMetricID == _seasonalMetric.SeasonalMetricID)
{
_lstSMetrics.RemoveAt(i);
}
}
commandText = "delete from SeasonalMetrics where SeasonalMetricID=" + _seasonalMetric.SeasonalMetricID + "";
fb.ExecuteNonQuery(CommonClass.Connection, CommandType.Text, commandText);
commandText = "delete from SeasonalMetricSeasons where SeasonalMetricID=" + _seasonalMetric.SeasonalMetricID + "";
fb.ExecuteNonQuery(CommonClass.Connection, CommandType.Text, commandText);
_seasonalMetric = null;
lstSeasonalMetrics.Items.RemoveAt(lstSeasonalMetrics.SelectedIndex);
if (lstSeasonalMetrics.Items.Count == 0)
{
lstSeasonalMetricSeasons.Items.Clear();
txtSeasonMetricName.Text = "";
txtSeasonMetricName.Enabled = false;
}
else
{
lstSeasonalMetrics.SelectedIndex = lstSeasonalMetrics.Items.Count - 1;
}
}
}
catch (Exception ex)
{
Logger.LogError(ex.Message);
}
}
private void btnAdd_Click(object sender, EventArgs e)
{
try
{
if (lstSeasonalMetrics.SelectedItem != null)
{
_seasonalMetric = updateSeasonalMetric(_seasonalMetric);
}
ManageSetupSeasonalMetric addSMetric = new ManageSetupSeasonalMetric();
FireBirdHelperBase fb = new ESILFireBirdHelper();
string commandText = "select max(SeasonalMetricID) from SeasonalMetrics";
seasonalmetricidadd++;
addSMetric.SeasonalMetricID = Convert.ToInt32(fb.ExecuteScalar(CommonClass.Connection, CommandType.Text, commandText)) + seasonalmetricidadd;
if (_lstSMetrics.Count == 0)
{
addSMetric.Metric = _metric; txtSeasonMetricName.Enabled = true;
}
else
{
addSMetric.Metric = _lstSMetrics[0].Metric;
}
bool checkExist = true;
if (lstSeasonalMetrics.Items.Count > 0)
{
while (checkExist)
{
foreach (ListItem it in lstSeasonalMetrics.Items)
{
if (it.ToString() == "SeasonalMetric " + _iSeasonalMetric.ToString() + "")
{
_iSeasonalMetric++;
checkExist = true;
break;
}
else
{
checkExist = false;
}
}
}
}
addSMetric.SeasonalMetricName = "SeasonalMetric " + _iSeasonalMetric;
txtSeasonMetricName.Text = "SeasonalMetric " + _iSeasonalMetric;
_lstSMetrics.Add(addSMetric);
lstSeasonalMetrics.Items.Add(new ListItem(addSMetric.SeasonalMetricID.ToString(), addSMetric.SeasonalMetricName));
_seasonalMetric = null;
lstSeasonalMetrics.SelectedIndex = lstSeasonalMetrics.Items.Count - 1;
_iSeasonalMetric++;
}
catch (Exception ex)
{
Logger.LogError(ex.Message);
}
}
private ManageSetupSeasonalMetric updateSeasonalMetric(ManageSetupSeasonalMetric sMetric)
{
try
{
ManageSetupSeasonalMetric sMetric1 = sMetric;
sMetric1.SeasonalMetricName = sMetric.SeasonalMetricName;
sMetric1.Seasons = _lstSMSeasons;
return(sMetric1);
}
catch (Exception ex)
{
Logger.LogError(ex.Message);
return(null);
}
}
