private void expCreateReport_Expanded(object sender, RoutedEventArgs e)
{
//setting local variables
string strValueForValidation;
bool blnFatalError = false;
bool blnThereIsAProblem = false;
string strErrorMessage = "";
int intCounter;
int intNumberOfRecords;
int intEmployeeID;
int intRecordsReturned;
decimal decTotalHours = 0;
try
{
expCreateReport.IsExpanded = false;
TheDesignDepartmentProductivityDataSet.designdepartmentproductivity.Rows.Clear();
TheDesignEmployeeProductivityDataSet.designemployeeproductivity.Rows.Clear();
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);
}
if ((gstrReportType == "EMPLOYEE") || (gstrReportType == "WOV"))
{
if (cboSelectEmployee.SelectedIndex < 1)
{
blnFatalError = true;
strErrorMessage += "The Employee Was Not Selected\n";
}
}
if (blnFatalError == true)
{
TheMessagesClass.ErrorMessage(strErrorMessage);
return;
}
if (gstrReportType == "DEPARTMENT")
{
TheFindDesignTotalDepartmentProductivityDataSet = TheDesignProductivityClass.FindDesignTotalDepartmentProductivity(gdatStartDate, gdatEndDate);
intNumberOfRecords = TheFindDesignTotalDepartmentProductivityDataSet.FindDesignTotalDepartmentProductivity.Rows.Count - 1;
if (intNumberOfRecords > -1)
{
for (intCounter = 0; intCounter <= intNumberOfRecords; intCounter++)
{
decTotalHours = 0;
intEmployeeID = TheFindDesignTotalDepartmentProductivityDataSet.FindDesignTotalDepartmentProductivity[intCounter].EmployeeID;
TheFindEmployeeProductionHoursOverPayPeriodDataSet = TheEmployeeProjectAssignmentClass.FindEmployeeProductionHoursOverPayPeriodDataSet(intEmployeeID, gdatStartDate, gdatEndDate);
intRecordsReturned = TheFindEmployeeProductionHoursOverPayPeriodDataSet.FindEmployeeProductionHoursOverPayPeriod.Rows.Count;
if (intRecordsReturned > 0)
{
decTotalHours = TheFindEmployeeProductionHoursOverPayPeriodDataSet.FindEmployeeProductionHoursOverPayPeriod[0].ProductionHours;
}
decTotalHours += TheFindDesignTotalDepartmentProductivityDataSet.FindDesignTotalDepartmentProductivity[intCounter].TotalHours;
DesignDepartmentProductivityDataSet.designdepartmentproductivityRow NewProductivityRow = TheDesignDepartmentProductivityDataSet.designdepartmentproductivity.NewdesigndepartmentproductivityRow();
NewProductivityRow.FirstName = TheFindDesignTotalDepartmentProductivityDataSet.FindDesignTotalDepartmentProductivity[intCounter].FirstName;
NewProductivityRow.LastName = TheFindDesignTotalDepartmentProductivityDataSet.FindDesignTotalDepartmentProductivity[intCounter].LastName;
NewProductivityRow.HomeOffice = TheFindDesignTotalDepartmentProductivityDataSet.FindDesignTotalDepartmentProductivity[intCounter].HomeOffice;
NewProductivityRow.TotalHours = decTotalHours;
TheDesignDepartmentProductivityDataSet.designdepartmentproductivity.Rows.Add(NewProductivityRow);
}
}
dgrEmployees.ItemsSource = TheDesignDepartmentProductivityDataSet.designdepartmentproductivity;
gblnDepartment = true;
}
else if (gstrReportType == "EMPLOYEE")
{
TheFindDesignEmployeeTotalHoursDataSet = TheDesignProductivityClass.FindDesignEmployeeTotalHours(MainWindow.gintEmployeeID, gdatStartDate, gdatEndDate);
intNumberOfRecords = TheFindDesignEmployeeTotalHoursDataSet.FindDesignEmployeeTotalHours.Rows.Count - 1;
if (intNumberOfRecords > -1)
{
for (intCounter = 0; intCounter <= intNumberOfRecords; intCounter++)
{
for (intCounter = 0; intCounter <= intNumberOfRecords; intCounter++)
{
DesignEmployeeProductivityDataSet.designemployeeproductivityRow NewProductivityRow = TheDesignEmployeeProductivityDataSet.designemployeeproductivity.NewdesignemployeeproductivityRow();
NewProductivityRow.AssignedProjectID = TheFindDesignEmployeeTotalHoursDataSet.FindDesignEmployeeTotalHours[intCounter].AssignedProjectID;
NewProductivityRow.ProjectName = TheFindDesignEmployeeTotalHoursDataSet.FindDesignEmployeeTotalHours[intCounter].ProjectName;
NewProductivityRow.TaskID = TheFindDesignEmployeeTotalHoursDataSet.FindDesignEmployeeTotalHours[intCounter].TaskID;
NewProductivityRow.TotalHours = TheFindDesignEmployeeTotalHoursDataSet.FindDesignEmployeeTotalHours[intCounter].TotalHours;
NewProductivityRow.WorkTask = TheFindDesignEmployeeTotalHoursDataSet.FindDesignEmployeeTotalHours[intCounter].WorkTask;
TheDesignEmployeeProductivityDataSet.designemployeeproductivity.Rows.Add(NewProductivityRow);
}
}
}
TheFindEmployeeTaskTotalHoursDataSet = TheEmployeeProjectAssignmentClass.FindEmployeeTaskTotalHours(MainWindow.gintEmployeeID, gdatStartDate, gdatEndDate);
intNumberOfRecords = TheFindEmployeeTaskTotalHoursDataSet.FindEmployeeTaskTotalHours.Rows.Count - 1;
if (intNumberOfRecords > -1)
{
for (intCounter = 0; intCounter <= intNumberOfRecords; intCounter++)
{
DesignEmployeeProductivityDataSet.designemployeeproductivityRow NewProductivityRow = TheDesignEmployeeProductivityDataSet.designemployeeproductivity.NewdesignemployeeproductivityRow();
NewProductivityRow.AssignedProjectID = TheFindEmployeeTaskTotalHoursDataSet.FindEmployeeTaskTotalHours[intCounter].AssignedProjectID;
NewProductivityRow.ProjectName = TheFindEmployeeTaskTotalHoursDataSet.FindEmployeeTaskTotalHours[intCounter].ProjectName;
NewProductivityRow.TaskID = TheFindEmployeeTaskTotalHoursDataSet.FindEmployeeTaskTotalHours[intCounter].TaskID;
NewProductivityRow.TotalHours = TheFindEmployeeTaskTotalHoursDataSet.FindEmployeeTaskTotalHours[intCounter].TotalHours;
NewProductivityRow.WorkTask = TheFindEmployeeTaskTotalHoursDataSet.FindEmployeeTaskTotalHours[intCounter].WorkTask;
TheDesignEmployeeProductivityDataSet.designemployeeproductivity.Rows.Add(NewProductivityRow);
}
}
dgrEmployees.ItemsSource = TheDesignEmployeeProductivityDataSet.designemployeeproductivity;
}
else if (gstrReportType == "WOV")
{
TheFindDesignEmployeeWOVCountDataSet = TheDesignProjectsSurveyorClass.FindDesignEmployeeWOVCount(MainWindow.gintEmployeeID, gdatStartDate, gdatEndDate);
dgrEmployees.ItemsSource = TheFindDesignEmployeeWOVCountDataSet.FindDesignEmployeeWOVCount;
}
else if (gstrReportType == "DEPARTMENTWOV")
{
TheFindDesignDepartmentWOVCountDataSet = TheDesignProjectsSurveyorClass.FindDesignDepartmentWOVCount(gdatStartDate, gdatEndDate);
dgrEmployees.ItemsSource = TheFindDesignDepartmentWOVCountDataSet.FindDesignDepartmentWOVCount;
}
}
catch (Exception Ex)
{
TheEventLogClass.InsertEventLogEntry(DateTime.Now, "New Blue Jay ERP // Design Employee Productivity // Create Report Expander " + Ex.Message);
TheMessagesClass.ErrorMessage(Ex.ToString());
}
}
