private void CboSelectLocation_SelectionChanged(object sender, SelectionChangedEventArgs e) { int intSelectedIndex; int intWarehouseID; string strWarehouse; int intCounter; int intNumberOfRecords; string strPhoneNumber; intSelectedIndex = cboSelectLocation.SelectedIndex - 1; if (intSelectedIndex > -1) { if (gblnLocations == true) { intWarehouseID = MainWindow.TheFindWarehousesDataSet.FindWarehouses[intSelectedIndex].EmployeeID; strWarehouse = MainWindow.TheFindWarehousesDataSet.FindWarehouses[intSelectedIndex].FirstName; TheNewPhoneListDataSet.phonelist.Rows.Clear(); TheFindPhoneExtensionByLocationDataSet = ThePhonesClass.FindPhoneExtensionByLocation(intWarehouseID); intNumberOfRecords = TheFindPhoneExtensionByLocationDataSet.FindPhoneExtensionsByLocation.Rows.Count - 1; if (intNumberOfRecords > -1) { for (intCounter = 0; intCounter <= intNumberOfRecords; intCounter++) { if (TheFindPhoneExtensionByLocationDataSet.FindPhoneExtensionsByLocation[intCounter].IsPhoneNumberNull() == true) { strPhoneNumber = ""; } else { strPhoneNumber = TheFindPhoneExtensionByLocationDataSet.FindPhoneExtensionsByLocation[intCounter].PhoneNumber; } NewPhoneListDataSet.phonelistRow NewPhone = TheNewPhoneListDataSet.phonelist.NewphonelistRow(); NewPhone.DIDNumber = TheFindPhoneExtensionByLocationDataSet.FindPhoneExtensionsByLocation[intCounter].DirectNumber; NewPhone.Extension = TheFindPhoneExtensionByLocationDataSet.FindPhoneExtensionsByLocation[intCounter].Extension; NewPhone.FirstName = TheFindPhoneExtensionByLocationDataSet.FindPhoneExtensionsByLocation[intCounter].FirstName; NewPhone.LastName = TheFindPhoneExtensionByLocationDataSet.FindPhoneExtensionsByLocation[intCounter].LastName; NewPhone.Location = strWarehouse; NewPhone.CellPhone = strPhoneNumber; TheNewPhoneListDataSet.phonelist.Rows.Add(NewPhone); } } } dgrResults.ItemsSource = TheNewPhoneListDataSet.phonelist; } }
public FindPhoneExtensionsByLocationDataSet FindPhoneExtensionByLocation(int intWarehouseID) { try { aFindPhoneExtensionsByLocationDataSet = new FindPhoneExtensionsByLocationDataSet(); aFindPhoneExtensionsByLocationTableAdapter = new FindPhoneExtensionsByLocationDataSetTableAdapters.FindPhoneExtensionsByLocationTableAdapter(); aFindPhoneExtensionsByLocationTableAdapter.Fill(aFindPhoneExtensionsByLocationDataSet.FindPhoneExtensionsByLocation, intWarehouseID); } catch (Exception Ex) { TheEventLogClass.InsertEventLogEntry(DateTime.Now, "Phone Class // Find Phone Extension By Location " + Ex.Message); } return(aFindPhoneExtensionsByLocationDataSet); }