private void button2_Click(object sender, EventArgs e)
{
using (AdoDataConnection connection = new AdoDataConnection("systemSettings"))
{
GSF.Data.Model.TableOperations <PQds.Model.CustomField> customFldTbl = new GSF.Data.Model.TableOperations <PQds.Model.CustomField>(connection);
if (this.textBox1.Text.Length < 1)
{
MessageBox.Show("A Domain name has to be selected", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
if (customFldTbl.QueryRecordCountWhere("domain = {0}", this.textBox1.Text) > 0)
{
MessageBox.Show("This domain already exists", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
else
{
PQds.Model.CustomField fld = new Model.CustomField()
{
EventID = m_eventid, AssetID = m_assetid, key = "Key", Value = "Value", Type = "T", domain = this.textBox1.Text
};
customFldTbl.AddNewRecord(fld);
}
}
this.Close();
}
private void button2_Click(object sender, EventArgs e)
{
string localAppData = $"{Environment.GetFolderPath(Environment.SpecialFolder.LocalApplicationData)}{Path.DirectorySeparatorChar}PQio{Path.DirectorySeparatorChar}DataBase.db";
string connectionstring = $"Data Source={localAppData}; Version=3; Foreign Keys=True; FailIfMissing=True";
using (AdoDataConnection connection = new AdoDataConnection(connectionstring, dataprovider))
{
GSF.Data.Model.TableOperations <PQio.Model.CustomField> customFldTbl = new GSF.Data.Model.TableOperations <PQio.Model.CustomField>(connection);
if (this.textBox1.Text.Length < 1)
{
MessageBox.Show("A Domain name has to be selected", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
if (customFldTbl.QueryRecordCountWhere("domain = {0}", this.textBox1.Text) > 0)
{
MessageBox.Show("This domain already exists", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
else
{
PQio.Model.CustomField fld = new Model.CustomField()
{
EventID = m_eventid, AssetID = m_assetid, key = "Key", Value = "Value", Type = "T", domain = this.textBox1.Text
};
customFldTbl.AddNewRecord(fld);
}
}
this.Close();
}
private void save_Click(object sender, EventArgs e)
{
if (Model.SignalType.ToValue((string)comboBox1.SelectedItem) != -1)
{
this.m_channel.SignalType = Model.SignalType.ToValue((string)comboBox1.SelectedItem);
}
else
{
this.m_channel.SignalType = null;
}
if (Model.MeasurementType.ToValue((string)comboBox2.SelectedItem) != "")
{
this.m_channel.MeasurementType = Model.MeasurementType.ToValue((string)comboBox2.SelectedItem);
}
else
{
this.m_channel.MeasurementType = "";
}
this.m_channel.MeterID = (comboDevice.SelectedItem as dynamic).Value;
using (AdoDataConnection connection = new AdoDataConnection(connectionstring, dataprovider))
{
(new GSF.Data.Model.TableOperations <PQio.Model.Channel>(connection)).UpdateRecord(this.m_channel);
GSF.Data.Model.TableOperations <PQio.Model.DataSensitivity> dataSensitivityTbl = new GSF.Data.Model.TableOperations <PQio.Model.DataSensitivity>(connection);
PQio.Model.DataSensitivity dataSensitivity;
if (this.m_channel.AssetID != null)
{
if (dataSensitivityTbl.QueryRecordCountWhere("Event = {0} AND Asset = {1}", this.m_evt.ID, this.m_channel.AssetID) > 0)
{
dataSensitivity = dataSensitivityTbl.QueryRecordsWhere("Event = {0} AND Asset = {1}", this.m_evt.ID, this.m_channel.AssetID).First();
}
else
{
dataSensitivity = new Model.DataSensitivity()
{
Event = this.m_evt.ID, Asset = (int)this.m_channel.AssetID
}
};
dataSensitivity.DataSensitivityCode = Model.DataSensitivityCode.ToValue((string)comboBox3.SelectedItem);
dataSensitivity.Note = DataSensitivityNoteText.Text;
dataSensitivityTbl.AddNewOrUpdateRecord(dataSensitivity);
}
}
this.Close();
}
private Boolean RemoveEmptyEvents(Event evt, AdoDataConnection connection)
{
GSF.Data.Model.TableOperations <DataSeries> dataSeriesTable = new GSF.Data.Model.TableOperations <DataSeries>(connection);
GSF.Data.Model.TableOperations <Event> evtTable = new GSF.Data.Model.TableOperations <Event>(connection);
int nEvents = dataSeriesTable.QueryRecordCountWhere("EventID = {0} ", evt.ID);
if (nEvents == 0)
{
evtTable.DeleteRecord(evt);
return(false);
}
else
{
return(true);
}
}
private Boolean RemoveEmptyChannel(Channel channel, AdoDataConnection connection)
{
GSF.Data.Model.TableOperations <DataSeries> dataSeriesTable = new GSF.Data.Model.TableOperations <DataSeries>(connection);
GSF.Data.Model.TableOperations <Channel> channelTable = new GSF.Data.Model.TableOperations <Channel>(connection);
int nEvents = dataSeriesTable.QueryRecordCountWhere("ChannelID = {0} ", channel.ID);
if (nEvents == 0)
{
//remove corresponsing MeasurmentID
channelTable.DeleteRecord(channel);
return(false);
}
else
{
return(true);
}
}
private Boolean RemoveEmptyEvents(PQds.Model.Event evt)
{
using (AdoDataConnection connection = new AdoDataConnection("systemSettings"))
{
GSF.Data.Model.TableOperations <PQds.Model.DataSeries> dataSeriesTable = new GSF.Data.Model.TableOperations <PQds.Model.DataSeries>(connection);
GSF.Data.Model.TableOperations <PQds.Model.Event> evtTable = new GSF.Data.Model.TableOperations <PQds.Model.Event>(connection);
int nEvents = dataSeriesTable.QueryRecordCountWhere("EventID = {0} ", evt.ID);
if (nEvents == 0)
{
evtTable.DeleteRecord(evt);
return(false);
}
else
{
return(true);
}
}
}
private void GenereateDataSensitivities(string note, int code)
{
// If we overwrite we need to create a set of Asset and event IDs that need to create a Data Sesitivity Code
List <Tuple <int, int> > combinations = new List <Tuple <int, int> >();
using (AdoDataConnection connection = new AdoDataConnection(connectionstring, dataprovider))
{
GSF.Data.Model.TableOperations <PQio.Model.Channel> channelTbl = new GSF.Data.Model.TableOperations <PQio.Model.Channel>(connection);
GSF.Data.Model.TableOperations <PQio.Model.Asset> assetTbl = new GSF.Data.Model.TableOperations <PQio.Model.Asset>(connection);
GSF.Data.Model.TableOperations <PQio.Model.DataSeries> seriesTbl = new GSF.Data.Model.TableOperations <PQio.Model.DataSeries>(connection);
GSF.Data.Model.TableOperations <PQio.Model.DataSensitivity> sensitivityTbl = new GSF.Data.Model.TableOperations <PQio.Model.DataSensitivity>(connection);
foreach (int assetID in assetTbl.QueryRecords().Select(item => item.ID))
{
foreach (int channelID in channelTbl.QueryRecordsWhere("AssetID = {0}", assetID).Select(item => item.ID))
{
foreach (int evtID in seriesTbl.QueryRecordsWhere("ChannelID = {0}", channelID).Select(item => item.EventID))
{
combinations.Add(new Tuple <int, int>(assetID, evtID));
}
}
}
combinations = combinations.Distinct().ToList();
foreach (Tuple <int, int> item in combinations)
{
if (sensitivityTbl.QueryRecordCountWhere("Event = {0} AND Asset = {1}", item.Item2, item.Item1) == 0)
{
sensitivityTbl.AddNewRecord(new Model.DataSensitivity()
{
Asset = item.Item1,
Event = item.Item2,
DataSensitivityCode = code,
Note = note
});
}
}
}
}
private void PQioChannel_Load(object sender, EventArgs e)
{
// Populate Combo Boxes
comboBox1.Items.AddRange(Model.SignalType.DisplayOptions());
comboBox2.Items.AddRange(Model.MeasurementType.DisplayOptions());
comboBox3.Items.AddRange(Model.DataSensitivityCode.DisplayOptions());
if (m_channel.SignalType != null)
{
comboBox1.SelectedIndex = Array.FindIndex(Model.SignalType.DisplayOptions(),
item => item == Model.SignalType.ToDisplay((int)m_channel.SignalType));
}
else
{
comboBox1.SelectedIndex = Array.FindIndex(Model.SignalType.DisplayOptions(),
item => item == Model.SignalType.ToDisplay(-1));
}
if (m_channel.MeasurementType != null)
{
comboBox2.SelectedIndex = Array.FindIndex(Model.MeasurementType.DisplayOptions(),
item => item == Model.MeasurementType.ToDisplay(m_channel.MeasurementType));
}
else
{
comboBox2.SelectedIndex = Array.FindIndex(Model.MeasurementType.DisplayOptions(),
item => item == Model.MeasurementType.ToDisplay(""));
}
using (AdoDataConnection connection = new AdoDataConnection(connectionstring, dataprovider))
{
GSF.Data.Model.TableOperations <PQio.Model.DataSensitivity> dataSensitivityTbl = new GSF.Data.Model.TableOperations <PQio.Model.DataSensitivity>(connection);
GSF.Data.Model.TableOperations <PQio.Model.Meter> deviceTbl = new GSF.Data.Model.TableOperations <PQio.Model.Meter>(connection);
if (this.m_channel.AssetID != null)
{
// Make sure we check if there is any Data Sensitivity associated with this event
if (dataSensitivityTbl.QueryRecordCountWhere("Event = {0} AND Asset = {1}", this.m_evt.ID, this.m_channel.AssetID) > 0)
{
PQio.Model.DataSensitivity dataSensitivity = dataSensitivityTbl.QueryRecordsWhere("Event = {0} AND Asset = {1}", this.m_evt.ID, this.m_channel.AssetID).First();
comboBox3.SelectedIndex = Array.FindIndex(Model.DataSensitivityCode.DisplayOptions(),
item => item == Model.DataSensitivityCode.ToDisplay((int)dataSensitivity.DataSensitivityCode));
DataSensitivityNoteText.Text = dataSensitivity.Note;
}
else
{
comboBox3.SelectedIndex = Array.FindIndex(Model.DataSensitivityCode.DisplayOptions(),
item => item == Model.DataSensitivityCode.ToDisplay(-1));
DataSensitivityNoteText.Text = "";
}
}
else
{
comboBox3.Enabled = false;
comboBox3.SelectedIndex = Array.FindIndex(Model.DataSensitivityCode.DisplayOptions(),
item => item == Model.DataSensitivityCode.ToDisplay(-1));
tabControl1.Enabled = false;
}
comboDevice.DisplayMember = "Text";
comboDevice.ValueMember = "Value";
PQio.Model.Meter[] meters = deviceTbl.QueryRecords("").ToArray();
comboDevice.Items.AddRange(meters.Select(item => new { Text = item.DeviceName, Value = item.ID }).ToArray());
comboDevice.SelectedIndex = Array.FindIndex(meters, item => item.ID == this.m_channel.MeterID);
}
if (this.m_evt != null)
{
UpdateCustomFields();
}
else
{
this.tabControl1.Enabled = false;
}
this.MouseDown += new MouseEventHandler(OnClick);
}