public ExecuteCommandViewThenVsNowSql(IActivateItems activator, SelectedDataSets selectedDataSet) : base(activator)
{
try
{
var rp = new FlatFileReleasePotential(Activator.RepositoryLocator, selectedDataSet);
rp.Check(new IgnoreAllErrorsCheckNotifier());
if (string.IsNullOrWhiteSpace(rp.SqlCurrentConfiguration))
{
SetImpossible("Could not generate Sql for dataset");
}
else
if (string.IsNullOrWhiteSpace(rp.SqlExtracted))
{
SetImpossible("Dataset has never been extracted");
}
else
if (rp.SqlCurrentConfiguration == rp.SqlExtracted)
{
SetImpossible("No differences");
}
_releasePotential = rp;
}
catch (Exception)
{
SetImpossible("Could not make assesment");
}
}
public override void Execute()
{
base.Execute();
var rp = new FlatFileReleasePotential(Activator.RepositoryLocator, _selectedDataSet);
rp.Check(new IgnoreAllErrorsCheckNotifier());
if (string.IsNullOrWhiteSpace(rp.SqlCurrentConfiguration))
{
Show("Could not generate Sql for dataset");
}
else
if (string.IsNullOrWhiteSpace(rp.SqlExtracted))
{
Show("Dataset has never been extracted");
}
else
if (rp.SqlCurrentConfiguration == rp.SqlExtracted)
{
Show("No differences");
}
else
{
_releasePotential = rp;
}
if (_releasePotential == null)
{
return;
}
var dialog = new SQLBeforeAndAfterViewer(_releasePotential.SqlCurrentConfiguration, _releasePotential.SqlExtracted, "Current Configuration", "Configuration when last run", "Sql Executed", MessageBoxButtons.OK);
dialog.Show();
}
