public FindWorkOrderStatusSortedDataSet FindWorkOrderStatusSorted() { try { aFindWorkOrderStatusSortedDataSet = new FindWorkOrderStatusSortedDataSet(); aFindWorkOrderStatusSortedTableAdapter = new FindWorkOrderStatusSortedDataSetTableAdapters.FindWorkOrderStatusSortedTableAdapter(); aFindWorkOrderStatusSortedTableAdapter.Fill(aFindWorkOrderStatusSortedDataSet.FindWorkOrderStatusSorted); } catch (Exception Ex) { TheEventLogClass.InsertEventLogEntry(DateTime.Now, "Work Order Class // Find Work Order Status Sorted " + Ex.Message); } return(aFindWorkOrderStatusSortedDataSet); }
private void ResetControls() { //setting up the variabvles int intCounter; int intNumberOfRecords; int intSelectedIndex = 0; txtAssignedProjectID.Text = ""; txtCustomerProjectID.Text = ""; ClearDateEntryControls(); SetControlsReadOnly(false); expProecess.IsEnabled = true; //loading up the combo boxes cboSelectManager.Items.Clear(); TheFindProductionManagersDataSet = TheEmployeeClass.FindProductionManagers(); cboSelectManager.Items.Add("Select Manager"); intNumberOfRecords = TheFindProductionManagersDataSet.FindProductionManagers.Rows.Count - 1; for (intCounter = 0; intCounter <= intNumberOfRecords; intCounter++) { cboSelectManager.Items.Add(TheFindProductionManagersDataSet.FindProductionManagers[intCounter].FullName); } cboSelectManager.SelectedIndex = 0; cboSelectDepartment.Items.Clear(); cboSelectDepartment.Items.Add("Select Department"); TheFindSortedCustomerLinesDataSet = TheDepartmentClass.FindSortedCustomerLines(); intNumberOfRecords = TheFindSortedCustomerLinesDataSet.FindSortedCustomerLines.Rows.Count - 1; for (intCounter = 0; intCounter <= intNumberOfRecords; intCounter++) { cboSelectDepartment.Items.Add(TheFindSortedCustomerLinesDataSet.FindSortedCustomerLines[intCounter].Department); } cboSelectDepartment.SelectedIndex = 0; cboSelectOffice.Items.Clear(); cboSelectOffice.Items.Add("Select Office"); TheFindWarehousesDataSet = TheEmployeeClass.FindWarehouses(); intNumberOfRecords = TheFindWarehousesDataSet.FindWarehouses.Rows.Count - 1; for (intCounter = 0; intCounter <= intNumberOfRecords; intCounter++) { cboSelectOffice.Items.Add(TheFindWarehousesDataSet.FindWarehouses[intCounter].FirstName); } cboSelectOffice.SelectedIndex = 0; cboSelectStatus.Items.Clear(); cboSelectStatus.Items.Add("Select Status"); TheFindWorkOrderStatusSortedDataSet = TheWorkOrderClass.FindWorkOrderStatusSorted(); cboSelectStatus.IsEnabled = true; intNumberOfRecords = TheFindWorkOrderStatusSortedDataSet.FindWorkOrderStatusSorted.Rows.Count - 1; for (intCounter = 0; intCounter <= intNumberOfRecords; intCounter++) { cboSelectStatus.Items.Add(TheFindWorkOrderStatusSortedDataSet.FindWorkOrderStatusSorted[intCounter].WorkOrderStatus); if (TheFindWorkOrderStatusSortedDataSet.FindWorkOrderStatusSorted[intCounter].WorkOrderStatus == "OPEN") { intSelectedIndex = intCounter + 1; } } cboSelectStatus.SelectedIndex = intSelectedIndex; cboSelectStatus.IsEnabled = false; rdoOverNo.Visibility = Visibility.Hidden; rdoOverYes.Visibility = Visibility.Hidden; }