private FindDuplicateVehicleAssignmentsDataSet FindDuplicateVehicleAssignments()
{
try
{
aFindDuplicateVehicleAsignmentsDataSet = new FindDuplicateVehicleAssignmentsDataSet();
aFindDuplicateVehicleAssignmentsTableAdapter = new FindDuplicateVehicleAssignmentsDataSetTableAdapters.FindDuplicateVehicleAssignmentsTableAdapter();
aFindDuplicateVehicleAssignmentsTableAdapter.Fill(aFindDuplicateVehicleAsignmentsDataSet.FindDuplicateVehicleAssignments);
}
catch (Exception Ex)
{
TheEventLogClass.InsertEventLogEntry(DateTime.Now, "Event Log Tracker // Main Window // Find Duplicate Vehicle Assignments " + Ex.Message);
TheMessagesClass.ErrorMessage(Ex.ToString());
}
return aFindDuplicateVehicleAsignmentsDataSet;
}
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());
}
}
