private void ResetControls()
{
int intCounter;
int intNumberOfRecords;
string strFullName;
try
{
//clearing text boxes
txtAssignedReelID.Text = "";
txtPartDescription.Text = "";
txtPartNumber.Text = "";
txtPONumber.Text = "";
txtProjectID.Text = "";
txtReelFootage.Text = "";
lblWarehouseSelected.Content = "Select Warehouse";
gblnReelIDChecked = false;
cboSelectEmployee.Items.Clear();
cboSelectEmployee.Items.Add("Select Warehouse Employee");
TheFindEmployeeByDepartmentDataSet = TheEmployeeClass.FindEmployeeByDepartment("WAREHOUSE");
intNumberOfRecords = TheFindEmployeeByDepartmentDataSet.FindEmployeeByDepartment.Rows.Count - 1;
for (intCounter = 0; intCounter <= intNumberOfRecords; intCounter++)
{
strFullName = TheFindEmployeeByDepartmentDataSet.FindEmployeeByDepartment[intCounter].FirstName + " ";
strFullName += TheFindEmployeeByDepartmentDataSet.FindEmployeeByDepartment[intCounter].LastName;
cboSelectEmployee.Items.Add(strFullName);
}
cboSelectEmployee.SelectedIndex = 0;
TheFindPartsWarehousesDataSet = TheEmployeeClass.FindPartsWarehouses();
intNumberOfRecords = TheFindPartsWarehousesDataSet.FindPartsWarehouses.Rows.Count - 1;
cboSelectWarehouse.Items.Clear();
cboSelectWarehouse.Items.Add("Select Warehouse");
for (intCounter = 0; intCounter <= intNumberOfRecords; intCounter++)
{
cboSelectWarehouse.Items.Add(TheFindPartsWarehousesDataSet.FindPartsWarehouses[intCounter].FirstName);
}
cboSelectWarehouse.SelectedIndex = 0;
}
catch (Exception Ex)
{
TheEventLogClass.InsertEventLogEntry(DateTime.Now, "New Blue Jay ERP // Add Cable Reel // Reset Controls " + Ex.Message);
TheMessagesClass.ErrorMessage(Ex.ToString());
}
}
public FindEmployeeByDepartmentDataSet FindEmployeeByDepartment(string strDepartment)
{
try
{
aFindEmployeeByDepartmentDataSet = new FindEmployeeByDepartmentDataSet();
aFindEmployeeByDepartmentTableAdapter = new FindEmployeeByDepartmentDataSetTableAdapters.FindEmployeeByDepartmentTableAdapter();
aFindEmployeeByDepartmentTableAdapter.Fill(aFindEmployeeByDepartmentDataSet.FindEmployeeByDepartment, strDepartment);
}
catch (Exception Ex)
{
TheEventLogClass.InsertEventLogEntry(DateTime.Now, "Employee Class // Find Employee By Department " + Ex.Message);
}
return(aFindEmployeeByDepartmentDataSet);
}
private void Window_Loaded(object sender, RoutedEventArgs e)
{
//setting up to load the combo box
gintProblemID = 0;
int intCounter;
int intNumberOfRecords;
try
{
//HideTextBoxes();
cboMultipleProblems.Items.Add("Select");
cboMultipleProblems.Items.Add("Yes");
cboMultipleProblems.Items.Add("No");
cboMultipleProblems.SelectedIndex = 0;
ExistingOpenProblemsDataSet.openordersRow FirstRow = TheExistingOpenProblemsDataSet.openorders.NewopenordersRow();
FirstRow.ProblemID = -1;
FirstRow.Problem = "NEW WORK ORDER";
TheExistingOpenProblemsDataSet.openorders.Rows.Add(FirstRow);
TheFindOpenVehicleMainProblemsByVehicleIDDataSet = TheVehicleProblemClass.FindOpenVehicleMainProblemsByVehicleID(MainWindow.gintVehicleID);
intNumberOfRecords = TheFindOpenVehicleMainProblemsByVehicleIDDataSet.FindOpenVehicleMainProblemsByVehicleID.Rows.Count - 1;
MainWindow.TheFindSortedEmployeeManagersDataSet = TheEmployeeClass.FindSortedEmployeeManagers();
if (intNumberOfRecords > -1)
{
for (intCounter = 0; intCounter <= intNumberOfRecords; intCounter++)
{
ExistingOpenProblemsDataSet.openordersRow NewOrderRow = TheExistingOpenProblemsDataSet.openorders.NewopenordersRow();
NewOrderRow.Problem = TheFindOpenVehicleMainProblemsByVehicleIDDataSet.FindOpenVehicleMainProblemsByVehicleID[intCounter].Problem;
NewOrderRow.ProblemID = TheFindOpenVehicleMainProblemsByVehicleIDDataSet.FindOpenVehicleMainProblemsByVehicleID[intCounter].ProblemID;
TheExistingOpenProblemsDataSet.openorders.Rows.Add(NewOrderRow);
}
}
cboSelectManager.Items.Add("Select Manager");
intNumberOfRecords = MainWindow.TheFindSortedEmployeeManagersDataSet.FindSortedEmployeeManagers.Rows.Count - 1;
for (intCounter = 0; intCounter <= intNumberOfRecords; intCounter++)
{
string strFirstName = MainWindow.TheFindSortedEmployeeManagersDataSet.FindSortedEmployeeManagers[intCounter].FirstName;
string strLastName = MainWindow.TheFindSortedEmployeeManagersDataSet.FindSortedEmployeeManagers[intCounter].LastName;
cboSelectManager.Items.Add(strFirstName + " " + strLastName);
}
TheFindEmployeeByDepartmentDataSet = TheEmployeeClass.FindEmployeeByDepartment("WAREHOUSE");
cboSelectEmployee.Items.Add("Select Fleet Employee");
intNumberOfRecords = TheFindEmployeeByDepartmentDataSet.FindEmployeeByDepartment.Rows.Count - 1;
for (intCounter = 0; intCounter <= intNumberOfRecords; intCounter++)
{
cboSelectEmployee.Items.Add(TheFindEmployeeByDepartmentDataSet.FindEmployeeByDepartment[intCounter].FirstName + " " + TheFindEmployeeByDepartmentDataSet.FindEmployeeByDepartment[intCounter].LastName);
}
cboSelectEmployee.SelectedIndex = 0;
cboSelectManager.SelectedIndex = 0;
dgrWorkOrders.ItemsSource = TheExistingOpenProblemsDataSet.openorders;
SetReadOnlyControls(false);
}
catch (Exception Ex)
{
TheEventLogClass.InsertEventLogEntry(DateTime.Now, "Blue Jay ERP // Vehicle Inspection Problem // Window Loaded " + Ex.Message);
TheMessagesClass.ErrorMessage(Ex.ToString());
}
}
private void ResetControls()
{
//setting variable
int intCounter;
int intNumberOfRecords;
string strFullName;
try
{
txtComputerName.Text = "";
txtCurrentUpdte.Text = "";
txtExtension.Text = "";
txtTicketUpdates.Text = "";
TheFindOpenHelpDeskTicketsDataSet = TheHelpDeskClass.FindOpenHelpDeskTickets();
TheOpenHelpDeskTicketsDataSet.openhelpdesktickets.Rows.Clear();
intNumberOfRecords = TheFindOpenHelpDeskTicketsAssignedDataSet.FindOpenHelpDeskTicketsAssgined.Rows.Count;
for (intCounter = 0; intCounter < intNumberOfRecords; intCounter++)
{
OpenHelpDeskTicketsDataSet.openhelpdeskticketsRow NewTicketRow = TheOpenHelpDeskTicketsDataSet.openhelpdesktickets.NewopenhelpdeskticketsRow();
NewTicketRow.FirstName = TheFindOpenHelpDeskTicketsAssignedDataSet.FindOpenHelpDeskTicketsAssgined[intCounter].FirstName;
NewTicketRow.LastName = TheFindOpenHelpDeskTicketsAssignedDataSet.FindOpenHelpDeskTicketsAssgined[intCounter].LastName;
NewTicketRow.ReportedProblem = TheFindOpenHelpDeskTicketsAssignedDataSet.FindOpenHelpDeskTicketsAssgined[intCounter].ReportedProblem;
NewTicketRow.TicketDate = TheFindOpenHelpDeskTicketsAssignedDataSet.FindOpenHelpDeskTicketsAssgined[intCounter].TicketDate;
NewTicketRow.TicketID = TheFindOpenHelpDeskTicketsAssignedDataSet.FindOpenHelpDeskTicketsAssgined[intCounter].TicketID;
TheOpenHelpDeskTicketsDataSet.openhelpdesktickets.Rows.Add(NewTicketRow);
}
dgrOpenTickets.ItemsSource = TheFindOpenHelpDeskTicketsDataSet.FindOpenHelpDeskTickets;
TheFindSortedHelpDeskProblemTypeDataSet = TheHelpDeskClass.FindSortedHelpDeskProblemType();
intNumberOfRecords = TheFindSortedHelpDeskProblemTypeDataSet.FindSortedHelpDeskProblemType.Rows.Count;
cboProblemType.Items.Clear();
cboProblemType.Items.Add("Select Problem Type");
for (intCounter = 0; intCounter < intNumberOfRecords; intCounter++)
{
cboProblemType.Items.Add(TheFindSortedHelpDeskProblemTypeDataSet.FindSortedHelpDeskProblemType[intCounter].ProblemType);
}
cboProblemType.SelectedIndex = 0;
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;
TheFindEmployeeByDepartmentDataSet = TheEmployeeClass.FindEmployeeByDepartment("INFORMATION TECHNOLOGY");
cboSelectEmployee.Items.Clear();
cboSelectEmployee.Items.Add("Select Employee");
intNumberOfRecords = TheFindEmployeeByDepartmentDataSet.FindEmployeeByDepartment.Rows.Count;
for (intCounter = 0; intCounter < intNumberOfRecords; intCounter++)
{
strFullName = TheFindEmployeeByDepartmentDataSet.FindEmployeeByDepartment[intCounter].FirstName + " ";
strFullName += TheFindEmployeeByDepartmentDataSet.FindEmployeeByDepartment[intCounter].LastName;
cboSelectEmployee.Items.Add(strFullName);
}
cboSelectEmployee.SelectedIndex = 0;
TheEmployeeDateEntryClass.InsertIntoEmployeeDateEntry(MainWindow.TheVerifyLogonDataSet.VerifyLogon[0].EmployeeID, "New Blue Jay ERP // Update Help Desk Tickets");
}
catch (Exception Ex)
{
TheEventLogClass.InsertEventLogEntry(DateTime.Now, "New Blue Jay ERP // Update Help Desk Tickets // Reset Controls " + Ex.Message);
TheMessagesClass.ErrorMessage(Ex.ToString());
}
}
private void Window_Loaded(object sender, RoutedEventArgs e)
{
int intCounter;
int intNumberOfRecords;
string strFullName;
try
{
//setting up the controls
cboNewProblem.Items.Add("Select New Problems");
cboNewProblem.Items.Add("Yes");
cboNewProblem.Items.Add("No");
cboNewProblem.SelectedIndex = 0;
cboMultipleProblems.Items.Add("Select Multiple Problems");
cboMultipleProblems.Items.Add("Yes");
cboMultipleProblems.Items.Add("No");
cboMultipleProblems.SelectedIndex = 0;
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;
TheFindEmployeeByDepartmentDataSet = TheEmployeeClass.FindEmployeeByDepartment("WAREHOUSE");
intNumberOfRecords = TheFindEmployeeByDepartmentDataSet.FindEmployeeByDepartment.Rows.Count - 1;
cboSelectFleetEmployee.Items.Add("Select Fleet Employee");
for (intCounter = 0; intCounter <= intNumberOfRecords; intCounter++)
{
strFullName = TheFindEmployeeByDepartmentDataSet.FindEmployeeByDepartment[intCounter].FirstName + " ";
strFullName += TheFindEmployeeByDepartmentDataSet.FindEmployeeByDepartment[intCounter].LastName;
cboSelectFleetEmployee.Items.Add(strFullName);
}
cboSelectFleetEmployee.SelectedIndex = 0;
TheFindOpenVehicleMainProblemsByVehicleIDDataSet = TheVehicleProblemClass.FindOpenVehicleMainProblemsByVehicleID(MainWindow.gintVehicleID);
intNumberOfRecords = TheFindOpenVehicleMainProblemsByVehicleIDDataSet.FindOpenVehicleMainProblemsByVehicleID.Rows.Count - 1;
if (intNumberOfRecords > -1)
{
for (intCounter = 0; intCounter <= intNumberOfRecords; intCounter++)
{
ExistingOpenProblemsDataSet.openproblemsRow NewProblemRow = TheExistingOpenProblemsDataSet.openproblems.NewopenproblemsRow();
NewProblemRow.Problem = TheFindOpenVehicleMainProblemsByVehicleIDDataSet.FindOpenVehicleMainProblemsByVehicleID[intCounter].Problem;
NewProblemRow.ProblemID = TheFindOpenVehicleMainProblemsByVehicleIDDataSet.FindOpenVehicleMainProblemsByVehicleID[intCounter].ProblemID;
TheExistingOpenProblemsDataSet.openproblems.Rows.Add(NewProblemRow);
}
}
dgrWorkOrders.ItemsSource = TheExistingOpenProblemsDataSet.openproblems;
}
catch (Exception Ex)
{
TheEventLogClass.InsertEventLogEntry(DateTime.Now, "Daily Vehicle Data Entry // Vehicle Inspection Problem // Window Loaded " + Ex.Message);
TheMessagesClass.ErrorMessage(Ex.ToString());
}
}
