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());
}
}
