private void ResetControls()
{
DateTime datTransactionDate = DateTime.Now;
int intCounter;
int intNumberOfRecords;
int intWarehouseID;
try
{
datTransactionDate = TheDateSearchClass.AddingDays(datTransactionDate, 3);
TheOverdueProjectReportDataSet.overdueprojectreport.Rows.Clear();
TheFindOverDueProductionProjectsDataSet = TheProductionProjectClass.FindOverdueProductionProjects(datTransactionDate);
intNumberOfRecords = TheFindOverDueProductionProjectsDataSet.FindOverdueOpenProductionProjects.Rows.Count;
if (intNumberOfRecords > 0)
{
for (intCounter = 0; intCounter < intNumberOfRecords; intCounter++)
{
intWarehouseID = TheFindOverDueProductionProjectsDataSet.FindOverdueOpenProductionProjects[intCounter].AssignedOfficeID;
TheFindEmployeeByEmployeeIDDataSet = TheEmployeeClass.FindEmployeeByEmployeeID(intWarehouseID);
OverdueProjectReportDataSet.overdueprojectreportRow NewProjectRow = TheOverdueProjectReportDataSet.overdueprojectreport.NewoverdueprojectreportRow();
NewProjectRow.AssignedOffice = TheFindEmployeeByEmployeeIDDataSet.FindEmployeeByEmployeeID[0].FirstName;
NewProjectRow.AssignedProjectID = TheFindOverDueProductionProjectsDataSet.FindOverdueOpenProductionProjects[intCounter].AssignedProjectID;
NewProjectRow.Customer = TheFindOverDueProductionProjectsDataSet.FindOverdueOpenProductionProjects[intCounter].Customer;
NewProjectRow.CustomerAssignedID = TheFindOverDueProductionProjectsDataSet.FindOverdueOpenProductionProjects[intCounter].CustomerAssignedID;
NewProjectRow.DateReceived = TheFindOverDueProductionProjectsDataSet.FindOverdueOpenProductionProjects[intCounter].DateReceived;
NewProjectRow.ECDDate = TheFindOverDueProductionProjectsDataSet.FindOverdueOpenProductionProjects[intCounter].ECDDate;
NewProjectRow.ProjectName = TheFindOverDueProductionProjectsDataSet.FindOverdueOpenProductionProjects[intCounter].ProjectName;
NewProjectRow.Status = TheFindOverDueProductionProjectsDataSet.FindOverdueOpenProductionProjects[intCounter].WorkOrderStatus;
TheOverdueProjectReportDataSet.overdueprojectreport.Rows.Add(NewProjectRow);
}
}
dgrOverdueProjects.ItemsSource = TheOverdueProjectReportDataSet.overdueprojectreport;
}
catch (Exception Ex)
{
TheEventLogClass.InsertEventLogEntry(DateTime.Now, "New Blue Jay ERP // Overdue Project Report // Reset Controls " + Ex.Message);
TheMessagesClass.ErrorMessage(Ex.ToString());
}
}
private void FindTopOverdueProjects()
{
int intCounter;
DateTime datTransactionDate = DateTime.Now;
int intNumberOfRecords;
try
{
datTransactionDate = TheDateSearchClass.AddingDays(datTransactionDate, 3);
TheTopAgedOverdueProjectsDataSet.topagedoverdueprojects.Rows.Clear();
TheFindOverdueProductionProjectsDataSet = TheProductionProjectClass.FindOverdueProductionProjects(datTransactionDate);
intNumberOfRecords = TheFindOverdueProductionProjectsDataSet.FindOverdueOpenProductionProjects.Rows.Count;
if (intNumberOfRecords > 10)
{
intNumberOfRecords = 10;
}
if (intNumberOfRecords > 0)
{
for (intCounter = 0; intCounter < intNumberOfRecords; intCounter++)
{
TopAgedOverdueProjectsDataSet.topagedoverdueprojectsRow NewProjectReport = TheTopAgedOverdueProjectsDataSet.topagedoverdueprojects.NewtopagedoverdueprojectsRow();
NewProjectReport.AssignedProjectID = TheFindOverdueProductionProjectsDataSet.FindOverdueOpenProductionProjects[intCounter].AssignedProjectID;
NewProjectReport.CustomerAssignedID = TheFindOverdueProductionProjectsDataSet.FindOverdueOpenProductionProjects[intCounter].CustomerAssignedID;
NewProjectReport.ECDDate = TheFindOverdueProductionProjectsDataSet.FindOverdueOpenProductionProjects[intCounter].ECDDate;
NewProjectReport.ProjectName = TheFindOverdueProductionProjectsDataSet.FindOverdueOpenProductionProjects[intCounter].ProjectName;
TheTopAgedOverdueProjectsDataSet.topagedoverdueprojects.Rows.Add(NewProjectReport);
}
}
dgrLongestAgedProjects.ItemsSource = TheTopAgedOverdueProjectsDataSet.topagedoverdueprojects;
}
catch (Exception Ex)
{
TheEventLogClass.InsertEventLogEntry(DateTime.Now, "New Blue Jay ERP // Overdue Project Dashboard // Find Top Overdue Projects " + Ex.Message);
TheMessagesClass.ErrorMessage(Ex.ToString());
}
}
private void SendOverdueProjectReport()
{
int intCounter;
int intNumberOfRecords;
string strEmailAddress = "*****@*****.**";
DateTime datTransactionDate = DateTime.Now;
string strCustomer;
string strCustomerAssignedID;
string strAssignedProjectID;
string strProjectName;
string strDateReceived;
string strECDDate;
string strAssignedOffice;
string strStatus;
int intWarehouseID;
string strHeader = "BJC Overdue Projects Report";
string strMessage;
bool blnFatalError;
try
{
datTransactionDate = TheDateSearchClass.AddingDays(datTransactionDate, 3);
TheFindOverDueProductionProjectsDataSet = TheProductionProjectClass.FindOverdueProductionProjects(datTransactionDate);
strMessage = "<h1>" + strHeader + " - Do Not Reply</h1>";
strMessage += "<table>";
strMessage += "<tr>";
strMessage += "<td>Customer</td>";
strMessage += "<td>Custoner Project ID</td>";
strMessage += "<td>BJC Project ID</td>";
strMessage += "<td>Project Name</td>";
strMessage += "<td>Date Received</td>";
strMessage += "<td>ECD Date</td>";
strMessage += "<td>Assigned Office</td>";
strMessage += "<td>Status</td>";
strMessage += "</tr>";
strMessage += "<p> </p>";
intNumberOfRecords = TheFindOverDueProductionProjectsDataSet.FindOverdueOpenProductionProjects.Rows.Count;
if(intNumberOfRecords > 0)
{
for(intCounter = 0; intCounter < intNumberOfRecords; intCounter++)
{
strCustomer = TheFindOverDueProductionProjectsDataSet.FindOverdueOpenProductionProjects[intCounter].Customer;
strCustomerAssignedID = TheFindOverDueProductionProjectsDataSet.FindOverdueOpenProductionProjects[intCounter].CustomerAssignedID;
strAssignedProjectID = TheFindOverDueProductionProjectsDataSet.FindOverdueOpenProductionProjects[intCounter].AssignedProjectID;
strProjectName = TheFindOverDueProductionProjectsDataSet.FindOverdueOpenProductionProjects[intCounter].ProjectName;
strDateReceived = Convert.ToString(TheFindOverDueProductionProjectsDataSet.FindOverdueOpenProductionProjects[intCounter].DateReceived);
strECDDate = Convert.ToString(TheFindOverDueProductionProjectsDataSet.FindOverdueOpenProductionProjects[intCounter].ECDDate);
strStatus = TheFindOverDueProductionProjectsDataSet.FindOverdueOpenProductionProjects[intCounter].WorkOrderStatus;
intWarehouseID = TheFindOverDueProductionProjectsDataSet.FindOverdueOpenProductionProjects[intCounter].AssignedOfficeID;
TheFindEmployeeByEmployeeIDDataSet = TheEmployeeClass.FindEmployeeByEmployeeID(intWarehouseID);
strAssignedOffice = TheFindEmployeeByEmployeeIDDataSet.FindEmployeeByEmployeeID[0].FirstName;
strMessage += "<tr>";
strMessage += "<td>" + strCustomer + "</td>";
strMessage += "<td>" + strCustomerAssignedID + "</td>";
strMessage += "<td>" + strAssignedProjectID + "</td>";
strMessage += "<td>" + strProjectName + "</td>";
strMessage += "<td>" + strDateReceived + "</td>";
strMessage += "<td>" + strECDDate + "</td>";
strMessage += "<td>" + strAssignedOffice + "</td>";
strMessage += "<td>" + strStatus + "</td>";
strMessage += "</tr>";
}
}
strMessage += "</table>";
blnFatalError = TheSendEmailClass.SendEmail(strEmailAddress, strHeader, strMessage);
if (blnFatalError == true)
throw new Exception();
}
catch (Exception Ex)
{
TheEventLogClass.InsertEventLogEntry(DateTime.Now, "Event Log Tracker // Send Overdue Project Report " + Ex.Message);
TheMessagesClass.ErrorMessage(Ex.ToString());
}
}
