示例#1
0
        protected virtual async Task SortItemsByScript(string script, bool descending)
        {
            using (var transaction = this.Database.BeginTransaction(this.Database.PreferredIsolationLevel))
            {
                var set           = this.Database.Set <PlaylistItem>(transaction);
                var playlistItems = set.ToArray();
                using (var comparer = new PlaylistItemScriptComparer(script))
                {
                    comparer.InitializeComponent(this.Core);
                    Array.Sort(playlistItems, comparer);
                    if (descending)
                    {
                        Array.Reverse(playlistItems);
                    }
                }
                for (var a = 0; a < playlistItems.Length; a++)
                {
                    playlistItems[a].Sequence = a;
                }
                await EntityHelper <PlaylistItem> .Create(
                    this.Database,
                    this.Database.Tables.PlaylistItem,
                    transaction
                    ).UpdateAsync(
                    playlistItems,
                    new[] { nameof(PlaylistItem.Sequence) }
                    ).ConfigureAwait(false);

                if (transaction.HasTransaction)
                {
                    transaction.Commit();
                }
            }
        }
示例#2
0
 protected virtual async Task SortItemsByScript(string script, bool descending)
 {
     using (var comparer = new PlaylistItemScriptComparer(script))
     {
         comparer.InitializeComponent(this.Core);
         await this.SortItems(comparer, descending).ConfigureAwait(false);
     }
 }