public static List <Participacao> GetParticipacoesEmEventos() { using (MySqlConnection conn = new MySqlConnection(Properties.Settings.Default.DB)) { conn.Open(); using (MySqlCommand cmd = new MySqlCommand("SELECT * FROM participacoes_evento_view", conn)) { MySqlDataReader reader = cmd.ExecuteReader(); List <Participacao> participacoes = new List <Participacao>(); while (reader.Read()) { participacoes.Add(Participacao.FromDB(reader)); } return(participacoes); } } }
public static List <Participacao> GetParticipacoes(int id) { using (MySqlConnection conn = new MySqlConnection(Properties.Settings.Default.DB)) { conn.Open(); using (MySqlCommand cmd = new MySqlCommand("SELECT * FROM participacoes_evento_view where idPessoa=@id", conn)) { cmd.Parameters.AddWithValue("@id", id); MySqlDataReader reader = cmd.ExecuteReader(); List <Participacao> participacoes = new List <Participacao>(); while (reader.Read()) { participacoes.Add(Participacao.FromDB(reader)); } return(participacoes); } } }