private void CreateNewSystem(SeeCommonDataSet.SysDefsRow defRow, bool sendOpen)
{
SqlManagerSystem sqlSys = new SqlManagerSystem();
sqlSys.SetDb(defRow.DbName, DatabasePath);
bool dbAvailable = sqlSys.IsDbRegistered();
if (!dbAvailable)//Create database if necessary
{
dbAvailable = CreateSysDatabase(defRow.DbName);
}
if (dbAvailable) //Only start monitoring if the database is available
{
ManageSystem sys = new ManageSystem(defRow); //Database must be available before creating this object
SystemsCollection.Add(sys); //Add to the collection
if (sys.IsMonitorOn)
{
ThreadPool.QueueUserWorkItem(new WaitCallback(TurnOnMonitor), sys);
}
Thread.Sleep(1000);
if (sendOpen)
{
SendSysOpenMessage(sys);
}
}
}
private void CreateNewSystem(string name)
{
SeeCommonDataSet.SysDefsRow defRow = GetSysDefRow(name);
if (defRow != null)
{
CreateNewSystem(defRow, true);
}
}
private void RemoveSysDefRow(string name)
{
SeeCommonDataSet.SysDefsRow defRow = GetSysDefRow(name);
if (defRow != null)
{
DefsTable.RemoveSysDefsRow(defRow);
//SysDefsTableAdapter DefsAdapter = new SysDefsTableAdapter();
//DefsAdapter.Update(defRow);
}
}
private void RemoveSystem(string name)
{
RemoveFromCollection(name);
SeeCommonDataSet.SysDefsRow defRow = GetSysDefRow(name);
if (defRow != null)
{
if (DropDatabase(defRow.DbName))
{
FillSysDefsTable();
} //now the row should be gone
}
}
private void ModifySystem(string origName, string currName, bool sendOpen)
{
ManageSystem sys = SystemsCollection.GetByName(origName);
RemoveFromCollection(sys);//remove old system
SeeCommonDataSet.SysDefsRow defRow = GetSysDefRow(currName);
if (defRow != null)
{
if (origName != currName)
{
RenameDatabase(origName.Replace(' ', '_'), currName.Replace(' ', '_'));
}
CreateNewSystem(defRow, sendOpen);
} //this should start(or stop)polling with new settings
}
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
}
