aboutsummaryrefslogtreecommitdiff
path: root/Emby.Server.Implementations/Notifications/SqliteNotificationsRepository.cs
diff options
context:
space:
mode:
authorLuke Pulverenti <luke.pulverenti@gmail.com>2016-12-13 02:36:30 -0500
committerLuke Pulverenti <luke.pulverenti@gmail.com>2016-12-13 02:36:30 -0500
commite1b880a5a072764cabace79cd6d1d65315ec65e4 (patch)
tree971f995ffd89246ca96c80b44a6266315812e4de /Emby.Server.Implementations/Notifications/SqliteNotificationsRepository.cs
parentbff0cd4447119278d6aab5961f79f8a17c566a04 (diff)
update series queries
Diffstat (limited to 'Emby.Server.Implementations/Notifications/SqliteNotificationsRepository.cs')
-rw-r--r--Emby.Server.Implementations/Notifications/SqliteNotificationsRepository.cs20
1 files changed, 10 insertions, 10 deletions
diff --git a/Emby.Server.Implementations/Notifications/SqliteNotificationsRepository.cs b/Emby.Server.Implementations/Notifications/SqliteNotificationsRepository.cs
index 43e19da65..f18278cb2 100644
--- a/Emby.Server.Implementations/Notifications/SqliteNotificationsRepository.cs
+++ b/Emby.Server.Implementations/Notifications/SqliteNotificationsRepository.cs
@@ -65,9 +65,9 @@ namespace Emby.Server.Implementations.Notifications
var whereClause = " where " + string.Join(" And ", clauses.ToArray());
- using (var connection = CreateConnection(true))
+ using (WriteLock.Read())
{
- lock (WriteLock)
+ using (var connection = CreateConnection(true))
{
result.TotalRecordCount = connection.Query("select count(Id) from Notifications" + whereClause, paramList.ToArray()).SelectScalarInt().First();
@@ -106,9 +106,9 @@ namespace Emby.Server.Implementations.Notifications
{
var result = new NotificationsSummary();
- using (var connection = CreateConnection(true))
+ using (WriteLock.Read())
{
- lock (WriteLock)
+ using (var connection = CreateConnection(true))
{
using (var statement = connection.PrepareStatement("select Level from Notifications where UserId=@UserId and IsRead=@IsRead"))
{
@@ -223,9 +223,9 @@ namespace Emby.Server.Implementations.Notifications
cancellationToken.ThrowIfCancellationRequested();
- using (var connection = CreateConnection())
+ lock (WriteLock)
{
- lock (WriteLock)
+ using (var connection = CreateConnection())
{
connection.RunInTransaction(conn =>
{
@@ -286,9 +286,9 @@ namespace Emby.Server.Implementations.Notifications
{
cancellationToken.ThrowIfCancellationRequested();
- using (var connection = CreateConnection())
+ using (WriteLock.Write())
{
- lock (WriteLock)
+ using (var connection = CreateConnection())
{
connection.RunInTransaction(conn =>
{
@@ -308,9 +308,9 @@ namespace Emby.Server.Implementations.Notifications
{
cancellationToken.ThrowIfCancellationRequested();
- using (var connection = CreateConnection())
+ using (WriteLock.Write())
{
- lock (WriteLock)
+ using (var connection = CreateConnection())
{
connection.RunInTransaction(conn =>
{