public void AddPuzzleData(PuzzleDataModel data)
{
using (IDbConnection connection = new SQLiteConnection(ConfigurationString))
{
connection.Execute("INSERT INTO PUZZLEDATA (PuzzleCode, Type, Data) " +
"VALUES (@PuzzleCode, @Type, @Data)",
data);
}
}
public async Task AddPuzzleDataAsync(PuzzleDataModel puzzle)
{
if (_data.GetPuzzle(puzzle.PuzzleCode) == null)
{
var newPuzzle = new PuzzleModel
{
Code = puzzle.PuzzleCode,
Points = CalculatePuzzlePoints(0)
};
_data.AddOrUpdatePuzzle(newPuzzle);
await SendMessageToChannelAsync($"Added new puzzle: <#{puzzle.PuzzleCode}>",
Constants.NOTIFICATIONS_CHANNEL);
}
_data.AddPuzzleData(puzzle);
}
private async Task SetPuzzleDataAsync(IMessageChannel channel, string content, PuzzleDataType type)
{
var message = Context.Message;
await message.DeleteAsync();
string code = channel.Id.ToString();
var puzzle = new PuzzleDataModel
{
PuzzleCode = code,
Type = type,
Data = content
};
await _actions.AddPuzzleDataAsync(puzzle);
await _logger.LogAsync(new LogMessage(LogSeverity.Debug, "Bot", $"Added answer: {code} = {content}"));
await ReplyAsync($"Added {type} to problem <#{code}>.");
}
