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