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