public async Task SetMessageLogAsync(ulong guildId, bool value)
{
using var connection = DataExtentions.GetConnection();
connection.Open();
await connection.ExecuteAsync($"select set_message_log('{guildId}', {value})");
}
public void SetPrefix(ulong guildId, char prefix)
{
using var connection = DataExtentions.GetConnection();
connection.Open();
connection.Execute($"select set_prefix('{guildId}', '{prefix}')");
}
public async Task SetPrefixAsync(ulong guildId, char prefix)
{
using var connection = DataExtentions.GetConnection();
connection.Open();
await connection.ExecuteAsync($"select set_prefix('{guildId}', '{prefix}')");
}
public void SetModChannel(ulong guildId, ulong modChannelId)
{
using var connection = DataExtentions.GetConnection();
connection.Open();
connection.Execute($"select set_mod_channel_id('{guildId}', '{modChannelId}')");
}
public async Task SetModChannelAsync(ulong guildId, ulong modChannelId)
{
using var connection = DataExtentions.GetConnection();
connection.Open();
await connection.ExecuteAsync($"select set_mod_channel_id('{guildId}', '{modChannelId}')");
}
public async Task <Config> GetGuildConfigAsync(ulong guildId)
{
using var connection = DataExtentions.GetConnection();
connection.Open();
return(await connection.QuerySingleAsync <Config>($"select * from get_config('{guildId}')"));
}
public async Task AddConfigAsync(ulong guildId, ulong ModchannelId, char prefix, bool messagelog)
{
using var connection = DataExtentions.GetConnection();
connection.Open();
await connection.ExecuteAsync($"select * from add_config('{guildId}', '{ModchannelId}', '{prefix}', {messagelog})");
}
public async Task AddMessageAsync(ulong guildId, ulong modChannelId, ulong userId, string message, DateTime dateTime)
{
using var connection = DataExtentions.GetConnection();
connection.Open();
await connection.ExecuteAsync($"select add_message('{guildId}', '{modChannelId}', '{userId}', E'{message}', '{dateTime}')");
}
public Config GetGuildConfig(ulong guildId)
{
using var connection = DataExtentions.GetConnection();
connection.Open();
return(connection.QuerySingle <Config>($"select * from get_config('{guildId}')"));
}
public List <Message> GetMessages(ulong guildId)
{
using var connection = DataExtentions.GetConnection();
connection.Open();
return(connection.Query <Message>($"SELECT * FROM message WHERE guild_id = '{guildId}'").ToList());
}
public async Task <List <Message> > GetMessagesAsync(ulong guildId)
{
using var connection = DataExtentions.GetConnection();
connection.Open();
return(await Task.FromResult(connection.QueryAsync <Message>($"SELECT * FROM message WHERE guild_id = '{guildId}'").Result.ToList()));
}
public async Task RemoveAllStrikesFromUserAsync(ulong guildId, ulong userId)
{
using var connection = DataExtentions.GetConnection();
connection.Open();
await connection.ExecuteAsync($"select remove_all_strikes('{guildId}', '{userId}')");
}
public async Task RemoveStrikeAsync(ulong guildId, int strikeId)
{
using var connection = DataExtentions.GetConnection();
connection.Open();
await connection.ExecuteAsync($"select remove_strike('{guildId}', {strikeId})");
}
public async Task AddStrikeAsync(ulong guildId, ulong userId, ulong modId, string reason, string date)
{
using var connection = DataExtentions.GetConnection();
connection.Open();
await connection.ExecuteAsync($"select add_strike('{guildId}', '{userId}', '{modId}', '{reason}', '{date}')");
}
public async Task <List <Strike> > GetStrikesAsync(ulong guildId, ulong userId)
{
using var connection = DataExtentions.GetConnection();
connection.Open();
return(await Task.FromResult(connection.QueryAsync <Strike>($"select * from get_strikes('{guildId}', '{userId}')").Result.ToList()));
}
public List <Strike> GetStrikes(ulong guildId, ulong userId)
{
using var connection = DataExtentions.GetConnection();
connection.Open();
return(connection.Query <Strike>($"select * from get_strikes('{guildId}', '{userId}')").ToList());
}
