private void txtEnterExtension_TextChanged(object sender, TextChangedEventArgs e) { string strValueForValidation; bool blnFatalError = false; int intLength; int intRecordsReturned; int intExtension; try { strValueForValidation = txtEnterExtension.Text; intLength = strValueForValidation.Length; if (intLength == 4) { blnFatalError = TheDataValidationClass.VerifyIntegerData(strValueForValidation); if (blnFatalError == true) { TheMessagesClass.ErrorMessage("The Value Entered is not an Integer"); return; } intExtension = Convert.ToInt32(strValueForValidation); TheFindPhoneByExtensionDataSet = ThePhoneClass.FindPhoneByExtension(intExtension); intRecordsReturned = TheFindPhoneByExtensionDataSet.FindPhoneByExtension.Rows.Count; if (intRecordsReturned == 0) { TheMessagesClass.ErrorMessage("The Extension Entered Does Not Exist"); return; } MainWindow.gintTransactionID = TheFindPhoneByExtensionDataSet.FindPhoneByExtension[0].TransactionID; txtCurrentAssignment.Text = TheFindPhoneByExtensionDataSet.FindPhoneByExtension[0].FullName; } else if (intLength > 4) { TheMessagesClass.ErrorMessage("Invalid Extension"); return; } } catch (Exception Ex) { TheSendEmailClass.SendEventLog("New Blue Jay ERP // Assign Phone Extension // Extension Text box " + Ex.Message); TheEventLogClass.InsertEventLogEntry(DateTime.Now, "New Blue Jay ERP // Assign Phone Extension // Extension Text box " + Ex.Message); TheMessagesClass.ErrorMessage(Ex.ToString()); } }
public FindPhoneByExtensionDataSet FindPhoneByExtension(int intExtension) { try { aFindPhoneByExtensionDataSet = new FindPhoneByExtensionDataSet(); aFindPhoneByExtensionTableAdapter = new FindPhoneByExtensionDataSetTableAdapters.FindPhoneByExtensionTableAdapter(); aFindPhoneByExtensionTableAdapter.Fill(aFindPhoneByExtensionDataSet.FindPhoneByExtension, intExtension); } catch (Exception Ex) { TheEventLogClass.InsertEventLogEntry(DateTime.Now, "Phones Class // Find Phone By Extension " + Ex.Message); } return(aFindPhoneByExtensionDataSet); }
private void expFindExtension_Expanded(object sender, RoutedEventArgs e) { bool blnFatalError = false; string strValueForValidation; int intPhoneExt = 0; int intRecordsReturned; int intEmployeeID; string strLastName; int intWarehouseID; int intSelectedIndex = 0; int intCounter; int intNumberOfRecords; try { expFindExtension.IsExpanded = false; strValueForValidation = txtEnterPhoneExt.Text; if (strValueForValidation.Length == 4) { blnFatalError = TheDataValidationClass.VerifyIntegerData(strValueForValidation); if (blnFatalError == true) { TheMessagesClass.ErrorMessage("The Extension Entered is not Numeric"); return; } else if (blnFatalError == false) { intPhoneExt = Convert.ToInt32(strValueForValidation); TheFindPhoneByExtensionDataSet = ThePhoneClass.FindPhoneByExtension(intPhoneExt); intRecordsReturned = TheFindPhoneByExtensionDataSet.FindPhoneByExtension.Rows.Count; if (intRecordsReturned < 1) { TheMessagesClass.ErrorMessage("The Phone Extension Does Not Exist"); return; } txtDirectNumber.Text = TheFindPhoneByExtensionDataSet.FindPhoneByExtension[0].DirectNumber; txtMACAddress.Text = TheFindPhoneByExtensionDataSet.FindPhoneByExtension[0].MACAddress; intEmployeeID = TheFindPhoneByExtensionDataSet.FindPhoneByExtension[0].EmployeeID; strLastName = TheFindPhoneByExtensionDataSet.FindPhoneByExtension[0].LastName; intWarehouseID = TheFindPhoneByExtensionDataSet.FindPhoneByExtension[0].WarehouseID; MainWindow.gintTransactionID = TheFindPhoneByExtensionDataSet.FindPhoneByExtension[0].TransactionID; //setting up the employee combo box cboSelectEmployee.Items.Clear(); cboSelectEmployee.Items.Add("Select Employee"); TheComboEmployeeDataSet = TheEmployeeClass.FillEmployeeComboBox(strLastName); intNumberOfRecords = TheComboEmployeeDataSet.employees.Rows.Count; for (intCounter = 0; intCounter < intNumberOfRecords; intCounter++) { cboSelectEmployee.Items.Add(TheComboEmployeeDataSet.employees[intCounter].FullName); if (intEmployeeID == TheComboEmployeeDataSet.employees[intCounter].EmployeeID) { intSelectedIndex = intCounter + 1; } } cboSelectEmployee.SelectedIndex = intSelectedIndex; intNumberOfRecords = TheFindWarehousesDataSet.FindWarehouses.Rows.Count; for (intCounter = 0; intCounter < intNumberOfRecords; intCounter++) { if (intWarehouseID == TheFindWarehousesDataSet.FindWarehouses[intCounter].EmployeeID) { intSelectedIndex = intCounter + 1; } } cboSelectOffice.SelectedIndex = intSelectedIndex; } } else if (strValueForValidation.Length > 4) { TheMessagesClass.ErrorMessage("There Are To Many Characters"); return; } } catch (Exception Ex) { TheEventLogClass.InsertEventLogEntry(DateTime.Now, "New Blue Jay ERP // Edit Phone Ext // Find Extension Expander " + Ex.Message); TheMessagesClass.ErrorMessage(Ex.ToString()); } }
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 txtEnterInfo_TextChanged(object sender, TextChangedEventArgs e) { //this will load up the controls for the search //setting local variables int intCounter; int intNumberOfRecords; string strInfoEntered; bool blnFatalError; try { strInfoEntered = txtEnterInfo.Text; if (gstrReportType == "PHONE") { if (strInfoEntered.Length == 4) { gstrPhoneNumber = strInfoEntered; } else if (strInfoEntered.Length > 4) { TheMessagesClass.ErrorMessage("There are Two Many Digits"); return; } } else if (gstrReportType == "EXT") { if (strInfoEntered.Length == 4) { blnFatalError = TheDataValidationClass.VerifyIntegerData(strInfoEntered); if (blnFatalError == true) { TheMessagesClass.ErrorMessage("The Extension Entered is not Numeric"); return; } else { gintExtension = Convert.ToInt32(strInfoEntered); TheFindPhoneByExtensionDataSet = ThePhonesClass.FindPhoneByExtension(gintExtension); intNumberOfRecords = TheFindPhoneByExtensionDataSet.FindPhoneByExtension.Rows.Count; if (intNumberOfRecords < 1) { TheMessagesClass.ErrorMessage("The Extension Entered does not Exist"); return; } } } else if (strInfoEntered.Length > 4) { TheMessagesClass.ErrorMessage("There are Two Many Digits"); return; } } else if (gstrReportType == "EMPLOYEE") { if (strInfoEntered.Length > 2) { TheComboEmployeeDataSet = TheEmployeeClass.FillEmployeeComboBox(strInfoEntered); intNumberOfRecords = TheComboEmployeeDataSet.employees.Rows.Count; if (intNumberOfRecords < 1) { TheMessagesClass.ErrorMessage("Employee Was Not Found"); return; } cboSelectEmployee.Items.Clear(); cboSelectEmployee.Items.Add("Select Employee"); for (intCounter = 0; intCounter < intNumberOfRecords; intCounter++) { cboSelectEmployee.Items.Add(TheComboEmployeeDataSet.employees[intCounter].FullName); } cboSelectEmployee.SelectedIndex = 0; } } } catch (Exception ex) { TheEventLogClass.InsertEventLogEntry(DateTime.Now, "New Blue Jay ERP // Search Phone Calls // Enter Info Text Box " + ex.Message); TheMessagesClass.ErrorMessage(ex.ToString()); } }