public async Task RemoveUsersFromSession(int sessionId)
{
//Get the questionnaire by its Id
await _db.BulkDeleteAsync <SessionUser>(query => query
.Where($"{nameof(SessionUser.SessionId):C} = @sessionId")
.WithParameters(new { sessionId }));
}
public async Task <int> DeleteAllTokens(int id)
{
using (IDbConnection dbConnection = Connection)
{
dbConnection.Open();
return(await dbConnection.BulkDeleteAsync <AccountToken>(statement => statement.Where($"{nameof(AccountToken.AccountId):C}={id}")));
}
}
public static async Task <int> BulkDeleteAsync <TEntity>(IDbConnection db,
Action <IConditionalBulkSqlStatementOptionsBuilder <TEntity> > statementOptions = null)
{
// using (await Sync.LockAsync())
{
try
{
return(await db.BulkDeleteAsync(statementOptions));
}
catch (Exception e)
{
Logger.Error($"DBError, {e}");
}
return(-1);
}
}
