private void button1_Click(object sender, EventArgs e)
{
var connectionDialog = new ConnectDialog();
connectionDialog.ShowDialog();
if (!string.IsNullOrEmpty(connectionDialog.ConnectionString))
{
connectionString.Text = connectionDialog.ConnectionString;
}
}
void BuildStore()
{
if (String.IsNullOrEmpty(ConnectionString))
{
var dialog = new ConnectDialog();
dialog.ShowDialog();
ConnectionString = dialog.ConnectionString;
if (String.IsNullOrEmpty(ConnectionString))
return;
}
Store = new QueryCostStore(new PlanParser(new QueryCostDataGateway(ConnectionString)));
ShowCosts = false; //caller flips it first time used
}
public ScriptCoster(DTE dte)
{
if (String.IsNullOrEmpty(ConnectionString))
{
var dialog = new ConnectDialog();
dialog.ShowDialog();
ConnectionString = dialog.ConnectionString;
if (String.IsNullOrEmpty(ConnectionString))
return;
}
Dte = dte;
Store = new QueryCostStore(new PlanParser(new QueryCostDataGateway(ConnectionString)));
ShowCosts = false; //caller flips it first time used
}
public static void DeployFile(string newCode)
{
if (String.IsNullOrEmpty(ConnectionString))
{
var connectDialog = new ConnectDialog();
connectDialog.ShowDialog();
ConnectionString = connectDialog.ConnectionString;
if (String.IsNullOrEmpty(ConnectionString))
return;
}
var procedures = ScriptDom.GetProcedures(newCode);
var deployScripts = new List<string>();
foreach (var procedure in procedures)
{
OutputPane.WriteMessage("Deploying {0}", procedure.ProcedureReference.Name.ToQuotedString());
Deploy(BuildIfNotExistsStatements(procedure));
Deploy(ChangeCreateToAlter(procedure, newCode));
OutputPane.WriteMessage("Deploying {0}...Done", procedure.ProcedureReference.Name.ToQuotedString());
}
var functions = ScriptDom.GetFunctions(newCode);
foreach (var function in functions)
{
OutputPane.WriteMessage("Deploying {0}", function.Name.ToQuotedString());
if (function.ReturnType is SelectFunctionReturnType)
{
Deploy(BuildIfNotExistsStatementsInlineFunction(function));
}
else
{
Deploy(BuildIfNotExistsStatements(function));
}
Deploy(ChangeCreateToAlter(function, newCode));
OutputPane.WriteMessage("Deploying {0}...Done", function.Name.ToQuotedString());
}
foreach (var statement in deployScripts)
{
Deploy(statement);
}
//Deploy();
}
private void Start(object sender, RoutedEventArgs e)
{
if (String.IsNullOrEmpty(_connectionString))
{
var dialog = new ConnectDialog();
dialog.ShowDialog();
_connectionString = dialog.ConnectionString;
if (String.IsNullOrEmpty(_connectionString))
return;
}
Task.Run(() =>
{
_reader = new ExtendedEventDataDataReader(_connectionString);
_reader.Start();
});
StartButton.IsEnabled = false;
StopButton.IsEnabled = true;
}
private void Start(object sender, RoutedEventArgs e)
{
try
{
if (String.IsNullOrEmpty(_connectionString))
{
var dialog = new ConnectDialog();
dialog.ShowDialog();
_connectionString = dialog.ConnectionString;
if (String.IsNullOrEmpty(_connectionString))
return;
}
Task.Run(() =>
{
try
{
_reader = new ExtendedEventDataDataReader(_connectionString);
_reader.Start();
}
catch (Exception ex)
{
OutputPane.WriteMessageAndActivatePane("SSDTDevPack: CodeCoverage: Exception calling Start (Worker Thread): {0}", ex);
}
});
StartButton.IsEnabled = false;
StopButton.IsEnabled = true;
}
catch (Exception ex)
{
OutputPane.WriteMessageAndActivatePane("SSDTDevPack: CodeCoverage: Exception calling Start (UI Thread): {0}", ex);
}
}