private void refreshPortLists()
{
string ppPortQuery = "SELECT PatchPanelPort.PatchPanelPortID, PatchPanelPort.PatchPanelPortNum, PatchPanelPort.PatchPanelID FROM [PatchPanelPort] WHERE PatchPanelPort.SwitchPortID IS NULL;";
string switchPortQuery = "SELECT SwitchPort.SwitchPortID, SwitchPort.SwitchPortNum, SwitchPort.SwitchID FROM [SwitchPort] WHERE SwitchPort.PatchPanelPortID IS NULL;";
DataSet swpDS = getDataSet(switchPortQuery);
DataSet pppDS = getDataSet(ppPortQuery);
List<SwitchPort> newSwitchPortList = new List<SwitchPort>();
List<PatchPanelPort> newPatchPanelPortList = new List<PatchPanelPort>();
try
{
foreach (DataRow dr in swpDS.Tables[0].Rows)
{
SwitchPort swp = new SwitchPort();
swp.switchPortID = (int)dr.ItemArray.GetValue(0);
swp.switchPortNum = (int)dr.ItemArray.GetValue(1);
swp.switchID = (int)dr.ItemArray.GetValue(2);
newSwitchPortList.Add(swp);
}
foreach (DataRow dr in pppDS.Tables[0].Rows)
{
PatchPanelPort ppp = new PatchPanelPort();
ppp.patchPanelPortID = (int)dr.ItemArray.GetValue(0);
ppp.patchPanelPortNum = (int)dr.ItemArray.GetValue(1);
ppp.patchPanelID = (int)dr.ItemArray.GetValue(2);
newPatchPanelPortList.Add(ppp);
}
switchPortList = newSwitchPortList;
PPPList = newPatchPanelPortList;
}
catch (OleDbException exp)
{
MessageBox.Show("Database Error:" + exp.Message.ToString());
}
}
//load venues into combobox
private void Form2_Load(object sender, EventArgs e)
{
string venueQuery = "SELECT Venue.VenueID, Venue.VenueName FROM [Venue];";
string venueSpaceQuery = "SELECT VenueSpace.VenueSpaceID, VenueSpace.VenueSpaceName, VenueSpace.VenueID FROM [VenueSpace];";
string idfQuery = "SELECT IDF.IDFID, IDF.IDFName, IDF.VenueSpaceID FROM [IDF];";
string ppQuery = "SELECT PatchPanel.PatchPanelID, PatchPanel.PatchPanelName, PatchPanel.IDFID FROM [PatchPanel];";
string switchQuery = "SELECT Switch.SwitchID, Switch.DNSName, Switch.IDFID FROM [Switch];";
string ppPortQuery = "SELECT PatchPanelPort.PatchPanelPortID, PatchPanelPort.PatchPanelPortNum, PatchPanelPort.PatchPanelID FROM [PatchPanelPort] WHERE PatchPanelPort.SwitchPortID IS NULL;";
string switchPortQuery = "SELECT SwitchPort.SwitchPortID, SwitchPort.SwitchPortNum, SwitchPort.SwitchID FROM [SwitchPort] WHERE SwitchPort.PatchPanelPortID IS NULL;";
DataSet venDS = getDataSet(venueQuery);
DataSet vsDS = getDataSet(venueSpaceQuery);
DataSet idfDS = getDataSet(idfQuery);
DataSet swDS = getDataSet(switchQuery);
DataSet ppDS = getDataSet(ppQuery);
DataSet swpDS = getDataSet(switchPortQuery);
DataSet pppDS = getDataSet(ppPortQuery);
try
{
foreach (DataRow dr in venDS.Tables[0].Rows)
{
Venue venue = new Venue();
venue.venueID = (int)dr.ItemArray.GetValue(0);
venue.venueName = dr.ItemArray.GetValue(1).ToString();
venueList.Add(venue);
}
foreach (DataRow dr in vsDS.Tables[0].Rows)
{
VenueSpace venueSpace = new VenueSpace();
venueSpace.venueSpaceID = (int)dr.ItemArray.GetValue(0);
venueSpace.venueSpaceName = dr.ItemArray.GetValue(1).ToString();
venueSpace.venueID = (int)dr.ItemArray.GetValue(2);
venueSpaceList.Add(venueSpace);
}
foreach (DataRow dr in idfDS.Tables[0].Rows)
{
IDF idf = new IDF();
idf.idfID = (int)dr.ItemArray.GetValue(0);
idf.idfName = dr.ItemArray.GetValue(1).ToString();
idf.venueSpaceID = (int)dr.ItemArray.GetValue(2);
idfList.Add(idf);
}
foreach (DataRow dr in swDS.Tables[0].Rows)
{
Switch sw = new Switch();
sw.switchID = (int)dr.ItemArray.GetValue(0);
sw.switchNameDNS = dr.ItemArray.GetValue(1).ToString();
sw.idfID = (int)dr.ItemArray.GetValue(2);
switchList.Add(sw);
}
foreach (DataRow dr in ppDS.Tables[0].Rows)
{
PatchPanel pp = new PatchPanel();
pp.patchPanelID = (int)dr.ItemArray.GetValue(0);
pp.patchPanelName = dr.ItemArray.GetValue(1).ToString();
pp.idfID = (int)dr.ItemArray.GetValue(2);
PPList.Add(pp);
}
foreach (DataRow dr in swpDS.Tables[0].Rows)
{
SwitchPort swp = new SwitchPort();
swp.switchPortID = (int)dr.ItemArray.GetValue(0);
swp.switchPortNum = (int)dr.ItemArray.GetValue(1);
swp.switchID = (int)dr.ItemArray.GetValue(2);
switchPortList.Add(swp);
}
foreach (DataRow dr in pppDS.Tables[0].Rows)
{
PatchPanelPort ppp = new PatchPanelPort();
ppp.patchPanelPortID = (int)dr.ItemArray.GetValue(0);
ppp.patchPanelPortNum = (int)dr.ItemArray.GetValue(1);
ppp.patchPanelID = (int)dr.ItemArray.GetValue(2);
PPPList.Add(ppp);
}
}
catch (OleDbException exp)
{
MessageBox.Show("Database Error:" + exp.Message.ToString());
}
updateVenueBoxList(venueList);
updateDataGridView();
}
