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);
        }