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 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;
decimal decHours;
decimal decLaborCosts;
try
{
strProjectID = txtEnterProjectID.Text;
TheCompleteProjectInfoDataSet.projectinfo.Rows.Clear();
MainWindow.ProjectMaterialWindow.Visibility = Visibility.Hidden;
gdecTotalHours = 0;
gdecTotalLaborCosts = 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;
TheFindProjectHoursTotalDataSet = TheEmployeeProjectAssignmentClass.FindProjectHoursTotal(MainWindow.gintProjectID);
intNumberOfRecords = TheFindProjectHoursTotalDataSet.FindProjectHourTotals.Rows.Count - 1;
intSecondNumberOfRecords = 0;
if (intNumberOfRecords > -1)
{
for (intCounter = 0; intCounter <= intNumberOfRecords; intCounter++)
{
blnItemFound = false;
decHours = TheFindProjectHoursTotalDataSet.FindProjectHourTotals[intCounter].TotalHours;
decLaborCosts = TheFindProjectHoursTotalDataSet.FindProjectHourTotals[intCounter].TotalEmployeeCost;
gdecTotalHours += decHours;
gdecTotalLaborCosts += decLaborCosts;
datTransactionDate = TheFindProjectHoursTotalDataSet.FindProjectHourTotals[intCounter].TransactionDate;
strWorkTask = TheFindProjectHoursTotalDataSet.FindProjectHourTotals[intCounter].WorkTask;
if (intSecondNumberOfRecords > 0)
{
for (intSecondCounter = 0; intSecondCounter < intSecondNumberOfRecords; intSecondCounter++)
{
if (strWorkTask == TheCompleteProjectInfoDataSet.projectinfo[intSecondCounter].WorkTask)
{
if (datTransactionDate == TheCompleteProjectInfoDataSet.projectinfo[intSecondCounter].TransactionDate)
{
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 (datTransactionDate == TheFindSpecificProjectWorkTaskDataSet.FindSpecificProjectWorkTask[intSecondCounter].TransactionDate)
{
intFootage += Convert.ToInt32(TheFindSpecificProjectWorkTaskDataSet.FindSpecificProjectWorkTask[intSecondCounter].FootagePieces);
}
}
TheCompleteProjectInfoDataSet.projectinfo[intCounter].FootagePieces = intFootage;
}
dgrResults.ItemsSource = TheCompleteProjectInfoDataSet.projectinfo;
txtTotalHours.Text = Convert.ToString(gdecTotalHours);
txtLaborCost.Text = Convert.ToString(gdecTotalLaborCosts);
MainWindow.ProjectMaterialWindow.Visibility = Visibility.Visible;
}
catch (Exception Ex)
{
TheEventLogClass.InsertEventLogEntry(DateTime.Now, "Blue Jay ERP // Total Project Information // Generate Report Menu Item " + Ex.Message);
TheMessagesClass.ErrorMessage(Ex.ToString());
}
}