public void TestCleanUp()
{
//Delete Bet
TransactionOptions to = new TransactionOptions {
IsolationLevel = IsolationLevel.ReadCommitted
};
using (TransactionScope scope = new TransactionScope(TransactionScopeOption.Required, to)) {
using (SqlConnection connection = GetSqlConnection()) {
connection.Open();
using (SqlCommand command = connection.CreateCommand()) {
command.CommandText = "DELETE FROM TeamsOnBetsOnMatch WHERE TeamId=@id";
command.Parameters.AddWithValue("id", TestTeam1.Id);
command.ExecuteNonQuery();
command.Parameters.Clear();
command.CommandText = "DELETE FROM BetsOnmatch WHERE BetId=@id";
command.Parameters.AddWithValue("id", TestBet.Id);
command.ExecuteNonQuery();
command.Parameters.Clear();
command.CommandText = "DELETE FROM Bet WHERE Id=@id";
command.Parameters.AddWithValue("id", TestBet.Id);
command.ExecuteNonQuery();
}
connection.Close();
}
scope.Complete();
}
//Delete TestUser
UserController.DeleteUser(TestUser);
//Delete TestPlayers
foreach (Player p in TestTeam1.Players)
{
PlayerController.DeletePlayer(p);
}
foreach (Player p in TestTeam2.Players)
{
PlayerController.DeletePlayer(p);
}
//Delete TestMatch
MatchController.DeleteMatch(TestMatch);
//Delete TestEvent
EventController.DeleteEvent(TestEvent);
//Delete TestTeam
TeamController.DeleteTeam(TestTeam1);
TeamController.DeleteTeam(TestTeam2);
//Delete TestMap
MatchController.DeleteMap(TestMap);
}
