private void buttonOK_Click(object sender, EventArgs e)
{
sysDefsBindingSource.EndEdit();//Make sure changes get saved
SysDefsTableAdapter defsAdapter = new SysDefsTableAdapter();
//Perform database operations, and dispatch changes to the service
foreach (SeeCommonDataSet.SysDefsRow defRow in seeCommonDataSet.SysDefs)
{
if (defRow.RowState == DataRowState.Added)
{
defRow.DateCreated = DateTime.Now;
defRow.DbName = defRow.Name.Replace(' ', '_'); //Set the database name
defsAdapter.Update(defRow); //Update the database
SysAdded(defRow.Name); //Notify the service
}
else if (defRow.RowState == DataRowState.Modified)
{
string origName = (string)defRow["Name", DataRowVersion.Original];
string currName = (string)defRow["Name", DataRowVersion.Current];
if (origName != currName)
{
defRow.DbName = currName.Replace(' ', '_');
} //Update the database name
defsAdapter.Update(defRow); //Update the database
SysModified(origName, currName); //Notify the service
}
}
}
private void sysDefsBindingSource_ListChanged(object sender, ListChangedEventArgs e)
{
if (e.ListChangedType == ListChangedType.ItemDeleted)
{
DialogResult result = MessageBox.Show("All data will be lost." + Environment.NewLine + "Are you sure you want to remove this system?",
"Remove System", MessageBoxButtons.YesNo, MessageBoxIcon.Warning);
foreach (SeeCommonDataSet.SysDefsRow defRow in seeCommonDataSet.SysDefs)
{
if (defRow.RowState == DataRowState.Deleted)
{
defRow.RejectChanges();//Get the original data back
if (result == DialogResult.Yes)
{
SysDeleted((string)defRow["Name", DataRowVersion.Original]); //Notify the service
defRow.Delete(); //Now delete the row
SysDefsTableAdapter defsAdapter = new SysDefsTableAdapter();
defsAdapter.Update(defRow); //Update the database
}
break;
}
}
InvokeOnClick(buttonOK, new EventArgs());//Save any other changes and close
}
if (sysDefsBindingSource.List.Count > 0)
{
groupBox1.Enabled = true; nameTextBox.Enabled = true;
}
else
{
groupBox1.Enabled = false; nameTextBox.Enabled = false;
}
}
private int FillSysDefsTable()
{
SysDefsTableAdapter DefsAdapter = new SysDefsTableAdapter();
DefsAdapter.ClearBeforeFill = false;//must stay false or the rows referenced by the systems are deleted
return(DefsAdapter.Fill(DefsTable));
}
public FormSystems()
{
InitializeComponent();
#region Set value defaults
seeCommonDataSet.SysDefs.DateCreatedColumn.DefaultValue = DateTime.Now;
seeCommonDataSet.SysDefs.DbNameColumn.DefaultValue = "New";
seeCommonDataSet.SysDefs.NameColumn.DefaultValue = "New";
seeCommonDataSet.SysDefs.IpAddressColumn.DefaultValue = "255.255.255.255";
seeCommonDataSet.SysDefs.PortColumn.DefaultValue = 5450;
seeCommonDataSet.SysDefs.UserIdColumn.DefaultValue = "$SEEVSE1";
seeCommonDataSet.SysDefs.PasswordColumn.DefaultValue = "$SEEVSE1";
seeCommonDataSet.SysDefs.UtcOffsetColumn.DefaultValue = 0;
seeCommonDataSet.SysDefs.StartPollTimeColumn.DefaultValue = _midnight;// Continuous
seeCommonDataSet.SysDefs.EndPollTimeColumn.DefaultValue = _midnight;
seeCommonDataSet.SysDefs.monOnColumn.DefaultValue = true;
seeCommonDataSet.SysDefs.monCpuColumn.DefaultValue = true;
seeCommonDataSet.SysDefs.monJobsColumn.DefaultValue = true;
seeCommonDataSet.SysDefs.monIpsColumn.DefaultValue = true;
seeCommonDataSet.SysDefs.monBSDCColumn.DefaultValue = true;
seeCommonDataSet.SysDefs.monConnsColumn.DefaultValue = true;
seeCommonDataSet.SysDefs.monFTPsColumn.DefaultValue = true;
seeCommonDataSet.SysDefs.useConsoleColumn.DefaultValue = true;
seeCommonDataSet.SysDefs.pollIntervalmsColumn.DefaultValue = 300000;//5 min
#endregion
#region Set tool tips
toolTip1.SetToolTip(nameTextBox, "Assign a unique name for each system." + Environment.NewLine +
"The name must be 40 characters or less and can not contain special characters.");
toolTip1.SetToolTip(ipAddressTextBox, "The IP address for the TCP/IP stack to monitor." + Environment.NewLine +
"If you enter a domain name, it will be resolved to an IP address.");
toolTip1.SetToolTip(portTextBox, "The port number on which the mainframe server is listening for connections. The default is 5450." + Environment.NewLine +
"The mainframe will use 3 sequential TCP ports for communications." + Environment.NewLine +
"(The other two ports will be one less than this value. i.e. 5450, 5449, 5448)");
toolTip1.SetToolTip(userIdTextBox, "The user id used to log on to the mainframe server. The default is $SEEVSE1.");
toolTip1.SetToolTip(passwordTextBox, "The password used to log on to the mainframe server. The default is $SEEVSE1.");
toolTip1.SetToolTip(monOnCheckBox, "Use this to start or stop monitoring the system." + Environment.NewLine +
"This will not shutdown the mainframe server.");
string monTip = "Monitor settings control when and how often TCP/IP data is sampled." + Environment.NewLine +
"Poll Interval - how often to update the system information.";// +Environment.NewLine +
//"Continuous - monitor the system 24 hours a day." + Environment.NewLine +
//"Start/End Time - only monitor the system between these times.";
toolTip1.SetToolTip(groupBoxMonitor, monTip);
toolTip1.SetToolTip(dateTimePicker1, monTip);
toolTip1.SetToolTip(panelStartEnd, monTip);
toolTip1.SetToolTip(startPollTimeDateTimePicker1, monTip);
toolTip1.SetToolTip(endPollTimeDateTimePicker1, monTip);
#endregion
#region Fill the dataset
SysDefsTableAdapter defsAdapter = new SysDefsTableAdapter();
//defsAdapter.Fill(seeCommonDataSet.SysDefs);
//if (DefsTable != null) { DefsTable = null; }
/*This is much faster */
SeeCommonDataSet.SysDefsDataTable DefsTable = defsAdapter.GetData();
foreach (SeeCommonDataSet.SysDefsRow sRow in DefsTable)
{
SeeCommonDataSet.SysDefsRow nwRow = seeCommonDataSet.SysDefs.NewSysDefsRow();
nwRow.ItemArray = sRow.ItemArray;
seeCommonDataSet.SysDefs.AddSysDefsRow(nwRow);
}
#endregion
seeCommonDataSet.SysDefs.AcceptChanges();//Now all the RowStates are current
}
