public void ChannelSave(BotChannel bChan) { using (SQLiteCommand cmd = new SQLiteCommand()) { bChan.UpdateKey(); cmd.CommandType = CommandType.Text; cmd.Connection = Core.Data; if (bChan.isLinked || bChan.GuildID != 0) { cmd.CommandText = $"UPDATE {PLUGINNAME} SET " + $"isLinked = @isLinked, " + $"Key = @Key, " + $"GuildName = @GuildName, " + $"discordDefaultBotChannel = @discordDefaultBotChannel, " + $"discordAdminChannel = @discordAdminChannel, " + $"TwitchChannelID = @TwitchChannelID, " + $"TwitchChannelName = @TwitchChannelName, " + $"isTwitch = @isTwitch, " + $"isLive = @isLive, " + $"TwitchAutojoin = @TwitchAutojoin, " + $"pubsubOauth = @pubsubOauth " + $" WHERE GuildID is @GuildID"; cmd.Parameters.AddWithValue("@GuildID", bChan.GuildID); } else { cmd.CommandText = $"UPDATE {PLUGINNAME} SET " + $"isLinked = @isLinked, " + $"Key = @Key, " + $"GuildName = @GuildName, " + $"discordDefaultBotChannel = @discordDefaultBotChannel, " + $"discordAdminChannel = @discordAdminChannel, " + $"TwitchChannelID = @TwitchChannelID, " + $"TwitchChannelName = @TwitchChannelName, " + $"isTwitch = @isTwitch, " + $"isLive = @isLive, " + $"TwitchAutojoin = @TwitchAutojoin, " + $"pubsubOauth = @pubsubOauth " + $" WHERE TwitchChannelName is @TwitchChannelName"; cmd.Parameters.AddWithValue("@TwitchChannelName", bChan.TwitchChannelName); } cmd.Parameters.AddWithValue("@isLinked", bChan.isLinked); cmd.Parameters.AddWithValue("@Key", bChan.Key); cmd.Parameters.AddWithValue("@GuildName", bChan.GuildName); cmd.Parameters.AddWithValue("@discordDefaultBotChannel", bChan.discordDefaultBotChannel); cmd.Parameters.AddWithValue("@discordAdminChannel", bChan.discordAdminChannel); cmd.Parameters.AddWithValue("@TwitchChannelID", bChan.TwitchChannelID); cmd.Parameters.AddWithValue("@TwitchChannelName", bChan.TwitchChannelName); cmd.Parameters.AddWithValue("@isTwitch", bChan.isTwitch); cmd.Parameters.AddWithValue("@isLive", bChan.isLive); cmd.Parameters.AddWithValue("@TwitchAutojoin", bChan.TwitchAutojoin); cmd.Parameters.AddWithValue("@pubsubOauth", bChan.pubsubOauth); cmd.ExecuteNonQuery(); } //await Core.LOG(new LogMessage(LogSeverity.Warning, PLUGINNAME, $"Saving updated channeldata")); }
/// <summary> /// This only takes a botchannel instance and write it into the DB. Not for saving or udpating values /// </summary> /// <param name="bChan"></param> /// <returns></returns> private async Task ChannelDataWrite(BotChannel bChan) { using (SQLiteCommand cmd = new SQLiteCommand()) { bChan.UpdateKey(); cmd.CommandType = CommandType.Text; cmd.Connection = Core.Data; cmd.CommandText = $"INSERT INTO {PLUGINNAME} VALUES (" + $"@isLinked, " + $"@Key, " + $"@GuildID, " + $"@GuildName, " + $"@discordDefaultBotChannel, " + $"@discordAdminChannel, " + $"@TwitchChannelID, " + $"@TwitchChannelName, " + $"@isTwitch, " + $"@isLive, " + $"@TwitchAutojoin, " + $"@pubsubOauth " + $")"; cmd.Parameters.AddWithValue("@isLinked", bChan.isLinked); cmd.Parameters.AddWithValue("@Key", bChan.Key); cmd.Parameters.AddWithValue("@GuildID", bChan.GuildID); cmd.Parameters.AddWithValue("@GuildName", bChan.GuildName); cmd.Parameters.AddWithValue("@discordDefaultBotChannel", bChan.discordDefaultBotChannel); cmd.Parameters.AddWithValue("@discordAdminChannel", bChan.discordAdminChannel); cmd.Parameters.AddWithValue("@TwitchChannelID", bChan.TwitchChannelID); cmd.Parameters.AddWithValue("@TwitchChannelName", bChan.TwitchChannelName); cmd.Parameters.AddWithValue("@isTwitch", bChan.isTwitch); cmd.Parameters.AddWithValue("@isLive", bChan.isLive); cmd.Parameters.AddWithValue("@TwitchAutojoin", bChan.TwitchAutojoin); cmd.Parameters.AddWithValue("@pubsubOauth", bChan.pubsubOauth); cmd.ExecuteNonQuery(); if (bChan.isLinked) { await Core.LOG(new LogEntry(LOGSEVERITY.WARNING, PLUGINNAME, $"Created linked entry for Discord Guild {bChan.GuildName} and Twitchchannel {bChan.TwitchChannelName}")); } else if (bChan.isTwitch) { await Core.LOG(new LogEntry(LOGSEVERITY.WARNING, PLUGINNAME, $"Created entry for Twitch channel {bChan.TwitchChannelName}")); } else { await Core.LOG(new LogEntry(LOGSEVERITY.WARNING, PLUGINNAME, $"Created entry for Discord Guild {bChan.GuildName}")); } } }