public MainForm()
{
_presenter = new ChangeTracker(this);
_mySettings = new MySettings();
InitializeComponent();
InitFormView();
CreateStatusBar();
}
public MainForm()
{
_presenter = new ChangeTracker(this);
_mySettings = new MySettings();
InitializeComponent();
InitFormView();
CreateStatusBar();
}
public void ScanWorker()
{
MySettings settings = new MySettings();
_shouldStopScan = false;
List<string> availableTables = new List<string>();
_view.Status("Scanner: Getting all tables list");
_view.Log("===================================================================");
using (var command = new SqlCommand(settings.GetAllTablesSql, _sqlConnection))
{
try
{
using (var reader = command.ExecuteReader())
{
while (reader.Read())
{
if (_shouldStopScan)
{
SetScanIsCanceled();
return;
}
availableTables.Add(reader[0].ToString());
}
}
}
catch(Exception e)
{
_view.LogError("Get All tables execution failed");
_view.LogError("QUERY: " + settings.GetAllTablesSql);
_view.LogError(e.Message);
}
}
_view.InitProgress(availableTables.Count);
using (var command = new SqlCommand())
{
command.Connection = _sqlConnection;
foreach (var table in availableTables)
{
if (_shouldStopScan )
{
SetScanIsCanceled();
return;
}
_view.Status("Scanning: " + table);
_view.PerformStep();
command.CommandText = String.Format(settings.GetCheckSumSql, table);
Int32? checksum = 0;
try
{
checksum = command.ExecuteScalar() as Int32?;
}
catch (Exception e)
{
_view.LogError(e.Message + " TABLE " + table);
_view.LogError("QUERY: " + settings.GetCheckSumSql);
continue;
}
bool printchanged = false;
if (!_lastTables.ContainsKey(table))
{
_lastTables[table] = 0;
}
if (_lastTables[table] != checksum)
{
printchanged = true;
_lastTables[table] = checksum;
}
if (printchanged)
{
_view.Log(table);
}
}
IsScanInProgress = false;
_view.Status("Ready");
_view.UpdateScanIsStopped();
}
}
public void ScanWorker()
{
MySettings settings = new MySettings();
_shouldStopScan = false;
List <string> availableTables = new List <string>();
_view.Status("Scanner: Getting all tables list");
_view.Log("===================================================================");
using (var command = new SqlCommand(settings.GetAllTablesSql, _sqlConnection))
{
try
{
using (var reader = command.ExecuteReader())
{
while (reader.Read())
{
if (_shouldStopScan)
{
SetScanIsCanceled();
return;
}
availableTables.Add(reader[0].ToString());
}
}
}
catch (Exception e)
{
_view.LogError("Get All tables execution failed");
_view.LogError("QUERY: " + settings.GetAllTablesSql);
_view.LogError(e.Message);
}
}
_view.InitProgress(availableTables.Count);
using (var command = new SqlCommand())
{
command.Connection = _sqlConnection;
foreach (var table in availableTables)
{
if (_shouldStopScan)
{
SetScanIsCanceled();
return;
}
_view.Status("Scanning: " + table);
_view.PerformStep();
command.CommandText = String.Format(settings.GetCheckSumSql, table);
Int32?checksum = 0;
try
{
checksum = command.ExecuteScalar() as Int32?;
}
catch (Exception e)
{
_view.LogError(e.Message + " TABLE " + table);
_view.LogError("QUERY: " + settings.GetCheckSumSql);
continue;
}
bool printchanged = false;
if (!_lastTables.ContainsKey(table))
{
_lastTables[table] = 0;
}
if (_lastTables[table] != checksum)
{
printchanged = true;
_lastTables[table] = checksum;
}
if (printchanged)
{
_view.Log(table);
}
}
IsScanInProgress = false;
_view.Status("Ready");
_view.UpdateScanIsStopped();
}
}