public async Task RemoveRole(string genus, string species, string role)
{
// Get the species.
Species sp = await BotUtils.ReplyFindSpeciesAsync(Context, genus, species);
if (sp is null)
{
return;
}
// Get the role.
Role role_info = await BotUtils.GetRoleFromDb(role);
if (!await BotUtils.ReplyAsync_ValidateRole(Context, role_info))
{
return;
}
// Update the species.
using (SQLiteCommand cmd = new SQLiteCommand("DELETE FROM SpeciesRoles WHERE species_id=$species_id AND role_id=$role_id;")) {
cmd.Parameters.AddWithValue("$species_id", sp.Id);
cmd.Parameters.AddWithValue("$role_id", role_info.id);
await Database.ExecuteNonQuery(cmd);
await BotUtils.ReplyAsync_Success(Context, string.Format("Role **{0}** has successfully been unassigned from **{1}**.", StringUtils.ToTitleCase(role_info.name), sp.ShortName));
}
}
public async Task SetRole(string genus, string species, string role, string notes = "")
{
// Get the species.
Species sp = await BotUtils.ReplyFindSpeciesAsync(Context, genus, species);
if (sp is null)
{
return;
}
// Get the role.
Role role_info = await BotUtils.GetRoleFromDb(role);
if (!await BotUtils.ReplyAsync_ValidateRole(Context, role_info))
{
return;
}
// Update the species.
using (SQLiteCommand cmd = new SQLiteCommand("INSERT OR REPLACE INTO SpeciesRoles(species_id, role_id, notes) VALUES($species_id, $role_id, $notes);")) {
cmd.Parameters.AddWithValue("$species_id", sp.Id);
cmd.Parameters.AddWithValue("$role_id", role_info.id);
cmd.Parameters.AddWithValue("$notes", notes);
await Database.ExecuteNonQuery(cmd);
await BotUtils.ReplyAsync_Success(Context, string.Format("**{0}** has successfully been assigned the role of **{1}**.", sp.ShortName, StringUtils.ToTitleCase(role_info.name)));
}
}
public async Task Roles(string nameOrSpecies)
{
// If a role with this name exists, that's what we'll prioritize (users can use the genus + species overload if they need to).
// If no such role exists, check for a species with this name instead.
Role role = await BotUtils.GetRoleFromDb(nameOrSpecies);
if (role is null)
{
// No such role exists, so check if a species exists with the given name instead.
Species[] matching_species = await BotUtils.GetSpeciesFromDb("", nameOrSpecies);
if (matching_species.Count() == 1)
{
// If only one species was returned, show the roles assigned to that species.
await Roles(matching_species[0]);
}
else if (matching_species.Count() > 1)
{
// If multiple species were returned, provide a list of matching species for the user to choose from.
await BotUtils.ReplyValidateSpeciesAsync(Context, matching_species);
}
if (matching_species.Count() > 0)
{
return;
}
}
// If we got here, the role is eiher not null, or it is null, but no species with the given name exists.
// In this case, proceed to validate the role, and display its information if possible.
if (!await BotUtils.ReplyAsync_ValidateRole(Context, role))
{
return;
}
// List all extant species with this role.
List <Species> species_list = new List <Species>(await BotUtils.GetSpeciesFromDbByRole(role));
species_list.RemoveAll(x => x.IsExtinct);
species_list.Sort((lhs, rhs) => lhs.ShortName.CompareTo(rhs.ShortName));
Bot.PaginatedMessageBuilder embed = new Bot.PaginatedMessageBuilder(EmbedUtils.SpeciesListToEmbedPages(species_list,
fieldName: string.Format("Extant species with this role ({0}):", species_list.Count())));
embed.SetTitle(string.Format("Role: {0}", StringUtils.ToTitleCase(role.name)));
embed.SetDescription(role.GetDescriptionOrDefault());
await Bot.DiscordUtils.SendMessageAsync(Context, embed.Build());
}
public async Task SetRoleDescription(string name, string description)
{
Role role = await BotUtils.GetRoleFromDb(name);
if (!await BotUtils.ReplyAsync_ValidateRole(Context, role))
{
return;
}
using (SQLiteCommand cmd = new SQLiteCommand("UPDATE Roles SET description=$description WHERE name=$name;")) {
cmd.Parameters.AddWithValue("$name", role.name);
cmd.Parameters.AddWithValue("$description", description);
await Database.ExecuteNonQuery(cmd);
}
await BotUtils.ReplyAsync_Success(Context, string.Format("Successfully updated description for role **{0}**.", StringUtils.ToTitleCase(role.name)));
}
