private void ResetControls() { //setting local variables int intCounter; int intNumberOfRecords; string strCustomerAssignedID; int intSecondCounter; int intSecondNumberOfRecords; PleaseWait PleaseWait = new PleaseWait(); PleaseWait.Show(); try { TheDuplicateProjectsDataSet.duplicateprojects.Rows.Clear(); //loading up the first data set TheFindDuplicateProjectMatrixDataSet = TheProjectMatrixClass.FindDuplicateProjectMatrix(); intNumberOfRecords = TheFindDuplicateProjectMatrixDataSet.FindDuplicateProjectMatrix.Rows.Count - 1; if (intNumberOfRecords > -1) { for (intCounter = 0; intCounter <= intNumberOfRecords; intCounter++) { strCustomerAssignedID = TheFindDuplicateProjectMatrixDataSet.FindDuplicateProjectMatrix[intCounter].CustomerAssignedID; TheFindProjectMatrixByCustomerAssignedIDShortDataSet = TheProjectMatrixClass.FindProjectMatrixByCustomerAssignedIDShort(strCustomerAssignedID); intSecondNumberOfRecords = TheFindProjectMatrixByCustomerAssignedIDShortDataSet.FindProjectMatrixByCustomerAssignedIDShort.Rows.Count - 1; for (intSecondCounter = 0; intSecondCounter <= intSecondNumberOfRecords; intSecondCounter++) { DuplicateProjectsDataSet.duplicateprojectsRow NewProjectEntry = TheDuplicateProjectsDataSet.duplicateprojects.NewduplicateprojectsRow(); NewProjectEntry.AssignedOffice = TheFindProjectMatrixByCustomerAssignedIDShortDataSet.FindProjectMatrixByCustomerAssignedIDShort[intSecondCounter].AssignedOffice; NewProjectEntry.AssignedProjectID = TheFindProjectMatrixByCustomerAssignedIDShortDataSet.FindProjectMatrixByCustomerAssignedIDShort[intSecondCounter].AssignedProjectID; NewProjectEntry.CustomerProjectID = TheFindProjectMatrixByCustomerAssignedIDShortDataSet.FindProjectMatrixByCustomerAssignedIDShort[intSecondCounter].CustomerAssignedID; NewProjectEntry.ProjectID = TheFindProjectMatrixByCustomerAssignedIDShortDataSet.FindProjectMatrixByCustomerAssignedIDShort[intSecondCounter].ProjectID; NewProjectEntry.RemoveProject = false; NewProjectEntry.TransactionDate = TheFindProjectMatrixByCustomerAssignedIDShortDataSet.FindProjectMatrixByCustomerAssignedIDShort[intSecondCounter].TransactionDate; NewProjectEntry.TransactionID = TheFindProjectMatrixByCustomerAssignedIDShortDataSet.FindProjectMatrixByCustomerAssignedIDShort[intSecondCounter].TransactionID; TheDuplicateProjectsDataSet.duplicateprojects.Rows.Add(NewProjectEntry); } } } dgrDuplicateProjects.ItemsSource = TheDuplicateProjectsDataSet.duplicateprojects; } catch (Exception Ex) { TheEventLogClass.InsertEventLogEntry(DateTime.Now, "New Blue Jay ERP // Remove Duplicate Project Matrix // Reset Controls " + Ex.Message); TheMessagesClass.ErrorMessage(Ex.ToString()); } PleaseWait.Close(); }
private void UpdateGrid() { //setting variables int intNumberOfRecords; bool blnFatalError = false; DateTime datEndDate = DateTime.Now; DateTime datStartDate = DateTime.Now; try { TheFindDuplicateVehicleAssignmentsDataSet = FindDuplicateVehicleAssignments(); intNumberOfRecords = TheFindDuplicateVehicleAssignmentsDataSet.FindDuplicateVehicleAssignments.Rows.Count; if(intNumberOfRecords > 0) { blnFatalError = TheSendEmailClass.SendEmail("*****@*****.**", "New Event Log Entry", "We Have a Duplicate Vehicle Assignment Event"); if (blnFatalError == true) throw new Exception(); TheMessagesClass.ErrorMessage("We Have a Duplicate Vehicle Assignment Event"); } TheFindDuplicateProjectMatrixDataSet = TheProjectMatrixClass.FindDuplicateProjectMatrix(); intNumberOfRecords = TheFindDuplicateProjectMatrixDataSet.FindDuplicateProjectMatrix.Rows.Count; if(intNumberOfRecords > 0) { blnFatalError = CreateDuplicateProjectEmail(); if (blnFatalError == true) throw new Exception(); } datEndDate = TheDateSearchClass.RemoveTime(datEndDate); datStartDate = TheDateSearchClass.SubtractingDays(datEndDate, 5); datEndDate = TheDateSearchClass.AddingDays(datEndDate, 1); TheFindEventLogByDateRangeDataSet = TheEventLogClass.FindEventLogByDateRange(datStartDate, datEndDate); intNumberOfRecords = TheFindEventLogByDateRangeDataSet.FindEventLogEntriesByDateRange.Rows.Count; if (intNumberOfRecords != gintNumberOfRecords) { gintNumberOfRecords = intNumberOfRecords; intNumberOfRecords -= 1; blnFatalError = TheSendEmailClass.SendEmail("*****@*****.**", "New Event Log Entry", TheFindEventLogByDateRangeDataSet.FindEventLogEntriesByDateRange[0].LogEntry); if (blnFatalError == true) throw new Exception(); blnFatalError = TheSendEmailClass.SendEmail("*****@*****.**", "New Event Log Entry", TheFindEventLogByDateRangeDataSet.FindEventLogEntriesByDateRange[0].LogEntry); if (blnFatalError == true) throw new Exception(); dgrResults.ItemsSource = TheFindEventLogByDateRangeDataSet.FindEventLogEntriesByDateRange; } dgrResults.ItemsSource = TheFindEventLogByDateRangeDataSet.FindEventLogEntriesByDateRange; } catch (Exception Ex) { TheEventLogClass.InsertEventLogEntry(DateTime.Now, "Event Log Tracker // Main Window // Update Grid " + Ex.Message); TheMessagesClass.ErrorMessage(Ex.ToString()); } }