| protected static RaiseUpdated ( int progid ) : void | ||
| progid | int | |
| return | void | |
private static void AddAsync(int progid)
{
lock (Database.DbUpdateLock)
{
using (SQLiteCommand command = new SQLiteCommand("insert into subscriptions (progid) values (@progid)", FetchDbConn()))
{
command.Parameters.Add(new SQLiteParameter("@progid", progid));
try
{
command.ExecuteNonQuery();
}
catch (SQLiteException sqliteExp)
{
if (sqliteExp.ErrorCode == SQLiteErrorCode.Constraint)
{
// Already added while this was waiting in the threadpool
return;
}
throw;
}
}
}
if (Added != null)
{
Added(progid);
}
Programme.RaiseUpdated(progid);
}
private static void RemoveAsync(int progid)
{
lock (Database.DbUpdateLock)
{
using (SQLiteCommand command = new SQLiteCommand("delete from subscriptions where progid=@progid", FetchDbConn()))
{
command.Parameters.Add(new SQLiteParameter("@progid", progid));
if (command.ExecuteNonQuery() == 0)
{
// Subscription has already been removed
return;
}
}
}
Programme.RaiseUpdated(progid);
if (Removed != null)
{
Removed(progid);
}
}