private void FormatDataGridView()
{
this.dataGrid1.ColumnHeadersHeightSizeMode = DataGridViewColumnHeadersHeightSizeMode.AutoSize;
if (dataGrid1.ColumnCount > 0)
{
this.dataGrid1.Columns[0].ReadOnly = true;
}
for (int c = 1; c < dataGrid1.ColumnCount; c++)
{
dataGrid1.Columns[c].DefaultCellStyle.Format = msDataTable.LookupSeries(c).DisplayFormat;
dataGrid1.Columns[c].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleRight;
dataGrid1.Columns[c].ReadOnly = msDataTable.LookupSeries(c).ReadOnly;
}
}
/// <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);
}
}
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);
}
}