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()); } }