private void ResetControls()
{
//setting variables
int intCounter;
int intNumberOfRecords;
try
{
txtInETA.Text = "";
txtLastName.Text = "";
txtOutTime.Text = "";
txtProjectID.Text = "";
txtVehicleNumber.Text = "";
txtWorkDate.Text = "";
txtWorkLocation.Text = "";
gblnVehicleFound = false;
TheAfterWorkEmployeesDataSet.afterhoursemployees.Rows.Clear();
dgrAssignedEmployees.ItemsSource = TheAfterWorkEmployeesDataSet.afterhoursemployees;
TheFindWarehousesDataSet = TheEmployeeClass.FindWarehouses();
cboSelectOffice.Items.Clear();
cboSelectOffice.Items.Add("Select Office");
intNumberOfRecords = TheFindWarehousesDataSet.FindWarehouses.Rows.Count - 1;
for (intCounter = 0; intCounter <= intNumberOfRecords; intCounter++)
{
cboSelectOffice.Items.Add(TheFindWarehousesDataSet.FindWarehouses[intCounter].FirstName);
}
cboSelectOffice.SelectedIndex = 0;
TheFindSortedDepartmentDataSet = TheDepartmentClass.FindSortedDepartment();
cboSelectDepartment.Items.Clear();
cboSelectDepartment.Items.Add("Select Department");
intNumberOfRecords = TheFindSortedDepartmentDataSet.FindSortedDepartment.Rows.Count - 1;
for (intCounter = 0; intCounter <= intNumberOfRecords; intCounter++)
{
cboSelectDepartment.Items.Add(TheFindSortedDepartmentDataSet.FindSortedDepartment[intCounter].Department);
}
cboSelectDepartment.SelectedIndex = 0;
cboSelectEmployee.Items.Clear();
TheEmployeeDateEntryClass.InsertIntoEmployeeDateEntry(MainWindow.TheVerifyLogonDataSet.VerifyLogon[0].EmployeeID, "New Blue Jay ERP // Submit After Hours Work");
}
catch (Exception Ex)
{
TheEventLogClass.InsertEventLogEntry(DateTime.Now, "New Blue Jay ERP // Submit After Hours Work // Reset Controls " + Ex.Message);
TheMessagesClass.ErrorMessage(Ex.ToString());
}
}
private void ResetControls()
{
int intCounter;
int intNumberOfRecords;
try
{
txtTaskDescription.Text = "";
txtTaskPrice.Text = "";
cboSelectOffice.Items.Clear();
cboSelectOffice.Items.Add("Select Office");
TheFindWarehousesDataSet = TheEmployeeClass.FindWarehouses();
intNumberOfRecords = TheFindWarehousesDataSet.FindWarehouses.Rows.Count;
for (intCounter = 0; intCounter < intNumberOfRecords; intCounter++)
{
cboSelectOffice.Items.Add(TheFindWarehousesDataSet.FindWarehouses[intCounter].FirstName);
}
cboSelectOffice.SelectedIndex = 0;
}
catch (Exception ex)
{
TheSendEmailClass.SendEventLog("New Blue Jay ERP // Add WOV Tasks // Reset Controls " + ex.Message);
TheEventLogClass.InsertEventLogEntry(DateTime.Now, "New Blue Jay ERP // Add WOV Tasks // Reset Controls " + ex.Message);
TheMessagesClass.ErrorMessage(ex.ToString());
}
}
private void ResetControls()
{
int intCounter;
int intNumberOfRecords;
try
{
cboSelectLocation.Items.Clear();
cboSelectLocation.Items.Add("Select Location");
cboSelectLocation.Items.Add("All Locations");
TheFindWarehouseDataSet = TheEmployeeClass.FindWarehouses();
intNumberOfRecords = TheFindWarehouseDataSet.FindWarehouses.Rows.Count - 1;
for (intCounter = 0; intCounter <= intNumberOfRecords; intCounter++)
{
cboSelectLocation.Items.Add(TheFindWarehouseDataSet.FindWarehouses[intCounter].FirstName);
}
cboSelectLocation.SelectedIndex = 0;
}
catch (Exception Ex)
{
TheEventLogClass.InsertEventLogEntry(DateTime.Now, "New Blue Jay ERP // Vehicle Roster // Reset Controls " + Ex.Message);
TheMessagesClass.ErrorMessage(Ex.ToString());
}
}
private void ResetControls()
{
//this will load the controls
int intCounter;
int intNumberOfRecords;
try
{
cboSelectLocation.Items.Clear();
cboSelectLocation.Items.Add("Select Location");
TheFindWarehousesDataSet = TheEmployeeClass.FindWarehouses();
intNumberOfRecords = TheFindWarehousesDataSet.FindWarehouses.Rows.Count;
cboSelectSite.Items.Clear();
cboSelectSite.Items.Add("Select Site");
for (intCounter = 0; intCounter < intNumberOfRecords; intCounter++)
{
cboSelectSite.Items.Add(TheFindWarehousesDataSet.FindWarehouses[intCounter].FirstName);
}
cboSelectSite.SelectedIndex = 0;
TheEmployeeDateEntryClass.InsertIntoEmployeeDateEntry(MainWindow.TheVerifyLogonDataSet.VerifyLogon[0].EmployeeID, "New Blue Jay ERP // Select Wasp Assets");
}
catch (Exception Ex)
{
TheEventLogClass.InsertEventLogEntry(DateTime.Now, "New Blue Jay ERP // Select Wasp Update // Reset Controls " + Ex.Message);
TheMessageClass.ErrorMessage(Ex.ToString());
}
}
private void ResetControls()
{
int intCounter;
int intNumberOfRecords;
bool blnFatalError = false;
try
{
txtEnterLastName.Text = "";
txtProblemNotes.Text = "";
cboSelectEmployee.Items.Clear();
cboProblemType.Items.Clear();
cboSelectOffice.Items.Clear();
//loading the warehouses
TheFindWarehousesDataSet = TheEmployeeClass.FindWarehouses();
cboSelectOffice.Items.Add("Select Office");
intNumberOfRecords = TheFindWarehousesDataSet.FindWarehouses.Rows.Count - 1;
for (intCounter = 0; intCounter <= intNumberOfRecords; intCounter++)
{
cboSelectOffice.Items.Add(TheFindWarehousesDataSet.FindWarehouses[intCounter].FirstName);
}
cboSelectOffice.SelectedIndex = 0;
cboProblemType.Items.Add("Select Problem Type");
TheFindSortedHelpDeskProblemTypeDataSet = TheHelpDeskClass.FindSortedHelpDeskProblemType();
intNumberOfRecords = TheFindSortedHelpDeskProblemTypeDataSet.FindSortedHelpDeskProblemType.Rows.Count - 1;
for (intCounter = 0; intCounter <= intNumberOfRecords; intCounter++)
{
cboProblemType.Items.Add(TheFindSortedHelpDeskProblemTypeDataSet.FindSortedHelpDeskProblemType[intCounter].ProblemType);
}
cboProblemType.SelectedIndex = 0;
gstrComputerName = System.Environment.MachineName.ToUpper();
gstrUserName = System.Environment.UserName.ToUpper();
gstrIPAddress = System.Net.Dns.GetHostEntry(System.Net.Dns.GetHostName()).AddressList.GetValue(0).ToString();
cboSelectEmployee.Items.Add("Select Employee");
cboSelectEmployee.SelectedIndex = 0;
blnFatalError = TheEmployeeDateEntryClass.InsertIntoEmployeeDateEntry(MainWindow.TheVerifyLogonDataSet.VerifyLogon[0].EmployeeID, "New Blue Jay ERP // IT Create Help Desk Ticket");
if (blnFatalError == true)
{
throw new Exception();
}
}
catch (Exception Ex)
{
TheEventLogClass.InsertEventLogEntry(DateTime.Now, "Blue Jay Help Desk // Main Window // Window Loaded " + Ex.Message);
TheMessagesClass.ErrorMessage(Ex.ToString());
}
}
private void ResetControls()
{
TheImportGEOFenceDataSet.importgeofence.Rows.Clear();
TheFindActiveVehicleMainDataSet = TheVehicleMainClass.FindActiveVehicleMain();
TheFindWarehouseDataSet = TheEmployeeClass.FindWarehouses();
dgrResults.ItemsSource = TheImportGEOFenceDataSet.importgeofence;
}
private void ResetControls()
{
int intCounter;
int intNumberOfRecords;
bool blnFatalError = false;
try
{
blnFatalError = TheEmployeeDataEntryClass.InsertIntoEmployeeDateEntry(MainWindow.TheVerifyLogonDataSet.VerifyLogon[0].EmployeeID, "New Blue Jay ERP // Add New Tool");
if (blnFatalError == true)
{
throw new Exception();
}
txtToolCost.Text = "";
txtToolDescription.Text = "";
txtToolID.Text = "";
txtToolPartNumber.Text = "";
TheFindSortedToolCategoryDataSet = TheToolCategoryClass.FindSortedToolCategory();
cboSelectToolCategory.Items.Clear();
cboSelectToolCategory.Items.Add("Select Tool Category");
intNumberOfRecords = TheFindSortedToolCategoryDataSet.FindSortedToolCategory.Rows.Count;
for (intCounter = 0; intCounter < intNumberOfRecords; intCounter++)
{
cboSelectToolCategory.Items.Add(TheFindSortedToolCategoryDataSet.FindSortedToolCategory[intCounter].ToolCategory);
}
cboSelectToolCategory.SelectedIndex = 0;
TheFindWarehousesDataSet = TheEmployeeClass.FindWarehouses();
cboSelectWarehouse.Items.Clear();
cboSelectWarehouse.Items.Add("Select Warehouse");
intNumberOfRecords = TheFindWarehousesDataSet.FindWarehouses.Rows.Count;
for (intCounter = 0; intCounter < intNumberOfRecords; intCounter++)
{
cboSelectWarehouse.Items.Add(TheFindWarehousesDataSet.FindWarehouses[intCounter].FirstName);
}
cboSelectWarehouse.SelectedIndex = 0;
}
catch (Exception Ex)
{
TheEventLogClass.InsertEventLogEntry(DateTime.Now, "New Blue Jay ERP // Add New Tools // Reset Controls " + Ex.Message);
TheSendEmailClass.SendEventLog(Ex.ToString());
TheMessagesClass.ErrorMessage(Ex.ToString());
}
}
private void ResetControls()
{
//setting up the variabvles
int intCounter;
int intNumberOfRecords;
txtAssignedProjectID.Text = "";
txtCustomerProjectID.Text = "";
ClearRadioButtons();
ClearDateEntryControls();
SetControlsReadOnly(false);
gblnDoNotRun = false;
//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;
expAddEditProjectInfo.IsEnabled = false;
}
public FindWarehousesDataSet FindWarehouses()
{
try
{
aFindWarehousesDataSet = new FindWarehousesDataSet();
aFindWarehousesTableAdapter = new FindWarehousesDataSetTableAdapters.FindWarehousesTableAdapter();
aFindWarehousesTableAdapter.Fill(aFindWarehousesDataSet.FindWarehouses);
}
catch (Exception Ex)
{
TheEventLogClass.InsertEventLogEntry(DateTime.Now, "New Employee DLL // Find Parts Warehouses // " + Ex.Message);
}
return(aFindWarehousesDataSet);
}
private void ResetControls()
{
//setting local variables
int intCounter;
int intNumberOfRecords;
try
{
TheImportProjectsDataSet.importprojects.Rows.Clear();
txtEmployeeID.Text = "";
cboSelectDepartment.Items.Clear();
cboSelectDepartment.Items.Add("Select Department");
TheFindSortedDepartmentDataSet = TheDepartmentClass.FindSortedDepartment();
intNumberOfRecords = TheFindSortedDepartmentDataSet.FindSortedDepartment.Rows.Count - 1;
for (intCounter = 0; intCounter <= intNumberOfRecords; intCounter++)
{
cboSelectDepartment.Items.Add(TheFindSortedDepartmentDataSet.FindSortedDepartment[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;
dgrProjects.ItemsSource = TheImportProjectsDataSet.importprojects;
}
catch (Exception Ex)
{
TheEventLogClass.InsertEventLogEntry(DateTime.Now, "Import Projects // Main Window // Reset Controls " + Ex.Message);
TheMessagesClass.ErrorMessage(Ex.ToString());
}
}
private void ResetControls()
{
int intCounter;
int intNumberOfRecords;
bool blnFatalError = false;
try
{
txtDirectNumber.Text = "";
txtEnterLastName.Text = "";
txtEnterPhoneExt.Text = "";
txtMACAddress.Text = "";
cboSelectEmployee.Items.Clear();
cboSelectEmployee.Items.Add("Select Employee");
cboSelectEmployee.SelectedIndex = 0;
cboSelectOffice.Items.Clear();
cboSelectOffice.Items.Add("Select Office");
TheFindWarehousesDataSet = TheEmployeeClass.FindWarehouses();
intNumberOfRecords = TheFindWarehousesDataSet.FindWarehouses.Rows.Count;
for (intCounter = 0; intCounter < intNumberOfRecords; intCounter++)
{
cboSelectOffice.Items.Add(TheFindWarehousesDataSet.FindWarehouses[intCounter].FirstName);
}
cboSelectOffice.SelectedIndex = 0;
blnFatalError = TheEmployeeDateEntryClass.InsertIntoEmployeeDateEntry(MainWindow.TheVerifyLogonDataSet.VerifyLogon[0].EmployeeID, "New Blue Jay ERP // Edit Phone Ext");
if (blnFatalError == true)
{
throw new Exception();
}
}
catch (Exception Ex)
{
TheEventLogClass.InsertEventLogEntry(DateTime.Now, "New Blue Jay ERP // Edit Phone Ext // Reset Controls " + Ex.Message);
TheMessagesClass.ErrorMessage(Ex.ToString());
}
}
private void ResetControls()
{
int intCounter;
int intNumberOfRecords;
try
{
TheFindWarehousesDataSet = TheEmployeeClass.FindWarehouses();
cboSelectOffice.Items.Clear();
cboSelectOffice.Items.Add("Select Office");
intNumberOfRecords = TheFindWarehousesDataSet.FindWarehouses.Rows.Count;
for (intCounter = 0; intCounter < intNumberOfRecords; intCounter++)
{
cboSelectOffice.Items.Add(TheFindWarehousesDataSet.FindWarehouses[intCounter].FirstName);
}
cboSelectOffice.SelectedIndex = 0;
cboSelectBusinessLine.Items.Clear();
cboSelectBusinessLine.Items.Add("Select Business Line");
TheFindSortedCustomerLinesDataSet = TheDepartmentClass.FindSortedCustomerLines();
intNumberOfRecords = TheFindSortedCustomerLinesDataSet.FindSortedCustomerLines.Rows.Count;
for (intCounter = 0; intCounter < intNumberOfRecords; intCounter++)
{
cboSelectBusinessLine.Items.Add(TheFindSortedCustomerLinesDataSet.FindSortedCustomerLines[intCounter].Department);
}
cboSelectBusinessLine.SelectedIndex = 0;
cboSelectBusinessLine.IsEnabled = false;
TheEmployeeDateEntryClass.InsertIntoEmployeeDateEntry(MainWindow.TheVerifyLogonDataSet.VerifyLogon[0].EmployeeID, "New Blue Jay ERP // Office Info Dashboard");
}
catch (Exception Ex)
{
TheEventLogClass.InsertEventLogEntry(DateTime.Now, "New Blue Jay ERP // Office Info Dashboard // Reset Controls " + Ex.Message);
TheMessagesClass.ErrorMessage(Ex.ToString());
}
}
private int FindWarehouseID(string strWarehouseName)
{
int intCounter;
int intNumberOfRecords;
int intWarehouseID = 0;
TheFindWarehousesDataSet = TheEmployeeClass.FindWarehouses();
intNumberOfRecords = TheFindWarehousesDataSet.FindWarehouses.Rows.Count - 1;
for (intCounter = 0; intCounter <= intNumberOfRecords; intCounter++)
{
if (strWarehouseName == TheFindWarehousesDataSet.FindWarehouses[intCounter].FirstName)
{
intWarehouseID = TheFindWarehousesDataSet.FindWarehouses[intCounter].EmployeeID;
}
}
return(intWarehouseID);
}
private void ResetControls()
{
//setting local variables
int intCounter;
int intNumberOfRecords;
txtActiveDate.Text = "";
txtAssetDescription.Text = "";
txtAssetNotes.Text = "";
txtAssetPartNumber.Text = "";
txtAssetPrice.Text = "";
btnProcess.IsEnabled = false;
//loading up the warehouses
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;
cboSelectAssetType.Items.Clear();
cboSelectAssetType.Items.Add("Select Asset Type");
TheFindSortedAssetTypesDataSet = TheAssetClass.FindSortedAssetTypes();
intNumberOfRecords = TheFindSortedAssetTypesDataSet.FindSortedAssetTypes.Rows.Count - 1;
for (intCounter = 0; intCounter <= intNumberOfRecords; intCounter++)
{
cboSelectAssetType.Items.Add(TheFindSortedAssetTypesDataSet.FindSortedAssetTypes[intCounter].AssetType);
}
cboSelectAssetType.SelectedIndex = 0;
}
private void ResetControls()
{
int intCounter;
int intNumberOfRecords;
try
{
txtEnterCellNumber.Text = "";
txtEnterLastName.Text = "";
txtEquipmentNotes.Text = "";
cboSelectEmployee.Items.Clear();
cboSelectEmployee.Items.Add("Select Employee");
cboSelectEmployee.SelectedIndex = 0;
TheFindWarehousesDataSet = TheEmployeeClass.FindWarehouses();
intNumberOfRecords = TheFindWarehousesDataSet.FindWarehouses.Rows.Count;
cboSelectOffice.Items.Clear();
cboSelectOffice.Items.Add("Select Office");
for (intCounter = 0; intCounter < intNumberOfRecords; intCounter++)
{
cboSelectOffice.Items.Add(TheFindWarehousesDataSet.FindWarehouses[intCounter].FirstName);
}
cboSelectOffice.SelectedIndex = 0;
TheEmployeeDateEntryClass.InsertIntoEmployeeDateEntry(MainWindow.TheVerifyLogonDataSet.VerifyLogon[0].EmployeeID, "New Blue Jay ERP // Add Cell Phone");
}
catch (Exception Ex)
{
TheEventLogClass.InsertEventLogEntry(DateTime.Now, "New Blue Jay ERP // Add Cell Phone // Reset Controls " + Ex.Message);
TheSendEmailClass.SendEventLog(Ex.ToString());
TheMessagesClass.ErrorMessage(Ex.ToString());
}
}
private void ResetControls()
{
int intCounter;
int intNumberOfRecords;
try
{
txtEnterVehicleNumber.Text = "";
txtmake.Text = "";
txtModel.Text = "";
txtNotes.Text = "";
txtVinNumber.Text = "";
txtYear.Text = "";
cboSelectWarehouse.Items.Clear();
cboSelectWarehouse.Items.Add("Select Warehouse");
TheFindWarehousesDataSet = TheEmployeeClass.FindWarehouses();
intNumberOfRecords = TheFindWarehousesDataSet.FindWarehouses.Rows.Count;
for (intCounter = 0; intCounter < intNumberOfRecords; intCounter++)
{
cboSelectWarehouse.Items.Add(TheFindWarehousesDataSet.FindWarehouses[intCounter].FirstName);
}
cboSelectWarehouse.SelectedIndex = 0;
btnProcess.IsEnabled = false;
cboSelectWarehouse.IsEnabled = false;
}
catch (Exception Ex)
{
TheEventLogClass.InsertEventLogEntry(DateTime.Now, "New Blue Jay ERP // Change Vehicle Location // Reset Controls " + Ex.Message);
TheMessagesClass.ErrorMessage(Ex.ToString());
}
}
private void ResetControls()
{
//setting up the variables
int intCounter;
int intNumberOfRecords;
try
{
txtEnterLocation.Text = "";
cboSelectLocation.Items.Clear();
cboSelectLocation.Items.Add("Select Site");
TheFindWarehousesDataSet = TheEmployeeClass.FindWarehouses();
intNumberOfRecords = TheFindWarehousesDataSet.FindWarehouses.Rows.Count;
for (intCounter = 0; intCounter < intNumberOfRecords; intCounter++)
{
cboSelectLocation.Items.Add(TheFindWarehousesDataSet.FindWarehouses[intCounter].FirstName);
}
cboSelectLocation.SelectedIndex = 0;
TheImportWaspToolAssetsDataSet.importassets.Rows.Clear();
dgrAssets.ItemsSource = TheImportWaspToolAssetsDataSet.importassets;
TheEmployeeDateEntryClass.InsertIntoEmployeeDateEntry(MainWindow.TheVerifyLogonDataSet.VerifyLogon[0].EmployeeID, "New Blue Jay ERP // Import Vehicle Assets");
}
catch (Exception Ex)
{
TheEventLogClass.InsertEventLogEntry(DateTime.Now, "New Blue Jay ERP // Import Vehicle Assets // Reset Controls " + Ex.Message);
TheMessagesClass.ErrorMessage(Ex.ToString());
}
}
private void Window_Loaded(object sender, RoutedEventArgs e)
{
int intCounter;
int intNumberOfRecords;
int intSelectedIndex = 0;
string strOffice = "";
try
{
//loading the warehouses
TheFindWarehousesDataSet = TheEmployeeClass.FindWarehouses();
cboOffice.Items.Add("Select Office");
intNumberOfRecords = TheFindWarehousesDataSet.FindWarehouses.Rows.Count - 1;
for (intCounter = 0; intCounter <= intNumberOfRecords; intCounter++)
{
cboOffice.Items.Add(TheFindWarehousesDataSet.FindWarehouses[intCounter].FirstName);
}
cboOffice.SelectedIndex = 0;
cboProblemType.Items.Add("Select Problem Type");
TheFindSortedHelpDeskProblemTypeDataSet = TheHelpDeskClass.FindSortedHelpDeskProblemType();
intNumberOfRecords = TheFindSortedHelpDeskProblemTypeDataSet.FindSortedHelpDeskProblemType.Rows.Count - 1;
for (intCounter = 0; intCounter <= intNumberOfRecords; intCounter++)
{
cboProblemType.Items.Add(TheFindSortedHelpDeskProblemTypeDataSet.FindSortedHelpDeskProblemType[intCounter].ProblemType);
}
cboProblemType.SelectedIndex = 0;
gstrComputerName = System.Environment.MachineName.ToUpper();
gstrUserName = System.Environment.UserName.ToUpper();
gstrIPAddress = System.Net.Dns.GetHostEntry(System.Net.Dns.GetHostName()).AddressList.GetValue(0).ToString();
if (gstrIPAddress.Contains(".0."))
{
strOffice = "CLEVELAND";
}
else if (gstrIPAddress.Contains(".11."))
{
strOffice = "CBUS-GROVEPORT";
}
else if (gstrIPAddress.Contains(".31."))
{
strOffice = "NASHVILLE";
}
else if (gstrIPAddress.Contains(".41."))
{
strOffice = "MILWUKEE";
}
else if (gstrIPAddress.Contains(".51."))
{
strOffice = "TOLEDO";
}
else if (gstrIPAddress.Contains(".61."))
{
strOffice = "YOUNGSTOWN";
}
intNumberOfRecords = cboOffice.Items.Count - 1;
for (intCounter = 0; intCounter <= intNumberOfRecords; intCounter++)
{
cboOffice.SelectedIndex = intCounter;
if (cboOffice.SelectedItem.ToString() == strOffice)
{
intSelectedIndex = cboOffice.SelectedIndex;
}
}
cboOffice.SelectedIndex = intSelectedIndex;
}
catch (Exception Ex)
{
TheEventLogClass.InsertEventLogEntry(DateTime.Now, "Blue Jay Help Desk // Main Window // Window Loaded " + Ex.Message);
TheMessagesClass.ErrorMessage(Ex.ToString());
}
}
private void expImportExcel_Expanded(object sender, RoutedEventArgs e)
{
Excel.Application xlDropOrder;
Excel.Workbook xlDropBook;
Excel.Worksheet xlDropSheet;
Excel.Range range;
int intColumnRange = 0;
int intCounter;
int intNumberOfRecords;
string strTowMotorNumber;
string strTowMotorYear;
int intTowMotorYear;
string strTowMotorMake;
string strTowMotorModel;
string strTowMotorHours;
decimal decTowMotorHours;
string strWarehouse;
int intWarehouseID = 0;
string strOilChangeDate;
DateTime datOilChangeDate;
bool blnActive = true;
int intWarehouseCounter;
int intWarehouseNumberOfRecords;
string strSerialNumber;
string strWeight;
int intWeight;
string strCapacity;
int intCapacity;
try
{
TheImportTowMotorDataSet.importtowmotors.Rows.Clear();
TheFindWarehousesDataSet = TheEmployeeClass.FindWarehouses();
intWarehouseNumberOfRecords = TheFindWarehousesDataSet.FindWarehouses.Rows.Count - 1;
Microsoft.Win32.OpenFileDialog dlg = new Microsoft.Win32.OpenFileDialog();
dlg.FileName = "Document"; // Default file name
dlg.DefaultExt = ".xlsx"; // Default file extension
dlg.Filter = "Excel (.xlsx)|*.xlsx"; // Filter files by extension
// Show open file dialog box
Nullable <bool> result = dlg.ShowDialog();
// Process open file dialog box results
if (result == true)
{
// Open document
string filename = dlg.FileName;
}
PleaseWait PleaseWait = new PleaseWait();
PleaseWait.Show();
xlDropOrder = new Excel.Application();
xlDropBook = xlDropOrder.Workbooks.Open(dlg.FileName, 0, true, 5, "", "", true, Microsoft.Office.Interop.Excel.XlPlatform.xlWindows, "\t", false, false, 0, true, 1, 0);
xlDropSheet = (Excel.Worksheet)xlDropOrder.Worksheets.get_Item(1);
range = xlDropSheet.UsedRange;
intNumberOfRecords = range.Rows.Count;
intColumnRange = range.Columns.Count;
for (intCounter = 2; intCounter <= intNumberOfRecords; intCounter++)
{
strTowMotorNumber = Convert.ToString((range.Cells[intCounter, 1] as Excel.Range).Value2).ToUpper();
strTowMotorYear = Convert.ToString((range.Cells[intCounter, 2] as Excel.Range).Value2).ToUpper();
intTowMotorYear = Convert.ToInt32(strTowMotorYear);
strTowMotorMake = Convert.ToString((range.Cells[intCounter, 3] as Excel.Range).Value2).ToUpper();
strTowMotorModel = Convert.ToString((range.Cells[intCounter, 4] as Excel.Range).Value2).ToUpper();
strSerialNumber = Convert.ToString((range.Cells[intCounter, 5] as Excel.Range).Value2).ToUpper();
strTowMotorHours = Convert.ToString((range.Cells[intCounter, 6] as Excel.Range).Value2).ToUpper();
decTowMotorHours = Convert.ToDecimal(strTowMotorHours);
strWarehouse = Convert.ToString((range.Cells[intCounter, 7] as Excel.Range).Value2).ToUpper();
strWeight = Convert.ToString((range.Cells[intCounter, 8] as Excel.Range).Value2).ToUpper();
intWeight = Convert.ToInt32(strWeight);
strCapacity = Convert.ToString((range.Cells[intCounter, 9] as Excel.Range).Value2).ToUpper();
intCapacity = Convert.ToInt32(strCapacity);
for (intWarehouseCounter = 0; intWarehouseCounter <= intWarehouseNumberOfRecords; intWarehouseCounter++)
{
if (strWarehouse == TheFindWarehousesDataSet.FindWarehouses[intWarehouseCounter].FirstName)
{
intWarehouseID = TheFindWarehousesDataSet.FindWarehouses[intWarehouseCounter].EmployeeID;
}
}
strOilChangeDate = Convert.ToString((range.Cells[intCounter, 8] as Excel.Range).Value2).ToUpper();
DateTime.TryParse(strOilChangeDate, out datOilChangeDate);
ImportTowMotorDataSet.importtowmotorsRow NewTowMotorRow = TheImportTowMotorDataSet.importtowmotors.NewimporttowmotorsRow();
NewTowMotorRow.TowMotorNumber = strTowMotorNumber;
NewTowMotorRow.TowMotorYear = intTowMotorYear;
NewTowMotorRow.TowMotorMake = strTowMotorMake;
NewTowMotorRow.TowMotorModel = strTowMotorModel;
NewTowMotorRow.TowMotorHours = decTowMotorHours;
NewTowMotorRow.WarehouseID = intWarehouseID;
NewTowMotorRow.OilChangeDate = DateTime.Now;
NewTowMotorRow.TowMotorActive = blnActive;
NewTowMotorRow.TowMotorSerialNo = strSerialNumber;
NewTowMotorRow.TowMotorWeight = intWeight;
NewTowMotorRow.TowMotorCapacity = intCapacity;
TheImportTowMotorDataSet.importtowmotors.Rows.Add(NewTowMotorRow);
}
dgrTowMotors.ItemsSource = TheImportTowMotorDataSet.importtowmotors;
PleaseWait.Close();
}
catch (Exception Ex)
{
TheEventLogClass.InsertEventLogEntry(DateTime.Now, "New Blue Jay ERP // Import Tow Motors // Import Excel " + Ex.Message);
TheMessagesClass.ErrorMessage(Ex.ToString());
}
}
private void ResetControls()
{
//setting local variables;
int intNumberOfRecords;
int intCounter;
txtEmployeeID.Text = "";
txtFirstName.Text = "";
txtLastName.Text = "";
txtPhoneNumber.Text = "";
txtEmail.Text = "";
txtPayID.Text = "";
EnableControls(true);
TheFindSortedEmployeeGroupDataSet = TheEmployeeClass.FindSortedEmpoyeeGroup();
intNumberOfRecords = TheFindSortedEmployeeGroupDataSet.FindSortedEmployeeGroup.Rows.Count - 1;
cboSelectGroup.Items.Clear();
cboSelectGroup.Items.Add("Select Group");
for (intCounter = 0; intCounter <= intNumberOfRecords; intCounter++)
{
cboSelectGroup.Items.Add(TheFindSortedEmployeeGroupDataSet.FindSortedEmployeeGroup[intCounter].GroupName);
}
cboHomeOffice.Items.Clear();
cboHomeOffice.Items.Add("Select Office");
TheFindWarehousesDataSet = TheEmployeeClass.FindWarehouses();
intNumberOfRecords = TheFindWarehousesDataSet.FindWarehouses.Rows.Count - 1;
for (intCounter = 0; intCounter <= intNumberOfRecords; intCounter++)
{
cboHomeOffice.Items.Add(TheFindWarehousesDataSet.FindWarehouses[intCounter].FirstName);
}
cboDepartment.Items.Clear();
cboDepartment.Items.Add("Select Department");
TheFindSortedDepartmentDataSet = TheDepartmentClass.FindSortedDepartment();
intNumberOfRecords = TheFindSortedDepartmentDataSet.FindSortedDepartment.Rows.Count - 1;
for (intCounter = 0; intCounter <= intNumberOfRecords; intCounter++)
{
cboDepartment.Items.Add(TheFindSortedDepartmentDataSet.FindSortedDepartment[intCounter].Department);
}
cboManager.Items.Clear();
cboManager.Items.Add("Select Manager");
TheFindSortedEmployeeManagersDataSet = TheEmployeeClass.FindSortedEmployeeManagers();
intNumberOfRecords = TheFindSortedEmployeeManagersDataSet.FindSortedEmployeeManagers.Rows.Count - 1;
for (intCounter = 0; intCounter <= intNumberOfRecords; intCounter++)
{
cboManager.Items.Add(TheFindSortedEmployeeManagersDataSet.FindSortedEmployeeManagers[intCounter].FullName);
}
cboSelectType.Items.Clear();
cboSelectType.Items.Add("Select Type");
cboSelectType.Items.Add("EMPLOYEE");
cboSelectType.Items.Add("CONTRACTOR");
cboSalaryType.Items.Clear();
cboSalaryType.Items.Add("Select Salary Type");
cboSalaryType.Items.Add("EXEMPT");
cboSalaryType.Items.Add("NON-EXEMPT");
cboSelectGroup.SelectedIndex = 0;
cboHomeOffice.SelectedIndex = 0;
cboSelectType.SelectedIndex = 0;
cboSalaryType.SelectedIndex = 0;
cboDepartment.SelectedIndex = 0;
cboManager.SelectedIndex = 0;
EnableControls(false);
}
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;
}
private void Window_Loaded(object sender, RoutedEventArgs e)
{
int intCounter;
int intNumberOfRecords;
int intSelectedIndex = 0;
string strSite;
string strLocation;
try
{
cboSelectLocation.Items.Clear();
cboSelectLocation.Items.Add("Select Location");
cboSelectLocation.SelectedIndex = 0;
cboSelectSite.Items.Clear();
cboSelectSite.Items.Add("Select Site");
TheFindWarehousesDataSet = TheEmployeeClass.FindWarehouses();
intNumberOfRecords = TheFindWarehousesDataSet.FindWarehouses.Rows.Count;
for (intCounter = 0; intCounter < intNumberOfRecords; intCounter++)
{
cboSelectSite.Items.Add(TheFindWarehousesDataSet.FindWarehouses[intCounter].FirstName);
}
cboSelectSite.SelectedIndex = 0;
TheFindWaspAssetByAssetIDDataSet = TheAssetClass.FindWaspAssetByAssetID(MainWindow.gintAssetID);
txtAssetID.Text = Convert.ToString(MainWindow.gintAssetID);
strSite = TheFindWaspAssetByAssetIDDataSet.FindWaspAssetByAssetID[0].AssetSite;
gstrSite = strSite;
if (strSite == "GROVEPORT")
{
strSite = "CBUS-GROVEPORT";
}
strLocation = TheFindWaspAssetByAssetIDDataSet.FindWaspAssetByAssetID[0].AssetLocation;
intNumberOfRecords = TheFindWarehousesDataSet.FindWarehouses.Rows.Count;
for (intCounter = 0; intCounter < intNumberOfRecords; intCounter++)
{
if (strSite == TheFindWarehousesDataSet.FindWarehouses[intCounter].FirstName)
{
intSelectedIndex = intCounter + 1;
}
}
cboSelectSite.SelectedIndex = intSelectedIndex;
TheFindSortedAssetLocationsBySiteDataSet = TheAssetClass.FindSortedAssetLocationsBySite(gstrSite);
intNumberOfRecords = TheFindSortedAssetLocationsBySiteDataSet.FindSortedWaspAssetLoctionsBySite.Rows.Count;
intSelectedIndex = 0;
if (intNumberOfRecords > 0)
{
for (intCounter = 0; intCounter < intNumberOfRecords; intCounter++)
{
if (strLocation == TheFindSortedAssetLocationsBySiteDataSet.FindSortedWaspAssetLoctionsBySite[intCounter].AssetLocation)
{
intSelectedIndex = intCounter + 1;
}
}
}
cboSelectLocation.SelectedIndex = intSelectedIndex;
}
catch (Exception Ex)
{
TheEventLogClass.InsertEventLogEntry(DateTime.Now, "New Blue Jay ERP // Change Wasp Location // Window Loaded Event " + Ex.Message);
TheMessagesClass.ErrorMessage(Ex.ToString());
}
}
private void ResetControls()
{
//setting local variables
int intCounter;
int intNumberOfRecords;
try
{
txtAssignedProjectID.Text = "";
txtJobNumber.Text = "";
txtRequestDate.Text = Convert.ToString(DateTime.Now);
txtRequestNotes.Text = "";
txtRequiredDate.Text = "";
cboSelectManager.Items.Clear();
cboSelectDepartment.Items.Clear();
cboSelectOffice.Items.Clear();
cboSelectVendor.Items.Clear();
chkRequestPurchase.IsChecked = false;
chkRequestQuote.IsChecked = false;
gintEmployeeID = MainWindow.TheVerifyLogonDataSet.VerifyLogon[0].EmployeeID;
//loading up the combo boxes
TheFindSortedEmployeeManagersDataSet = TheEmployeeClass.FindSortedEmployeeManagers();
intNumberOfRecords = TheFindSortedEmployeeManagersDataSet.FindSortedEmployeeManagers.Rows.Count - 1;
cboSelectManager.Items.Add("Select Manager");
for (intCounter = 0; intCounter <= intNumberOfRecords; intCounter++)
{
cboSelectManager.Items.Add(TheFindSortedEmployeeManagersDataSet.FindSortedEmployeeManagers[intCounter].FullName);
}
cboSelectManager.SelectedIndex = 0;
cboSelectDepartment.Items.Add("Select Department");
TheFindSortedDepartmentDataSet = TheDepartmentClass.FindSortedDepartment();
intNumberOfRecords = TheFindSortedDepartmentDataSet.FindSortedDepartment.Rows.Count - 1;
for (intCounter = 0; intCounter <= intNumberOfRecords; intCounter++)
{
cboSelectDepartment.Items.Add(TheFindSortedDepartmentDataSet.FindSortedDepartment[intCounter].Department);
}
cboSelectDepartment.SelectedIndex = 0;
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;
cboSelectVendor.Items.Add("Select Vendor");
TheFindSortedVendorsDataSet = TheVendorsClass.FindVendorsSortedByVendorName();
intNumberOfRecords = TheFindSortedVendorsDataSet.FindVendorsSortedByVendorName.Rows.Count - 1;
for (intCounter = 0; intCounter <= intNumberOfRecords; intCounter++)
{
cboSelectVendor.Items.Add(TheFindSortedVendorsDataSet.FindVendorsSortedByVendorName[intCounter].VendorName);
}
cboSelectVendor.SelectedIndex = 0;
}
catch (Exception Ex)
{
TheEventLogClass.InsertEventLogEntry(DateTime.Now, "New Blue Jay ERP // Create Purchase Request // Reset Controls " + Ex.Message);
TheMessagesClass.ErrorMessage(Ex.ToString());
}
}
private void ResetControls()
{
//setting up local variables
int intCounter;
int intNumberOfRecords;
bool blnFatalError;
try
{
//clearing the text boxes
txtEnterLastName.Text = "";
txtEmailAddress.Text = "";
txtEmployeeID.Text = "";
txtEndDate.Text = "";
txtFirstName.Text = "";
txtLastName.Text = "";
txtPayID.Text = "";
txtPhoneNumber.Text = "";
txtStartDate.Text = "";
//setting up the combo boxes
cboSelectEmployee.Items.Clear();
cboSelectEmployee.Items.Add("Select Employee");
cboSelectEmployee.SelectedIndex = 0;
//setting up the active combo box
cboActive.Items.Clear();
cboActive.Items.Add("Select Active");
cboActive.Items.Add("Yes");
cboActive.Items.Add("No");
cboActive.SelectedIndex = 0;
//setting up the group combo box
cboGroup.Items.Clear();
cboGroup.Items.Add("Select Group");
TheFindSortedEmployeeGroupDataSet = TheEmployeeClass.FindSortedEmpoyeeGroup();
intNumberOfRecords = TheFindSortedEmployeeGroupDataSet.FindSortedEmployeeGroup.Rows.Count;
for (intCounter = 0; intCounter < intNumberOfRecords; intCounter++)
{
cboGroup.Items.Add(TheFindSortedEmployeeGroupDataSet.FindSortedEmployeeGroup[intCounter].GroupName);
}
cboGroup.SelectedIndex = 0;
//setting ho the home office combo box
cboHomeOffice.Items.Clear();
cboHomeOffice.Items.Add("Select Home Office");
TheFindWarehousesDataSet = TheEmployeeClass.FindWarehouses();
intNumberOfRecords = TheFindWarehousesDataSet.FindWarehouses.Rows.Count;
for (intCounter = 0; intCounter < intNumberOfRecords; intCounter++)
{
cboHomeOffice.Items.Add(TheFindWarehousesDataSet.FindWarehouses[intCounter].FirstName);
}
cboHomeOffice.SelectedIndex = 0;
//setting employee type
cboEmployeeType.Items.Clear();
cboEmployeeType.Items.Add("Select Employee Type");
cboEmployeeType.Items.Add("EMPLOYEE");
cboEmployeeType.Items.Add("CONTRACTOR");
cboEmployeeType.SelectedIndex = 0;
//setting up the salary type
cboSalaryType.Items.Clear();
cboSalaryType.Items.Add("Select Salary Type");
cboSalaryType.Items.Add("EXEMPT");
cboSalaryType.Items.Add("NON-EXEMPT");
cboSalaryType.SelectedIndex = 0;
//setting up the combo box for departments
cboDepartment.Items.Clear();
cboDepartment.Items.Add("Select Department");
TheFindSortedDepartmentDataSet = TheDepartmentClass.FindSortedDepartment();
intNumberOfRecords = TheFindSortedDepartmentDataSet.FindSortedDepartment.Rows.Count;
for (intCounter = 0; intCounter < intNumberOfRecords; intCounter++)
{
cboDepartment.Items.Add(TheFindSortedDepartmentDataSet.FindSortedDepartment[intCounter].Department);
}
cboDepartment.SelectedIndex = 0;
//setting up the managers
cboManager.Items.Clear();
cboManager.Items.Add("Select Managers");
TheFindSortedEmployeeManagersDataSet = TheEmployeeClass.FindSortedEmployeeManagers();
intNumberOfRecords = TheFindSortedEmployeeManagersDataSet.FindSortedEmployeeManagers.Rows.Count;
for (intCounter = 0; intCounter < intNumberOfRecords; intCounter++)
{
cboManager.Items.Add(TheFindSortedEmployeeManagersDataSet.FindSortedEmployeeManagers[intCounter].FullName);
}
cboManager.SelectedIndex = 0;
EnableControls(false);
blnFatalError = TheEmployeeDateEntryClass.InsertIntoEmployeeDateEntry(MainWindow.TheVerifyLogonDataSet.VerifyLogon[0].EmployeeID, "New Blue Jay ERP // Edit Employee");
if (blnFatalError == true)
{
throw new Exception();
}
expIsManager.IsEnabled = false;
}
catch (Exception Ex)
{
TheEventLogClass.InsertEventLogEntry(DateTime.Now, "New Blue Jay ERP // Edit Employee // Reset Control " + Ex.Message);
TheMessagesClass.ErrorMessage(Ex.ToString());
}
}
