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