Exemple #1
0
        private void cboSelectEmployee_SelectionChanged(object sender, SelectionChangedEventArgs e)
        {
            int intSelectedIndex;
            int intRecordsReturned;

            try
            {
                intSelectedIndex = cboSelectEmployee.SelectedIndex - 1;

                if (intSelectedIndex > -1)
                {
                    gintEmployeeID = TheComboEmployeeDataSet.employees[intSelectedIndex].EmployeeID;
                    gstrFullName   = TheComboEmployeeDataSet.employees[intSelectedIndex].FullName;

                    TheFindEmployeeByEmployeeIDDataSet = TheEmployeeClass.FindEmployeeByEmployeeID(gintEmployeeID);

                    if (TheFindEmployeeByEmployeeIDDataSet.FindEmployeeByEmployeeID[0].IsEmailAddressNull() == true)
                    {
                        gstrEmailAddress = "NONE";
                    }
                    else
                    {
                        gstrEmailAddress = TheFindEmployeeByEmployeeIDDataSet.FindEmployeeByEmployeeID[0].EmailAddress;

                        if (gstrEmailAddress.Contains("bluejaycommunications.com") == false)
                        {
                            gstrEmailAddress = "NONE";
                        }
                    }



                    TheFindPhoneExtensionByEmployeeIDDataSet = ThePhonesClass.FindPhoneExtensionByEmployeeID(gintEmployeeID);

                    intRecordsReturned = TheFindPhoneExtensionByEmployeeIDDataSet.FindPhoneExtensionByEmployeeID.Rows.Count;

                    if (intRecordsReturned > 0)
                    {
                        gintPhoneExtension = TheFindPhoneExtensionByEmployeeIDDataSet.FindPhoneExtensionByEmployeeID[0].Extension;
                    }
                    else
                    {
                        gintPhoneExtension = 0;
                    }
                }
            }
            catch (Exception Ex)
            {
                TheEventLogClass.InsertEventLogEntry(DateTime.Now, "Blue Jay Help Desk // Main Window // Employee Combo Box " + Ex.Message);

                TheMessagesClass.ErrorMessage(Ex.ToString());
            }
        }
Exemple #2
0
        public FindPhoneExtensionByEmployeeIDDataSet FindPhoneExtensionByEmployeeID(int intEmployeeID)
        {
            try
            {
                aFindPhoneExtensionByEmployeeIDDataSet      = new FindPhoneExtensionByEmployeeIDDataSet();
                aFindPhoneExtensionByEmployeeIDTableAdapter = new FindPhoneExtensionByEmployeeIDDataSetTableAdapters.FindPhoneExtensionByEmployeeIDTableAdapter();
                aFindPhoneExtensionByEmployeeIDTableAdapter.Fill(aFindPhoneExtensionByEmployeeIDDataSet.FindPhoneExtensionByEmployeeID, intEmployeeID);
            }
            catch (Exception Ex)
            {
                TheEventLogClass.InsertEventLogEntry(DateTime.Now, "Phone Class // Find Phone Extension By Employee ID " + Ex.Message);
            }

            return(aFindPhoneExtensionByEmployeeIDDataSet);
        }
Exemple #3
0
        private void Window_Loaded(object sender, RoutedEventArgs e)
        {
            //setting local variables
            int    intCounter;
            int    intNumberOfRecords;
            int    intRecordsReturned;
            int    intEmployeeID;
            int    intPhoneExtension = 0;
            string strProblemStatus;
            int    intSelectedIndex   = 0;
            string strUpdates         = "";
            bool   blnEmailNotCorrect = false;

            try
            {
                cboTicketStatus.Items.Clear();
                cboTicketStatus.Items.Add("Select Status");
                cboTicketStatus.Items.Add("OPEN");
                cboTicketStatus.Items.Add("IN PROCESS");
                cboTicketStatus.Items.Add("WAITING ON USER");
                cboTicketStatus.Items.Add("WAITING ON PARTS");
                cboTicketStatus.Items.Add("CLOSED");
                cboTicketStatus.SelectedIndex = 0;

                TheFindHelpDeskTicketsByTicketIDDataSet = TheHelpDeskClass.FindHelpDeskTicketByTicketID(MainWindow.gintTicketID);

                intEmployeeID = TheFindHelpDeskTicketsByTicketIDDataSet.FindHelpDeskTicketsByTicketID[0].EmployeeID;

                TheFindEmployeeByEmployeeIDDataSet = TheEmployeeClass.FindEmployeeByEmployeeID(intEmployeeID);

                if (TheFindEmployeeByEmployeeIDDataSet.FindEmployeeByEmployeeID[0].IsEmailAddressNull() == true)
                {
                    gstrUserEmailAddress = "*****@*****.**";
                }
                else
                {
                    gstrUserEmailAddress = TheFindEmployeeByEmployeeIDDataSet.FindEmployeeByEmployeeID[0].EmailAddress;

                    blnEmailNotCorrect = TheDataValidationClass.VerifyEmailAddress(gstrUserEmailAddress);

                    if (blnEmailNotCorrect == true)
                    {
                        gstrUserEmailAddress = "*****@*****.**";
                    }
                }

                TheFindPhoneExtensionByEmployeeIDDataSet = ThePhoneClass.FindPhoneExtensionByEmployeeID(intEmployeeID);

                intRecordsReturned = TheFindPhoneExtensionByEmployeeIDDataSet.FindPhoneExtensionByEmployeeID.Rows.Count;

                if (intRecordsReturned < 1)
                {
                    intPhoneExtension = 0;
                }
                else if (intRecordsReturned > 0)
                {
                    intPhoneExtension = TheFindPhoneExtensionByEmployeeIDDataSet.FindPhoneExtensionByEmployeeID[0].Extension;
                }

                txtExtension.Text   = Convert.ToString(intPhoneExtension);
                txtFirstName.Text   = TheFindHelpDeskTicketsByTicketIDDataSet.FindHelpDeskTicketsByTicketID[0].FirstName;
                txtLastName.Text    = TheFindHelpDeskTicketsByTicketIDDataSet.FindHelpDeskTicketsByTicketID[0].LastName;
                txtProblem.Text     = TheFindHelpDeskTicketsByTicketIDDataSet.FindHelpDeskTicketsByTicketID[0].ReportedProblem;
                txtProblemType.Text = TheFindHelpDeskTicketsByTicketIDDataSet.FindHelpDeskTicketsByTicketID[0].ProblemType;
                txtTicketDate.Text  = Convert.ToString(TheFindHelpDeskTicketsByTicketIDDataSet.FindHelpDeskTicketsByTicketID[0].TicketDate);
                txtTicketID.Text    = Convert.ToString(MainWindow.gintTicketID);

                strProblemStatus = TheFindHelpDeskTicketsByTicketIDDataSet.FindHelpDeskTicketsByTicketID[0].TicketStatus;

                intNumberOfRecords = cboTicketStatus.Items.Count;

                for (intCounter = 0; intCounter < intNumberOfRecords; intCounter++)
                {
                    cboTicketStatus.SelectedIndex = intCounter;

                    if (strProblemStatus == cboTicketStatus.SelectedItem.ToString())
                    {
                        intSelectedIndex = intCounter;
                    }
                }

                cboTicketStatus.SelectedIndex = intSelectedIndex;

                TheFindHelpDeskTicketUpdatesByTicketIDDataSet = TheHelpDeskClass.FindHelpDeskTicketUpdatesByTicketID(MainWindow.gintTicketID);

                intNumberOfRecords = TheFindHelpDeskTicketUpdatesByTicketIDDataSet.FindHelpDeskTicketUpdatesByTicketID.Rows.Count;

                if (intNumberOfRecords > 0)
                {
                    for (intCounter = 0; intCounter < intNumberOfRecords; intCounter++)
                    {
                        strUpdates += Convert.ToString(TheFindHelpDeskTicketUpdatesByTicketIDDataSet.FindHelpDeskTicketUpdatesByTicketID[intCounter].TransactionDate);
                        strUpdates += " - ";
                        strUpdates += TheFindHelpDeskTicketUpdatesByTicketIDDataSet.FindHelpDeskTicketUpdatesByTicketID[intCounter].UpdateNotes;
                        strUpdates += "\n\n";
                    }
                }

                txtProblemUpdates.Text = strUpdates;
            }
            catch (Exception Ex)
            {
                TheEventLogClass.InsertEventLogEntry(DateTime.Now, "New Blue Jay ERP // Update Ticket Information // Window Loaded " + Ex.Message);

                TheMessagesClass.ErrorMessage(Ex.ToString());
            }
        }
Exemple #4
0
        private void dgrOpenTickets_SelectionChanged(object sender, SelectionChangedEventArgs e)
        {
            DataGrid     dataGrid;
            DataGridRow  selectedRow;
            DataGridCell TicketID;
            string       strTicketID;
            int          intRecordsReturned;
            int          intEmployeeID;
            int          intProblemTypeID;
            int          intAssignedEmployeeID;
            int          intCounter;
            int          intNumberOfRecords;
            int          intSelectedIndex = 0;
            string       strTicketStatus  = "";
            string       strTicketUpdate;
            bool         blnFatalError;

            try
            {
                if (dgrOpenTickets.SelectedIndex > -1)
                {
                    //setting local variable
                    dataGrid    = dgrOpenTickets;
                    selectedRow = (DataGridRow)dataGrid.ItemContainerGenerator.ContainerFromIndex(dataGrid.SelectedIndex);
                    TicketID    = (DataGridCell)dataGrid.Columns[0].GetCellContent(selectedRow).Parent;
                    strTicketID = ((TextBlock)TicketID.Content).Text;


                    //find the record
                    MainWindow.gintTicketID = Convert.ToInt32(strTicketID);

                    TheFindHelpDeskTicketsByTicketIDDataSet = TheHelpDeskClass.FindHelpDeskTicketByTicketID(MainWindow.gintTicketID);

                    intEmployeeID        = TheFindHelpDeskTicketsByTicketIDDataSet.FindHelpDeskTicketsByTicketID[0].EmployeeID;
                    txtComputerName.Text = TheFindHelpDeskTicketsByTicketIDDataSet.FindHelpDeskTicketsByTicketID[0].ComputerName;

                    strTicketUpdate  = TheFindHelpDeskTicketsByTicketIDDataSet.FindHelpDeskTicketsByTicketID[0].FirstName + " ";
                    strTicketUpdate += TheFindHelpDeskTicketsByTicketIDDataSet.FindHelpDeskTicketsByTicketID[0].LastName + " - ";
                    strTicketUpdate += Convert.ToString(TheFindHelpDeskTicketsByTicketIDDataSet.FindHelpDeskTicketsByTicketID[0].TicketDate) + " - ";
                    strTicketUpdate += TheFindHelpDeskTicketsByTicketIDDataSet.FindHelpDeskTicketsByTicketID[0].ReportedProblem + "\n\n";

                    TheFindEmployeeByEmployeeIDDataSet = TheEmployeeClass.FindEmployeeByEmployeeID(intEmployeeID);

                    if (TheFindEmployeeByEmployeeIDDataSet.FindEmployeeByEmployeeID[0].IsEmailAddressNull() == true)
                    {
                        gstrUserEmailAddress = "*****@*****.**";
                    }
                    else
                    {
                        gstrUserEmailAddress = TheFindEmployeeByEmployeeIDDataSet.FindEmployeeByEmployeeID[0].EmailAddress;

                        blnFatalError = TheDataValidationClass.VerifyEmailAddress(gstrUserEmailAddress);

                        if (blnFatalError == true)
                        {
                            gstrUserEmailAddress = "*****@*****.**";
                        }
                    }

                    TheFindHelpDeskCurrentAssignmentDataSet = TheHelpDeskClass.FindHelpDeskTicketCurrentAssignment(MainWindow.gintTicketID);

                    intRecordsReturned = TheFindHelpDeskCurrentAssignmentDataSet.FindHelpDeskTicketCurrentAssignment.Rows.Count;

                    if (intRecordsReturned > 0)
                    {
                        intAssignedEmployeeID = TheFindHelpDeskCurrentAssignmentDataSet.FindHelpDeskTicketCurrentAssignment[0].EmployeeID;
                        intNumberOfRecords    = TheFindEmployeeByDepartmentDataSet.FindEmployeeByDepartment.Rows.Count;

                        for (intCounter = 0; intCounter < intNumberOfRecords; intCounter++)
                        {
                            if (intAssignedEmployeeID == TheFindEmployeeByDepartmentDataSet.FindEmployeeByDepartment[intCounter].EmployeeID)
                            {
                                cboSelectEmployee.SelectedIndex = intCounter + 1;
                            }
                        }
                    }
                    else
                    {
                        cboSelectEmployee.SelectedIndex = 0;
                    }

                    intProblemTypeID = TheFindHelpDeskTicketsByTicketIDDataSet.FindHelpDeskTicketsByTicketID[0].ProblemTypeID;

                    intNumberOfRecords = TheFindSortedHelpDeskProblemTypeDataSet.FindSortedHelpDeskProblemType.Rows.Count;

                    for (intCounter = 0; intCounter < intNumberOfRecords; intCounter++)
                    {
                        if (intProblemTypeID == TheFindSortedHelpDeskProblemTypeDataSet.FindSortedHelpDeskProblemType[intCounter].ProblemTypeID)
                        {
                            cboProblemType.SelectedIndex = intCounter + 1;
                        }
                    }

                    strTicketStatus = TheFindHelpDeskTicketsByTicketIDDataSet.FindHelpDeskTicketsByTicketID[0].TicketStatus;

                    intNumberOfRecords = cboTicketStatus.Items.Count;

                    for (intCounter = 0; intCounter < intNumberOfRecords; intCounter++)
                    {
                        cboTicketStatus.SelectedIndex = intCounter;

                        if (strTicketStatus == cboTicketStatus.SelectedItem.ToString())
                        {
                            intSelectedIndex = intCounter;
                        }
                    }

                    cboTicketStatus.SelectedIndex = intSelectedIndex;

                    TheFindPhoneExtensionByEmployeeIDDataSet = ThePhoneClass.FindPhoneExtensionByEmployeeID(intEmployeeID);

                    intRecordsReturned = TheFindPhoneExtensionByEmployeeIDDataSet.FindPhoneExtensionByEmployeeID.Rows.Count;

                    if (intRecordsReturned > 0)
                    {
                        txtExtension.Text = Convert.ToString(TheFindPhoneExtensionByEmployeeIDDataSet.FindPhoneExtensionByEmployeeID[0].Extension);
                    }
                    else
                    {
                        txtExtension.Text = "0";
                    }

                    TheFindHelpDeskTicketUpdatesByTicketIDDataSet = TheHelpDeskClass.FindHelpDeskTicketUpdatesByTicketID(MainWindow.gintTicketID);

                    intNumberOfRecords = TheFindHelpDeskTicketUpdatesByTicketIDDataSet.FindHelpDeskTicketUpdatesByTicketID.Rows.Count;

                    if (intNumberOfRecords > 0)
                    {
                        for (intCounter = 0; intCounter < intNumberOfRecords; intCounter++)
                        {
                            strTicketUpdate += Convert.ToString(TheFindHelpDeskTicketUpdatesByTicketIDDataSet.FindHelpDeskTicketUpdatesByTicketID[intCounter].TransactionDate) + " - ";
                            strTicketUpdate += TheFindHelpDeskTicketUpdatesByTicketIDDataSet.FindHelpDeskTicketUpdatesByTicketID[intCounter].FirstName + " ";
                            strTicketUpdate += TheFindHelpDeskTicketUpdatesByTicketIDDataSet.FindHelpDeskTicketUpdatesByTicketID[intCounter].LastName + " - ";
                            strTicketUpdate += TheFindHelpDeskTicketUpdatesByTicketIDDataSet.FindHelpDeskTicketUpdatesByTicketID[intCounter].UpdateNotes + "\n\n";
                        }
                    }

                    txtTicketUpdates.Text = strTicketUpdate;
                }
            }
            catch (Exception Ex)
            {
                TheEventLogClass.InsertEventLogEntry(DateTime.Now, "New Blue Jay ERP // Update Help Desk Tickets // dgr Open Tickets Grid Selection " + Ex.Message);

                TheMessagesClass.ErrorMessage(Ex.ToString());
            }
        }
Exemple #5
0
        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());
            }
        }