Пример #1
0
        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;
            }
        }
Пример #2
0
        public FindPhoneExtensionsByLocationDataSet FindPhoneExtensionByLocation(int intWarehouseID)
        {
            try
            {
                aFindPhoneExtensionsByLocationDataSet      = new FindPhoneExtensionsByLocationDataSet();
                aFindPhoneExtensionsByLocationTableAdapter = new FindPhoneExtensionsByLocationDataSetTableAdapters.FindPhoneExtensionsByLocationTableAdapter();
                aFindPhoneExtensionsByLocationTableAdapter.Fill(aFindPhoneExtensionsByLocationDataSet.FindPhoneExtensionsByLocation, intWarehouseID);
            }
            catch (Exception Ex)
            {
                TheEventLogClass.InsertEventLogEntry(DateTime.Now, "Phone Class // Find Phone Extension By Location " + Ex.Message);
            }

            return(aFindPhoneExtensionsByLocationDataSet);
        }