private void LoadControls()
{
//setting local variables
DateTime datTransactionDate = DateTime.Now;
int intRecordsReturned;
datTransactionDate = TheDateSearchClass.AddingDays(datTransactionDate, 3);
TheFindTotalOverdueProductionProjectsDataSet = TheProductionProjectClass.FindTotalOverdueProductionProjects(datTransactionDate);
intRecordsReturned = TheFindTotalOverdueProductionProjectsDataSet.FindTotalOverdueProductionProjects.Rows.Count;
if (intRecordsReturned < 1)
{
txtTotalOverdueProjects.Text = "0";
}
else if (intRecordsReturned > 0)
{
txtTotalOverdueProjects.Text = Convert.ToString(TheFindTotalOverdueProductionProjectsDataSet.FindTotalOverdueProductionProjects[0].TotalOpen);
}
TheFindTotalOverdueProjectStatusDataSet = TheProductionProjectClass.FindTotalOverdueProjectStatus(datTransactionDate);
dgrTotalProjects.ItemsSource = TheFindTotalOverdueProjectStatusDataSet.FindTotalOverdueProjectsStatus;
TheFindOverdueProjectsByOfficeBusinessDataSet = TheProductionProjectClass.FindOverdueProjectsByOfficeBusiness(datTransactionDate);
dgrOfficeOverdue.ItemsSource = TheFindOverdueProjectsByOfficeBusinessDataSet.FindOverdueProjectsByOfficeBusiness;
ComputeTotalDays();
FindTopOverdueProjects();
}
private void ComputeTotalDays()
{
DateTime datStartDate = DateTime.Now;
DateTime datEndDate = DateTime.Now;
int intCounter;
int intNumberOfRecords;
int intSecondCounter;
string strOffice;
string strDepartment;
int intTotalCount;
bool blnItemFound;
try
{
TheAgedOverdueProjectsDataSet.agedoverdueprojects.Rows.Clear();
gintCounter = 0;
gintNumberOfRecords = 0;
datStartDate = TheDateSearchClass.SubtractingDays(datStartDate, 30);
datEndDate = TheDateSearchClass.AddingDays(datEndDate, 3);
TheFindOverdueProjectsByDateRangeDataSet = TheProductionProjectClass.FindOverdueProjectsByDateRange(datStartDate, datEndDate);
intNumberOfRecords = TheFindOverdueProjectsByDateRangeDataSet.FindOverdueProjectsByDateRange.Rows.Count;
if (intNumberOfRecords > 0)
{
for (intCounter = 0; intCounter < intNumberOfRecords; intCounter++)
{
strOffice = TheFindOverdueProjectsByDateRangeDataSet.FindOverdueProjectsByDateRange[intCounter].Office;
strDepartment = TheFindOverdueProjectsByDateRangeDataSet.FindOverdueProjectsByDateRange[intCounter].Department;
intTotalCount = TheFindOverdueProjectsByDateRangeDataSet.FindOverdueProjectsByDateRange[intCounter].TotalProjects;
blnItemFound = false;
if (gintCounter > 0)
{
for (intSecondCounter = 0; intSecondCounter < gintNumberOfRecords; intSecondCounter++)
{
if (TheAgedOverdueProjectsDataSet.agedoverdueprojects[intSecondCounter].Office == strOffice)
{
if (TheAgedOverdueProjectsDataSet.agedoverdueprojects[intSecondCounter].BusinessLine == strDepartment)
{
blnItemFound = true;
TheAgedOverdueProjectsDataSet.agedoverdueprojects[intSecondCounter].LessThan30 += intTotalCount;
}
}
}
}
if (blnItemFound == false)
{
AgedOverdueProjectsDataSet.agedoverdueprojectsRow NewProjectRow = TheAgedOverdueProjectsDataSet.agedoverdueprojects.NewagedoverdueprojectsRow();
NewProjectRow.Between30and60 = 0;
NewProjectRow.BusinessLine = strDepartment;
NewProjectRow.LessThan30 = intTotalCount;
NewProjectRow.Office = strOffice;
NewProjectRow.Over60 = 0;
TheAgedOverdueProjectsDataSet.agedoverdueprojects.Rows.Add(NewProjectRow);
gintNumberOfRecords = gintCounter;
gintCounter++;
}
}
}
datEndDate = datStartDate;
datStartDate = TheDateSearchClass.SubtractingDays(datStartDate, 30);
TheFindOverdueProjectsByDateRangeDataSet = TheProductionProjectClass.FindOverdueProjectsByDateRange(datStartDate, datEndDate);
intNumberOfRecords = TheFindOverdueProjectsByDateRangeDataSet.FindOverdueProjectsByDateRange.Rows.Count;
if (intNumberOfRecords > 0)
{
for (intCounter = 0; intCounter < intNumberOfRecords; intCounter++)
{
strOffice = TheFindOverdueProjectsByDateRangeDataSet.FindOverdueProjectsByDateRange[intCounter].Office;
strDepartment = TheFindOverdueProjectsByDateRangeDataSet.FindOverdueProjectsByDateRange[intCounter].Department;
intTotalCount = TheFindOverdueProjectsByDateRangeDataSet.FindOverdueProjectsByDateRange[intCounter].TotalProjects;
blnItemFound = false;
if (gintCounter > 0)
{
for (intSecondCounter = 0; intSecondCounter < gintNumberOfRecords; intSecondCounter++)
{
if (TheAgedOverdueProjectsDataSet.agedoverdueprojects[intSecondCounter].Office == strOffice)
{
if (TheAgedOverdueProjectsDataSet.agedoverdueprojects[intSecondCounter].BusinessLine == strDepartment)
{
blnItemFound = true;
TheAgedOverdueProjectsDataSet.agedoverdueprojects[intSecondCounter].Between30and60 += intTotalCount;
}
}
}
}
if (blnItemFound == false)
{
AgedOverdueProjectsDataSet.agedoverdueprojectsRow NewProjectRow = TheAgedOverdueProjectsDataSet.agedoverdueprojects.NewagedoverdueprojectsRow();
NewProjectRow.Between30and60 = intTotalCount;
NewProjectRow.BusinessLine = strDepartment;
NewProjectRow.LessThan30 = 0;
NewProjectRow.Office = strOffice;
NewProjectRow.Over60 = 0;
TheAgedOverdueProjectsDataSet.agedoverdueprojects.Rows.Add(NewProjectRow);
gintNumberOfRecords = gintCounter;
gintCounter++;
}
}
}
TheFindOverdueProjectsByOfficeBusinessDataSet = TheProductionProjectClass.FindOverdueProjectsByOfficeBusiness(datStartDate);
intNumberOfRecords = TheFindOverdueProjectsByOfficeBusinessDataSet.FindOverdueProjectsByOfficeBusiness.Rows.Count;
if (intNumberOfRecords > 0)
{
for (intCounter = 0; intCounter < intNumberOfRecords; intCounter++)
{
strOffice = TheFindOverdueProjectsByOfficeBusinessDataSet.FindOverdueProjectsByOfficeBusiness[intCounter].Office;
strDepartment = TheFindOverdueProjectsByOfficeBusinessDataSet.FindOverdueProjectsByOfficeBusiness[intCounter].Department;
intTotalCount = TheFindOverdueProjectsByOfficeBusinessDataSet.FindOverdueProjectsByOfficeBusiness[intCounter].TotalProjects;
blnItemFound = false;
if (gintCounter > 0)
{
for (intSecondCounter = 0; intSecondCounter < gintNumberOfRecords; intSecondCounter++)
{
if (TheAgedOverdueProjectsDataSet.agedoverdueprojects[intSecondCounter].Office == strOffice)
{
if (TheAgedOverdueProjectsDataSet.agedoverdueprojects[intSecondCounter].BusinessLine == strDepartment)
{
blnItemFound = true;
TheAgedOverdueProjectsDataSet.agedoverdueprojects[intSecondCounter].Over60 += intTotalCount;
}
}
}
}
if (blnItemFound == false)
{
AgedOverdueProjectsDataSet.agedoverdueprojectsRow NewProjectRow = TheAgedOverdueProjectsDataSet.agedoverdueprojects.NewagedoverdueprojectsRow();
NewProjectRow.Between30and60 = 0;
NewProjectRow.BusinessLine = strDepartment;
NewProjectRow.LessThan30 = 0;
NewProjectRow.Office = strOffice;
NewProjectRow.Over60 = intTotalCount;
TheAgedOverdueProjectsDataSet.agedoverdueprojects.Rows.Add(NewProjectRow);
gintNumberOfRecords = gintCounter;
gintCounter++;
}
}
}
dgrAgedOverdue.ItemsSource = TheAgedOverdueProjectsDataSet.agedoverdueprojects;
}
catch (Exception Ex)
{
TheEventLogClass.InsertEventLogEntry(DateTime.Now, "New Blue Jay ERP // Overdue Projects Dashboard " + Ex.Message);
TheMessagesClass.ErrorMessage(Ex.ToString());
}
}
