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}"));
}
}
}