public static void SaveAsNewPair(this ChatIdToUsernamePair model, SQLiteConnection connection)
{
connection.ExecuteNonQuery(@"
INSERT INTO ChatIdUsernamePairs (ChatId, UserId, Username)
VALUES (@ChatId, @UserId, @Username)",
model);
}
public static bool ExistsInDatabaseByChatId(this ChatIdToUsernamePair pair, SQLiteConnection connection)
{
string sql = @$ "
SELECT COUNT(1) AS 'Count'
FROM ChatIdUsernamePairs
WHERE ChatId = {pair.ChatId}";
var rows = connection.Query(sql);
return((int)(rows.First().Count) > 0);
}
public override async Task Execute(Message message)
{
string responseText = $"Ahoj! Když vás někdo pozve do hry, upozorním vás na to!";
await TabooChatBot.BotClient.SendTextMessageAsync(message.Chat.Id, responseText,
replyToMessageId : message.MessageId);
var newPair = new ChatIdToUsernamePair
{
ChatId = message.Chat.Id,
UserId = message.From.Id,
Username = message.From.Username
};
if (!newPair.ExistsInDatabaseByUserId(TabooChatBot.Database.Connection))
{
newPair.SaveAsNewPair(TabooChatBot.Database.Connection);
}
// TODO: IF USERNAME CHANGES UPDATE (bot diaglog restart)
}
