public FindWorkTaskByTaskIDDataSet FindWorkTaskByWorkTaskID(int intWorkTaskID)
{
try
{
aFindWorkTaskByWorkTaskIDDataSet = new FindWorkTaskByTaskIDDataSet();
aFindWorkTaskByWorkTaskIDTableAdapter = new FindWorkTaskByTaskIDDataSetTableAdapters.FindWorkTaskByWorkTaskIDTableAdapter();
aFindWorkTaskByWorkTaskIDTableAdapter.Fill(aFindWorkTaskByWorkTaskIDDataSet.FindWorkTaskByWorkTaskID, intWorkTaskID);
}
catch (Exception Ex)
{
TheEventLogClass.InsertEventLogEntry(DateTime.Now, "Work Task Class // Find Work Task By Work Task ID " + Ex.Message);
}
return(aFindWorkTaskByWorkTaskIDDataSet);
}
private void cboSelectTask_SelectionChanged(object sender, SelectionChangedEventArgs e)
{
int intSelectedIndex;
try
{
intSelectedIndex = cboSelectTask.SelectedIndex - 1;
if (intSelectedIndex > -1)
{
MainWindow.gintWorkTaskID = TheFindWorkTaskByKeywoardDataSet.FindWorkTaskByTaskKeyword[0].WorkTaskID;
txtTotalCost.Text = Convert.ToString(TheFindWorkTaskByKeywoardDataSet.FindWorkTaskByTaskKeyword[intSelectedIndex].TaskCost);
txtWorkTask.Text = TheFindWorkTaskByKeywoardDataSet.FindWorkTaskByTaskKeyword[intSelectedIndex].WorkTask;
txtWorkTaskID.Text = Convert.ToString(MainWindow.gintWorkTaskID);
btnProcess.IsEnabled = true;
TheFindWorkTaskByTaskIDDataSet = TheWorkTaskClass.FindWorkTaskByWorkTaskID(MainWindow.gintWorkTaskID);
if (TheFindWorkTaskByTaskIDDataSet.FindWorkTaskByWorkTaskID[0].TaskActive == true)
{
cboSelectActive.SelectedIndex = 1;
}
else
{
cboSelectActive.SelectedIndex = 2;
}
}
}
catch (Exception Ex)
{
TheEventLogClass.InsertEventLogEntry(DateTime.Now, "New Blue Jay ERP // cbo Select Task Selection " + Ex.Message);
TheMessagesClass.ErrorMessage(Ex.ToString());
}
}
private void expImportExcel_Expanded(object sender, RoutedEventArgs e)
{
Excel.Application xlDropOrder;
Excel.Workbook xlDropBook;
Excel.Worksheet xlDropSheet;
Excel.Range range;
int intColumnRange = 0;
int intCounter;
int intNumberOfRecords;
int intWorkTaskID = 0;
string strWorkTask = "";
string strWorkTaskID = "";
string strBusinessLine;
string strBusinessLineID;
int intBusinessLineID;
string strDepartment;
int intDepartmentID;
int intDepartmentID2 = 0;
string strDepartment2 = "";
bool blnAll = false;
int intRecordsReturned;
try
{
expImportExcel.IsExpanded = false;
TheProductionCodesForImportDataSet.productioncodes.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 = 2; intCounter <= intNumberOfRecords; intCounter++)
{
blnAll = false;
strWorkTaskID = Convert.ToString((range.Cells[intCounter, 1] as Excel.Range).Value2).ToUpper();
strWorkTask = Convert.ToString((range.Cells[intCounter, 2] as Excel.Range).Value2).ToUpper();
intWorkTaskID = Convert.ToInt32(strWorkTaskID);
strBusinessLine = Convert.ToString((range.Cells[intCounter, 3] as Excel.Range).Value2).ToUpper();
strDepartment = Convert.ToString((range.Cells[intCounter, 4] as Excel.Range).Value2).ToUpper();
TheFindWorkTaskByTaskKeyWordDataSet = TheWorkTaskClass.FindWorkTaskByTaskKeyword(strWorkTask);
intRecordsReturned = TheFindWorkTaskByTaskKeyWordDataSet.FindWorkTaskByTaskKeyword.Rows.Count;
if (intRecordsReturned > 0)
{
intWorkTaskID = TheFindWorkTaskByTaskKeyWordDataSet.FindWorkTaskByTaskKeyword[0].WorkTaskID;
}
TheFindDepartmentByNameDataSet = TheDepartmentClass.FindDepartmentByName(strBusinessLine);
intBusinessLineID = TheFindDepartmentByNameDataSet.FindDepartmentByName[0].DepartmentID;
if (strDepartment == "ALL")
{
strDepartment = "AERIAL";
strDepartment2 = "UNDERGROUND";
blnAll = true;
}
TheFindDepartmentByNameDataSet = TheDepartmentClass.FindDepartmentByName(strDepartment);
intDepartmentID = TheFindDepartmentByNameDataSet.FindDepartmentByName[0].DepartmentID;
TheFindWorkTaskByTaskIDDataSet = TheWorkTaskClass.FindWorkTaskByWorkTaskID(intWorkTaskID);
ProductionCodesForImportDataSet.productioncodesRow NewProductionCode = TheProductionCodesForImportDataSet.productioncodes.NewproductioncodesRow();
NewProductionCode.BusinessLine = strBusinessLine;
NewProductionCode.BusinessLineID = intBusinessLineID;
NewProductionCode.Department = strDepartment;
NewProductionCode.DepartmentID = intDepartmentID;
NewProductionCode.WorkTask = strWorkTask;
NewProductionCode.WorkTaskID = intWorkTaskID;
TheProductionCodesForImportDataSet.productioncodes.Rows.Add(NewProductionCode);
if (blnAll == true)
{
TheFindDepartmentByNameDataSet = TheDepartmentClass.FindDepartmentByName(strDepartment2);
intDepartmentID2 = TheFindDepartmentByNameDataSet.FindDepartmentByName[0].DepartmentID;
ProductionCodesForImportDataSet.productioncodesRow NewProductionCode2 = TheProductionCodesForImportDataSet.productioncodes.NewproductioncodesRow();
NewProductionCode2.BusinessLine = strBusinessLine;
NewProductionCode2.BusinessLineID = intBusinessLineID;
NewProductionCode2.Department = strDepartment2;
NewProductionCode2.DepartmentID = intDepartmentID2;
NewProductionCode2.WorkTask = strWorkTask;
NewProductionCode2.WorkTaskID = intWorkTaskID;
TheProductionCodesForImportDataSet.productioncodes.Rows.Add(NewProductionCode2);
}
}
dgrProductionCodes.ItemsSource = TheProductionCodesForImportDataSet.productioncodes;
PleaseWait.Close();
}
catch (Exception Ex)
{
TheEventLogClass.InsertEventLogEntry(DateTime.Now, "New Blue Jay ERP // Import Codes for Sheets // Import Excel " + Ex.Message);
TheMessageClass.ErrorMessage(Ex.ToString());
}
}
private void Window_Loaded(object sender, RoutedEventArgs e)
{
//setting local variables
int intCounter;
int intNumberOfRecords;
int intProjectID = 0;
int intTaskID = 0;
decimal decTotalFootage = 0;
string strWorkTask = "";
string strAssignedProjectID = "";
bool blnItemFound;
int intSummaryCounter;
decimal decHours;
int intSecondCounter;
int intSecondNumberOfRecords;
PleaseWait PleaseWait = new PleaseWait();
PleaseWait.Show();
gdecTotalHours = 0;
try
{
TheFindEmployeeByEmployeeIDDataSet = TheEmployeeClass.FindEmployeeByEmployeeID(MainWindow.gintEmployeeID);
MainWindow.gstrFirstName = TheFindEmployeeByEmployeeIDDataSet.FindEmployeeByEmployeeID[0].FirstName;
MainWindow.gstrLastName = TheFindEmployeeByEmployeeIDDataSet.FindEmployeeByEmployeeID[0].LastName;
TheFindEmployeeTaskHoursByEmployeeIDDataSet = TheEmployeeProjectAssignmentClass.FindEmployeeTaskHoursByEmployeeID(MainWindow.gintEmployeeID, MainWindow.gdatStartDate, MainWindow.gdatEndDate);
intNumberOfRecords = TheFindEmployeeTaskHoursByEmployeeIDDataSet.FindEmployeeTaskHoursByEmployeeID.Rows.Count - 1;
gintSummaryCounter = 0;
gintSummaryNumberOfRecords = 0;
for (intCounter = 0; intCounter <= intNumberOfRecords; intCounter++)
{
gdecTotalHours += TheFindEmployeeTaskHoursByEmployeeIDDataSet.FindEmployeeTaskHoursByEmployeeID[intCounter].EmployeeTotalHours;
intProjectID = TheFindEmployeeTaskHoursByEmployeeIDDataSet.FindEmployeeTaskHoursByEmployeeID[intCounter].ProjectID;
intTaskID = TheFindEmployeeTaskHoursByEmployeeIDDataSet.FindEmployeeTaskHoursByEmployeeID[intCounter].TaskID;
decHours = TheFindEmployeeTaskHoursByEmployeeIDDataSet.FindEmployeeTaskHoursByEmployeeID[intCounter].EmployeeTotalHours;
blnItemFound = false;
TheFindProjectByProjectIDDataSet = TheProjectClass.FindProjectByProjectID(intProjectID);
strAssignedProjectID = TheFindProjectByProjectIDDataSet.FindProjectByProjectID[0].AssignedProjectID;
TheFindWorkTaskByTaskIDDataSet = TheWorkTaskClass.FindWorkTaskByWorkTaskID(intTaskID);
strWorkTask = TheFindWorkTaskByTaskIDDataSet.FindWorkTaskByWorkTaskID[0].WorkTask;
if (gintSummaryCounter > 0)
{
for (intSummaryCounter = 0; intSummaryCounter <= gintSummaryNumberOfRecords; intSummaryCounter++)
{
if (strAssignedProjectID == TheEmployeeProjectSummaryDataSet.projectsummary[intSummaryCounter].AssignedProjectID)
{
if (strWorkTask == TheEmployeeProjectSummaryDataSet.projectsummary[intSummaryCounter].WorkTask)
{
TheEmployeeProjectSummaryDataSet.projectsummary[intSummaryCounter].TotalHours += decHours;
blnItemFound = true;
}
}
}
}
if (blnItemFound == false)
{
EmployeeProjectSummaryDataSet.projectsummaryRow NewTaskRow = TheEmployeeProjectSummaryDataSet.projectsummary.NewprojectsummaryRow();
NewTaskRow.AssignedProjectID = strAssignedProjectID;
NewTaskRow.TotalFootagePieces = decTotalFootage;
NewTaskRow.TotalHours = decHours;
NewTaskRow.WorkTask = strWorkTask;
NewTaskRow.TaskID = intTaskID;
NewTaskRow.ProjectID = intProjectID;
TheEmployeeProjectSummaryDataSet.projectsummary.Rows.Add(NewTaskRow);
gintSummaryNumberOfRecords = gintSummaryCounter;
gintSummaryCounter++;
}
}
intNumberOfRecords = TheEmployeeProjectSummaryDataSet.projectsummary.Rows.Count - 1;
for (intCounter = 0; intCounter <= intNumberOfRecords; intCounter++)
{
intProjectID = TheEmployeeProjectSummaryDataSet.projectsummary[intCounter].ProjectID;
intTaskID = TheEmployeeProjectSummaryDataSet.projectsummary[intCounter].TaskID;
decTotalFootage = 0;
TheFindProjectTaskEmployeeStatsDataSet = TheEmployeeProductivityStatsClass.FindProjectTaskEmployeeStats(MainWindow.gintEmployeeID, intProjectID, MainWindow.gdatStartDate, MainWindow.gdatEndDate);
intSecondNumberOfRecords = TheFindProjectTaskEmployeeStatsDataSet.FindProjectTaskEmployeeStats.Rows.Count - 1;
if (intSecondNumberOfRecords > -1)
{
for (intSecondCounter = 0; intSecondCounter <= intSecondNumberOfRecords; intSecondCounter++)
{
if (intTaskID == TheFindProjectTaskEmployeeStatsDataSet.FindProjectTaskEmployeeStats[intSecondCounter].WorkTaskID)
{
decTotalFootage += TheFindProjectTaskEmployeeStatsDataSet.FindProjectTaskEmployeeStats[intSecondCounter].FootagePieces;
}
}
}
TheEmployeeProjectSummaryDataSet.projectsummary[intCounter].TotalFootagePieces = decTotalFootage;
}
txtTotalHours.Text = Convert.ToString(gdecTotalHours);
dgrResults.ItemsSource = TheEmployeeProjectSummaryDataSet.projectsummary;
}
catch (Exception Ex)
{
TheEventLogClass.InsertEventLogEntry(DateTime.Now, "Blue Jay ERP // Find Employee Hours // Generate Report Menu Item " + Ex.Message);
TheMessagesClass.ErrorMessage(Ex.ToString());
}
PleaseWait.Close();
}
private void expImportExcel_Expanded(object sender, RoutedEventArgs e)
{
Excel.Application xlDropOrder;
Excel.Workbook xlDropBook;
Excel.Worksheet xlDropSheet;
Excel.Range range;
int intColumnRange = 0;
int intCounter;
int intNumberOfRecords;
int intWorkTaskID = 0;
string strWorkTask = "";
string strWorkTaskID = "";
try
{
expImportExcel.IsExpanded = false;
TheImportEditedWorkTaskDataSet.worktask.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 = 2; intCounter <= intNumberOfRecords; intCounter++)
{
strWorkTaskID = Convert.ToString((range.Cells[intCounter, 1] as Excel.Range).Value2).ToUpper();
strWorkTask = Convert.ToString((range.Cells[intCounter, 2] as Excel.Range).Value2).ToUpper();
intWorkTaskID = Convert.ToInt32(strWorkTaskID);
TheFindWorkTaskByTaskIDDataSet = TheWorkTaskClass.FindWorkTaskByWorkTaskID(intWorkTaskID);
ImportEditedWorkTaskDataSet.worktaskRow NewWorkTask = TheImportEditedWorkTaskDataSet.worktask.NewworktaskRow();
NewWorkTask.WorkTask = strWorkTask;
NewWorkTask.WorkTaskID = intWorkTaskID;
NewWorkTask.CurrentWorkTask = TheFindWorkTaskByTaskIDDataSet.FindWorkTaskByWorkTaskID[0].WorkTask;
NewWorkTask.Replace = false;
TheImportEditedWorkTaskDataSet.worktask.Rows.Add(NewWorkTask);
}
dgrTasks.ItemsSource = TheImportEditedWorkTaskDataSet.worktask;
PleaseWait.Close();
}
catch (Exception Ex)
{
TheEventLogClass.InsertEventLogEntry(DateTime.Now, "New Blue Jay ERP // Import Production Codes // Import Excel " + Ex.Message);
TheMessagesClass.ErrorMessage(Ex.ToString());
}
}
private void dgrResults_SelectionChanged(object sender, SelectionChangedEventArgs e)
{
DataGrid dataGrid;
DataGridRow selectedRow;
DataGridCell WorkTask;
DataGridCell TransactionDate;
string strWorkTask;
string strTransactionDate;
DateTime datTransactionDate;
int intCounter;
int intNumberOfRecords;
try
{
if (dgrResults.SelectedIndex > -1)
{
//setting local variable
dataGrid = dgrResults;
selectedRow = (DataGridRow)dataGrid.ItemContainerGenerator.ContainerFromIndex(dataGrid.SelectedIndex);
WorkTask = (DataGridCell)dataGrid.Columns[3].GetCellContent(selectedRow).Parent;
TransactionDate = (DataGridCell)dataGrid.Columns[1].GetCellContent(selectedRow).Parent;
strWorkTask = ((TextBlock)WorkTask.Content).Text;
strTransactionDate = ((TextBlock)TransactionDate.Content).Text;
datTransactionDate = Convert.ToDateTime(strTransactionDate);
datTransactionDate = TheDataSearchClass.RemoveTime(datTransactionDate);
TheFindWorkTaskByWorkTaskDataSet = TheWorkTaskClass.FindWorkTaskByWorkTask(strWorkTask);
MainWindow.gintWorkTaskID = TheFindWorkTaskByWorkTaskDataSet.FindWorkTaskByWorkTask[0].WorkTaskID;
TheFindCrewProductivityForATaskDataSet = TheEmployeeCrewAssignmentClass.FindCrewProductivityForATask(MainWindow.gintProjectID, MainWindow.gintWorkTaskID, datTransactionDate, datTransactionDate);
intNumberOfRecords = TheFindCrewProductivityForATaskDataSet.FindCrewProductivtyForATask.Rows.Count - 1;
TheProjectEmployeeHoursDataSet.employees.Rows.Clear();
for (intCounter = 0; intCounter <= intNumberOfRecords; intCounter++)
{
MainWindow.gintWorkTaskID = TheFindCrewProductivityForATaskDataSet.FindCrewProductivtyForATask[intCounter].TaskID;
MainWindow.gintEmployeeID = TheFindCrewProductivityForATaskDataSet.FindCrewProductivtyForATask[intCounter].EmployeeID;
TheFindEmployeeByEmployeeIDDataSet = TheEmployeeClass.FindEmployeeByEmployeeID(MainWindow.gintEmployeeID);
TheFindWorkTaskByTaskIDDataSet = TheWorkTaskClass.FindWorkTaskByWorkTaskID(MainWindow.gintWorkTaskID);
ProjectEmployeeHoursDataSet.employeesRow NewEmployeeRow = TheProjectEmployeeHoursDataSet.employees.NewemployeesRow();
NewEmployeeRow.FirstName = TheFindEmployeeByEmployeeIDDataSet.FindEmployeeByEmployeeID[0].FirstName;
NewEmployeeRow.LastName = TheFindEmployeeByEmployeeIDDataSet.FindEmployeeByEmployeeID[0].LastName;
NewEmployeeRow.TotalHours = TheFindCrewProductivityForATaskDataSet.FindCrewProductivtyForATask[intCounter].EmployeeTotalHours;
NewEmployeeRow.TransactionDate = TheFindCrewProductivityForATaskDataSet.FindCrewProductivtyForATask[intCounter].TransactionDate;
NewEmployeeRow.WorkTask = TheFindWorkTaskByTaskIDDataSet.FindWorkTaskByWorkTaskID[0].WorkTask;
TheProjectEmployeeHoursDataSet.employees.Rows.Add(NewEmployeeRow);
}
dgrEmployees.ItemsSource = TheProjectEmployeeHoursDataSet.employees;
}
}
catch (Exception Ex)
{
TheEventLogClass.InsertEventLogEntry(DateTime.Now, "Blue Jay ERP // Send Vehicle To Shop // Grid Selection " + Ex.Message);
TheMessagesClass.ErrorMessage(Ex.ToString());
}
}
private void mitGenerateReport_Click(object sender, RoutedEventArgs e)
{
string strProjectID;
int intRecordsReturned;
int intCounter;
int intNumberOfRecords;
string strFirstName;
string strLastName;
DateTime datTransactionDate;
string strWorkTask;
int intSecondCounter;
int intSecondNumberOfRecords;
bool blnItemFound;
int intTaskCounter;
DateTime datStartDate = DateTime.Now;
PleaseWait PleaseWait = new PleaseWait();
PleaseWait.Show();
try
{
TheProjectDailyTaskDataSet.projecttask.Rows.Clear();
TheProjectEmployeeHoursDataSet.employees.Rows.Clear();
strProjectID = txtEnterProjectID.Text;
if (strProjectID == "")
{
TheMessagesClass.ErrorMessage("Project ID Was Not Entered");
PleaseWait.Close();
return;
}
gdecTotalHours = 0;
TheEmployeeCrewDataSet.employeework.Rows.Clear();
TheFindProjectByAssignedProjectIDDataSet = TheProjectClass.FindProjectByAssignedProjectID(strProjectID);
intRecordsReturned = TheFindProjectByAssignedProjectIDDataSet.FindProjectByAssignedProjectID.Rows.Count;
if (intRecordsReturned == 0)
{
TheMessagesClass.InformationMessage("Project Was Not Found");
PleaseWait.Close();
return;
}
MainWindow.gintProjectID = TheFindProjectByAssignedProjectIDDataSet.FindProjectByAssignedProjectID[0].ProjectID;
TheFindProjectTaskHoursByAssignedProjectIDDataSet = TheProjectTaskClass.FindProjectTaskHoursByAssignedProjectID(strProjectID);
datStartDate = TheDataSearchClass.SubtractingDays(datStartDate, 1200);
TheFindProjectHoursDataSet = TheEmployeeProjectAssignmentClass.FindProjectHours(MainWindow.gintProjectID, datStartDate);
intNumberOfRecords = TheFindProjectHoursDataSet.FindProjectHours.Rows.Count - 1;
intSecondNumberOfRecords = 0;
for (intCounter = 0; intCounter <= intNumberOfRecords; intCounter++)
{
strFirstName = TheFindProjectHoursDataSet.FindProjectHours[intCounter].FirstName;
strLastName = TheFindProjectHoursDataSet.FindProjectHours[intCounter].LastName;
strWorkTask = TheFindProjectHoursDataSet.FindProjectHours[intCounter].WorkTask;
datTransactionDate = TheFindProjectHoursDataSet.FindProjectHours[intCounter].TransactionDate;
blnItemFound = false;
gdecTotalHours += TheFindProjectHoursDataSet.FindProjectHours[intCounter].TotalHours;
if (intSecondNumberOfRecords > 0)
{
for (intSecondCounter = 0; intSecondCounter < intSecondNumberOfRecords; intSecondCounter++)
{
if (datTransactionDate == TheEmployeeCrewDataSet.employeework[intSecondCounter].TransactionDate)
{
if (strFirstName == TheEmployeeCrewDataSet.employeework[intSecondCounter].FirstName)
{
if (strLastName == TheEmployeeCrewDataSet.employeework[intSecondCounter].LastName)
{
if (strWorkTask == TheEmployeeCrewDataSet.employeework[intSecondCounter].WorkTask)
{
blnItemFound = true;
TheEmployeeCrewDataSet.employeework[intSecondCounter].Hours += TheFindProjectHoursDataSet.FindProjectHours[intCounter].TotalHours;
}
}
}
}
}
}
if (blnItemFound == false)
{
EmployeeCrewDataSet.employeeworkRow NewEmployeeRow = TheEmployeeCrewDataSet.employeework.NewemployeeworkRow();
NewEmployeeRow.AssignedProjectID = TheFindProjectByAssignedProjectIDDataSet.FindProjectByAssignedProjectID[0].AssignedProjectID;
NewEmployeeRow.Crew = "";
NewEmployeeRow.FirstName = strFirstName;
NewEmployeeRow.FootagePieces = 0;
NewEmployeeRow.Hours = TheFindProjectHoursDataSet.FindProjectHours[intCounter].TotalHours;
NewEmployeeRow.LastName = strLastName;
NewEmployeeRow.ProjectName = TheFindProjectByAssignedProjectIDDataSet.FindProjectByAssignedProjectID[0].ProjectName;
NewEmployeeRow.TransactionDate = datTransactionDate;
NewEmployeeRow.WorkTask = strWorkTask;
TheEmployeeCrewDataSet.employeework.Rows.Add(NewEmployeeRow);
intSecondNumberOfRecords++;
}
}
intNumberOfRecords = intSecondNumberOfRecords - 1;
for (intCounter = 0; intCounter <= intNumberOfRecords; intCounter++)
{
strFirstName = TheEmployeeCrewDataSet.employeework[intCounter].FirstName;
strLastName = TheEmployeeCrewDataSet.employeework[intCounter].LastName;
strWorkTask = TheEmployeeCrewDataSet.employeework[intCounter].WorkTask;
datTransactionDate = TheEmployeeCrewDataSet.employeework[intCounter].TransactionDate;
TheFindWorkTaskByWorkTaskDataSet = TheWorkTaskClass.FindWorkTaskByWorkTask(strWorkTask);
MainWindow.gintWorkTaskID = TheFindWorkTaskByWorkTaskDataSet.FindWorkTaskByWorkTask[0].WorkTaskID;
MainWindow.gintEmployeeID = FindEmployeeID(strFirstName, strLastName);
if (MainWindow.gintEmployeeID == -1)
{
throw new Exception();
}
TheFindProjectWorkTaskDataSet = TheProjectTaskClass.FindProjectWorkTask(MainWindow.gintProjectID, MainWindow.gintEmployeeID, MainWindow.gintWorkTaskID, datTransactionDate, datTransactionDate);
intSecondNumberOfRecords = TheFindProjectWorkTaskDataSet.FindProjectWorkTask.Rows.Count - 1;
for (intSecondCounter = 0; intSecondCounter <= intSecondNumberOfRecords; intSecondCounter++)
{
TheEmployeeCrewDataSet.employeework[intCounter].FootagePieces += TheFindProjectWorkTaskDataSet.FindProjectWorkTask[intSecondCounter].FootagePieces;
}
TheFindEmployeeCrewAssignmentByDateRange = TheEmployeeCrewAssignmentClass.FindEmployeeCrewAssignmentByDateRange(MainWindow.gintEmployeeID, datTransactionDate, datTransactionDate);
intSecondNumberOfRecords = TheFindEmployeeCrewAssignmentByDateRange.FindEmployeeCrewAssignmentByDateRange.Rows.Count - 1;
for (intSecondCounter = 0; intSecondCounter <= intSecondNumberOfRecords; intSecondCounter++)
{
if (strProjectID == TheFindEmployeeCrewAssignmentByDateRange.FindEmployeeCrewAssignmentByDateRange[intSecondCounter].AssignedProjectID)
{
TheEmployeeCrewDataSet.employeework[intCounter].Crew = TheFindEmployeeCrewAssignmentByDateRange.FindEmployeeCrewAssignmentByDateRange[intSecondCounter].CrewID;
}
}
}
intNumberOfRecords = TheEmployeeCrewDataSet.employeework.Rows.Count - 1;
gintTaskCounter = 0;
gintTaskUIpperLimit = 0;
for (intCounter = 0; intCounter <= intNumberOfRecords; intCounter++)
{
blnItemFound = false;
strWorkTask = TheEmployeeCrewDataSet.employeework[intCounter].WorkTask;
datTransactionDate = TheEmployeeCrewDataSet.employeework[intCounter].TransactionDate;
if (gintTaskCounter > 0)
{
for (intTaskCounter = 0; intTaskCounter <= gintTaskUIpperLimit; intTaskCounter++)
{
if (datTransactionDate == TheProjectDailyTaskDataSet.projecttask[intTaskCounter].TransactionDate)
{
if (strWorkTask == TheProjectDailyTaskDataSet.projecttask[intTaskCounter].WorkTask)
{
TheProjectDailyTaskDataSet.projecttask[intTaskCounter].Hours += TheEmployeeCrewDataSet.employeework[intCounter].Hours;
blnItemFound = true;
if (TheProjectDailyTaskDataSet.projecttask[intTaskCounter].Footage == 0)
{
TheProjectDailyTaskDataSet.projecttask[intTaskCounter].Footage = TheEmployeeCrewDataSet.employeework[intCounter].FootagePieces;
}
}
}
}
}
if (blnItemFound == false)
{
ProjectDailyTaskDataSet.projecttaskRow NewTaskRow = TheProjectDailyTaskDataSet.projecttask.NewprojecttaskRow();
NewTaskRow.Crew = TheEmployeeCrewDataSet.employeework[intCounter].Crew;
NewTaskRow.Footage = TheEmployeeCrewDataSet.employeework[intCounter].FootagePieces;
NewTaskRow.Hours = TheEmployeeCrewDataSet.employeework[intCounter].Hours;
NewTaskRow.TransactionDate = TheEmployeeCrewDataSet.employeework[intCounter].TransactionDate;
NewTaskRow.WorkTask = TheEmployeeCrewDataSet.employeework[intCounter].WorkTask;
TheProjectDailyTaskDataSet.projecttask.Rows.Add(NewTaskRow);
gintTaskUIpperLimit = gintTaskCounter;
gintTaskCounter++;
}
}
txtTotalHours.Text = Convert.ToString(gdecTotalHours);
intNumberOfRecords = TheFindProjectTaskHoursByAssignedProjectIDDataSet.FindProjectTaskHoursByAssignedProjectID.Rows.Count - 1;
for (intCounter = 0; intCounter <= intNumberOfRecords; intCounter++)
{
MainWindow.gintWorkTaskID = TheFindProjectTaskHoursByAssignedProjectIDDataSet.FindProjectTaskHoursByAssignedProjectID[intCounter].TaskID;
MainWindow.gintEmployeeID = TheFindProjectTaskHoursByAssignedProjectIDDataSet.FindProjectTaskHoursByAssignedProjectID[intCounter].EmployeeID;
TheFindEmployeeByEmployeeIDDataSet = TheEmployeeClass.FindEmployeeByEmployeeID(MainWindow.gintEmployeeID);
TheFindWorkTaskByTaskIDDataSet = TheWorkTaskClass.FindWorkTaskByWorkTaskID(MainWindow.gintWorkTaskID);
ProjectEmployeeHoursDataSet.employeesRow NewEmployeeRow = TheProjectEmployeeHoursDataSet.employees.NewemployeesRow();
NewEmployeeRow.FirstName = TheFindEmployeeByEmployeeIDDataSet.FindEmployeeByEmployeeID[0].FirstName;
NewEmployeeRow.LastName = TheFindEmployeeByEmployeeIDDataSet.FindEmployeeByEmployeeID[0].LastName;
NewEmployeeRow.TotalHours = TheFindProjectTaskHoursByAssignedProjectIDDataSet.FindProjectTaskHoursByAssignedProjectID[intCounter].EmployeeTotalHours;
NewEmployeeRow.TransactionDate = TheFindProjectTaskHoursByAssignedProjectIDDataSet.FindProjectTaskHoursByAssignedProjectID[intCounter].TransactionDate;
NewEmployeeRow.WorkTask = TheFindWorkTaskByTaskIDDataSet.FindWorkTaskByWorkTaskID[0].WorkTask;
TheProjectEmployeeHoursDataSet.employees.Rows.Add(NewEmployeeRow);
}
dgrResults.ItemsSource = TheProjectDailyTaskDataSet.projecttask;
dgrEmployees.ItemsSource = TheProjectEmployeeHoursDataSet.employees;
bool blnFatalError = TheEmployeeDateEntryClass.InsertIntoEmployeeDateEntry(MainWindow.TheVerifyLogonDataSet.VerifyLogon[0].EmployeeID, "Blue Jay ERP // Find Project Employee Hours // Generate Report Menu Item ");
}
catch (Exception Ex)
{
PleaseWait.Close();
TheEventLogClass.InsertEventLogEntry(DateTime.Now, "Blue Jay ERP // Find Project Employee Hours // Generate Report Menu Item " + Ex.Message);
TheMessagesClass.ErrorMessage(Ex.ToString());
}
PleaseWait.Close();
}
