public FindProjectHoursAboveLimitDataSet FindProjectHoursAboveLimit(int intProjectID, DateTime datStartDate, decimal decUpperLimit)
{
try
{
aFindProjectHoursAboveLimitDataSet = new FindProjectHoursAboveLimitDataSet();
aFindProjectHoursAboveLimitTableAdapter = new FindProjectHoursAboveLimitDataSetTableAdapters.FindProjectHoursAboveLimitTableAdapter();
aFindProjectHoursAboveLimitTableAdapter.Fill(aFindProjectHoursAboveLimitDataSet.FindProjectHoursAboveLimit, intProjectID, datStartDate, decUpperLimit);
}
catch (Exception Ex)
{
TheEventLogClass.InsertEventLogEntry(DateTime.Now, "Employee Project Assignement Class // Find Project Hours Above Limit " + Ex.Message);
}
return(aFindProjectHoursAboveLimitDataSet);
}
private void ResetControls()
{
//setting up the local variables
int intCounter;
int intNumberOfRecords;
int intProjectID;
DateTime datTransactionDate = DateTime.Now;
DateTime datStartDate = DateTime.Now;
decimal decAveragePayRate;
try
{
PleaseWait PleaseWait = new PleaseWait();
PleaseWait.Show();
TheShopViolatorDataSet.violator.Rows.Clear();
datTransactionDate = TheDateSearchClass.RemoveTime(datTransactionDate);
datTransactionDate = TheDateSearchClass.SubtractingDays(datTransactionDate, 31);
TheFindProjectMatrixByAssignedProjectIDDataSet = TheProjectMatrixClass.FindProjectMatrixByAssignedProjectID("SHOP");
intProjectID = TheFindProjectMatrixByAssignedProjectIDDataSet.FindProjectMatrixByAssignedProjectID[0].ProjectID;
datStartDate = TheDateSearchClass.SubtractingDays(datStartDate, 31);
TheFindProjectStatsDataSet = TheEmployeeProductivityStatsClass.FindProjectStats(intProjectID);
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);
decAveragePayRate = TheFindProjectStatsDataSet.FindProjectStats[0].AveragePayRate;
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);
TheFindProjectHoursAboveLimitDataSet = TheEmployeeProjectAssignmentClass.FindProjectHoursAboveLimit(intProjectID, datStartDate, gdecUpperBound);
intNumberOfRecords = TheFindProjectHoursAboveLimitDataSet.FindProjectHoursAboveLimit.Rows.Count;
if (intNumberOfRecords > 0)
{
for (intCounter = 0; intCounter < intNumberOfRecords; intCounter++)
{
ShopViolatorDataSet.violatorRow NewViolatorRow = TheShopViolatorDataSet.violator.NewviolatorRow();
NewViolatorRow.FirstName = TheFindProjectHoursAboveLimitDataSet.FindProjectHoursAboveLimit[intCounter].FirstName;
NewViolatorRow.HomeOffice = TheFindProjectHoursAboveLimitDataSet.FindProjectHoursAboveLimit[intCounter].HomeOffice;
NewViolatorRow.Hours = TheFindProjectHoursAboveLimitDataSet.FindProjectHoursAboveLimit[intCounter].TotalHours;
NewViolatorRow.LastName = TheFindProjectHoursAboveLimitDataSet.FindProjectHoursAboveLimit[intCounter].LastName;
NewViolatorRow.TransactionDate = TheFindProjectHoursAboveLimitDataSet.FindProjectHoursAboveLimit[intCounter].TransactionDate;
TheShopViolatorDataSet.violator.Rows.Add(NewViolatorRow);
}
}
dgrResults.ItemsSource = TheShopViolatorDataSet.violator;
gdecProjectHours = TheFindProjectStatsDataSet.FindProjectStats[0].TotalHours;
txtShopHours.Text = Convert.ToString(gdecProjectHours);
gdecProjectCost = gdecProjectHours * decAveragePayRate;
gdecProjectCost = Math.Round(gdecProjectCost, 4);
txtProjectCost.Text = Convert.ToString(gdecProjectCost);
PleaseWait.Close();
}
catch (Exception Ex)
{
TheEventLogClass.InsertEventLogEntry(DateTime.Now, "New Blue Jay ERP // Shop Hours Analysis // Reset Controls " + Ex.Message);
TheMessagesClass.ErrorMessage(Ex.ToString());
}
}
