private SeasonalMetricSeason updateSMSeason(SeasonalMetricSeason sMSeason)
{
try
{
SeasonalMetricSeason sMSeason1 = sMSeason;
switch (tabMetricFunction.SelectedIndex)
{
case 0:
sMSeason1.SeasonalMetricType = 0;
sMSeason1.MetricFunction = cboStatisticFunction.GetItemText(cboStatisticFunction.SelectedItem);
break;
case 1:
sMSeason1.SeasonalMetricType = 1;
sMSeason1.MetricFunction = txtFunctionManage.Text;
break;
}
return(sMSeason1);
}
catch (Exception ex)
{
Logger.LogError(ex.Message);
return(null);
}
}
private void setMonthAndDay(SeasonalMetricSeason season)
{
DateTime dt = new DateTime(2011, 1, 1);
dt = dt.AddDays(Convert.ToInt32(season.StartDay));
dtpStartTime.Value = dt;
DateTime dt2 = new DateTime(2011, 1, 1);
dt2 = dt2.AddDays(Convert.ToInt32(season.EndDay));
dtpEndTime.Value = dt2;
}
private void btnDeleteSeasonalMetricSeason_Click(object sender, EventArgs e)
{
if (lstSeasonalMetrics.Items.Count <= 0 || lstSeasonalMetricSeasons.SelectedItem == null)
{
return;
}
FireBirdHelperBase fb = new ESILFireBirdHelper();
string commandText = string.Empty;
try
{
DialogResult result = MessageBox.Show("Are you sure you want to delete this season?", "", MessageBoxButtons.OKCancel);
if (result == DialogResult.OK)
{
ListItem smsItem = lstSeasonalMetricSeasons.SelectedItem as ListItem;
lstSeasonalMetricSeasons.Items.RemoveAt(lstSeasonalMetricSeasons.SelectedIndex);
commandText = "delete from SeasonalMetricSeasons where SeasonalMetricSeasonID=" + smsItem.ID + "";
fb.ExecuteNonQuery(CommonClass.Connection, CommandType.Text, commandText);
for (int i = 0; i < _lstSMSeasons.Count; i++)
{
if (_lstSMSeasons[i].SeasonalMetricSeasonID.ToString() == smsItem.ID)
{
_lstSMSeasons.RemoveAt(i);
}
}
_seasonalMetricSeason = null;
if (lstSeasonalMetricSeasons.Items.Count > 0)
{
lstSeasonalMetricSeasons.SelectedIndex = lstSeasonalMetricSeasons.Items.Count - 1;
}
else
{
dtpStartTime.Value = new DateTime(2011, 1, 1);
dtpEndTime.Value = new DateTime(2011, 12, 31);
dtpStartTime.Enabled = false;
dtpEndTime.Enabled = false;
btnDeleteSeasonalMetricSeason.Enabled = false;
}
}
else
{
return;
}
}
catch (Exception ex)
{
Logger.LogError(ex.Message);
}
}
private void lstSeasonalMetricSeasons_SelectedIndexChanged(object sender, EventArgs e)
{
try
{
if (sender == null || lstSeasonalMetricSeasons.SelectedItem == null)
{
return;
}
ListItem lt = lstSeasonalMetricSeasons.SelectedItem as ListItem;
_seasonalMetricSeason = (from p in _lstSMSeasons where p.SeasonalMetricSeasonID.ToString() == lt.ID select p).ToList()[0];
setMonthAndDay(_seasonalMetricSeason);
switch (_seasonalMetricSeason.SeasonalMetricType)
{
case 0:
tabMetricFunction.SelectedTab = tbpStatistic;
cboStatisticFunction.Text = _seasonalMetricSeason.MetricFunction;
break;
case 1:
tabMetricFunction.SelectedTab = tbpCustomFunction;
txtFunctionManage.Text = _seasonalMetricSeason.MetricFunction;
break;
}
if (lstSeasonalMetricSeasons.SelectedIndex == lstSeasonalMetricSeasons.Items.Count - 1)
{
dtpStartTime.Enabled = true;
dtpEndTime.Enabled = true;
btnDeleteSeasonalMetricSeason.Enabled = true;
}
else
{
dtpStartTime.Enabled = false;
dtpEndTime.Enabled = false;
btnDeleteSeasonalMetricSeason.Enabled = false;
}
}
catch (Exception ex)
{
Logger.LogError(ex.Message);
}
}
private void dtpStartTime_Leave(object sender, EventArgs e)
{
try
{
if (_seasonalMetricSeason == null || lstSeasonalMetricSeasons.Items.Count <= 0)
{
return;
}
tabMetricFunction.Focus(); if (dtpEndTime.Value.DayOfYear <= dtpStartTime.Value.DayOfYear)
{
MessageBox.Show("Start date must be earlier than end date. Please check the start and end dates.");
dtpStartTime.Value = new DateTime(2011, 1, 1).AddDays(_seasonalMetricSeason.StartDay);
flagStartTime = 2;
return;
}
if (lstSeasonalMetricSeasons.Items.Count <= 1)
{
_seasonalMetricSeason.StartDay = dtpStartTime.Value.DayOfYear - 1;
}
else
{
ListItem lseason = lstSeasonalMetricSeasons.Items[lstSeasonalMetricSeasons.Items.Count - 2] as ListItem;
SeasonalMetricSeason lastsms = (from p in _lstSMSeasons where p.SeasonalMetricSeasonID.ToString() == lseason.ID select p).ToList()[0];
if (dtpStartTime.Value.DayOfYear <= lastsms.EndDay + 1)
{
MessageBox.Show("Seasons can not overlap.");
dtpStartTime.Value = new DateTime(2011, 1, 1).AddDays(_seasonalMetricSeason.StartDay);
return;
}
else
{
_seasonalMetricSeason.StartDay = dtpStartTime.Value.DayOfYear - 1;
}
}
flagStartTime = 1;
}
catch
{ }
}
private void btnAddSeasonalMetricSeason_Click(object sender, EventArgs e)
{
try
{
if (lstSeasonalMetrics.Items.Count <= 0)
{
MessageBox.Show("Please define the seasonal metric first.", "", MessageBoxButtons.OK);
return;
}
lstSeasonalMetricSeasons.SelectedIndex = lstSeasonalMetricSeasons.Items.Count - 1;
if (flagStartTime == 0)
{
dtpStartTime_Leave(sender, e);
}
if (flagEndTime == 0)
{
dtpEndTime_Leave(sender, e);
}
if (flagStartTime == 2 || flagEndTime == 2)
{
flagStartTime = 0;
flagEndTime = 0;
return;
}
flagStartTime = 0;
flagEndTime = 0;
DateTime endTime = dtpEndTime.Value;
if (endTime.Month == 12 && endTime.Day == 31 && lstSeasonalMetricSeasons.Items.Count > 0)
{
MessageBox.Show("Can not add another season because the entire year has already been covered.");
return;
}
FireBirdHelperBase fb = new ESILFireBirdHelper();
if (lstSeasonalMetrics.SelectedItem == null)
{
return;
}
ListItem ltSMetric = lstSeasonalMetrics.SelectedItem as ListItem;
if (lstSeasonalMetricSeasons.Items.Count == 0)
{
dtpStartTime.Enabled = true;
dtpEndTime.Enabled = true;
}
SeasonalMetricSeason sms = new SeasonalMetricSeason();
sms.SeasonalMetricID = Convert.ToInt32(ltSMetric.ID);
string commandText = "select max(SeasonalMetricSeasonID) from SeasonalMetricSeasons";
newSeasonalMetricSeasonID++;
sms.SeasonalMetricSeasonID = Convert.ToInt32(fb.ExecuteScalar(CommonClass.Connection, CommandType.Text, commandText)) + newSeasonalMetricSeasonID;
int i = lstSeasonalMetricSeasons.Items.Count + 1;
lstSeasonalMetricSeasons.Items.Add(new ListItem(sms.SeasonalMetricSeasonID.ToString(), "Season " + i));
dtpStartTime.Value = endTime.AddDays(1);
dtpEndTime.Value = new DateTime(2011, 12, 31);
sms.StartDay = dtpStartTime.Value.DayOfYear - 1;
sms.EndDay = 364;
tabMetricFunction.SelectedIndex = 0;
sms.SeasonalMetricType = tabMetricFunction.SelectedIndex;
cboStatisticFunction.SelectedIndex = 0;
sms.MetricFunction = cboStatisticFunction.Text;
txtFunctionManage.Text = "";
if (_lstSMSeasons == null)
{
_lstSMSeasons = new List <SeasonalMetricSeason>();
}
_lstSMSeasons.Add(sms);
_seasonalMetric.Seasons = _lstSMSeasons;
lstSeasonalMetricSeasons.SelectedIndex = lstSeasonalMetricSeasons.Items.Count - 1;
}
catch (Exception ex)
{
Logger.LogError(ex.Message);
}
}
