public async Task Delete(Guid tagId) { try { using var command = sql.CreateStoredProcedure("[Core].[DeleteTag]"); command.WithParameter("tagId", tagId); await command.ExecuteNonQueryAsync().ConfigureAwait(false); } catch (Exception ex) { logger.LogWarning(ex, "Error when attempting to delete tag with id {tagId}", tagId); throw; } }
public async Task <List <string> > GetSuspendedUsersForChannel(string channelName) { var result = new List <string>(); using (var command = sql.CreateStoredProcedure("[Core].[GetSuspendedUsersForChannel]")) { command.WithParameter("channelOfOrigin", channelName); using var reader = await command.ExecuteReaderAsync().ConfigureAwait(false); while (await reader.ReadAsync().ConfigureAwait(false)) { result.Add(reader.GetString("username")); } } return(result); }
public async Task <DateTime> GetTimeStampForLatestMessage() { using (var command = sql.CreateStoredProcedure("[Core].[GetLatestMessageTimestamp]")) using (var reader = await command.ExecuteReaderAsync().ConfigureAwait(false)) { if (await reader.ReadAsync().ConfigureAwait(false)) { return(reader.GetDateTime("Timestamp")); } } return(default);
public async Task InsertPosition(RecordedPosition recordedPosition) { try { using (var command = sql.CreateStoredProcedure("[Core].[InsertPosition]")) { command.WithParameter("latitude", recordedPosition.Latitude) .WithParameter("longitude", recordedPosition.Longitude) .WithParameter("altitude", recordedPosition.Altitude) .WithParameter("timeStamp", recordedPosition.TimeStamp) .WithParameter("username", recordedPosition.Username); await command.ExecuteNonQueryAsync().ConfigureAwait(false); } } catch (Exception) { // LOG throw; } }
public async Task <List <User> > GetUsers() { try { var result = new List <User>(); using var command = sql.CreateStoredProcedure("[Core].[GetAllUsers]"); using var reader = await command.ExecuteReaderAsync().ConfigureAwait(false); while (await reader.ReadAsync().ConfigureAwait(false)) { result.Add(Serialization.Deserialize <User>(reader.GetString("data"))); } return(result); } catch (Exception ex) { logger.LogWarning(ex, "Error when getting all users"); throw; } }
public async Task <List <Channel> > GetChannels() { try { var result = new List <Channel>(); using var command = sql.CreateStoredProcedure("[Core].[GetChannels]"); using var reader = await command.ExecuteReaderAsync(System.Data.CommandBehavior.Default).ConfigureAwait(false); while (await reader.ReadAsync().ConfigureAwait(false)) { var channel = Serialization.Deserialize <Channel>(reader.GetString("data")); result.Add(channel); } return(result); } catch (Exception ex) { logger.LogWarning(ex, "Error getting channels"); throw; } }
public async Task UpsertChatter(string twitchUsername, DateTime timestamp) { try { using var command = sql.CreateStoredProcedure("[Core].[UpsertChatter]"); command.WithParameter("@twitchUsername", twitchUsername) .WithParameter("@firstTimeSeen", timestamp); await command.ExecuteNonQueryAsync().ConfigureAwait(false); } catch (Exception ex) { logger.LogWarning(ex, "Error when attempting to save new chatter"); throw; } }
public async Task SaveBitrate(RecordedBitrate bitrate) { try { using (var command = sql.CreateStoredProcedure("[Core].[InsertBitrate]")) { command.WithParameter("bitrate", bitrate.Bitrate) .WithParameter("timestamp", bitrate.Timestamp) .WithParameter("username", bitrate.Username); await command.ExecuteNonQueryAsync().ConfigureAwait(false); } } catch (Exception) { throw; } }
public async Task Insert(string channel, string username, string deletedBy, string message, DateTime timestamp) { try { using var command = sql.CreateStoredProcedure("[Core].[InsertDeletedMessage]"); command.WithParameter("username", username) .WithParameter("channelOfOrigin", channel) .WithParameter("message", message) .WithParameter("timestamp", timestamp) .WithParameter("deletedBy", deletedBy); await command.ExecuteNonQueryAsync().ConfigureAwait(false); } catch (Exception ex) { logger.LogWarning(ex, "Error when attempting to save chat message"); throw; } }