public FindSortedPhoneListByExtensionDataSet FindSortedPhoneListByExtension() { try { aFindSortedPhoneListByExtensionDataSet = new FindSortedPhoneListByExtensionDataSet(); aFindSortedPhoneListByExtensionTableAdapter = new FindSortedPhoneListByExtensionDataSetTableAdapters.FindSortedPhoneListByExtensionTableAdapter(); aFindSortedPhoneListByExtensionTableAdapter.Fill(aFindSortedPhoneListByExtensionDataSet.FindSortedPhoneListByExtension); } catch (Exception Ex) { TheEventLogClass.InsertEventLogEntry(DateTime.Now, "Phone Class // Find Sorted Phone List By Extension " + Ex.Message); } return(aFindSortedPhoneListByExtensionDataSet); }
private void PhoneListByExtension() { //setting local variables int intCounter; int intNumberOfRecords; string strPhoneNumber = ""; int intExtension = 0; string strDIDNumber = ""; try { TheFindSortedPhoneListByExtensionsDataSet = ThePhonesClass.FindSortedPhoneListByExtension(); TheNewPhoneListDataSet.phonelist.Rows.Clear(); intNumberOfRecords = TheFindSortedPhoneListByExtensionsDataSet.FindSortedPhoneListByExtension.Rows.Count - 1; for (intCounter = 0; intCounter <= intNumberOfRecords; intCounter++) { if (TheFindSortedPhoneListByExtensionsDataSet.FindSortedPhoneListByExtension[intCounter].IsPhoneNumberNull() == true) { strPhoneNumber = ""; } else { strPhoneNumber = TheFindSortedPhoneListByExtensionsDataSet.FindSortedPhoneListByExtension[intCounter].PhoneNumber; } if (TheFindSortedPhoneListByExtensionsDataSet.FindSortedPhoneListByExtension[intCounter].IsExtensionNull() == true) { gintExtensionFiller += -1; intExtension = gintExtensionFiller; } else { intExtension = TheFindSortedPhoneListByExtensionsDataSet.FindSortedPhoneListByExtension[intCounter].Extension; } if (TheFindSortedPhoneListByExtensionsDataSet.FindSortedPhoneListByExtension[intCounter].IsDirectNumberNull() == true) { strDIDNumber = ""; } else { strDIDNumber = TheFindSortedPhoneListByExtensionsDataSet.FindSortedPhoneListByExtension[intCounter].DirectNumber; } NewPhoneListDataSet.phonelistRow NewPhone = TheNewPhoneListDataSet.phonelist.NewphonelistRow(); NewPhone.DIDNumber = strDIDNumber; NewPhone.Extension = intExtension; NewPhone.FirstName = TheFindSortedPhoneListByExtensionsDataSet.FindSortedPhoneListByExtension[intCounter].FirstName; NewPhone.LastName = TheFindSortedPhoneListByExtensionsDataSet.FindSortedPhoneListByExtension[intCounter].LastName; NewPhone.CellPhone = strPhoneNumber; NewPhone.Location = TheFindSortedPhoneListByExtensionsDataSet.FindSortedPhoneListByExtension[intCounter].HomeOffice; TheNewPhoneListDataSet.phonelist.Rows.Add(NewPhone); } dgrResults.ItemsSource = TheNewPhoneListDataSet.phonelist; txtEnterExtension.Text = ""; txtEnterExtension.Visibility = Visibility.Hidden; lblEnterExtension.Visibility = Visibility.Hidden; cboSelectLocation.Items.Clear(); cboSelectLocation.Visibility = Visibility.Hidden; lblSelectLocation.Visibility = Visibility.Hidden; } catch (Exception Ex) { TheEventLogClass.InsertEventLogEntry(DateTime.Now, "Blue Jay ERP // Phone List // Phone List By Extension " + Ex.Message); TheMessagesClass.ErrorMessage(Ex.ToString()); } }