private void LoadTrailerInformation() { int intOfficeID; try { txtFirstName.Text = TheFindActiveTrailerByTrailerNumberDataSet.FindActiveTrailerByTrailerNumber[0].FirstName; txtLastName.Text = TheFindActiveTrailerByTrailerNumberDataSet.FindActiveTrailerByTrailerNumber[0].LastName; txtLicensePlate.Text = TheFindActiveTrailerByTrailerNumberDataSet.FindActiveTrailerByTrailerNumber[0].LicensePlate; intOfficeID = TheFindActiveTrailerByTrailerNumberDataSet.FindActiveTrailerByTrailerNumber[0].LocationID; MainWindow.gintTrailerID = TheFindActiveTrailerByTrailerNumberDataSet.FindActiveTrailerByTrailerNumber[0].TrailerID; //getting the location TheFindEmployeeByEmployeeIDDataSet = TheEmployeeClass.FindEmployeeByEmployeeID(intOfficeID); txtTrailerLocation.Text = TheFindActiveTrailerByTrailerNumberDataSet.FindActiveTrailerByTrailerNumber[0].FirstName; txtTrailerDescription.Text = TheFindActiveTrailerByTrailerNumberDataSet.FindActiveTrailerByTrailerNumber[0].TrailerDescription; txtTrailerNotes.Text = TheFindActiveTrailerByTrailerNumberDataSet.FindActiveTrailerByTrailerNumber[0].TrailerNotes; } catch (Exception Ex) { TheEventLogClass.InsertEventLogEntry(DateTime.Now, "Blue Jay ERP // Create Trailer Problem // Load Trailer Information " + Ex.Message); TheMessagesClass.ErrorMessage(Ex.ToString()); } }
private void expCreateNewEmployee_Expanded(object sender, RoutedEventArgs e) { //setting local variables int intRecordsReturned; bool blnEmployeeExists = true; while (blnEmployeeExists == true) { MainWindow.gintEmployeeID = TheEmployeeClass.CreateEmployeeID(); TheFindEmployeeByEmployeeIDDataSet = TheEmployeeClass.FindEmployeeByEmployeeID(MainWindow.gintEmployeeID); intRecordsReturned = TheFindEmployeeByEmployeeIDDataSet.FindEmployeeByEmployeeID.Rows.Count; if (intRecordsReturned > 0) { blnEmployeeExists = true; } else if (intRecordsReturned < 1) { blnEmployeeExists = false; } } EnableControls(true); txtEmployeeID.Text = Convert.ToString(MainWindow.gintEmployeeID); }
private void cboSelectEmployee_SelectionChanged(object sender, SelectionChangedEventArgs e) { int intSelectedIndex; try { intSelectedIndex = cboSelectEmployee.SelectedIndex - 1; if (intSelectedIndex > -1) { MainWindow.gintEmployeeID = TheComboEmployeeDataSet.employees[intSelectedIndex].EmployeeID; TheFindEmployeeByEmployeeIDDataSet = TheEmployeeClass.FindEmployeeByEmployeeID(MainWindow.gintEmployeeID); if (TheFindEmployeeByEmployeeIDDataSet.FindEmployeeByEmployeeID[0].IsEmailAddressNull() == true) { txtEmailAddress.Text = ""; } else { txtEmailAddress.Text = TheFindEmployeeByEmployeeIDDataSet.FindEmployeeByEmployeeID[0].EmailAddress; } } } catch (Exception Ex) { TheEventLogClass.InsertEventLogEntry(DateTime.Now, "New Blue Jay ERP // Add Employee To Vehicle Emails // Select Employee Combobox " + Ex.Message); TheSendEmailClass.SendEventLog(Ex.ToString()); TheMessagesClass.ErrorMessage(Ex.ToString()); } }
private void Window_Loaded(object sender, RoutedEventArgs e) { int intEmployeeID; try { TheFindAlohaTimePunchesByTransactionIDDataSet = TheEmployeePunchedHoursClass.FindAlohaTimePunchesByTransactionID(MainWindow.gintTransactionID); intEmployeeID = TheFindAlohaTimePunchesByTransactionIDDataSet.FindAlohaTimePunchesByTransactionID[0].EmployeeID; TheFindEmployeeByEmployeeIDDataSet = TheEmployeeClass.FindEmployeeByEmployeeID(intEmployeeID); txtEmployeeID.Text = Convert.ToString(intEmployeeID); txtEndDate.Text = Convert.ToString(TheFindAlohaTimePunchesByTransactionIDDataSet.FindAlohaTimePunchesByTransactionID[0].EndDate); txtFirstName.Text = TheFindEmployeeByEmployeeIDDataSet.FindEmployeeByEmployeeID[0].FirstName; txtHours.Text = Convert.ToString(TheFindAlohaTimePunchesByTransactionIDDataSet.FindAlohaTimePunchesByTransactionID[0].DailyHours); txtLastName.Text = TheFindEmployeeByEmployeeIDDataSet.FindEmployeeByEmployeeID[0].LastName; txtStartDate.Text = Convert.ToString(TheFindAlohaTimePunchesByTransactionIDDataSet.FindAlohaTimePunchesByTransactionID[0].StartDate); txtTransactionID.Text = Convert.ToString(MainWindow.gintTransactionID); } catch (Exception Ex) { TheEventLogClass.InsertEventLogEntry(DateTime.Now, "New Blue Jay ERP // Change Aloha Times // Window Loaded " + Ex.Message); TheMessagesClass.ErrorMessage(Ex.ToString()); } }
private void chkDailyTrailerInspection_Checked(object sender, RoutedEventArgs e) { //setting local variables string strValueForValidation; bool blnFatalError; int intRecordsReturned; string strEmployeeGroup; strValueForValidation = txtEnterID.Text; blnFatalError = TheDataValidationClass.VerifyIntegerData(strValueForValidation); if (blnFatalError == true) { if (gblnRecordSaved == false) { TheMessagesClass.ErrorMessage("The Employee ID is not an Integer"); gblnRecordSaved = false; chkDailyTrailerInspection.IsChecked = false; return; } } else { gintWarehouseEmployeeID = Convert.ToInt32(strValueForValidation); TheFindEmployeeByEmployeeIDDataSet = TheEmployeeClass.FindEmployeeByEmployeeID(gintWarehouseEmployeeID); intRecordsReturned = TheFindEmployeeByEmployeeIDDataSet.FindEmployeeByEmployeeID.Rows.Count; if (intRecordsReturned < 1) { TheMessagesClass.ErrorMessage("Employee Not Found"); chkDailyTrailerInspection.IsChecked = false; return; } else { strEmployeeGroup = TheFindEmployeeByEmployeeIDDataSet.FindEmployeeByEmployeeID[0].EmployeeGroup; if (strEmployeeGroup != "WAREHOUSE") { if (strEmployeeGroup != "ADMIN") { if (strEmployeeGroup != "MANAGERS") { TheMessagesClass.ErrorMessage("This is not a Warehouse Employee, Please Use the Full ERP"); chkDailyTrailerInspection.IsChecked = false; return; } } } } } chkAssignVehicle.IsChecked = false; chkDailyVehicleInspection.IsChecked = false; txtTrailerNumber.IsEnabled = true; gblnDailyTrailerInspection = true; txtVehicleNumber.IsEnabled = false; }
private void LoadGrid() { int intEmployeeCounter; int intEmployeeNumberOfRecords; int intToolCounter; int intToolNumberOfRecords; int intEmployeeID; int intCurrentLocation; try { TheCurrentToolsDataSet.currenttools.Rows.Clear(); TheFindDeactivatedEmployeesDataSet = TheEmployeeClass.FindDeactivatedEmployees(); intEmployeeNumberOfRecords = TheFindDeactivatedEmployeesDataSet.FindDeactivatedEmployees.Rows.Count - 1; for (intEmployeeCounter = 0; intEmployeeCounter <= intEmployeeNumberOfRecords; intEmployeeCounter++) { intEmployeeID = TheFindDeactivatedEmployeesDataSet.FindDeactivatedEmployees[intEmployeeCounter].EmployeeID; TheFindToolsByEmployeeIDDataSet = TheToolsClass.FindToolsByEmployeeID(intEmployeeID); intToolNumberOfRecords = TheFindToolsByEmployeeIDDataSet.FindToolsByEmployeeID.Rows.Count - 1; if (intToolNumberOfRecords > -1) { for (intToolCounter = 0; intToolCounter <= intToolNumberOfRecords; intToolCounter++) { intCurrentLocation = TheFindToolsByEmployeeIDDataSet.FindToolsByEmployeeID[intToolCounter].CurrentLocation; TheFindEmployeeByEmployeeIDDataSet = TheEmployeeClass.FindEmployeeByEmployeeID(intCurrentLocation); CurrentToolsDataSet.currenttoolsRow NewToolRow = TheCurrentToolsDataSet.currenttools.NewcurrenttoolsRow(); NewToolRow.AssignedOffice = TheFindEmployeeByEmployeeIDDataSet.FindEmployeeByEmployeeID[0].FirstName; NewToolRow.FirstName = TheFindDeactivatedEmployeesDataSet.FindDeactivatedEmployees[intEmployeeCounter].FirstName; NewToolRow.LastName = TheFindDeactivatedEmployeesDataSet.FindDeactivatedEmployees[intEmployeeCounter].LastName; NewToolRow.ToolID = TheFindToolsByEmployeeIDDataSet.FindToolsByEmployeeID[intToolCounter].ToolID; NewToolRow.Description = TheFindToolsByEmployeeIDDataSet.FindToolsByEmployeeID[intToolCounter].ToolDescription; NewToolRow.TransactionDate = TheFindToolsByEmployeeIDDataSet.FindToolsByEmployeeID[intToolCounter].TransactionDate; TheCurrentToolsDataSet.currenttools.Rows.Add(NewToolRow); } } } dgrTools.ItemsSource = TheCurrentToolsDataSet.currenttools; } catch (Exception Ex) { TheEventLogClass.InsertEventLogEntry(DateTime.Now, "Blue Jay ERP // Deactivate Employee Tools // Load Grid " + Ex.Message); TheMessagesClass.ErrorMessage(Ex.ToString()); } }
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()); } }
private void cboSelectCategory_SelectionChanged(object sender, SelectionChangedEventArgs e) { int intSelectedIndex; string strCategory; int intCounter; int intNumberOfRecords; int intCurrentLocation; try { intSelectedIndex = cboSelectCategory.SelectedIndex - 1; if (intSelectedIndex > -1) { strCategory = TheFindSortedToolCategoryDataSet.FindSortedToolCategory[intSelectedIndex].ToolCategory; TheCurrentToolsDataSet.currenttools.Rows.Clear(); TheFindToolsByCategoryDataSet = TheToolsClass.FindToolsByCategory(strCategory); intNumberOfRecords = TheFindToolsByCategoryDataSet.FindToolsByCategory.Rows.Count - 1; for (intCounter = 0; intCounter <= intNumberOfRecords; intCounter++) { intCurrentLocation = TheFindToolsByCategoryDataSet.FindToolsByCategory[intCounter].CurrentLocation; TheFindEmployeeByEmployeeIDDataSet = TheEmployeeClass.FindEmployeeByEmployeeID(intCurrentLocation); CurrentToolsDataSet.currenttoolsRow NewToolRow = TheCurrentToolsDataSet.currenttools.NewcurrenttoolsRow(); NewToolRow.AssignedOffice = TheFindEmployeeByEmployeeIDDataSet.FindEmployeeByEmployeeID[0].FirstName; NewToolRow.Description = TheFindToolsByCategoryDataSet.FindToolsByCategory[intCounter].ToolDescription; NewToolRow.FirstName = TheFindToolsByCategoryDataSet.FindToolsByCategory[intCounter].FirstName; NewToolRow.LastName = TheFindToolsByCategoryDataSet.FindToolsByCategory[intCounter].LastName; NewToolRow.ToolID = TheFindToolsByCategoryDataSet.FindToolsByCategory[intCounter].ToolID; NewToolRow.TransactionDate = TheFindToolsByCategoryDataSet.FindToolsByCategory[intCounter].TransactionDate; TheCurrentToolsDataSet.currenttools.Rows.Add(NewToolRow); } dgrTools.ItemsSource = TheCurrentToolsDataSet.currenttools; } } catch (Exception Ex) { TheEventLogClass.InsertEventLogEntry(DateTime.Now, "Blue Jay ERP // Current Tool Location // Combo Box Selectiong " + Ex.Message); TheMessagesClass.ErrorMessage(Ex.ToString()); } }
public FindEmployeeByEmployeeIDDataSet FindEmployeeByEmployeeID(int intEmployeeID) { try { aFindEmployeeByEmployeeIDDataSet = new FindEmployeeByEmployeeIDDataSet(); aFindEmployeeByEmployeeIDTableAdapter = new FindEmployeeByEmployeeIDDataSetTableAdapters.FindEmployeeByEmployeeIDTableAdapter(); aFindEmployeeByEmployeeIDTableAdapter.Fill(aFindEmployeeByEmployeeIDDataSet.FindEmployeeByEmployeeID, intEmployeeID); } catch (Exception Ex) { TheEventLogClass.InsertEventLogEntry(DateTime.Now, "New Employee DLL // Verify Employee // " + Ex.Message); } return(aFindEmployeeByEmployeeIDDataSet); }
private void Window_Loaded(object sender, RoutedEventArgs e) { //setting local variables int intCounter; int intNumberOfRecords; decimal decInvoiceTotal = 0; try { TheFindEmployeeByEmployeeIDDataSet = TheEmployeeClass.FindEmployeeByEmployeeID(MainWindow.gintWarehouseID); txtBillingLocation.Text = TheFindEmployeeByEmployeeIDDataSet.FindEmployeeByEmployeeID[0].FirstName; if (txtBillingLocation.Text == "CLEVELAND") { dgrResults.ItemsSource = MainWindow.TheClevelandDesignProjectInvoicingDataSet.clevelanddesigninvoice; intNumberOfRecords = MainWindow.TheClevelandDesignProjectInvoicingDataSet.clevelanddesigninvoice.Rows.Count - 1; for (intCounter = 0; intCounter <= intNumberOfRecords; intCounter++) { decInvoiceTotal += MainWindow.TheClevelandDesignProjectInvoicingDataSet.clevelanddesigninvoice[intCounter].TotalProjectCharge; } } else if (txtBillingLocation.Text == "MILWAUKEE") { dgrResults.ItemsSource = MainWindow.TheWisconsinDesignProjectInvoicingDataSet.wisconsindesigninvoice; intNumberOfRecords = MainWindow.TheWisconsinDesignProjectInvoicingDataSet.wisconsindesigninvoice.Rows.Count - 1; for (intCounter = 0; intCounter <= intNumberOfRecords; intCounter++) { decInvoiceTotal += MainWindow.TheWisconsinDesignProjectInvoicingDataSet.wisconsindesigninvoice[intCounter].ProjectTotal; } } TheFindWOVBillingCodesByBillingIDDataSet = TheWOVInvoicingClass.FindWOVBillingCodesByBillingID(MainWindow.gintBillingID); txtBillingType.Text = TheFindWOVBillingCodesByBillingIDDataSet.FindWOVBillingCodesByBillingID[0].BillingCode; txtInvoicedAmount.Text = Convert.ToString(decInvoiceTotal); } catch (Exception Ex) { TheEventLogClass.InsertEventLogEntry(DateTime.Now, "Blue Jay ERP // Process Design Invoice // Window Loaded " + Ex.Message); TheMessagesClass.ErrorMessage(Ex.ToString()); } }
private void ResetControls() { DateTime datTransactionDate = DateTime.Now; int intCounter; int intNumberOfRecords; int intWarehouseID; try { datTransactionDate = TheDateSearchClass.AddingDays(datTransactionDate, 3); TheOverdueProjectReportDataSet.overdueprojectreport.Rows.Clear(); TheFindOverDueProductionProjectsDataSet = TheProductionProjectClass.FindOverdueProductionProjects(datTransactionDate); intNumberOfRecords = TheFindOverDueProductionProjectsDataSet.FindOverdueOpenProductionProjects.Rows.Count; if (intNumberOfRecords > 0) { for (intCounter = 0; intCounter < intNumberOfRecords; intCounter++) { intWarehouseID = TheFindOverDueProductionProjectsDataSet.FindOverdueOpenProductionProjects[intCounter].AssignedOfficeID; TheFindEmployeeByEmployeeIDDataSet = TheEmployeeClass.FindEmployeeByEmployeeID(intWarehouseID); OverdueProjectReportDataSet.overdueprojectreportRow NewProjectRow = TheOverdueProjectReportDataSet.overdueprojectreport.NewoverdueprojectreportRow(); NewProjectRow.AssignedOffice = TheFindEmployeeByEmployeeIDDataSet.FindEmployeeByEmployeeID[0].FirstName; NewProjectRow.AssignedProjectID = TheFindOverDueProductionProjectsDataSet.FindOverdueOpenProductionProjects[intCounter].AssignedProjectID; NewProjectRow.Customer = TheFindOverDueProductionProjectsDataSet.FindOverdueOpenProductionProjects[intCounter].Customer; NewProjectRow.CustomerAssignedID = TheFindOverDueProductionProjectsDataSet.FindOverdueOpenProductionProjects[intCounter].CustomerAssignedID; NewProjectRow.DateReceived = TheFindOverDueProductionProjectsDataSet.FindOverdueOpenProductionProjects[intCounter].DateReceived; NewProjectRow.ECDDate = TheFindOverDueProductionProjectsDataSet.FindOverdueOpenProductionProjects[intCounter].ECDDate; NewProjectRow.ProjectName = TheFindOverDueProductionProjectsDataSet.FindOverdueOpenProductionProjects[intCounter].ProjectName; NewProjectRow.Status = TheFindOverDueProductionProjectsDataSet.FindOverdueOpenProductionProjects[intCounter].WorkOrderStatus; TheOverdueProjectReportDataSet.overdueprojectreport.Rows.Add(NewProjectRow); } } dgrOverdueProjects.ItemsSource = TheOverdueProjectReportDataSet.overdueprojectreport; } catch (Exception Ex) { TheEventLogClass.InsertEventLogEntry(DateTime.Now, "New Blue Jay ERP // Overdue Project Report // Reset Controls " + Ex.Message); TheMessagesClass.ErrorMessage(Ex.ToString()); } }
private void LoadGrid() { int intCounter; int intNumberOfRecords; int intLocationID; try { TheTrailerRosterDataSet.trailerroster.Rows.Clear(); TheFindActiveSortedTrailersDataSet = TheTrailersClass.FindActiveSortedTrailers(); intNumberOfRecords = TheFindActiveSortedTrailersDataSet.FindActiveSortedTrailers.Rows.Count - 1; for (intCounter = 0; intCounter <= intNumberOfRecords; intCounter++) { intLocationID = TheFindActiveSortedTrailersDataSet.FindActiveSortedTrailers[intCounter].LocationID; TheFindEmployeeByEmployeeIDDataSet = TheEmployeeClass.FindEmployeeByEmployeeID(intLocationID); TrailerRosterDataSet.trailerrosterRow NewTrailerRow = TheTrailerRosterDataSet.trailerroster.NewtrailerrosterRow(); NewTrailerRow.AssignedOffice = TheFindEmployeeByEmployeeIDDataSet.FindEmployeeByEmployeeID[0].FirstName; NewTrailerRow.LastName = TheFindActiveSortedTrailersDataSet.FindActiveSortedTrailers[intCounter].LastName; NewTrailerRow.FirstName = TheFindActiveSortedTrailersDataSet.FindActiveSortedTrailers[intCounter].FirstName; NewTrailerRow.LicensePlate = TheFindActiveSortedTrailersDataSet.FindActiveSortedTrailers[intCounter].LicensePlate; NewTrailerRow.Notes = TheFindActiveSortedTrailersDataSet.FindActiveSortedTrailers[intCounter].TrailerNotes; NewTrailerRow.TrailerDescription = TheFindActiveSortedTrailersDataSet.FindActiveSortedTrailers[intCounter].TrailerDescription; NewTrailerRow.TrailerID = TheFindActiveSortedTrailersDataSet.FindActiveSortedTrailers[intCounter].TrailerID; NewTrailerRow.TrailerNumber = TheFindActiveSortedTrailersDataSet.FindActiveSortedTrailers[intCounter].TrailerNumber; NewTrailerRow.TrailerType = TheFindActiveSortedTrailersDataSet.FindActiveSortedTrailers[intCounter].TrailerCategory; NewTrailerRow.VINNumber = TheFindActiveSortedTrailersDataSet.FindActiveSortedTrailers[intCounter].VINNumber; TheTrailerRosterDataSet.trailerroster.Rows.Add(NewTrailerRow); } dgrResults.ItemsSource = TheTrailerRosterDataSet.trailerroster; } catch (Exception Ex) { TheEventLogClass.InsertEventLogEntry(DateTime.Now, "Blue Jay ERP // Trailer Roster // Load Grid " + Ex.Message); TheMessagesClass.ErrorMessage(Ex.ToString()); } }
private void cboSelectEmployee_SelectionChanged(object sender, SelectionChangedEventArgs e) { int intSelectedIndex; try { intSelectedIndex = cboSelectEmployee.SelectedIndex - 1; btnResetTask.IsEnabled = false; btnResetEmployees.IsEnabled = true; if (intSelectedIndex > -1) { MainWindow.gstrFirstName = TheFindEmployeeByLastNameEndDateDataSet.FindEmployeesByLastNameEndDate[intSelectedIndex].FirstName; MainWindow.gstrLastName = TheFindEmployeeByLastNameEndDateDataSet.FindEmployeesByLastNameEndDate[intSelectedIndex].LastName; MainWindow.gintEmployeeID = TheFindEmployeeByLastNameEndDateDataSet.FindEmployeesByLastNameEndDate[intSelectedIndex].EmployeeID; TheFindEmployeeByEmployeeIDDataSet = TheEmployeeClass.FindEmployeeByEmployeeID(MainWindow.gintEmployeeID); if (TheFindEmployeeByEmployeeIDDataSet.FindEmployeeByEmployeeID[0].EmployeeType == "CONTRACTOR") { TheMessagesClass.ErrorMessage("You Have Selected a Contractor, Please Select Again"); cboSelectEmployee.SelectedIndex = 0; txtEnterLastName.Focus(); return; } btnAddEmployee.IsEnabled = true; if (gblnCrewIDSet == false) { gstrCrewID = MainWindow.gstrLastName; gblnCrewIDSet = true; } } } catch (Exception Ex) { TheEventLogClass.InsertEventLogEntry(DateTime.Now, "New Blue Jay ERP // Add Project Labor // cboSelectEmployee Event" + Ex.Message); TheSendEmailClass.SendEventLog("New Blue Jay ERP // Add Project Labor // cboSelectEmployee Event" + Ex.ToString()); TheMessagesClass.ErrorMessage(Ex.ToString()); } }
private void expVehiclesInYard_Expanded(object sender, RoutedEventArgs e) { //loading Vehicles In Yard //setting local variables string strValueForValidation; bool blnFatalError = false; int intRecordsReturned; try { strValueForValidation = txtEnterID.Text; blnFatalError = TheDataValidationClass.VerifyIntegerData(strValueForValidation); if (blnFatalError == true) { TheMessagesClass.ErrorMessage("The Employee ID is not an Integer"); return; } gintWarehouseEmployeeID = Convert.ToInt32(strValueForValidation); TheFindEmployeeByEmployeeIDDataSet = TheEmployeeClass.FindEmployeeByEmployeeID(gintWarehouseEmployeeID); intRecordsReturned = TheFindEmployeeByEmployeeIDDataSet.FindEmployeeByEmployeeID.Rows.Count; if (intRecordsReturned < 1) { TheMessagesClass.ErrorMessage("Employee Was Not Found"); return; } VehiclesInYard VehiclesInYard = new VehiclesInYard(); VehiclesInYard.ShowDialog(); } catch (Exception Ex) { TheEventLogClass.InsertEventLogEntry(DateTime.Now, "Daily Vehicle Data Entry // Main Window // Vehicles In Yard Expander " + Ex.Message); TheMessagesClass.ErrorMessage(Ex.ToString()); } }
private void LoadDataSet() { int intCounter; int intNumberOfRecords; int intManagerID; try { TheEmployeeRosterDataSet.employees.Rows.Clear(); TheFindActiveEmployeesDataSet = TheEmployeeClass.FindActiveEmployees(); intNumberOfRecords = TheFindActiveEmployeesDataSet.FindActiveEmployees.Rows.Count - 1; for (intCounter = 0; intCounter <= intNumberOfRecords; intCounter++) { intManagerID = TheFindActiveEmployeesDataSet.FindActiveEmployees[intCounter].ManagerID; TheFindEmployeeByEmployeeIDDataSet = TheEmployeeClass.FindEmployeeByEmployeeID(intManagerID); EmployeeRosterDataSet.employeesRow NewEmployeeRow = TheEmployeeRosterDataSet.employees.NewemployeesRow(); NewEmployeeRow.Department = TheFindActiveEmployeesDataSet.FindActiveEmployees[intCounter].Department; NewEmployeeRow.FirstName = TheFindActiveEmployeesDataSet.FindActiveEmployees[intCounter].FirstName; NewEmployeeRow.HomeOffice = TheFindActiveEmployeesDataSet.FindActiveEmployees[intCounter].HomeOffice; NewEmployeeRow.LastName = TheFindActiveEmployeesDataSet.FindActiveEmployees[intCounter].LastName; NewEmployeeRow.ManagerFirstName = TheFindEmployeeByEmployeeIDDataSet.FindEmployeeByEmployeeID[0].FirstName; NewEmployeeRow.ManagerLastName = TheFindEmployeeByEmployeeIDDataSet.FindEmployeeByEmployeeID[0].LastName; TheEmployeeRosterDataSet.employees.Rows.Add(NewEmployeeRow); } dgrResults.ItemsSource = TheEmployeeRosterDataSet.employees; } catch (Exception Ex) { TheEventLogClass.InsertEventLogEntry(DateTime.Now, "Blue Jay ERP // Employee Roster // Employee Roster Load Data Set " + Ex.Message); TheMessagesClass.ErrorMessage(Ex.ToString()); } }
private void Window_Loaded(object sender, RoutedEventArgs e) { try { TheFindEmployeeByEmployeeIDDataSet = TheEmployeeClass.FindEmployeeByEmployeeID(MainWindow.gintEmployeeID); txtEmployeeID.Text = Convert.ToString(TheFindEmployeeByEmployeeIDDataSet.FindEmployeeByEmployeeID[0].EmployeeID); txtFirstName.Text = TheFindEmployeeByEmployeeIDDataSet.FindEmployeeByEmployeeID[0].FirstName; txtLastName.Text = TheFindEmployeeByEmployeeIDDataSet.FindEmployeeByEmployeeID[0].LastName; txtPayID.Text = Convert.ToString(TheFindEmployeeByEmployeeIDDataSet.FindEmployeeByEmployeeID[0].PayID); btnProcess.IsEnabled = false; } catch (Exception Ex) { TheEventLogClass.InsertEventLogEntry(DateTime.Now, "New Blue Jay ERP // Add Ahola Punch // Window Loaded " + Ex.Message); TheSendEmailClass.SendEventLog(Ex.ToString()); TheMessagesClass.ErrorMessage(Ex.ToString()); } }
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()); } }
private void cboSelectEmployee_SelectionChanged(object sender, SelectionChangedEventArgs e) { int intSelectedIndex; int intEmployeeID; int intManagerID; string strManagerName; try { intSelectedIndex = cboSelectEmployee.SelectedIndex - 1; if (intSelectedIndex > -1) { intEmployeeID = TheFindAllEmployeesByLastNameDataSet.FindAllEmployeeByLastName[intSelectedIndex].EmployeeID; TheFindEmployeeByEmployeeIDDataSet = TheEmployeeClass.FindEmployeeByEmployeeID(intEmployeeID); txtFirstName.Text = TheFindEmployeeByEmployeeIDDataSet.FindEmployeeByEmployeeID[0].FirstName; txtLastName.Text = TheFindEmployeeByEmployeeIDDataSet.FindEmployeeByEmployeeID[0].LastName; txtPhoneNumber.Text = TheFindEmployeeByEmployeeIDDataSet.FindEmployeeByEmployeeID[0].PhoneNumber; if (TheFindEmployeeByEmployeeIDDataSet.FindEmployeeByEmployeeID[0].IsEmailAddressNull() == true) { txtEmail.Text = ""; } else { txtEmail.Text = TheFindEmployeeByEmployeeIDDataSet.FindEmployeeByEmployeeID[0].EmailAddress; } txtHomeOffice.Text = TheFindEmployeeByEmployeeIDDataSet.FindEmployeeByEmployeeID[0].HomeOffice; if (TheFindEmployeeByEmployeeIDDataSet.FindEmployeeByEmployeeID[0].IsDepartmentNull() == true) { txtDepartment.Text = ""; } else { txtDepartment.Text = TheFindEmployeeByEmployeeIDDataSet.FindEmployeeByEmployeeID[0].Department; } if (TheFindEmployeeByEmployeeIDDataSet.FindEmployeeByEmployeeID[0].IsStartDateNull() == true) { txtStartDate.Text = ""; } else { txtStartDate.Text = Convert.ToString(TheFindEmployeeByEmployeeIDDataSet.FindEmployeeByEmployeeID[0].StartDate); } if (TheFindEmployeeByEmployeeIDDataSet.FindEmployeeByEmployeeID[0].Active == true) { txtActive.Text = "YES"; } else { txtActive.Text = "NO"; } if (TheFindEmployeeByEmployeeIDDataSet.FindEmployeeByEmployeeID[0].IsManagerIDNull() == false) { intManagerID = TheFindEmployeeByEmployeeIDDataSet.FindEmployeeByEmployeeID[0].ManagerID; TheFindEmployeeByEmployeeIDDataSet = TheEmployeeClass.FindEmployeeByEmployeeID(intManagerID); strManagerName = TheFindEmployeeByEmployeeIDDataSet.FindEmployeeByEmployeeID[0].FirstName + " "; strManagerName += TheFindEmployeeByEmployeeIDDataSet.FindEmployeeByEmployeeID[0].LastName; txtManager.Text = strManagerName; txtManagerEmail.Text = TheFindEmployeeByEmployeeIDDataSet.FindEmployeeByEmployeeID[0].EmailAddress; txtManagerOffice.Text = TheFindEmployeeByEmployeeIDDataSet.FindEmployeeByEmployeeID[0].HomeOffice; txtManagerPhone.Text = TheFindEmployeeByEmployeeIDDataSet.FindEmployeeByEmployeeID[0].PhoneNumber; } else { txtManager.Text = ""; txtManagerEmail.Text = ""; txtManagerOffice.Text = ""; txtManagerPhone.Text = ""; } } } catch (Exception Ex) { TheEventLogClass.InsertEventLogEntry(DateTime.Now, "New Blue Jay ERP // Employee Lookup // Select Employee Combo Box " + Ex.Message); TheMessagesClass.ErrorMessage(Ex.ToString()); } }
private void expProcess_Expanded_1(object sender, RoutedEventArgs e) { int intVehicleCounter; int intVehicleNumberOfRecords; int intAutomileCounter; int intAutomileNumberOfRecords; int intVehicleID; string strVehicleNumber; string strAutomileVehicleNumber; bool blnItemFound; bool blnItemEntered; int intThirdCounter; string strInOrOut; string strManager; string strFullName; string strAssignedOffice; DateTime datStartDate; DateTime datEndDate; int intRecordsReturned; int intManagerID; try { expProcess.IsExpanded = false; //loading the vehicle data set TheFindActiveVehicleMainDataSet = TheVehicleMainClass.FindActiveVehicleMain(); TheVehicleCurrentStatusDataSet.vehiclecurrentstatus.Rows.Clear(); TheShortedCurrentVehicleDataSet.shortenlist.Rows.Clear(); datStartDate = DateTime.Now; datStartDate = TheDateSearchClass.RemoveTime(datStartDate); datEndDate = TheDateSearchClass.AddingDays(datStartDate, 1); intVehicleNumberOfRecords = TheFindActiveVehicleMainDataSet.FindActiveVehicleMain.Rows.Count - 1; intAutomileNumberOfRecords = TheAutomileImportDataSet.automileimport.Rows.Count - 1; gintThirdCounter = 0; gintThirdNumberOfRecords = 0; for (intVehicleCounter = 0; intVehicleCounter <= intVehicleNumberOfRecords; intVehicleCounter++) { intVehicleID = TheFindActiveVehicleMainDataSet.FindActiveVehicleMain[intVehicleCounter].VehicleID; if (intVehicleID != 9076) { strVehicleNumber = TheFindActiveVehicleMainDataSet.FindActiveVehicleMain[intVehicleCounter].VehicleNumber; strAssignedOffice = TheFindActiveVehicleMainDataSet.FindActiveVehicleMain[intVehicleCounter].AssignedOffice; TheFindCurrentAssignedVehicleMainByVehicleIDDataSet = TheVehicleAssignmentClass.FindCurrentAssignedVehicleMainByVehicleID(intVehicleID); strFullName = TheFindCurrentAssignedVehicleMainByVehicleIDDataSet.FindCurrentAssignedVehicleMainByVehicleID[0].FirstName + " "; strFullName += TheFindCurrentAssignedVehicleMainByVehicleIDDataSet.FindCurrentAssignedVehicleMainByVehicleID[0].LastName; intManagerID = TheFindCurrentAssignedVehicleMainByVehicleIDDataSet.FindCurrentAssignedVehicleMainByVehicleID[0].ManagerID; TheFindEnmployeeByEmployeeIDDataSet = TheEmployeeClass.FindEmployeeByEmployeeID(intManagerID); strManager = TheFindEnmployeeByEmployeeIDDataSet.FindEmployeeByEmployeeID[0].FirstName + " "; strManager += TheFindEnmployeeByEmployeeIDDataSet.FindEmployeeByEmployeeID[0].LastName; strInOrOut = "UNKNOWN"; if (TheFindCurrentAssignedVehicleMainByVehicleIDDataSet.FindCurrentAssignedVehicleMainByVehicleID[0].LastName == "WAREHOUSE") { strManager = "FLEET MANAGER"; } TheFindVehicleInShopByVehicleIDDataSet = TheVehiclesInShopClass.FindVehicleMainInShopByVehicleID(intVehicleID); TheFindVehicleInYardByVehicleIDAndDateRangeDataSet = TheVehicleInYardClass.FindVehiclesInYardByVehicleIDAndDateRange(intVehicleID, datStartDate, datEndDate); intRecordsReturned = TheFindVehicleInYardByVehicleIDAndDateRangeDataSet.FindVehiclesInYardByVehicleIDAndDateRange.Rows.Count; if (intRecordsReturned > 0) { strInOrOut = "IN YARD"; } blnItemEntered = false; for (intAutomileCounter = 0; intAutomileCounter <= intAutomileNumberOfRecords; intAutomileCounter++) { strAutomileVehicleNumber = TheAutomileImportDataSet.automileimport[intAutomileCounter].VehicleNumber; blnItemFound = strAutomileVehicleNumber.Contains(strVehicleNumber); if (blnItemFound == true) { strInOrOut = TheAutomileImportDataSet.automileimport[intAutomileCounter].IsInside; if (strInOrOut == "YES") { strInOrOut = "IN YARD"; } else if (strInOrOut == "NO") { strInOrOut = "OUT"; } if (gintThirdCounter > 0) { for (intThirdCounter = 0; gintThirdCounter <= gintThirdNumberOfRecords; intThirdCounter++) { if (strVehicleNumber == TheVehicleCurrentStatusDataSet.vehiclecurrentstatus[intThirdCounter].VehicleNumber) { if (strInOrOut == "YES") { TheVehicleCurrentStatusDataSet.vehiclecurrentstatus[intThirdCounter].InOrOut = "IN YARD"; } else if (strInOrOut == "NO") { TheVehicleCurrentStatusDataSet.vehiclecurrentstatus[intThirdCounter].InOrOut = strInOrOut; } blnItemEntered = true; } } } } } intRecordsReturned = TheFindVehicleInShopByVehicleIDDataSet.FindVehicleMainInShopByVehicleID.Rows.Count; if (intRecordsReturned > 0) { strInOrOut = "IN SHOP"; } if (blnItemEntered == false) { VehicleCurrentStatusDataSet.vehiclecurrentstatusRow NewVehicleRow = TheVehicleCurrentStatusDataSet.vehiclecurrentstatus.NewvehiclecurrentstatusRow(); NewVehicleRow.AssignedOffice = strAssignedOffice; NewVehicleRow.Manager = strManager; NewVehicleRow.Driver = strFullName; NewVehicleRow.InOrOut = strInOrOut; NewVehicleRow.VehicleNumber = strVehicleNumber; TheVehicleCurrentStatusDataSet.vehiclecurrentstatus.Rows.Add(NewVehicleRow); ShortedCurrentVehicleDataSet.shortenlistRow SecondVehicleRow = TheShortedCurrentVehicleDataSet.shortenlist.NewshortenlistRow(); SecondVehicleRow.Driver = strFullName; SecondVehicleRow.VehicleNumber = strVehicleNumber; SecondVehicleRow.InOrOut = strInOrOut; TheShortedCurrentVehicleDataSet.shortenlist.Rows.Add(SecondVehicleRow); } } } TheMessagesClass.InformationMessage("Processing the Report Is Completed"); dgrResults.ItemsSource = TheVehicleCurrentStatusDataSet.vehiclecurrentstatus; } catch (Exception Ex) { TheEventLogClass.InsertEventLogEntry(DateTime.Now, "Four Thirty Report // Main Window // Process Expander " + Ex.Message); TheMessagesClass.ErrorMessage(Ex.ToString()); } }
private void ResetControls() { //setting local variables int intCounter; int intNumberOfRecords; string strEmployee; string strPhoneNumber; string strEmailAddress; string strDepartment; string strLocation; string strManager; int intManagerID; try { TheActiveEmployeeDataSet.activeemployees.Rows.Clear(); TheFindActiveEmployeeDataSet = TheEmployeeClass.FindActiveEmployees(); intNumberOfRecords = TheFindActiveEmployeeDataSet.FindActiveEmployees.Rows.Count; for (intCounter = 0; intCounter < intNumberOfRecords; intCounter++) { strEmailAddress = ""; intManagerID = TheFindActiveEmployeeDataSet.FindActiveEmployees[intCounter].ManagerID; strEmployee = TheFindActiveEmployeeDataSet.FindActiveEmployees[intCounter].FirstName + " "; strEmployee += TheFindActiveEmployeeDataSet.FindActiveEmployees[intCounter].LastName; strPhoneNumber = TheFindActiveEmployeeDataSet.FindActiveEmployees[intCounter].PhoneNumber; if (TheFindActiveEmployeeDataSet.FindActiveEmployees[intCounter].IsEmailAddressNull() == false) { strEmailAddress = TheFindActiveEmployeeDataSet.FindActiveEmployees[intCounter].EmailAddress; } strDepartment = TheFindActiveEmployeeDataSet.FindActiveEmployees[intCounter].Department; strLocation = TheFindActiveEmployeeDataSet.FindActiveEmployees[intCounter].HomeOffice; TheFindEmployeeByEmployeeIDDataSet = TheEmployeeClass.FindEmployeeByEmployeeID(intManagerID); strManager = TheFindEmployeeByEmployeeIDDataSet.FindEmployeeByEmployeeID[0].FirstName + " "; strManager += TheFindEmployeeByEmployeeIDDataSet.FindEmployeeByEmployeeID[0].LastName; ActiveEmployeeDataSet.activeemployeesRow NewEmployeeRow = TheActiveEmployeeDataSet.activeemployees.NewactiveemployeesRow(); NewEmployeeRow.Department = strDepartment; NewEmployeeRow.EmailAddress = strEmailAddress; NewEmployeeRow.EmployeeName = strEmployee; NewEmployeeRow.Location = strLocation; NewEmployeeRow.Manager = strManager; NewEmployeeRow.PhoneNumber = strPhoneNumber; TheActiveEmployeeDataSet.activeemployees.Rows.Add(NewEmployeeRow); } dgrEmployees.ItemsSource = TheActiveEmployeeDataSet.activeemployees; TheEmployeeDateEntryClass.InsertIntoEmployeeDateEntry(MainWindow.TheVerifyLogonDataSet.VerifyLogon[0].EmployeeID, "New Blue Jay ERP // Employee Roster"); } catch (Exception Ex) { TheEventLogClass.InsertEventLogEntry(DateTime.Now, "New Blue Jay ERP // Employee Roster // Reset Controls " + Ex.Message); TheMessagesClass.ErrorMessage(Ex.ToString()); } }
private void btnSubmit_Click(object sender, RoutedEventArgs e) { bool blnFatalError = false; string strErrorMessage = ""; DateTime datTicketDate = DateTime.Now; string strRepotedProblem; string strEmailAddress = "*****@*****.**"; string strHeader; string strMessage; int intEmployeeID; string strFullName; string strUserEmail; try { //data valication if (cboOffice.SelectedIndex < 1) { blnFatalError = true; strErrorMessage += "The Office Was Not Selected\n"; } if (cboProblemType.SelectedIndex < 1) { blnFatalError = true; strErrorMessage += "The Problem Type Was Not Selected"; } strRepotedProblem = txtProblemNotes.Text; if (strRepotedProblem.Length < 10) { blnFatalError = true; strErrorMessage += "The Reported Problem is not Long Enough\n"; } if (blnFatalError == true) { TheMessagesClass.ErrorMessage(strErrorMessage); return; } intEmployeeID = MainWindow.TheVerifyLogonDataSet.VerifyLogon[0].EmployeeID; strFullName = MainWindow.TheVerifyLogonDataSet.VerifyLogon[0].FirstName + " "; strFullName += MainWindow.TheVerifyLogonDataSet.VerifyLogon[0].LastName; TheFindEmployeeByEmployeeIDDataSet = TheEmployeeClass.FindEmployeeByEmployeeID(intEmployeeID); if (TheFindEmployeeByEmployeeIDDataSet.FindEmployeeByEmployeeID[0].IsEmailAddressNull() == true) { strUserEmail = "NONE"; } else { if (TheFindEmployeeByEmployeeIDDataSet.FindEmployeeByEmployeeID[0].EmailAddress.Contains("bluejaycommunications") == false) { strUserEmail = "NONE"; } else { strUserEmail = TheFindEmployeeByEmployeeIDDataSet.FindEmployeeByEmployeeID[0].EmailAddress; } } strUserEmail = TheFindEmployeeByEmployeeIDDataSet.FindEmployeeByEmployeeID[0].EmailAddress; //inserting ticket blnFatalError = TheHelpDeskClass.InsertHelpDeskTicket(datTicketDate, gstrComputerName, gstrUserName, gstrIPAddress, MainWindow.gintWarehouseID, gintProblemTypeID, strRepotedProblem, intEmployeeID); if (blnFatalError == true) { throw new Exception(); } TheFindHelpDeskTicketByMatchDateDataSet = TheHelpDeskClass.FindHelpDeskTicketByTicketDateMatch(datTicketDate); gintTicketID = TheFindHelpDeskTicketByMatchDateDataSet.FindHelpDeskTicketByTicketDateMatch[0].TicketID; blnFatalError = TheHelpDeskClass.InsertHelpDeskTicketUpdate(gintTicketID, intEmployeeID, "TICKET CREATED"); if (blnFatalError == true) { throw new Exception(); } strHeader = strFullName + " Has Submitted a Help Desk Ticket - Do Not Reply"; strMessage = "<h1>" + strFullName + " Has Submitted a Help Desk Ticket - Do Not Reply</h1>"; strMessage += "<h3> Ticket ID " + Convert.ToString(gintTicketID) + "</h3>"; strMessage += "<h3> They have Reported The Following Problem </h3>"; strMessage += "<h3>" + strRepotedProblem + "</h3>"; strMessage += "<h3> They can be reached at Extension " + Convert.ToString(gintPhoneExtension) + "</h3>"; strMessage += "<h3> Computer Name " + gstrComputerName + " User Name " + gstrUserName + " IP Address " + gstrIPAddress + "<h3>"; blnFatalError = TheSendEmailClass.SendEmail(strEmailAddress, strHeader, strMessage); if (blnFatalError == false) { throw new Exception(); } blnFatalError = TheSendEmailClass.SendEmail(strUserEmail, strHeader, strMessage); if (blnFatalError == false) { throw new Exception(); } TheMessagesClass.InformationMessage("Help Desk Ticket Number " + Convert.ToString(gintTicketID) + " Has Been Created"); blnFatalError = TheEmployeeDataEntryClass.InsertIntoEmployeeDateEntry(MainWindow.TheVerifyLogonDataSet.VerifyLogon[0].EmployeeID, "New Blue Jay ERP // Create Help Desk Ticket"); if (blnFatalError == true) { throw new Exception(); } const string message = "Would You Like to send a Document or Attach a File?"; const string caption = "Please Answer"; MessageBoxResult result = MessageBox.Show(message, caption, MessageBoxButton.YesNo, MessageBoxImage.Question); if (result == MessageBoxResult.Yes) { AttachDocuments(); } this.Close(); } catch (Exception Ex) { TheEventLogClass.InsertEventLogEntry(DateTime.Now, "Blue Jay Help Desk // Main Window // Submit Button " + Ex.Message); TheMessagesClass.ErrorMessage(Ex.ToString()); } }
private void rdoAllEmployees_Checked(object sender, RoutedEventArgs e) { //setting up variables string strValueForValidation; bool blnFatalError = false; DateTime datPayPeriod = DateTime.Now; DateTime datStartDate = DateTime.Now; int intCounter; int intNumberOfRecords; int intEmployeeID; int intManagerID; string strFirstName; string strLastName; string strManagerFirstName; string strManagerLastName; int intRecordReturned; decimal decHoursPunched; decimal decProductiveHours = 0; try { TheEmployeeProductionPunchDataSet.employees.Rows.Clear(); lblSelectManger.Visibility = Visibility.Hidden; cboSelectManager.Visibility = Visibility.Hidden; strValueForValidation = txtEnterPayPeriod.Text; blnFatalError = TheDataValidationClass.VerifyDateData(strValueForValidation); if (blnFatalError == true) { TheMessagesClass.ErrorMessage("The Date is not a Date"); return; } datPayPeriod = Convert.ToDateTime(strValueForValidation); datStartDate = TheDateSearchClass.SubtractingDays(datPayPeriod, 6); TheFindActiveNoExemptEmployeesDataSet = TheEmployeeClass.FindActiveNonExemptEmployeesByPayDate(datPayPeriod); intNumberOfRecords = TheFindActiveNoExemptEmployeesDataSet.FindActiveNonExemptEmployeesByPayDate.Rows.Count - 1; for (intCounter = 0; intCounter <= intNumberOfRecords; intCounter++) { //getting employee info intEmployeeID = TheFindActiveNoExemptEmployeesDataSet.FindActiveNonExemptEmployeesByPayDate[intCounter].EmployeeID; strFirstName = TheFindActiveNoExemptEmployeesDataSet.FindActiveNonExemptEmployeesByPayDate[intCounter].FirstName; strLastName = TheFindActiveNoExemptEmployeesDataSet.FindActiveNonExemptEmployeesByPayDate[intCounter].LastName; intManagerID = TheFindActiveNoExemptEmployeesDataSet.FindActiveNonExemptEmployeesByPayDate[intCounter].ManagerID; TheFindEmployeeByEmployeeIDDataSet = TheEmployeeClass.FindEmployeeByEmployeeID(intManagerID); strManagerFirstName = TheFindEmployeeByEmployeeIDDataSet.FindEmployeeByEmployeeID[0].FirstName; strManagerLastName = TheFindEmployeeByEmployeeIDDataSet.FindEmployeeByEmployeeID[0].LastName; //getting employee punched hours TheFindEmployeePunchedHoursDataSet = TheEmployeePunchedHoursClass.FindEmployeePunchedHours(intEmployeeID, datStartDate, datPayPeriod); intRecordReturned = TheFindEmployeePunchedHoursDataSet.FindEmployeePunchedHours.Rows.Count; if (intRecordReturned == 0) { decHoursPunched = 0; } else { decHoursPunched = TheFindEmployeePunchedHoursDataSet.FindEmployeePunchedHours[0].PunchedHours; } //getting production hours TheFindEmployeeProductionHoursOverPayPeriodDataSet = TheEmployeeProjectAssignmentClass.FindEmployeeProductionHoursOverPayPeriodDataSet(intEmployeeID, datStartDate, datPayPeriod); intRecordReturned = TheFindEmployeeProductionHoursOverPayPeriodDataSet.FindEmployeeProductionHoursOverPayPeriod.Rows.Count; if (intRecordReturned == 0) { decProductiveHours = 0; } else { decProductiveHours = TheFindEmployeeProductionHoursOverPayPeriodDataSet.FindEmployeeProductionHoursOverPayPeriod[0].ProductionHours; } TheFindDesignTotalEmployeeProductivityHoursDataSet = TheDesignProductivityClass.FindDesignTotalEmployeeProductivityHours(intEmployeeID, datStartDate, datPayPeriod); intRecordReturned = TheFindDesignTotalEmployeeProductivityHoursDataSet.FindDesignTotalEmployeeProductivityHours.Rows.Count; if (intRecordReturned > 0) { decProductiveHours += TheFindDesignTotalEmployeeProductivityHoursDataSet.FindDesignTotalEmployeeProductivityHours[0].TotalHours; } //loading the dataset EmployeeProductionPunchDataSet.employeesRow NewEmployeeRow = TheEmployeeProductionPunchDataSet.employees.NewemployeesRow(); NewEmployeeRow.HomeOffice = TheFindActiveNoExemptEmployeesDataSet.FindActiveNonExemptEmployeesByPayDate[intCounter].HomeOffice; NewEmployeeRow.FirstName = strFirstName; NewEmployeeRow.LastName = strLastName; NewEmployeeRow.ManagerFirstName = strManagerFirstName; NewEmployeeRow.ManagerLastName = strManagerLastName; NewEmployeeRow.ProductionHours = decProductiveHours; NewEmployeeRow.PunchedHours = decHoursPunched; NewEmployeeRow.HourVariance = decProductiveHours - decHoursPunched; TheEmployeeProductionPunchDataSet.employees.Rows.Add(NewEmployeeRow); } blnFatalError = TheEmployeeDateEntryClass.InsertIntoEmployeeDateEntry(MainWindow.TheVerifyLogonDataSet.VerifyLogon[0].EmployeeID, "New Blue Jay ERP // Employee Punched VS Production Hours // All Employees"); if (blnFatalError == true) { throw new Exception(); } dgrResults.ItemsSource = TheEmployeeProductionPunchDataSet.employees; } catch (Exception Ex) { TheEventLogClass.InsertEventLogEntry(DateTime.Now, "New Blue Jay ERP // Employee Punched Vs Production Hours // All Employees Radio Button " + Ex.Message); TheMessagesClass.ErrorMessage(Ex.ToString()); } }
private void expImportCalls_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 strCallType; string strExtension; int intExtension; string strDialedDigits; string strStartTime; DateTime datStartTime; string strCallDuration; int intPhoneID; int intEmployeeID; string strFirstName; string strLastName; int intRecordsReturned; double douDate; bool blnIsNotNumeric; double douTime; try { expImportCalls.IsExpanded = false; TheImportedPhoneCallsDataSet.importedphonecalls.Rows.Clear(); 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 = 1; intCounter <= intNumberOfRecords; intCounter++) { strCallType = Convert.ToString((range.Cells[intCounter, 1] as Excel.Range).Value2).ToUpper(); strExtension = Convert.ToString((range.Cells[intCounter, 2] as Excel.Range).Value2).ToUpper(); strDialedDigits = Convert.ToString((range.Cells[intCounter, 4] as Excel.Range).Value2).ToUpper(); strStartTime = Convert.ToString((range.Cells[intCounter, 5] as Excel.Range).Value2).ToUpper(); strCallDuration = Convert.ToString((range.Cells[intCounter, 6] as Excel.Range).Value2).ToUpper(); blnIsNotNumeric = TheDataValidationClass.VerifyIntegerData(strExtension); if (blnIsNotNumeric == false) { intExtension = Convert.ToInt32(strExtension); TheFindPhoneForImportDataSet = ThePhonesClass.FindPhoneForImport(intExtension); intRecordsReturned = TheFindPhoneForImportDataSet.FindPhoneForImport.Rows.Count; if (intRecordsReturned > 0) { intPhoneID = TheFindPhoneForImportDataSet.FindPhoneForImport[0].TransactionID; intEmployeeID = TheFindPhoneForImportDataSet.FindPhoneForImport[0].EmployeeID; TheFindEmployeeByEmployeeIDDataSet = TheEmployeeClass.FindEmployeeByEmployeeID(intEmployeeID); strFirstName = TheFindEmployeeByEmployeeIDDataSet.FindEmployeeByEmployeeID[0].FirstName; strLastName = TheFindEmployeeByEmployeeIDDataSet.FindEmployeeByEmployeeID[0].LastName; douDate = Convert.ToDouble(strStartTime); datStartTime = DateTime.FromOADate(douDate); douTime = Convert.ToDouble(strCallDuration); TimeSpan tspInterval = TimeSpan.FromDays(douTime); strCallDuration = tspInterval.ToString(); ImportedPhoneCallsDataSet.importedphonecallsRow NewCallRow = TheImportedPhoneCallsDataSet.importedphonecalls.NewimportedphonecallsRow(); NewCallRow.CallDuration = strCallDuration; NewCallRow.CallType = strCallType; NewCallRow.DialedDigits = strDialedDigits; NewCallRow.PhoneExtension = intExtension; NewCallRow.EmployeeID = intEmployeeID; NewCallRow.FirstName = strFirstName; NewCallRow.LastName = strLastName; NewCallRow.PhoneID = intPhoneID; NewCallRow.StartTime = datStartTime; TheImportedPhoneCallsDataSet.importedphonecalls.Rows.Add(NewCallRow); } } } dgrPhoneCalls.ItemsSource = TheImportedPhoneCallsDataSet.importedphonecalls; PleaseWait.Close(); } catch (Exception Ex) { TheEventLogClass.InsertEventLogEntry(DateTime.Now, "New Blue Jay ERP // Import Phone Calls // Import Excel " + Ex.Message); TheMessagesClass.ErrorMessage(Ex.ToString()); } }
public void CreateOverTimeReport() { //setting local variables int intCounter; int intNumberOfRecords; int intManagerID; string strManager; string strEmailAddress = "*****@*****.**"; string strHeader; string strMessage; DateTime datPayDate = DateTime.Now; bool blnFatalError = false; try { TheEmployeeOvertimeDataSet.employeeovertime.Rows.Clear(); datPayDate = TheDateSearchClass.RemoveTime(datPayDate); datPayDate = TheDateSearchClass.SubtractingDays(datPayDate, 9); TheFindEmployeesOverFortyHoursDataSet = TheEmployeePunchedHoursClass.FindEmployeesOverFortyHours(datPayDate); intNumberOfRecords = TheFindEmployeesOverFortyHoursDataSet.FindEmployeesOverFortyHours.Rows.Count; if (intNumberOfRecords > 0) { for (intCounter = 0; intCounter < intNumberOfRecords; intCounter++) { intManagerID = TheFindEmployeesOverFortyHoursDataSet.FindEmployeesOverFortyHours[intCounter].ManagerID; TheFindEmployeeByEmployeeIDDataSet = TheEmployeeClass.FindEmployeeByEmployeeID(intManagerID); strManager = TheFindEmployeeByEmployeeIDDataSet.FindEmployeeByEmployeeID[0].FirstName + " "; strManager += TheFindEmployeeByEmployeeIDDataSet.FindEmployeeByEmployeeID[0].LastName; EmployeeOvertimeDataSet.employeeovertimeRow NewEmployeeRow = TheEmployeeOvertimeDataSet.employeeovertime.NewemployeeovertimeRow(); NewEmployeeRow.FirstName = TheFindEmployeesOverFortyHoursDataSet.FindEmployeesOverFortyHours[intCounter].FirstName; NewEmployeeRow.LastName = TheFindEmployeesOverFortyHoursDataSet.FindEmployeesOverFortyHours[intCounter].LastName; NewEmployeeRow.HomeOffice = TheFindEmployeesOverFortyHoursDataSet.FindEmployeesOverFortyHours[intCounter].HomeOffice; NewEmployeeRow.Manager = strManager; NewEmployeeRow.TotalHours = TheFindEmployeesOverFortyHoursDataSet.FindEmployeesOverFortyHours[intCounter].PunchedHours; TheEmployeeOvertimeDataSet.employeeovertime.Rows.Add(NewEmployeeRow); } } strHeader = "Employee Overtime Report For " + Convert.ToString(datPayDate); strMessage = "<h1>Employee Overtime Report For " + Convert.ToString(datPayDate) + "</h1>"; strMessage += "<p> </p>"; strMessage += "<p> </p>"; strMessage += "<table>"; strMessage += "<tr>"; strMessage += "<td><b>First Name</b></td>"; strMessage += "<td><b>Last Name</b></td>"; strMessage += "<td><b>Home Office</b></td>"; strMessage += "<td><b>Manager</b></td>"; strMessage += "<td><b>Total Hours</b></td>"; strMessage += "</tr>"; strMessage += "<p> </p>"; intNumberOfRecords = TheEmployeeOvertimeDataSet.employeeovertime.Rows.Count; if (intNumberOfRecords > 0) { for (intCounter = 0; intCounter < intNumberOfRecords; intCounter++) { strMessage += "<tr>"; strMessage += "<td>" + TheEmployeeOvertimeDataSet.employeeovertime[intCounter].FirstName + "</td>"; strMessage += "<td>" + TheEmployeeOvertimeDataSet.employeeovertime[intCounter].LastName + "</td>"; strMessage += "<td>" + TheEmployeeOvertimeDataSet.employeeovertime[intCounter].HomeOffice + "</td>"; strMessage += "<td>" + TheEmployeeOvertimeDataSet.employeeovertime[intCounter].Manager + "</td>"; strMessage += "<td>" + Convert.ToString(TheEmployeeOvertimeDataSet.employeeovertime[intCounter].TotalHours) + "</td>"; strMessage += "</tr>"; strMessage += "<p> </p>"; } } strMessage += "</table>"; blnFatalError = TheSendEmailClass.SendEmail(strEmailAddress, strHeader, strMessage); if (blnFatalError == true) { throw new Exception(); } } catch (Exception Ex) { TheEventLogClass.InsertEventLogEntry(DateTime.Now, "Event Log Tracker // Run Punched Vs Production Class // Create Overtime Report " + Ex.Message); TheMessagesClass.ErrorMessage(Ex.ToString()); } }
public void RunPunchedVSProductionReport() { //setting local variables int intCounter; int intNumberOfRecords; int intEmployeeID; int intManagerID; string strFirstName; string strLastName; string strManagerFirstName; string strManagerLastName; int intRecordReturned; bool blnFatalError = false; decimal decHoursPunched; decimal decProductiveHours; int intManagerCounter; bool blnItemFound; decimal decVariance; int intTotalNumber; int intSelectedIndex; int intTotalNumberNeeded; decimal decTopPercentage; decimal decWorkingPercentage; int intArrayCounter; int intArrayNumberOfRecords = -1; int intEmployeeCounter; int intNumberOfEmployees; decimal decCalVariance; decimal decVarianceMean; decimal decSumOfDifferences; decimal decAverageOfDifferences; DateTime datStartDate; DateTime datEndDate; string strEmailAddress = "*****@*****.**"; string strHeader; string strMessage; string strManager; decimal decTotalPercentage; try { TheEmployeeProductionPunchDataSet.employees.Rows.Clear(); TheProductionManagerStatsDataSet.productionmanager.Rows.Clear(); TheFinalProductionManagerStatsDataSet.productionmanager.Rows.Clear(); datEndDate = DateTime.Now; datEndDate = TheDateSearchClass.RemoveTime(datEndDate); datEndDate = TheDateSearchClass.SubtractingDays(datEndDate, 16); datStartDate = TheDateSearchClass.SubtractingDays(datEndDate, 6); TheFindActiveNoExemptEmployeesDataSet = TheEmployeeClass.FindActiveNonExemptEmployeesByPayDate(datStartDate); intNumberOfRecords = TheFindActiveNoExemptEmployeesDataSet.FindActiveNonExemptEmployeesByPayDate.Rows.Count - 1; for (intCounter = 0; intCounter <= intNumberOfRecords; intCounter++) { //getting employee info intEmployeeID = TheFindActiveNoExemptEmployeesDataSet.FindActiveNonExemptEmployeesByPayDate[intCounter].EmployeeID; strFirstName = TheFindActiveNoExemptEmployeesDataSet.FindActiveNonExemptEmployeesByPayDate[intCounter].FirstName; strLastName = TheFindActiveNoExemptEmployeesDataSet.FindActiveNonExemptEmployeesByPayDate[intCounter].LastName; intManagerID = TheFindActiveNoExemptEmployeesDataSet.FindActiveNonExemptEmployeesByPayDate[intCounter].ManagerID; TheFindEmployeeByEmployeeIDDataSet = TheEmployeeClass.FindEmployeeByEmployeeID(intManagerID); strManagerFirstName = TheFindEmployeeByEmployeeIDDataSet.FindEmployeeByEmployeeID[0].FirstName; strManagerLastName = TheFindEmployeeByEmployeeIDDataSet.FindEmployeeByEmployeeID[0].LastName; //getting employee punched hours TheFindEmployeePunchedHoursDataSet = TheEmployeePunchedHoursClass.FindEmployeePunchedHours(intEmployeeID, datStartDate, datEndDate); intRecordReturned = TheFindEmployeePunchedHoursDataSet.FindEmployeePunchedHours.Rows.Count; if (intRecordReturned == 0) { decHoursPunched = 0; } else { decHoursPunched = TheFindEmployeePunchedHoursDataSet.FindEmployeePunchedHours[0].PunchedHours; } //getting production hours TheFindEmployeeProductionHoursOverPayPeriodDataSet = TheEmployeeProjectAssignmentClass.FindEmployeeProductionHoursOverPayPeriodDataSet(intEmployeeID, datStartDate, datEndDate); intRecordReturned = TheFindEmployeeProductionHoursOverPayPeriodDataSet.FindEmployeeProductionHoursOverPayPeriod.Rows.Count; if (intRecordReturned == 0) { TheFindDesignTotalEmployeeProductivityHoursDataSet = TheDesignProductivityClass.FindDesignTotalEmployeeProductivityHours(intEmployeeID, datStartDate, datEndDate); intRecordReturned = TheFindDesignTotalEmployeeProductivityHoursDataSet.FindDesignTotalEmployeeProductivityHours.Rows.Count; if (intRecordReturned == 0) { decProductiveHours = 0; } else { decProductiveHours = TheFindDesignTotalEmployeeProductivityHoursDataSet.FindDesignTotalEmployeeProductivityHours[0].TotalHours; } } else { decProductiveHours = TheFindEmployeeProductionHoursOverPayPeriodDataSet.FindEmployeeProductionHoursOverPayPeriod[0].ProductionHours; TheFindDesignTotalEmployeeProductivityHoursDataSet = TheDesignProductivityClass.FindDesignTotalEmployeeProductivityHours(intEmployeeID, datStartDate, datEndDate); intRecordReturned = TheFindDesignTotalEmployeeProductivityHoursDataSet.FindDesignTotalEmployeeProductivityHours.Rows.Count; if (intRecordReturned > 0) { decProductiveHours += TheFindDesignTotalEmployeeProductivityHoursDataSet.FindDesignTotalEmployeeProductivityHours[0].TotalHours; } } //loading the dataset EmployeeProductionPunchDataSet.employeesRow NewEmployeeRow = TheEmployeeProductionPunchDataSet.employees.NewemployeesRow(); NewEmployeeRow.HomeOffice = TheFindActiveNoExemptEmployeesDataSet.FindActiveNonExemptEmployeesByPayDate[intCounter].HomeOffice; NewEmployeeRow.FirstName = strFirstName; NewEmployeeRow.LastName = strLastName; NewEmployeeRow.ManagerFirstName = strManagerFirstName; NewEmployeeRow.ManagerLastName = strManagerLastName; NewEmployeeRow.ProductionHours = decProductiveHours; NewEmployeeRow.PunchedHours = decHoursPunched; NewEmployeeRow.HourVariance = decProductiveHours - decHoursPunched; TheEmployeeProductionPunchDataSet.employees.Rows.Add(NewEmployeeRow); } intNumberOfEmployees = TheEmployeeProductionPunchDataSet.employees.Rows.Count; decCalVariance = 0; for (intEmployeeCounter = 0; intEmployeeCounter < intNumberOfEmployees; intEmployeeCounter++) { decCalVariance += TheEmployeeProductionPunchDataSet.employees[intEmployeeCounter].HourVariance; } decVarianceMean = decCalVariance / Convert.ToDecimal(intNumberOfEmployees); decVarianceMean = Math.Round(decVarianceMean, 4); gdecMean = decVarianceMean; decSumOfDifferences = 0; for (intEmployeeCounter = 0; intEmployeeCounter < intNumberOfEmployees; intEmployeeCounter++) { decSumOfDifferences += Convert.ToDecimal(Math.Pow(Convert.ToDouble(TheEmployeeProductionPunchDataSet.employees[intEmployeeCounter].HourVariance - gdecMean), 2)); } decAverageOfDifferences = decSumOfDifferences / Convert.ToDecimal(intNumberOfEmployees); gdecStandardDeviation = Convert.ToDecimal(Math.Sqrt(Convert.ToDouble(decAverageOfDifferences))); gdecStandardDeviation = Math.Round(gdecStandardDeviation, 4); intNumberOfRecords = TheEmployeeProductionPunchDataSet.employees.Rows.Count - 1; gintManagerCounter = 0; gdecTotalAcceptable = 0; gdecTotalEntries = 0; for (intCounter = 0; intCounter <= intNumberOfRecords; intCounter++) { strManagerFirstName = TheEmployeeProductionPunchDataSet.employees[intCounter].ManagerFirstName; strManagerLastName = TheEmployeeProductionPunchDataSet.employees[intCounter].ManagerLastName; decVariance = TheEmployeeProductionPunchDataSet.employees[intCounter].HourVariance; blnItemFound = false; intArrayNumberOfRecords = -1; if (gintManagerCounter > 0) { for (intManagerCounter = 0; intManagerCounter <= gintManagerUpperLimit; intManagerCounter++) { if (strManagerFirstName == TheProductionManagerStatsDataSet.productionmanager[intManagerCounter].FirstName) { if (strManagerLastName == TheProductionManagerStatsDataSet.productionmanager[intManagerCounter].LastName) { blnItemFound = true; if ((decVariance >= -5 && decVariance <= 5)) { TheProductionManagerStatsDataSet.productionmanager[intManagerCounter].ZeroToFive++; gdecTotalEntries++; gdecTotalAcceptable++; } else if (((decVariance < -5) && (decVariance >= -10)) || ((decVariance > 5) && (decVariance <= 10))) { TheProductionManagerStatsDataSet.productionmanager[intManagerCounter].FiveToTen++; gdecTotalEntries++; } else if ((decVariance < -10) || (decVariance > 10)) { TheProductionManagerStatsDataSet.productionmanager[intManagerCounter].Above10++; gdecTotalEntries++; } } } } } if (blnItemFound == false) { ProductionManagerStatsDataSet.productionmanagerRow NewManagerRow = TheProductionManagerStatsDataSet.productionmanager.NewproductionmanagerRow(); NewManagerRow.FirstName = strManagerFirstName; NewManagerRow.LastName = strManagerLastName; NewManagerRow.PercentInTolerance = 0; if (Convert.ToDouble(decVariance) > -5.01) { NewManagerRow.ZeroToFive = 1; NewManagerRow.FiveToTen = 0; NewManagerRow.Above10 = 0; gdecTotalEntries++; gdecTotalAcceptable++; } else if ((Convert.ToDouble(decVariance) < -5) && (Convert.ToDouble(decVariance) > -10.01)) { NewManagerRow.ZeroToFive = 0; NewManagerRow.FiveToTen = 1; NewManagerRow.Above10 = 0; gdecTotalEntries++; } else if (Convert.ToDouble(decVariance) < -10) { NewManagerRow.ZeroToFive = 0; NewManagerRow.FiveToTen = 0; NewManagerRow.Above10 = 1; gdecTotalEntries++; } TheProductionManagerStatsDataSet.productionmanager.Rows.Add(NewManagerRow); gintManagerUpperLimit = gintManagerCounter; gintManagerCounter++; } } intNumberOfRecords = TheProductionManagerStatsDataSet.productionmanager.Rows.Count - 1; for (intCounter = 0; intCounter <= intNumberOfRecords; intCounter++) { intTotalNumber = TheProductionManagerStatsDataSet.productionmanager[intCounter].ZeroToFive; intTotalNumber += TheProductionManagerStatsDataSet.productionmanager[intCounter].FiveToTen; intTotalNumber += TheProductionManagerStatsDataSet.productionmanager[intCounter].Above10; TheProductionManagerStatsDataSet.productionmanager[intCounter].PercentInTolerance = (Convert.ToDecimal(TheProductionManagerStatsDataSet.productionmanager[intCounter].ZeroToFive) / intTotalNumber) * 100; TheProductionManagerStatsDataSet.productionmanager[intCounter].PercentInTolerance = Math.Round(TheProductionManagerStatsDataSet.productionmanager[intCounter].PercentInTolerance, 2); } decTotalPercentage = ((Math.Round(((gdecTotalAcceptable / gdecTotalEntries) * 100), 4))); intTotalNumberNeeded = 0; decTopPercentage = 1000; decWorkingPercentage = 0; strLastName = ""; intSelectedIndex = -1; while (intTotalNumberNeeded <= intNumberOfRecords) { for (intCounter = 0; intCounter <= intNumberOfRecords; intCounter++) { if (TheProductionManagerStatsDataSet.productionmanager[intCounter].PercentInTolerance <= decTopPercentage) { if (TheProductionManagerStatsDataSet.productionmanager[intCounter].PercentInTolerance >= decWorkingPercentage) { blnItemFound = false; if (intArrayNumberOfRecords > -1) { for (intArrayCounter = 0; intArrayCounter <= intArrayNumberOfRecords; intArrayCounter++) { if (TheProductionManagerStatsDataSet.productionmanager[intCounter].LastName == gstrLastName[intArrayCounter]) { blnItemFound = true; } } } if (blnItemFound == false) { decWorkingPercentage = TheProductionManagerStatsDataSet.productionmanager[intCounter].PercentInTolerance; intSelectedIndex = intCounter; } } } } ProductionManagerStatsDataSet.productionmanagerRow NewManagerRow = TheFinalProductionManagerStatsDataSet.productionmanager.NewproductionmanagerRow(); NewManagerRow.Above10 = TheProductionManagerStatsDataSet.productionmanager[intSelectedIndex].Above10; NewManagerRow.FirstName = TheProductionManagerStatsDataSet.productionmanager[intSelectedIndex].FirstName; NewManagerRow.LastName = TheProductionManagerStatsDataSet.productionmanager[intSelectedIndex].LastName; NewManagerRow.PercentInTolerance = TheProductionManagerStatsDataSet.productionmanager[intSelectedIndex].PercentInTolerance; NewManagerRow.FiveToTen = TheProductionManagerStatsDataSet.productionmanager[intSelectedIndex].FiveToTen; NewManagerRow.ZeroToFive = TheProductionManagerStatsDataSet.productionmanager[intSelectedIndex].ZeroToFive; TheFinalProductionManagerStatsDataSet.productionmanager.Rows.Add(NewManagerRow); intTotalNumberNeeded++; decTopPercentage = decWorkingPercentage; decWorkingPercentage = 0; intArrayNumberOfRecords++; gstrLastName[intArrayNumberOfRecords] = TheProductionManagerStatsDataSet.productionmanager[intSelectedIndex].LastName; } strHeader = "Employee Punched Vs Production Report For " + Convert.ToString(datEndDate); intNumberOfRecords = TheEmployeeProductionPunchDataSet.employees.Rows.Count; strMessage = "<h1> Employee Punched Vs Production Report For " + Convert.ToString(datEndDate) + "</h1>"; strMessage += "<p> </p>"; strMessage += "<table>"; strMessage += "<tr>"; strMessage += "<td><b>First Name</b></td>"; strMessage += "<td><b>Last Name</b></td>"; strMessage += "<td><b>Home Office</b></td>"; strMessage += "<td><b>Manager</b></td>"; strMessage += "<td><b>Punched Hours</b></td>"; strMessage += "<td><b>Production Hours</b></td>"; strMessage += "<td><b>Hour Variance</b></td>"; strMessage += "</tr>"; strMessage += "<p> </p>"; if (intNumberOfRecords > 0) { for (intCounter = 0; intCounter < intNumberOfRecords; intCounter++) { strManager = TheEmployeeProductionPunchDataSet.employees[intCounter].ManagerFirstName + " "; strManager += TheEmployeeProductionPunchDataSet.employees[intCounter].ManagerLastName; strMessage += "<tr>"; strMessage += "<td>" + TheEmployeeProductionPunchDataSet.employees[intCounter].FirstName + "</td>"; strMessage += "<td>" + TheEmployeeProductionPunchDataSet.employees[intCounter].LastName + "</td>"; strMessage += "<td>" + TheEmployeeProductionPunchDataSet.employees[intCounter].HomeOffice + "</td>"; strMessage += "<td>" + strManager + "</td>"; strMessage += "<td>" + Convert.ToString(TheEmployeeProductionPunchDataSet.employees[intCounter].PunchedHours) + "</td>"; strMessage += "<td>" + Convert.ToString(TheEmployeeProductionPunchDataSet.employees[intCounter].ProductionHours) + "</td>"; strMessage += "<td>" + Convert.ToString(TheEmployeeProductionPunchDataSet.employees[intCounter].HourVariance) + "</td>"; strMessage += "</tr>"; } } strMessage += "</table>"; strMessage += "<p> </p>"; blnFatalError = TheSendEmailClass.SendEmail(strEmailAddress, strHeader, strMessage); if (blnFatalError == true) { throw new Exception(); } strHeader = "Manager Punched Vs Productivity Report For " + Convert.ToString(datEndDate); strMessage = "<h1>Employee Punched Vs Production Report For " + Convert.ToString(datEndDate) + "</h1>"; strMessage += "<p> </p>"; strMessage += "<h3>Company Average   " + Convert.ToString(gdecMean) + "</h3>"; strMessage += "<h3>Company Standard Deviation   " + Convert.ToString(gdecStandardDeviation) + "</h3>"; strMessage += "<h3>Company Percentage   " + Convert.ToString(decTotalPercentage); strMessage += "<p> </p>"; strMessage += "<table>"; strMessage += "<tr>"; strMessage += "<td><b>First Name</b></td>"; strMessage += "<td><b>Last Name</b></td>"; strMessage += "<td><b>Zero to Five</b></td>"; strMessage += "<td><b>Five To Ten</b></td>"; strMessage += "<td><b>Above Ten</b></td>"; strMessage += "<td><b>Tolerance Percent</b></td>"; strMessage += "</tr>"; strMessage += "<p> </p>"; intNumberOfEmployees = TheFinalProductionManagerStatsDataSet.productionmanager.Rows.Count; if (intNumberOfEmployees > 0) { for (intCounter = 0; intCounter < intNumberOfEmployees; intCounter++) { strMessage += "<tr>"; strMessage += "<td>" + TheFinalProductionManagerStatsDataSet.productionmanager[intCounter].FirstName + "</td>"; strMessage += "<td>" + TheFinalProductionManagerStatsDataSet.productionmanager[intCounter].LastName + "</td>"; strMessage += "<td>" + Convert.ToString(TheFinalProductionManagerStatsDataSet.productionmanager[intCounter].ZeroToFive) + "</td>"; strMessage += "<td>" + Convert.ToString(TheFinalProductionManagerStatsDataSet.productionmanager[intCounter].FiveToTen) + "</td>"; strMessage += "<td>" + Convert.ToString(TheFinalProductionManagerStatsDataSet.productionmanager[intCounter].Above10) + "</td>"; strMessage += "<td>" + Convert.ToString(TheFinalProductionManagerStatsDataSet.productionmanager[intCounter].PercentInTolerance) + "</td>"; strMessage += "</tr>"; strMessage += "<p> </p>"; } } strMessage += "</table>"; blnFatalError = TheSendEmailClass.SendEmail(strEmailAddress, strHeader, strMessage); if (blnFatalError == true) { throw new Exception(); } } catch (Exception Ex) { TheEventLogClass.InsertEventLogEntry(DateTime.Now, "Event Log Tracker // Run Punched Vs Production Class // Run Punched Vs Production Report " + Ex.Message); TheMessagesClass.ErrorMessage(Ex.ToString()); } }
private void btnFind_Click(object sender, RoutedEventArgs e) { string strValueForValidation; string strToolID = ""; bool blnFatalError = false; bool blnThereIsAProblem = false; string strErrorMessage = ""; int intCounter; int intNumberOfRecords; int intWarehouseEmployee; string strWarehouseEmployeeName; try { strValueForValidation = txtStartDate.Text; blnThereIsAProblem = TheDataValidationClass.VerifyDateData(strValueForValidation); if (blnThereIsAProblem == true) { blnFatalError = true; strErrorMessage += "The Start Date is not a Date\n"; } else { gdatStartDate = Convert.ToDateTime(strValueForValidation); } strValueForValidation = txtEndDate.Text; blnThereIsAProblem = TheDataValidationClass.VerifyDateData(strValueForValidation); if (blnThereIsAProblem == true) { blnFatalError = true; strErrorMessage += "The End Date is not a Date\n"; } else { gdatEndDate = Convert.ToDateTime(strValueForValidation); gdatEndDate = TheDataSearchClass.AddingDays(gdatEndDate, 1); } if (gstrToolHistoryType == "Employee Search") { if (cboSelectEmployee.SelectedIndex == 0) { blnFatalError = true; strErrorMessage += "Employee Was Not Selected\n"; } } if (gstrToolHistoryType == "Tool ID Search") { strToolID = txtEnterLastName.Text; if (strToolID == "") { blnFatalError = true; strErrorMessage += "Tool ID Was Not Entered\n"; } } if (blnFatalError == true) { TheMessagesClass.ErrorMessage(strErrorMessage); return; } TheViewToolHistoryDataSet.toolhistory.Rows.Clear(); if (gstrToolHistoryType == "Date Range Search") { TheFindToolHistoryByDateRangeDataSet = TheToolHistoryClass.FindToolHistoryByDateRange(gdatStartDate, gdatEndDate); intNumberOfRecords = TheFindToolHistoryByDateRangeDataSet.FindToolHistoryByDateRange.Rows.Count - 1; if (intNumberOfRecords > -1) { for (intCounter = 0; intCounter <= intNumberOfRecords; intCounter++) { intWarehouseEmployee = TheFindToolHistoryByDateRangeDataSet.FindToolHistoryByDateRange[intCounter].WarehouseEmployeeID; TheFindEmployeeByEmployeeIDDataSet = TheEmployeeClass.FindEmployeeByEmployeeID(intWarehouseEmployee); strWarehouseEmployeeName = TheFindEmployeeByEmployeeIDDataSet.FindEmployeeByEmployeeID[0].FirstName + " " + TheFindEmployeeByEmployeeIDDataSet.FindEmployeeByEmployeeID[0].LastName; ViewToolHistoryDataSet.toolhistoryRow NewHistoryRow = TheViewToolHistoryDataSet.toolhistory.NewtoolhistoryRow(); NewHistoryRow.LastName = TheFindToolHistoryByDateRangeDataSet.FindToolHistoryByDateRange[intCounter].LastName; NewHistoryRow.Description = TheFindToolHistoryByDateRangeDataSet.FindToolHistoryByDateRange[intCounter].ToolDescription; NewHistoryRow.FirstName = TheFindToolHistoryByDateRangeDataSet.FindToolHistoryByDateRange[intCounter].FirstName; NewHistoryRow.ToolID = TheFindToolHistoryByDateRangeDataSet.FindToolHistoryByDateRange[intCounter].ToolID; NewHistoryRow.TransactionDate = TheFindToolHistoryByDateRangeDataSet.FindToolHistoryByDateRange[intCounter].TransactionDate; NewHistoryRow.TransactionID = TheFindToolHistoryByDateRangeDataSet.FindToolHistoryByDateRange[intCounter].TransactionID; NewHistoryRow.TransactionNotes = TheFindToolHistoryByDateRangeDataSet.FindToolHistoryByDateRange[intCounter].TransactionNotes; NewHistoryRow.WarehouseEmployee = strWarehouseEmployeeName; TheViewToolHistoryDataSet.toolhistory.Rows.Add(NewHistoryRow); } } } else if (gstrToolHistoryType == "Employee Search") { TheFindToolHistoryByEmployeeIDDataSet = TheToolHistoryClass.FindToolHistoryByEmployeeID(gdatStartDate, gdatEndDate, MainWindow.gintEmployeeID); intNumberOfRecords = TheFindToolHistoryByEmployeeIDDataSet.FindToolHistoryByEmployeeID.Rows.Count - 1; if (intNumberOfRecords > -1) { for (intCounter = 0; intCounter <= intNumberOfRecords; intCounter++) { intWarehouseEmployee = TheFindToolHistoryByEmployeeIDDataSet.FindToolHistoryByEmployeeID[intCounter].WarehouseEmployeeID; TheFindEmployeeByEmployeeIDDataSet = TheEmployeeClass.FindEmployeeByEmployeeID(intWarehouseEmployee); strWarehouseEmployeeName = TheFindEmployeeByEmployeeIDDataSet.FindEmployeeByEmployeeID[0].FirstName + " " + TheFindEmployeeByEmployeeIDDataSet.FindEmployeeByEmployeeID[0].LastName; ViewToolHistoryDataSet.toolhistoryRow NewHistoryRow = TheViewToolHistoryDataSet.toolhistory.NewtoolhistoryRow(); NewHistoryRow.LastName = TheFindToolHistoryByEmployeeIDDataSet.FindToolHistoryByEmployeeID[intCounter].LastName; NewHistoryRow.Description = TheFindToolHistoryByEmployeeIDDataSet.FindToolHistoryByEmployeeID[intCounter].ToolDescription; NewHistoryRow.FirstName = TheFindToolHistoryByEmployeeIDDataSet.FindToolHistoryByEmployeeID[intCounter].FirstName; NewHistoryRow.ToolID = TheFindToolHistoryByEmployeeIDDataSet.FindToolHistoryByEmployeeID[intCounter].ToolID; NewHistoryRow.TransactionDate = TheFindToolHistoryByEmployeeIDDataSet.FindToolHistoryByEmployeeID[intCounter].TransactionDate; NewHistoryRow.TransactionID = TheFindToolHistoryByEmployeeIDDataSet.FindToolHistoryByEmployeeID[intCounter].TransactionID; NewHistoryRow.TransactionNotes = TheFindToolHistoryByEmployeeIDDataSet.FindToolHistoryByEmployeeID[intCounter].TransactionNotes; NewHistoryRow.WarehouseEmployee = strWarehouseEmployeeName; TheViewToolHistoryDataSet.toolhistory.Rows.Add(NewHistoryRow); } } } else if (gstrToolHistoryType == "Tool ID Search") { TheFindActiveToolByToolIDDataSet = TheToolsClass.FindActiveToolByToolID(strToolID); intNumberOfRecords = TheFindActiveToolByToolIDDataSet.FindActiveToolByToolID.Rows.Count; if (intNumberOfRecords == 0) { TheMessagesClass.ErrorMessage("The Tool is not Active or Does Not Exist"); return; } MainWindow.gintToolKey = TheFindActiveToolByToolIDDataSet.FindActiveToolByToolID[0].ToolKey; TheFindToolHistoryByToolKeyDataSet = TheToolHistoryClass.FindToolHistoryByToolKey(gdatStartDate, gdatEndDate, MainWindow.gintToolKey); intNumberOfRecords = TheFindToolHistoryByToolKeyDataSet.FindToolHistoryByToolKey.Rows.Count - 1; if (intNumberOfRecords > -1) { for (intCounter = 0; intCounter <= intNumberOfRecords; intCounter++) { intWarehouseEmployee = TheFindToolHistoryByToolKeyDataSet.FindToolHistoryByToolKey[intCounter].WarehouseEmployeeID; TheFindEmployeeByEmployeeIDDataSet = TheEmployeeClass.FindEmployeeByEmployeeID(intWarehouseEmployee); strWarehouseEmployeeName = TheFindEmployeeByEmployeeIDDataSet.FindEmployeeByEmployeeID[0].FirstName + " " + TheFindEmployeeByEmployeeIDDataSet.FindEmployeeByEmployeeID[0].LastName; ViewToolHistoryDataSet.toolhistoryRow NewHistoryRow = TheViewToolHistoryDataSet.toolhistory.NewtoolhistoryRow(); NewHistoryRow.LastName = TheFindToolHistoryByToolKeyDataSet.FindToolHistoryByToolKey[intCounter].LastName; NewHistoryRow.Description = TheFindToolHistoryByToolKeyDataSet.FindToolHistoryByToolKey[intCounter].ToolDescription; NewHistoryRow.FirstName = TheFindToolHistoryByToolKeyDataSet.FindToolHistoryByToolKey[intCounter].FirstName; NewHistoryRow.ToolID = TheFindToolHistoryByToolKeyDataSet.FindToolHistoryByToolKey[intCounter].ToolID; NewHistoryRow.TransactionDate = TheFindToolHistoryByToolKeyDataSet.FindToolHistoryByToolKey[intCounter].TransactionDate; NewHistoryRow.TransactionID = TheFindToolHistoryByToolKeyDataSet.FindToolHistoryByToolKey[intCounter].TransactionID; NewHistoryRow.TransactionNotes = TheFindToolHistoryByToolKeyDataSet.FindToolHistoryByToolKey[intCounter].TransactionNotes; NewHistoryRow.WarehouseEmployee = strWarehouseEmployeeName; TheViewToolHistoryDataSet.toolhistory.Rows.Add(NewHistoryRow); } } } dgrResults.ItemsSource = TheViewToolHistoryDataSet.toolhistory; } catch (Exception Ex) { TheEventLogClass.InsertEventLogEntry(DateTime.Now, "Blue Jay ERP // Tool History // Find Button " + Ex.Message); TheMessagesClass.ErrorMessage(Ex.ToString()); } }
private void ResetControls() { int intCounter; int intNumberOfRecords; int intEmployeeID; int intProjectID; DateTime datTransactionDate; bool blnFatalError = false; int intRecordsReturned; int intManagerID; string strManagerName; int intSecondCounter; decimal decReportHours; PleaseWait PleaseWait = new PleaseWait(); PleaseWait.Show(); try { TheEmployeeDriveTimeDataSet.employeedrivetime.Rows.Clear(); TheFindEmployeeProjectAssignmentDriveTimeHoursDataSet = TheEmployeeProjectAssignmentClass.FindEmployeeProjectAssignmentDriveTimeHours(); intNumberOfRecords = TheFindEmployeeProjectAssignmentDriveTimeHoursDataSet.FindEmployeeProjectAssignmentDriveTimeHours.Rows.Count; if (intNumberOfRecords > 0) { for (intCounter = 0; intCounter < intNumberOfRecords; intCounter++) { intEmployeeID = TheFindEmployeeProjectAssignmentDriveTimeHoursDataSet.FindEmployeeProjectAssignmentDriveTimeHours[intCounter].EmployeeID; intProjectID = TheFindEmployeeProjectAssignmentDriveTimeHoursDataSet.FindEmployeeProjectAssignmentDriveTimeHours[intCounter].ProjectID; datTransactionDate = TheFindEmployeeProjectAssignmentDriveTimeHoursDataSet.FindEmployeeProjectAssignmentDriveTimeHours[intCounter].TransactionDate; TheFindEmployeeByEmployeeIDDataSet = TheEmployeeClass.FindEmployeeByEmployeeID(intEmployeeID); intManagerID = TheFindEmployeeByEmployeeIDDataSet.FindEmployeeByEmployeeID[0].ManagerID; TheFindEmployeeByEmployeeIDDataSet = TheEmployeeClass.FindEmployeeByEmployeeID(intManagerID); strManagerName = TheFindEmployeeByEmployeeIDDataSet.FindEmployeeByEmployeeID[0].FirstName + " "; strManagerName += TheFindEmployeeByEmployeeIDDataSet.FindEmployeeByEmployeeID[0].LastName; TheFindEmployeeProjectAssignmentForComparisonDataSet = TheEmployeeProjectAssignmentClass.FindEmployeeProjectAssignmentForComparison(intEmployeeID, intProjectID, datTransactionDate); intRecordsReturned = TheFindEmployeeProjectAssignmentForComparisonDataSet.FindEmployeeProjectAssignmentforComparison.Rows.Count; if (intRecordsReturned < 1) { EmployeeDriveTimeDataSet.employeedrivetimeRow NewEmployeeRow = TheEmployeeDriveTimeDataSet.employeedrivetime.NewemployeedrivetimeRow(); NewEmployeeRow.BlueJayProjectID = TheFindEmployeeProjectAssignmentDriveTimeHoursDataSet.FindEmployeeProjectAssignmentDriveTimeHours[intCounter].AssignedProjectID; NewEmployeeRow.CustomerProjectID = TheFindEmployeeProjectAssignmentDriveTimeHoursDataSet.FindEmployeeProjectAssignmentDriveTimeHours[intCounter].CustomerAssignedID; NewEmployeeRow.FirstName = TheFindEmployeeProjectAssignmentDriveTimeHoursDataSet.FindEmployeeProjectAssignmentDriveTimeHours[intCounter].FirstName; NewEmployeeRow.LastName = TheFindEmployeeProjectAssignmentDriveTimeHoursDataSet.FindEmployeeProjectAssignmentDriveTimeHours[intCounter].LastName; NewEmployeeRow.Manager = strManagerName; NewEmployeeRow.ProjectName = TheFindEmployeeProjectAssignmentDriveTimeHoursDataSet.FindEmployeeProjectAssignmentDriveTimeHours[intCounter].ProjectName; NewEmployeeRow.TotalHours = TheFindEmployeeProjectAssignmentDriveTimeHoursDataSet.FindEmployeeProjectAssignmentDriveTimeHours[intCounter].TotalHours; NewEmployeeRow.TransactionDate = datTransactionDate; TheEmployeeDriveTimeDataSet.employeedrivetime.Rows.Add(NewEmployeeRow); } else if (intRecordsReturned > 0) { decReportHours = 0; for (intSecondCounter = 0; intSecondCounter < intRecordsReturned; intSecondCounter++) { decReportHours += TheFindEmployeeProjectAssignmentForComparisonDataSet.FindEmployeeProjectAssignmentforComparison[intSecondCounter].TotalHours; } if (decReportHours == 0) { EmployeeDriveTimeDataSet.employeedrivetimeRow NewEmployeeRow = TheEmployeeDriveTimeDataSet.employeedrivetime.NewemployeedrivetimeRow(); NewEmployeeRow.BlueJayProjectID = TheFindEmployeeProjectAssignmentDriveTimeHoursDataSet.FindEmployeeProjectAssignmentDriveTimeHours[intCounter].AssignedProjectID; NewEmployeeRow.CustomerProjectID = TheFindEmployeeProjectAssignmentDriveTimeHoursDataSet.FindEmployeeProjectAssignmentDriveTimeHours[intCounter].CustomerAssignedID; NewEmployeeRow.FirstName = TheFindEmployeeProjectAssignmentDriveTimeHoursDataSet.FindEmployeeProjectAssignmentDriveTimeHours[intCounter].FirstName; NewEmployeeRow.LastName = TheFindEmployeeProjectAssignmentDriveTimeHoursDataSet.FindEmployeeProjectAssignmentDriveTimeHours[intCounter].LastName; NewEmployeeRow.Manager = strManagerName; NewEmployeeRow.ProjectName = TheFindEmployeeProjectAssignmentDriveTimeHoursDataSet.FindEmployeeProjectAssignmentDriveTimeHours[intCounter].ProjectName; NewEmployeeRow.TotalHours = TheFindEmployeeProjectAssignmentDriveTimeHoursDataSet.FindEmployeeProjectAssignmentDriveTimeHours[intCounter].TotalHours; NewEmployeeRow.TransactionDate = datTransactionDate; TheEmployeeDriveTimeDataSet.employeedrivetime.Rows.Add(NewEmployeeRow); } } } } dgrResults.ItemsSource = TheEmployeeDriveTimeDataSet.employeedrivetime; } catch (Exception Ex) { TheEventLogClass.InsertEventLogEntry(DateTime.Now, "New Blue Jay ERP // Drive Time Analysis " + Ex.Message); TheMessagesClass.ErrorMessage(Ex.ToString()); } PleaseWait.Close(); }
private void LoadMaterialDataSet() { //setting local variables //int intRecordsReturned; //bool blnItemNotFound = true; int intCounter; int intNumberOfRecords; int intReportCounter; bool blnItemFound; int intPartID; int intQuantity; int intWarehouseID; decimal decCost; decimal decTotalCost; try { TheProjectMaterialReportDataSet.projectmaterial.Rows.Clear(); gintReportCounter = 0; gintReportUpperLimit = 0; TheFindIssuedPartsByProjectIDDataSet = TheIssuePartsClass.FindIssuedPartsByProjectID(MainWindow.gintProjectID); intNumberOfRecords = TheFindIssuedPartsByProjectIDDataSet.FindIssuedPartsByProjectID.Rows.Count - 1; if (intNumberOfRecords > -1) { for (intCounter = 0; intCounter <= intNumberOfRecords; intCounter++) { blnItemFound = false; intPartID = TheFindIssuedPartsByProjectIDDataSet.FindIssuedPartsByProjectID[intCounter].PartID; intQuantity = TheFindIssuedPartsByProjectIDDataSet.FindIssuedPartsByProjectID[intCounter].Quantity; if (gintReportCounter > 0) { for (intReportCounter = 0; intReportCounter <= gintReportUpperLimit; intReportCounter++) { if (intPartID == TheProjectMaterialReportDataSet.projectmaterial[intReportCounter].PartID) { TheProjectMaterialReportDataSet.projectmaterial[intReportCounter].Issued += intQuantity; blnItemFound = true; } } } if (blnItemFound == false) { ProjectMaterialReportDataSet.projectmaterialRow NewPartRow = TheProjectMaterialReportDataSet.projectmaterial.NewprojectmaterialRow(); NewPartRow.PartDescription = TheFindIssuedPartsByProjectIDDataSet.FindIssuedPartsByProjectID[intCounter].PartDescription; NewPartRow.Issued = intQuantity; NewPartRow.JDEPartNumber = TheFindIssuedPartsByProjectIDDataSet.FindIssuedPartsByProjectID[intCounter].JDEPartNumber; NewPartRow.PartID = TheFindIssuedPartsByProjectIDDataSet.FindIssuedPartsByProjectID[intCounter].PartID; NewPartRow.PartNumber = TheFindIssuedPartsByProjectIDDataSet.FindIssuedPartsByProjectID[intCounter].PartNumber; NewPartRow.Cost = 0; intWarehouseID = TheFindIssuedPartsByProjectIDDataSet.FindIssuedPartsByProjectID[intCounter].WarehouseID; TheFindEmployeeByEmployeeIDDataSet = TheEmployeeClass.FindEmployeeByEmployeeID(intWarehouseID); NewPartRow.Warehouse = TheFindEmployeeByEmployeeIDDataSet.FindEmployeeByEmployeeID[0].FirstName; TheProjectMaterialReportDataSet.projectmaterial.Rows.Add(NewPartRow); gintReportUpperLimit = gintReportCounter; gintReportCounter++; } } } gdecTotalCost = 0; intNumberOfRecords = TheProjectMaterialReportDataSet.projectmaterial.Rows.Count - 1; for (intCounter = 0; intCounter <= intNumberOfRecords; intCounter++) { intQuantity = TheProjectMaterialReportDataSet.projectmaterial[intCounter].Issued; intPartID = TheProjectMaterialReportDataSet.projectmaterial[intCounter].PartID; TheFindPartByPartIDDataSet = ThePartNumberClass.FindPartByPartID(intPartID); decCost = Convert.ToDecimal(TheFindPartByPartIDDataSet.FindPartByPartID[0].Price); decTotalCost = intQuantity * decCost; decTotalCost = Math.Round(decTotalCost, 2); TheProjectMaterialReportDataSet.projectmaterial[intCounter].Cost = decTotalCost; gdecTotalCost += decTotalCost; } txtProjectCost.Text = Convert.ToString(gdecTotalCost); dgrResults.ItemsSource = TheProjectMaterialReportDataSet.projectmaterial; } catch (Exception Ex) { TheEventLogClass.InsertEventLogEntry(DateTime.Now, "Inventory Reports // Project Report // Search Button " + Ex.Message); TheMessagesClass.ErrorMessage(Ex.ToString()); } }
private void SendOverdueProjectReport() { int intCounter; int intNumberOfRecords; string strEmailAddress = "*****@*****.**"; DateTime datTransactionDate = DateTime.Now; string strCustomer; string strCustomerAssignedID; string strAssignedProjectID; string strProjectName; string strDateReceived; string strECDDate; string strAssignedOffice; string strStatus; int intWarehouseID; string strHeader = "BJC Overdue Projects Report"; string strMessage; bool blnFatalError; try { datTransactionDate = TheDateSearchClass.AddingDays(datTransactionDate, 3); TheFindOverDueProductionProjectsDataSet = TheProductionProjectClass.FindOverdueProductionProjects(datTransactionDate); strMessage = "<h1>" + strHeader + " - Do Not Reply</h1>"; strMessage += "<table>"; strMessage += "<tr>"; strMessage += "<td>Customer</td>"; strMessage += "<td>Custoner Project ID</td>"; strMessage += "<td>BJC Project ID</td>"; strMessage += "<td>Project Name</td>"; strMessage += "<td>Date Received</td>"; strMessage += "<td>ECD Date</td>"; strMessage += "<td>Assigned Office</td>"; strMessage += "<td>Status</td>"; strMessage += "</tr>"; strMessage += "<p> </p>"; intNumberOfRecords = TheFindOverDueProductionProjectsDataSet.FindOverdueOpenProductionProjects.Rows.Count; if(intNumberOfRecords > 0) { for(intCounter = 0; intCounter < intNumberOfRecords; intCounter++) { strCustomer = TheFindOverDueProductionProjectsDataSet.FindOverdueOpenProductionProjects[intCounter].Customer; strCustomerAssignedID = TheFindOverDueProductionProjectsDataSet.FindOverdueOpenProductionProjects[intCounter].CustomerAssignedID; strAssignedProjectID = TheFindOverDueProductionProjectsDataSet.FindOverdueOpenProductionProjects[intCounter].AssignedProjectID; strProjectName = TheFindOverDueProductionProjectsDataSet.FindOverdueOpenProductionProjects[intCounter].ProjectName; strDateReceived = Convert.ToString(TheFindOverDueProductionProjectsDataSet.FindOverdueOpenProductionProjects[intCounter].DateReceived); strECDDate = Convert.ToString(TheFindOverDueProductionProjectsDataSet.FindOverdueOpenProductionProjects[intCounter].ECDDate); strStatus = TheFindOverDueProductionProjectsDataSet.FindOverdueOpenProductionProjects[intCounter].WorkOrderStatus; intWarehouseID = TheFindOverDueProductionProjectsDataSet.FindOverdueOpenProductionProjects[intCounter].AssignedOfficeID; TheFindEmployeeByEmployeeIDDataSet = TheEmployeeClass.FindEmployeeByEmployeeID(intWarehouseID); strAssignedOffice = TheFindEmployeeByEmployeeIDDataSet.FindEmployeeByEmployeeID[0].FirstName; strMessage += "<tr>"; strMessage += "<td>" + strCustomer + "</td>"; strMessage += "<td>" + strCustomerAssignedID + "</td>"; strMessage += "<td>" + strAssignedProjectID + "</td>"; strMessage += "<td>" + strProjectName + "</td>"; strMessage += "<td>" + strDateReceived + "</td>"; strMessage += "<td>" + strECDDate + "</td>"; strMessage += "<td>" + strAssignedOffice + "</td>"; strMessage += "<td>" + strStatus + "</td>"; strMessage += "</tr>"; } } strMessage += "</table>"; blnFatalError = TheSendEmailClass.SendEmail(strEmailAddress, strHeader, strMessage); if (blnFatalError == true) throw new Exception(); } catch (Exception Ex) { TheEventLogClass.InsertEventLogEntry(DateTime.Now, "Event Log Tracker // Send Overdue Project Report " + Ex.Message); TheMessagesClass.ErrorMessage(Ex.ToString()); } }
private void expImportExcel_Expanded(object sender, RoutedEventArgs e) { //setting up local variables string strValueForValidation = ""; int intEmployeeID = 0; bool blnFatalError = false; bool blnThereIsAProblem = false; string strErrorMessage = ""; int intRecordsReturned; string strAssignedProjectID = ""; string strCustomerProjectID = ""; int intProjectID = 0; DateTime datTransactionDate = DateTime.Now; int intSecondProjectID = 0; int intColumnRange = 0; int intCounter; int intNumberOfRecords; bool blnDoNotImport; Excel.Application xlDropOrder; Excel.Workbook xlDropBook; Excel.Worksheet xlDropSheet; Excel.Range range; try { expImportExcel.IsExpanded = false; if (cboSelectDepartment.SelectedIndex < 1) { blnFatalError = true; strErrorMessage += "The Department Was Not Selected\n"; } if (cboSelectOffice.SelectedIndex < 1) { blnFatalError = true; strErrorMessage += "The Office Was Not Selected\n"; } strValueForValidation = txtEmployeeID.Text; blnThereIsAProblem = TheDataValidationClass.VerifyIntegerData(strValueForValidation); if (blnThereIsAProblem == true) { blnFatalError = true; strErrorMessage += "The Employee ID Was Not An Integer\n"; } else { intEmployeeID = Convert.ToInt32(strValueForValidation); TheFindEmployeeByEmployeeIDDataSet = TheEmployeeClass.FindEmployeeByEmployeeID(intEmployeeID); intRecordsReturned = TheFindEmployeeByEmployeeIDDataSet.FindEmployeeByEmployeeID.Rows.Count; if (intRecordsReturned == 0) { blnFatalError = true; strErrorMessage += "Employee Was Not Found\n"; } } if (blnFatalError == true) { TheMessagesClass.ErrorMessage(strErrorMessage); return; } TheImportProjectsDataSet.importprojects.Rows.Clear(); 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 = 1; intCounter <= intNumberOfRecords; intCounter++) { strCustomerProjectID = Convert.ToString((range.Cells[intCounter, 1] as Excel.Range).Value2).ToUpper(); strAssignedProjectID = Convert.ToString((range.Cells[intCounter, 2] as Excel.Range).Value2).ToUpper(); intProjectID = 0; intSecondProjectID = 0; blnDoNotImport = false; TheFindProjectByAssignedProjectIDDataSet = TheProjectClass.FindProjectByAssignedProjectID(strCustomerProjectID); if (TheFindProjectByAssignedProjectIDDataSet.FindProjectByAssignedProjectID.Rows.Count > 0) { intProjectID = TheFindProjectByAssignedProjectIDDataSet.FindProjectByAssignedProjectID[0].ProjectID; } TheFindProjectByAssignedProjectIDDataSet = TheProjectClass.FindProjectByAssignedProjectID(strAssignedProjectID); if (TheFindProjectByAssignedProjectIDDataSet.FindProjectByAssignedProjectID.Rows.Count > 0) { intSecondProjectID = TheFindProjectByAssignedProjectIDDataSet.FindProjectByAssignedProjectID[0].ProjectID; } TheFindProjectMatrixByCustomerProjectIDDataSet = TheProjectMatrixClass.FindProjectMatrixByCustomerProjectID(strCustomerProjectID); if (TheFindProjectMatrixByCustomerProjectIDDataSet.FindProjectMatrixByCustomerProjectID.Rows.Count > 0) { if (TheFindProjectMatrixByCustomerProjectIDDataSet.FindProjectMatrixByCustomerProjectID[0].AssignedProjectID == strAssignedProjectID) { blnDoNotImport = true; } } if (intProjectID == 0) { if (intSecondProjectID != 0) { intProjectID = intSecondProjectID; } } if ((intProjectID == 0) && intSecondProjectID == 0) { blnFatalError = TheProjectClass.InsertProject(strCustomerProjectID, strCustomerProjectID); if (blnFatalError == true) { throw new Exception(); } TheFindProjectByAssignedProjectIDDataSet = TheProjectClass.FindProjectByAssignedProjectID(strCustomerProjectID); intProjectID = TheFindProjectByAssignedProjectIDDataSet.FindProjectByAssignedProjectID[0].ProjectID; } ImportProjectsDataSet.importprojectsRow NewProjectRow = TheImportProjectsDataSet.importprojects.NewimportprojectsRow(); NewProjectRow.AssignedProjectID = strAssignedProjectID; NewProjectRow.CustomerProjectID = strCustomerProjectID; NewProjectRow.DepartmentID = gintDepartmentID; NewProjectRow.EmployeeID = intEmployeeID; NewProjectRow.ProjectID = intProjectID; NewProjectRow.SecondProjectID = intSecondProjectID; NewProjectRow.TransactionDate = DateTime.Now; NewProjectRow.WarehouseID = gintOfficeID; NewProjectRow.DoNotImport = blnDoNotImport; TheImportProjectsDataSet.importprojects.Rows.Add(NewProjectRow); } PleaseWait.Close(); dgrProjects.ItemsSource = TheImportProjectsDataSet.importprojects; } catch (Exception Ex) { TheEventLogClass.InsertEventLogEntry(DateTime.Now, "Import Projects // Main Window // Import Excel Expander " + Ex.Message); TheMessagesClass.ErrorMessage(Ex.ToString()); } }