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