public FindProjectHoursDataSet FindProjectHours(int intProjectID, DateTime datStartDate)
{
try
{
aFindProjectHoursDataSet = new FindProjectHoursDataSet();
aFindProjectHoursTableAdapter = new FindProjectHoursDataSetTableAdapters.FindProjectHoursTableAdapter();
aFindProjectHoursTableAdapter.Fill(aFindProjectHoursDataSet.FindProjectHours, intProjectID, datStartDate);
}
catch (Exception Ex)
{
TheEventLogClass.InsertEventLogEntry(DateTime.Now, "Employee Project Assignment Class // Find Project Hours " + Ex.Message);
}
return(aFindProjectHoursDataSet);
}
private void mitGenerateReport_Click(object sender, RoutedEventArgs e)
{
//setting local variables
string strProjectID;
int intRecordsReturned;
int intCounter;
int intNumberOfRecords;
DateTime datTransactionDate;
string strWorkTask;
int intSecondCounter;
int intSecondNumberOfRecords;
bool blnItemFound;
int intFootage;
int intSummaryCounter;
decimal decHours;
decimal decLaborCosts;
DateTime datStartDate = DateTime.Now;
PleaseWait PleaseWait = new PleaseWait();
PleaseWait.Show();
try
{
strProjectID = txtEnterProjectID.Text;
TheCompleteProjectInfoDataSet.projectinfo.Rows.Clear();
TheProjectWorkSummaryDataSet.worksummary.Rows.Clear();
gintSummaryCounter = 0;
gintSummaryUpperLimit = 0;
gdecTotalHours = 0;
gdecLaborCosts = 0;
TheFindProjectByAssignedProjectIDDataSet = TheProjectClass.FindProjectByAssignedProjectID(strProjectID);
intRecordsReturned = TheFindProjectByAssignedProjectIDDataSet.FindProjectByAssignedProjectID.Rows.Count;
if (intRecordsReturned == 0)
{
TheMessagesClass.ErrorMessage("Project Not Found");
return;
}
MainWindow.gintProjectID = TheFindProjectByAssignedProjectIDDataSet.FindProjectByAssignedProjectID[0].ProjectID;
datStartDate = TheDateSearchClass.SubtractingDays(datStartDate, 1500);
TheFindProjectHoursDataSet = TheEmployeeProjectAssignmentClass.FindProjectHours(MainWindow.gintProjectID, datStartDate);
intNumberOfRecords = TheFindProjectHoursDataSet.FindProjectHours.Rows.Count - 1;
intSecondNumberOfRecords = 0;
if (intNumberOfRecords > -1)
{
for (intCounter = 0; intCounter <= intNumberOfRecords; intCounter++)
{
blnItemFound = false;
gdecTotalHours += TheFindProjectHoursDataSet.FindProjectHours[intCounter].TotalHours;
gdecLaborCosts += TheFindProjectHoursDataSet.FindProjectHours[intCounter].TotalEmployeeCost;
datTransactionDate = TheFindProjectHoursDataSet.FindProjectHours[intCounter].TransactionDate;
strWorkTask = TheFindProjectHoursDataSet.FindProjectHours[intCounter].WorkTask;
decHours = TheFindProjectHoursDataSet.FindProjectHours[intCounter].TotalHours;
decLaborCosts = TheFindProjectHoursDataSet.FindProjectHours[intCounter].TotalEmployeeCost;
if (intSecondNumberOfRecords > 0)
{
for (intSecondCounter = 0; intSecondCounter < intSecondNumberOfRecords; intSecondCounter++)
{
if (strWorkTask == TheCompleteProjectInfoDataSet.projectinfo[intSecondCounter].WorkTask)
{
if (datTransactionDate == TheCompleteProjectInfoDataSet.projectinfo[intSecondCounter].TransactionDate)
{
TheCompleteProjectInfoDataSet.projectinfo[intSecondCounter].Hours += decHours;
TheCompleteProjectInfoDataSet.projectinfo[intSecondCounter].LaborCosts += decLaborCosts;
blnItemFound = true;
}
}
}
}
if (blnItemFound == false)
{
CompleteProjectInfoDataSet.projectinfoRow NewTaskRow = TheCompleteProjectInfoDataSet.projectinfo.NewprojectinfoRow();
NewTaskRow.FootagePieces = 0;
NewTaskRow.TransactionDate = datTransactionDate;
NewTaskRow.WorkTask = strWorkTask;
NewTaskRow.Hours = decHours;
NewTaskRow.LaborCosts = decLaborCosts;
TheCompleteProjectInfoDataSet.projectinfo.Rows.Add(NewTaskRow);
intSecondNumberOfRecords++;
}
}
}
intNumberOfRecords = TheCompleteProjectInfoDataSet.projectinfo.Rows.Count - 1;
for (intCounter = 0; intCounter <= intNumberOfRecords; intCounter++)
{
intFootage = 0;
strWorkTask = TheCompleteProjectInfoDataSet.projectinfo[intCounter].WorkTask;
datTransactionDate = TheCompleteProjectInfoDataSet.projectinfo[intCounter].TransactionDate;
TheFindWorkTaskByWorkTaskDataSet = TheWorkTaskClass.FindWorkTaskByWorkTask(strWorkTask);
MainWindow.gintWorkTaskID = TheFindWorkTaskByWorkTaskDataSet.FindWorkTaskByWorkTask[0].WorkTaskID;
TheFindSpecificProjectWorkTaskDataSet = TheProjectTaskClass.FindSpecificProjectWorkTask(MainWindow.gintProjectID, MainWindow.gintWorkTaskID);
intSecondNumberOfRecords = TheFindSpecificProjectWorkTaskDataSet.FindSpecificProjectWorkTask.Rows.Count - 1;
for (intSecondCounter = 0; intSecondCounter <= intSecondNumberOfRecords; intSecondCounter++)
{
if (TheCompleteProjectInfoDataSet.projectinfo[intCounter].FootagePieces == 0)
{
if (datTransactionDate == TheFindSpecificProjectWorkTaskDataSet.FindSpecificProjectWorkTask[intSecondCounter].TransactionDate)
{
intFootage = Convert.ToInt32(TheFindSpecificProjectWorkTaskDataSet.FindSpecificProjectWorkTask[intSecondCounter].FootagePieces);
TheCompleteProjectInfoDataSet.projectinfo[intCounter].FootagePieces = intFootage;
}
}
}
}
intNumberOfRecords = TheCompleteProjectInfoDataSet.projectinfo.Rows.Count - 1;
for (intCounter = 0; intCounter <= intNumberOfRecords; intCounter++)
{
blnItemFound = false;
strWorkTask = TheCompleteProjectInfoDataSet.projectinfo[intCounter].WorkTask;
if (gintSummaryCounter > 0)
{
for (intSummaryCounter = 0; intSummaryCounter <= gintSummaryUpperLimit; intSummaryCounter++)
{
if (strWorkTask == TheProjectWorkSummaryDataSet.worksummary[intSummaryCounter].WorkTask)
{
TheProjectWorkSummaryDataSet.worksummary[intSummaryCounter].FootagePieces += TheCompleteProjectInfoDataSet.projectinfo[intCounter].FootagePieces;
TheProjectWorkSummaryDataSet.worksummary[intSummaryCounter].Hours += TheCompleteProjectInfoDataSet.projectinfo[intCounter].Hours;
blnItemFound = true;
}
}
}
if (blnItemFound == false)
{
ProjectWorkSummaryDataSet.worksummaryRow NewTaskRow = TheProjectWorkSummaryDataSet.worksummary.NewworksummaryRow();
NewTaskRow.FootagePieces = TheCompleteProjectInfoDataSet.projectinfo[intCounter].FootagePieces;
NewTaskRow.WorkTask = strWorkTask;
NewTaskRow.Hours = TheCompleteProjectInfoDataSet.projectinfo[intCounter].Hours;
NewTaskRow.LaborCosts = TheCompleteProjectInfoDataSet.projectinfo[intCounter].LaborCosts;
TheProjectWorkSummaryDataSet.worksummary.Rows.Add(NewTaskRow);
gintSummaryUpperLimit = gintSummaryCounter;
gintSummaryCounter++;
}
}
dgrResults.ItemsSource = TheProjectWorkSummaryDataSet.worksummary;
txtTotalHours.Text = Convert.ToString(gdecTotalHours);
txtLaborCosts.Text = Convert.ToString(gdecLaborCosts);
PleaseWait.Close();
}
catch (Exception Ex)
{
PleaseWait.Close();
TheEventLogClass.InsertEventLogEntry(DateTime.Now, "Blue Jay ERP // Find Project Hours // Generate Report Menu Item " + Ex.Message);
TheMessagesClass.ErrorMessage(Ex.ToString());
}
}
private void Window_Loaded(object sender, RoutedEventArgs e)
{
//setting up the local variables
int intCounter;
int intNumberOfRecords;
int intProjectID;
DateTime datTransactionDate = DateTime.Now;
try
{
datTransactionDate = TheDateSearchClass.RemoveTime(datTransactionDate);
datTransactionDate = TheDateSearchClass.SubtractingDays(datTransactionDate, 31);
TheFindProjectByAssignedProjectIDDataSet = TheProjectClass.FindProjectByAssignedProjectID("SHOP");
intProjectID = TheFindProjectByAssignedProjectIDDataSet.FindProjectByAssignedProjectID[0].ProjectID;
TheFindProjectHoursDataSet = TheEmployeeProjectAssignmentClass.FindProjectHours(intProjectID, datTransactionDate);
TheFindProjectStatsDataSet = TheEmployeeProductivityStatsClass.FindProjectStats(intProjectID);
intNumberOfRecords = TheFindProjectHoursDataSet.FindProjectHours.Rows.Count - 1;
gdecMean = TheFindProjectStatsDataSet.FindProjectStats[0].AveHours;
gdecStandDeviation = Convert.ToDecimal(TheFindProjectStatsDataSet.FindProjectStats[0].HoursSTDev);
gdecVariance = Convert.ToDecimal(TheFindProjectStatsDataSet.FindProjectStats[0].HoursVariance);
gdecTotalHours = Convert.ToDecimal(TheFindProjectStatsDataSet.FindProjectStats[0].TotalHours);
gdecMean = Math.Round(gdecMean, 4);
txtAverageHours.Text = Convert.ToString(gdecMean);
gdecVariance = Math.Round(gdecVariance, 4);
gdecStandDeviation = Math.Round(gdecStandDeviation, 4);
gdecUpperBound = gdecMean + gdecStandDeviation;
txtUpperBound.Text = Convert.ToString(gdecUpperBound);
for (intCounter = 0; intCounter <= intNumberOfRecords; intCounter++)
{
if (TheFindProjectHoursDataSet.FindProjectHours[intCounter].TransactionDate > datTransactionDate)
{
if (TheFindProjectHoursDataSet.FindProjectHours[intCounter].TotalHours > gdecUpperBound)
{
ShopViolatorDataSet.violatorRow NewViolatorRow = TheShopViolatorDataSet.violator.NewviolatorRow();
NewViolatorRow.FirstName = TheFindProjectHoursDataSet.FindProjectHours[intCounter].FirstName;
NewViolatorRow.LastName = TheFindProjectHoursDataSet.FindProjectHours[intCounter].LastName;
NewViolatorRow.Hours = TheFindProjectHoursDataSet.FindProjectHours[intCounter].TotalHours;
NewViolatorRow.TransactionDate = TheFindProjectHoursDataSet.FindProjectHours[intCounter].TransactionDate;
NewViolatorRow.HomeOffice = TheFindProjectHoursDataSet.FindProjectHours[intCounter].HomeOffice;
TheShopViolatorDataSet.violator.Rows.Add(NewViolatorRow);
}
}
}
dgrResults.ItemsSource = TheShopViolatorDataSet.violator;
gdecProjectHours = gdecMean * 5 * 52;
txtProjectHours.Text = Convert.ToString(gdecProjectHours);
gdecProjectCost = gdecProjectHours * 12;
txtProjectedCost.Text = Convert.ToString(gdecProjectCost);
}
catch (Exception Ex)
{
TheEventLogClass.InsertEventLogEntry(DateTime.Now, "Blue Jay ERP // Shop Hours Analysis // Window Loaded " + 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();
}
