public List <GuildRole> GetRoles()
{
List <GuildRole> roles = new List <GuildRole>();
using (var conn = new SqlConnection(Settings.GetConnectionString()))
{
SqlCommand cmd = new SqlCommand("GuildRolesSelectAll", conn);
cmd.CommandType = System.Data.CommandType.StoredProcedure;
conn.Open();
using (SqlDataReader dr = cmd.ExecuteReader())
{
while (dr.Read())
{
GuildRole row = new GuildRole();
row.RoleID = (int)dr["RoleID"];
row.RoleName = dr["RoleName"].ToString();
roles.Add(row);
}
}
}
return(roles);
}
public GuildRole GetRoleById(int?id)
{
GuildRole role = null;
using (var conn = new SqlConnection(Settings.GetConnectionString()))
{
SqlCommand cmd = new SqlCommand("GuildRolesSelect", conn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@RoleID", id);
conn.Open();
using (SqlDataReader dr = cmd.ExecuteReader())
{
if (dr.Read())
{
role = new GuildRole();
role.RoleID = (int)dr["RoleID"];
role.RoleName = dr["RoleName"].ToString();
}
}
return(role);
}
}
public GuildRole GetRole(GuildRoles roles, string roleName)
{
GuildRole role = new GuildRole();
roleName = roleName.ToUpper();
role = roles.Where(x => x.Name.ToUpper() == roleName).FirstOrDefault();
return(role);
}
public async Task SetAsync([NotNull] Spectacles.NET.Types.Guild entry, string?parent = null)
{
await Task.WhenAll(Context.GuildMembers.SetAsync(entry.Members, entry.Id),
Context.GuildRoles.SetAsync(entry.Roles.Select(x => GuildRole.From(Context.Client, x)), entry.Id),
Context.GuildChannels.SetAsync(entry.Channels.Select(x => GuildChannel.From(Context.Client, x)),
entry.Id),
Context.VoiceStates.SetAsync(entry.VoiceStates.Select(x => VoiceState.From(Context.Client, x)),
entry.Id),
Context.GuildEmojis.SetAsync(entry.Emojis.Select(x => GuildEmoji.From(Context.Client, x)),
entry.Id),
SetAsync(Guild.From(Context.Client, entry), parent));
}
