diff options
| author | Luke <luke.pulverenti@gmail.com> | 2016-02-14 23:29:42 -0500 |
|---|---|---|
| committer | Luke <luke.pulverenti@gmail.com> | 2016-02-14 23:29:42 -0500 |
| commit | 5bee5acd27a98572b95380cad0d5b9278b60063f (patch) | |
| tree | 2364d6ba915b00f7190b7cc4cb8b99174ac7b4a2 /MediaBrowser.Server.Implementations/Persistence/SqliteItemRepository.cs | |
| parent | 515cf18703ecb27c318210a1e6917a4effb86bc8 (diff) | |
| parent | 65e0cd7740ec15212ea8991d945bb6f4f605b34d (diff) | |
Merge pull request #1463 from MediaBrowser/beta
Beta
Diffstat (limited to 'MediaBrowser.Server.Implementations/Persistence/SqliteItemRepository.cs')
| -rw-r--r-- | MediaBrowser.Server.Implementations/Persistence/SqliteItemRepository.cs | 16 |
1 files changed, 7 insertions, 9 deletions
diff --git a/MediaBrowser.Server.Implementations/Persistence/SqliteItemRepository.cs b/MediaBrowser.Server.Implementations/Persistence/SqliteItemRepository.cs index 346dcf359..9d6343568 100644 --- a/MediaBrowser.Server.Implementations/Persistence/SqliteItemRepository.cs +++ b/MediaBrowser.Server.Implementations/Persistence/SqliteItemRepository.cs @@ -1966,13 +1966,13 @@ namespace MediaBrowser.Server.Implementations.Persistence whereClauses.Add(string.Format("(InheritedParentalRatingValue > 0 or UnratedType not in ({0}))", inClause)); } - //var excludeTagIndex = 0; - //foreach (var excludeTag in query.ExcludeTags) - //{ - // whereClauses.Add("Tags not like @excludeTag" + excludeTagIndex); - // cmd.Parameters.Add(cmd, "@excludeTag" + excludeTagIndex, DbType.String).Value = "%" + excludeTag + "%"; - // excludeTagIndex++; - //} + var excludeTagIndex = 0; + foreach (var excludeTag in query.ExcludeTags) + { + whereClauses.Add("Tags not like @excludeTag" + excludeTagIndex); + cmd.Parameters.Add(cmd, "@excludeTag" + excludeTagIndex, DbType.String).Value = "%" + excludeTag + "%"; + excludeTagIndex++; + } if (addPaging) { @@ -2070,8 +2070,6 @@ namespace MediaBrowser.Server.Implementations.Persistence _updateInheritedRatingCommand.Transaction = transaction; _updateInheritedRatingCommand.ExecuteNonQuery(); - - _updateInheritedRatingCommand.ExecuteNonQuery(); } transaction.Commit(); |
