public FindSortedExtensionsByLastNameDataSet FindSortedExtensionsByLastName()
{
try
{
aFindSortedExtensionsByLastNameDataSet = new FindSortedExtensionsByLastNameDataSet();
aFindSortedExtensionsByLastNameTableAdapter = new FindSortedExtensionsByLastNameDataSetTableAdapters.FindSortedExtensionsByLastNameTableAdapter();
aFindSortedExtensionsByLastNameTableAdapter.Fill(aFindSortedExtensionsByLastNameDataSet.FindSortedExtensionsByLastName);
}
catch (Exception Ex)
{
TheEventLogClass.InsertEventLogEntry(DateTime.Now, "Phone Class // Find Sorted Extensions By Last Name " + Ex.Message);
}
return(aFindSortedExtensionsByLastNameDataSet);
}
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());
}
}
