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