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(); }