private void ResetControls()
{
//setting local variables
DateTime datStartDate = Convert.ToDateTime("01/01/1900");
cboSelectEmployee.Items.Clear();
cboSelectEmployee.Visibility = Visibility.Hidden;
lblSelectEmployee.Visibility = Visibility.Hidden;
txtEnterLastName.Text = "";
txtEnterLastName.Visibility = Visibility.Hidden;
lblEnterLastName.Visibility = Visibility.Hidden;
cboSelectReportType.Items.Clear();
cboSelectReportType.Items.Add("Select Report Type");
cboSelectReportType.Items.Add("Design Department Productivity");
cboSelectReportType.Items.Add("Design Employee Productivity");
cboSelectReportType.Items.Add("Employee WOV Report");
cboSelectReportType.Items.Add("Department WOV Report");
cboSelectReportType.SelectedIndex = 0;
txtStartDate.Text = "";
txtEndDate.Text = "";
TheFindDesignTotalDepartmentProductivityDataSet = TheDesignProductivityClass.FindDesignTotalDepartmentProductivity(datStartDate, datStartDate);
dgrResults.ItemsSource = TheFindDesignTotalDepartmentProductivityDataSet.FindDesignTotalDepartmentProductivity;
}
public FindDesignTotalDepartmentProductivityDataSet FindDesignTotalDepartmentProductivity(DateTime datStartDate, DateTime datEndDate)
{
try
{
aFindDesignTotalDepartmentProductivityDataSet = new FindDesignTotalDepartmentProductivityDataSet();
aFindDesignTotalDepartmentProductivityTableAdapter = new FindDesignTotalDepartmentProductivityDataSetTableAdapters.FindDesignTotalDepartmentProductivityTableAdapter();
aFindDesignTotalDepartmentProductivityTableAdapter.Fill(aFindDesignTotalDepartmentProductivityDataSet.FindDesignTotalDepartmentProductivity, datStartDate, datEndDate);
}
catch (Exception Ex)
{
TheEventLogClass.InsertEventLogEntry(DateTime.Now, "Design Productivity Class // Find Design Total Department Productivity " + Ex.Message);
}
return(aFindDesignTotalDepartmentProductivityDataSet);
}
private void MitGenerateReport_Click(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
{
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);
}
}
dgrResults.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);
}
}
dgrResults.ItemsSource = TheDesignEmployeeProductivityDataSet.designemployeeproductivity;
}
else if (gstrReportType == "WOV")
{
TheFindDesignEmployeeWOVCountDataSet = TheDesignProjectsSurveyorClass.FindDesignEmployeeWOVCount(MainWindow.gintEmployeeID, gdatStartDate, gdatEndDate);
dgrResults.ItemsSource = TheFindDesignEmployeeWOVCountDataSet.FindDesignEmployeeWOVCount;
}
else if (gstrReportType == "DEPARTMENTWOV")
{
TheFindDesignDepartmentWOVCountDataSet = TheDesignProjectsSurveyorClass.FindDesignDepartmentWOVCount(gdatStartDate, gdatEndDate);
dgrResults.ItemsSource = TheFindDesignDepartmentWOVCountDataSet.FindDesignDepartmentWOVCount;
}
}
catch (Exception Ex)
{
TheEventLogClass.InsertEventLogEntry(DateTime.Now, "Blue Jay ERP // Design Employee Productivity // Generate Report Button " + Ex.Message);
TheMessagesClass.ErrorMessage(Ex.ToString());
}
}
