private void btnRun_Click(object sender, EventArgs e)
{
var repo = new WebApiRepositoryContext("http://*****:*****@"Data Source=(localdb)\V11.0;Initial Catalog=Chinook;Integrated Security=True;", true, true);
if (connection.ConnectionProviderId != null)
connection.ConnectionProvider =
repo.ConnectionProviderRepository.GetDataById(connection.ConnectionProviderId).FirstOrDefault();
var valResult =
scriptVal.Validate(connection
, _test);
repo.RunHistoryRepository.Insert(_test.Id, null, null, connection.ConnectionId, valResult.RunDateTime, valResult.Duration, valResult.IsValid, valResult.RunLog);
MessageBox.Show(valResult.IsValid.ToString());
}
public ValidationResponse Validate()
{
var scriptVal = new SqlScriptValidator();
Response = scriptVal.Validate(Connection, Test);
return Response;
}
private static Collection<ValidationResponse> ExecuteTests(IEnumerable<Test> tests, Connection connection)
{
var scriptVal = new SqlScriptValidator();
var valResponse = new Collection<ValidationResponse>();
foreach (var test in tests)
{
var valResult = scriptVal.Validate(connection, test);
if (valResult == null) continue;
valResponse.Add(valResult);
}
return valResponse;
}
