/// <summary>
/// Recompute selected points
/// Required: selected point must have calculation
/// </summary>
public void Undo()
{
DataGridViewSelectedCellCollection x = timeSeriesSpreadsheet1.GetSelectedCells();
try
{
foreach (DataGridViewCell cell in x)
{
if (cell.ColumnIndex != 0) // not date column
{
DataRow row = ((DataRowView)cell.OwningRow.DataBoundItem).Row;
MultipleSeriesDataTable tbl = row.Table as MultipleSeriesDataTable;
DateTime t = Convert.ToDateTime(row[0]);
string interval = tbl.TableName;
HdbPoet.TimeSeriesDataSet.SeriesRow s = tbl.LookupSeries(cell.ColumnIndex);
if (s.IsComputed)
{
Hdb.Instance.Calculate_Series(s.hdb_site_datatype_id, interval, t, dataSet.GraphRow.TimeZone);
}
else
{
Logger.WriteLine("Warning series is not computed " + s.SiteName + " " + s.hdb_site_datatype_id);
}
}
}
}
catch (OracleException ex)
{
MessageBox.Show(ex.Message);
}
}
private MultipleSeriesDataTable IntervalTable(int seriesIndex)
{
var sr = SeriesRows.Skip(seriesIndex).First();
MultipleSeriesDataTable tbl = Tables[sr.Interval] as MultipleSeriesDataTable;
return(tbl);
}
public TimeSeriesCommitChanges(MultipleSeriesDataTable table,
string[] validationList, string colorColumnName)
{
InitializeComponent();
this.timeSeriesSpreadsheet1.SetTable(table, colorColumnName);
this.timeSeriesSpreadsheet1.DataViewRowState = DataViewRowState.ModifiedCurrent;
SetupValidationList(validationList);
}
internal void SetTable(MultipleSeriesDataTable table, string colorColumnName)
{
this.dataGrid1.DataSource = null;
m_colorColumnName = colorColumnName;
this.msDataTable = table;
this.dataGrid1.DataSource = msDataTable;
FormatDataGridView();
}
internal void BuildIntervalTables()
{
string[] intervals = IntervalList();
foreach (string interval in intervals)
{
NormalizeDates(interval);
}
// build table for each interval.
// using interval name for table name
for (int j = 0; j < intervals.Length; j++)
{
if (Tables.IndexOf(intervals[j]) >= 0)
{
Tables.Remove(intervals[j]);
}
MultipleSeriesDataTable msTable = new MultipleSeriesDataTable(this, intervals[j]);
Tables.Add(msTable);
}
}
public void SetFlagForSelectedCells(bool overwrite)
{
// List<string> msgList = new List<string>();
string msg = "Overwrite Flag will be set for all selected cells";
if (!overwrite)
{
msg = "Overwrite Flag will be cleared for all selected cells";
}
if (MessageBox.Show(msg, "Confirm Setting of Overwrite Flag", MessageBoxButtons.OKCancel) != DialogResult.OK)
{
return;
}
DataGridViewSelectedCellCollection x = timeSeriesSpreadsheet1.GetSelectedCells();
try
{
foreach (DataGridViewCell cell in x)
{
if (cell.ColumnIndex != 0) // no date column
{
DataRow row = ((DataRowView)cell.OwningRow.DataBoundItem).Row;
MultipleSeriesDataTable tbl = row.Table as MultipleSeriesDataTable;
DateTime t = Convert.ToDateTime(row[0]);
string interval = tbl.TableName;
HdbPoet.TimeSeriesDataSet.SeriesRow s = tbl.LookupSeries(cell.ColumnIndex);
Hdb.Instance.SetOverwriteFlag(s.hdb_site_datatype_id, interval, t, overwrite, dataSet.GraphRow.TimeZone);
}
}
}
catch (OracleException ex)
{
MessageBox.Show(ex.Message);
}
}
private void menuDetails_Click(object sender, EventArgs e)
{
DataGridViewCell cell = dataGrid1.SelectedCells[0];
if (cell.ColumnIndex != 0 && cell.Value != DBNull.Value)
{
DataRow row = ((DataRowView)cell.OwningRow.DataBoundItem).Row;
MultipleSeriesDataTable tbl = row.Table as MultipleSeriesDataTable;
DateTime t = Convert.ToDateTime(row[0]);
string interval = tbl.TableName;
HdbPoet.TimeSeriesDataSet.SeriesRow s = tbl.LookupSeries(cell.ColumnIndex);
var info = Hdb.Instance.BaseInfo(t, s.hdb_site_datatype_id, interval);
info = DataTableUtility.Transpose(info);
TableViewer tv = new TableViewer(info);
tv.Show();
//msDataTable
//row[cell.ColumnIndex] = DBNull.Value;
}
}
internal void SetValidationFlagForSelectedCells(string flag)
{
string msg = "Validation flag will be set to '" + flag + "' for all selected cells";
if (flag.Trim() == "")
{
msg = "Validation flag will be set to 'null' (cleared) for all selected cells";
}
if (MessageBox.Show(msg, "Confirm Setting of Validation Flag", MessageBoxButtons.OKCancel) != DialogResult.OK)
{
return;
}
DataGridViewSelectedCellCollection x = timeSeriesSpreadsheet1.GetSelectedCells();
try
{
foreach (DataGridViewCell cell in x)
{
if (cell.ColumnIndex != 0) // no date column
{
DataRow row = ((DataRowView)cell.OwningRow.DataBoundItem).Row;
MultipleSeriesDataTable tbl = row.Table as MultipleSeriesDataTable;
DateTime t = Convert.ToDateTime(row[0]);
string interval = tbl.TableName;
HdbPoet.TimeSeriesDataSet.SeriesRow s = tbl.LookupSeries(cell.ColumnIndex);
Hdb.Instance.SetValidationFlag(s.hdb_site_datatype_id, interval, t, flag, dataSet.GraphRow.TimeZone);
}
}
}
catch (OracleException ex)
{
MessageBox.Show(ex.Message);
}
}
/// <summary>
/// Updates specified value in MultipleSeriesDataTable
/// used when you drag a point on the Chart
/// </summary>
public void UpdateIntervalTable(int seriesIndex, DateTime t, object value)
{
MultipleSeriesDataTable tbl = IntervalTable(seriesIndex);
tbl.UpdateValue(seriesIndex, t, value);
}
public ExcelReportTemplate(MultipleSeriesDataTable msDataTable)
{
this.msDataTable = msDataTable;
xlsFilename = CreateTemporaryExcelFile();
}
