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 SaveField()
{
if (this.alreadySavedFlag)
{
return;
}
this.alreadySavedFlag = true;
string activeTab = tabControl1.SelectedTab.Text;
Control[] ctrls = tabControl1.SelectedTab.Controls.Find("listView1-" + activeTab, false);
ListView list = (ListView)ctrls[0];
ctrls = tabControl1.SelectedTab.Controls.Find("editkey", false);
TextBox txtkey = (TextBox)ctrls[0];
ctrls = tabControl1.SelectedTab.Controls.Find("editvalue", false);
TextBox txtvalue = (TextBox)ctrls[0];
ctrls = tabControl1.SelectedTab.Controls.Find("editType", false);
ComboBox txtType = (ComboBox)ctrls[0];
int index = (int)list.SelectedItems[0].Tag;
using (AdoDataConnection connection = new AdoDataConnection(connectionstring, dataprovider))
{
GSF.Data.Model.TableOperations <PQio.Model.CustomField> customFldTbl = new GSF.Data.Model.TableOperations <PQio.Model.CustomField>(connection);
PQio.Model.CustomField fld;
if (index == -1)
{
fld = new Model.CustomField();
fld.domain = activeTab;
fld.AssetID = (int)this.m_channel.AssetID;
fld.EventID = (int)this.m_evt.ID;
}
else
{
fld = customFldTbl.QueryRecordWhere("ID = {0}", index);
}
if (txtvalue.Text == "" && index != -1)
{
DialogResult confirm = System.Windows.Forms.MessageBox.Show("This will delete the MetaDataTag " + fld.key, "Warning",
System.Windows.Forms.MessageBoxButtons.OKCancel, System.Windows.Forms.MessageBoxIcon.Warning);
if (confirm == DialogResult.OK)
{
customFldTbl.DeleteRecord(fld);
HideTextEditor();
this.UpdateCustomFields();
return;
}
}
fld.key = txtkey.Text;
fld.Value = txtvalue.Text;
fld.Type = TextToType(txtType.Text);
customFldTbl.AddNewOrUpdateRecord(fld);
HideTextEditor();
this.UpdateCustomFields();
}
}