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; } }
private void TxtEnterExtension_TextChanged(object sender, TextChangedEventArgs e) { //setting local variables string strEnteredInformation; int intCounter; int intNumberOfRecords; int intLength; bool blnFatalError = false; int intEmployeeID; int intRecordsReturned; int intSecondCounter; string strFirstName; string strLastName; int intExtension; int intWarehouseID; string strPhoneNumber; try { strEnteredInformation = txtEnterExtension.Text; intLength = strEnteredInformation.Length; TheNewPhoneListDataSet.phonelist.Rows.Clear(); if (intLength == 3) { TheComboEmployeeDataSet.employees.Rows.Clear(); TheComboEmployeeDataSet = TheEmployeeClass.FillEmployeeComboBox(strEnteredInformation); intNumberOfRecords = TheComboEmployeeDataSet.employees.Rows.Count - 1; if (intNumberOfRecords > -1) { for (intCounter = 0; intCounter <= intNumberOfRecords; intCounter++) { intEmployeeID = TheComboEmployeeDataSet.employees[intCounter].EmployeeID; strFirstName = TheComboEmployeeDataSet.employees[intCounter].FirstName; strLastName = TheComboEmployeeDataSet.employees[intCounter].LastName; TheFindPhoneExtensionByEmployeeIDDataSet = ThePhonesClass.FindPhoneExtensionByEmployeeID(intEmployeeID); intRecordsReturned = TheFindPhoneExtensionByEmployeeIDDataSet.FindPhoneExtensionByEmployeeID.Rows.Count - 1; if (intRecordsReturned > -1) { for (intSecondCounter = 0; intSecondCounter <= intRecordsReturned; intSecondCounter++) { if (TheFindPhoneExtensionByEmployeeIDDataSet.FindPhoneExtensionByEmployeeID[intSecondCounter].IsPhoneNumberNull() == true) { strPhoneNumber = ""; } else { strPhoneNumber = TheFindPhoneExtensionByEmployeeIDDataSet.FindPhoneExtensionByEmployeeID[intSecondCounter].PhoneNumber; } NewPhoneListDataSet.phonelistRow NewPhone = TheNewPhoneListDataSet.phonelist.NewphonelistRow(); NewPhone.DIDNumber = TheFindPhoneExtensionByEmployeeIDDataSet.FindPhoneExtensionByEmployeeID[intSecondCounter].DirectNumber; NewPhone.Extension = TheFindPhoneExtensionByEmployeeIDDataSet.FindPhoneExtensionByEmployeeID[intSecondCounter].Extension; NewPhone.FirstName = strFirstName; NewPhone.LastName = strLastName; NewPhone.Location = TheFindPhoneExtensionByEmployeeIDDataSet.FindPhoneExtensionByEmployeeID[intSecondCounter].AssignedOffice; NewPhone.CellPhone = strPhoneNumber; TheNewPhoneListDataSet.phonelist.Rows.Add(NewPhone); } } } } } else if (intLength == 4) { blnFatalError = TheDataValiationClass.VerifyIntegerData(strEnteredInformation); if (blnFatalError == false) { intExtension = Convert.ToInt32(strEnteredInformation); TheFindPhoneByExtensionDataSet = ThePhonesClass.FindPhoneByExtension(intExtension); intRecordsReturned = TheFindPhoneByExtensionDataSet.FindPhoneByExtension.Rows.Count; if (intRecordsReturned == 0) { TheMessagesClass.ErrorMessage("The Extension Was Not Found"); return; } intWarehouseID = TheFindPhoneByExtensionDataSet.FindPhoneByExtension[0].WarehouseID; TheFindEmployeeByEmployeeIDDataSet = TheEmployeeClass.FindEmployeeByEmployeeID(intWarehouseID); if (TheFindPhoneByExtensionDataSet.FindPhoneByExtension[0].IsPhoneNumberNull() == true) { strPhoneNumber = ""; } else { strPhoneNumber = TheFindPhoneByExtensionDataSet.FindPhoneByExtension[0].PhoneNumber; } NewPhoneListDataSet.phonelistRow NewPhone = TheNewPhoneListDataSet.phonelist.NewphonelistRow(); NewPhone.DIDNumber = TheFindPhoneByExtensionDataSet.FindPhoneByExtension[0].DirectNumber; NewPhone.Extension = intExtension; NewPhone.FirstName = TheFindPhoneByExtensionDataSet.FindPhoneByExtension[0].FirstName; NewPhone.LastName = TheFindPhoneByExtensionDataSet.FindPhoneByExtension[0].LastName; NewPhone.Location = TheFindEmployeeByEmployeeIDDataSet.FindEmployeeByEmployeeID[0].FirstName; NewPhone.CellPhone = strPhoneNumber; TheNewPhoneListDataSet.phonelist.Rows.Add(NewPhone); } else { TheComboEmployeeDataSet.employees.Rows.Clear(); TheComboEmployeeDataSet = TheEmployeeClass.FillEmployeeComboBox(strEnteredInformation); intNumberOfRecords = TheComboEmployeeDataSet.employees.Rows.Count - 1; if (intNumberOfRecords > -1) { for (intCounter = 0; intCounter <= intNumberOfRecords; intCounter++) { intEmployeeID = TheComboEmployeeDataSet.employees[intCounter].EmployeeID; strFirstName = TheComboEmployeeDataSet.employees[intCounter].FirstName; strLastName = TheComboEmployeeDataSet.employees[intCounter].LastName; TheFindPhoneExtensionByEmployeeIDDataSet = ThePhonesClass.FindPhoneExtensionByEmployeeID(intEmployeeID); intRecordsReturned = TheFindPhoneExtensionByEmployeeIDDataSet.FindPhoneExtensionByEmployeeID.Rows.Count - 1; if (intRecordsReturned > -1) { for (intSecondCounter = 0; intSecondCounter <= intRecordsReturned; intSecondCounter++) { if (TheFindPhoneExtensionByEmployeeIDDataSet.FindPhoneExtensionByEmployeeID[intSecondCounter].IsPhoneNumberNull() == true) { strPhoneNumber = ""; } else { strPhoneNumber = TheFindPhoneExtensionByEmployeeIDDataSet.FindPhoneExtensionByEmployeeID[intSecondCounter].PhoneNumber; } NewPhoneListDataSet.phonelistRow NewPhone = TheNewPhoneListDataSet.phonelist.NewphonelistRow(); NewPhone.DIDNumber = TheFindPhoneExtensionByEmployeeIDDataSet.FindPhoneExtensionByEmployeeID[intSecondCounter].DirectNumber; NewPhone.Extension = TheFindPhoneExtensionByEmployeeIDDataSet.FindPhoneExtensionByEmployeeID[intSecondCounter].Extension; NewPhone.FirstName = strFirstName; NewPhone.LastName = strLastName; NewPhone.CellPhone = strPhoneNumber; NewPhone.Location = TheFindPhoneExtensionByEmployeeIDDataSet.FindPhoneExtensionByEmployeeID[intSecondCounter].AssignedOffice; TheNewPhoneListDataSet.phonelist.Rows.Add(NewPhone); } } } } } } else if (intLength > 5) { TheComboEmployeeDataSet.employees.Rows.Clear(); TheComboEmployeeDataSet = TheEmployeeClass.FillEmployeeComboBox(strEnteredInformation); intNumberOfRecords = TheComboEmployeeDataSet.employees.Rows.Count - 1; if (intNumberOfRecords > -1) { for (intCounter = 0; intCounter <= intNumberOfRecords; intCounter++) { intEmployeeID = TheComboEmployeeDataSet.employees[intCounter].EmployeeID; strFirstName = TheComboEmployeeDataSet.employees[intCounter].FirstName; strLastName = TheComboEmployeeDataSet.employees[intCounter].LastName; TheFindPhoneExtensionByEmployeeIDDataSet = ThePhonesClass.FindPhoneExtensionByEmployeeID(intEmployeeID); intRecordsReturned = TheFindPhoneExtensionByEmployeeIDDataSet.FindPhoneExtensionByEmployeeID.Rows.Count - 1; if (intRecordsReturned > -1) { for (intSecondCounter = 0; intSecondCounter <= intRecordsReturned; intSecondCounter++) { if (TheFindPhoneExtensionByEmployeeIDDataSet.FindPhoneExtensionByEmployeeID[intSecondCounter].IsPhoneNumberNull() == true) { strPhoneNumber = ""; } else { strPhoneNumber = TheFindPhoneExtensionByEmployeeIDDataSet.FindPhoneExtensionByEmployeeID[intSecondCounter].PhoneNumber; } NewPhoneListDataSet.phonelistRow NewPhone = TheNewPhoneListDataSet.phonelist.NewphonelistRow(); NewPhone.DIDNumber = TheFindPhoneExtensionByEmployeeIDDataSet.FindPhoneExtensionByEmployeeID[intSecondCounter].DirectNumber; NewPhone.Extension = TheFindPhoneExtensionByEmployeeIDDataSet.FindPhoneExtensionByEmployeeID[intSecondCounter].Extension; NewPhone.FirstName = strFirstName; NewPhone.LastName = strLastName; NewPhone.CellPhone = strPhoneNumber; NewPhone.Location = TheFindPhoneExtensionByEmployeeIDDataSet.FindPhoneExtensionByEmployeeID[intSecondCounter].AssignedOffice; TheNewPhoneListDataSet.phonelist.Rows.Add(NewPhone); } } } } else { TheMessagesClass.ErrorMessage("The Employee Entered was not found"); return; } } dgrResults.ItemsSource = TheNewPhoneListDataSet.phonelist; } catch (Exception Ex) { TheEventLogClass.InsertEventLogEntry(DateTime.Now, "Blue Jay ERP // Phone List // Text Box Changed Event " + Ex.Message); TheMessagesClass.ErrorMessage(Ex.ToString()); } }
private void PhoneListByLastName() { int intCounter; int intNumberOfRecords; string strPhoneNumber; int intExtension; string strDirectNumber; try { TheFindSortedExtensionsByLastNameDataSet = ThePhonesClass.FindSortedExtensionsByLastName(); TheNewPhoneListDataSet.phonelist.Rows.Clear(); intNumberOfRecords = TheFindSortedExtensionsByLastNameDataSet.FindSortedExtensionsByLastName.Rows.Count - 1; for (intCounter = 0; intCounter <= intNumberOfRecords; intCounter++) { if (TheFindSortedExtensionsByLastNameDataSet.FindSortedExtensionsByLastName[intCounter].IsPhoneNumberNull() == true) { strPhoneNumber = ""; } else { strPhoneNumber = TheFindSortedExtensionsByLastNameDataSet.FindSortedExtensionsByLastName[intCounter].PhoneNumber; } if (TheFindSortedExtensionsByLastNameDataSet.FindSortedExtensionsByLastName[intCounter].IsExtensionNull() == true) { gintExtensionFiller += -1; intExtension = gintExtensionFiller; } else { intExtension = TheFindSortedExtensionsByLastNameDataSet.FindSortedExtensionsByLastName[intCounter].Extension; } if (TheFindSortedExtensionsByLastNameDataSet.FindSortedExtensionsByLastName[intCounter].IsDirectNumberNull() == true) { strDirectNumber = ""; } else { strDirectNumber = TheFindSortedExtensionsByLastNameDataSet.FindSortedExtensionsByLastName[intCounter].DirectNumber; } NewPhoneListDataSet.phonelistRow NewPhone = TheNewPhoneListDataSet.phonelist.NewphonelistRow(); NewPhone.DIDNumber = strDirectNumber; NewPhone.Extension = intExtension; NewPhone.FirstName = TheFindSortedExtensionsByLastNameDataSet.FindSortedExtensionsByLastName[intCounter].FirstName; NewPhone.LastName = TheFindSortedExtensionsByLastNameDataSet.FindSortedExtensionsByLastName[intCounter].LastName; NewPhone.Location = TheFindSortedExtensionsByLastNameDataSet.FindSortedExtensionsByLastName[intCounter].HomeOffice; NewPhone.CellPhone = strPhoneNumber; 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 Last Name " + Ex.Message); TheMessagesClass.ErrorMessage(Ex.ToString()); } }