public void DeleteAll(IDbConnection connection)
{
var scheme = @"[dbo].";
//@createFkOrDeleteFk bit
//@createFkOrDeleteFk
var sqlBefore = $"EXEC {scheme}[g_detail_planet_change_fk_userId] 0; " +
$"EXEC {scheme}[g_detail_system_fk_allianceId] 0; " +
$"EXEC {scheme}[c_officer_delete_all]; " +
$"EXEC {scheme}[c_officer_histroy_delete_all]; " +
$"EXEC {scheme}[c_vote_delete_all];" +
$"EXEC {scheme}[c_vote_history_delete_all]; " +
$"EXEC {scheme}[c_officer_candidat_delete_all]; " +
$"EXEC {scheme}[c_officer_candidat_histrory_delete_all]; " +
$"EXEC {scheme}[help_reset_index] 'c_officer',0; " +
$"EXEC {scheme}[help_reset_index] 'c_officer_histroy',0; " +
$"EXEC {scheme}[help_reset_index] 'c_officer_candidat',0; " +
$"EXEC {scheme}[help_reset_index] 'c_officer_candidat_histrory',0; " +
$"EXEC {scheme}[help_reset_index] 'c_vote',0; " +
$"EXEC {scheme}[help_reset_index] 'c_vote_history',0; " +
$"";
var sqlAfter = $"EXEC {scheme}[g_detail_planet_change_fk_userId] 1;" +
$"EXEC {scheme}[g_detail_system_fk_allianceId] 1;";
_provider.Exec(connection, sqlBefore);
//c.g_detail_planet_change_fk_userId(false);
//c.g_detail_system_fk_allianceId(false);
//c.c_officer_delete_all();
//c.c_officer_histroy_delete_all();
//c.c_officer_candidat_delete_all();
//c.c_officer_candidat_histrory_delete_all();
//c.c_vote_delete_all();
//c.c_vote_history_delete_all();
_gameUserService.DeleteAll(connection);
_allianceInitializer.DeleteAll(connection);
if (deletAuthUsers)
{
_authUsersInitializer.DeleteAll(connection);
}
_mapGInitializer.DeleteAll(connection);
_provider.Exec(connection, sqlAfter);
//c.g_detail_planet_change_fk_userId(true);
//c.g_detail_system_fk_allianceId(true);
}