/// <summary>
/// Once the data is loaded into the application this timer will begin. This timer event will begin
/// running condition checks and then making a call to remove the data that is not needed from the database.
/// </summary>
/// <param name="sender">The data removal timer</param>
/// <param name="e">The tick event of the timer</param>
private void DataRemovalTimer_Tick(object sender, EventArgs e)
{
if (DatabaseDataRemovalUtils.DataRemoved)
{
DatabaseDataRemovalUtils.DataRemoved = false;
DataRemovalTimer.Stop();
if (AccessDatabaseUtils.US_PRPO_TableExists && AccessDatabaseUtils.MX_PRPO_TableExists)
{
ShowPage(Pages.CountrySelector);
}
else if (AccessDatabaseUtils.US_PRPO_TableExists)
{
ConfigureToUnitedStates();
BeginDataLoadProcess();
}
else // only the mexico file exists.
{
ConfigureToMexico();
BeginDataLoadProcess();
}
}
}
/// <summary>
/// Once the data is loaded into the application this timer will begin. This timer event will begin
/// running condition checks and then making a call to remove the data that is not needed from the database.
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void DataRemovalTimer_Tick(object sender, EventArgs e)
{
if (!PRPO_DB_Utils.DataRemovalProcessStarted)
{
PRPO_DB_Utils.DataRemovalProcessStarted = true;
if (AccessUtils.US_PRPO_TableExists)
{
PRPO_DB_Utils.ScheduledDataRemovals++;
usThread = new Thread(() =>
{
PRPO_DB_Utils.RemoveData(PRPOCommands.DatabaseTables.MainTables.US_PRPO);
});
usThread.Start();
}
if (AccessUtils.MX_PRPO_TableExists)
{
PRPO_DB_Utils.ScheduledDataRemovals++;
mxThread = new Thread(() =>
{
PRPO_DB_Utils.RemoveData(PRPOCommands.DatabaseTables.MainTables.MX_PRPO);
});
mxThread.Start();
}
}
if (PRPO_DB_Utils.DataRemoved)
{
DataRemovalTimer.Stop();
PRPO_DB_Utils.DataRemoved = false;
if (PRPO_DB_Utils.DatabaseConnection != null & PRPO_DB_Utils.DatabaseConnection.State == System.Data.ConnectionState.Open)
{
btn_DatabaseConnectionStatus.Image = Properties.Resources.databaseConn_Connected_Icon;
}
else
{
MessageBox.Show("There was an error while attempting to connect to the database", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
if (AccessUtils.US_PRPO_TableExists && AccessUtils.MX_PRPO_TableExists)
{
pnl_CountrySelector.BringToFront();
}
else if (AccessUtils.US_PRPO_TableExists)
{
Overall.SelectedCountry = AccessInfo.MainTables.US_PRPO;
PRPO_DB_Utils.DataLoadProcessStarted = false;
PRPO_DB_Utils.DataLoaded = false;
PRPO_DB_Utils.CompletedDataLoads = 0;
PRPO_DB_Utils.ScheduledDataLoads = 0;
DataLoaderTimer.Start();
}
else // only the mexico file exists.
{
Overall.SelectedCountry = AccessInfo.MainTables.MX_PRPO;
PRPO_DB_Utils.DataLoadProcessStarted = false;
PRPO_DB_Utils.DataLoaded = false;
PRPO_DB_Utils.CompletedDataLoads = 0;
PRPO_DB_Utils.ScheduledDataLoads = 0;
DataLoaderTimer.Start();
}
}
}