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