public static List <Palestra> GetAllPalestrasSimposio(int id)
{
using (MySqlConnection conn = new MySqlConnection(Properties.Settings.Default.DB))
{
conn.Open();
using (MySqlCommand cmd = new MySqlCommand("Select * from palestras_simposio_view WHERE idSimposio = @id order by dataEvento DESC", conn))
{
cmd.Parameters.AddWithValue("@id", id);
List <Palestra> palestras = new List <Palestra>();
MySqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
palestras.Add(Palestra.FromDB(reader));
}
return(palestras);
}
}
}
public static bool CreatePalestraSimposio(Palestra palestra)
{
try
{
using (MySqlConnection conn = new MySqlConnection(Properties.Settings.Default.DB))
{
conn.Open();
using (MySqlCommand sqlCommand = new MySqlCommand("INSERT INTO palestrasimposio VALUES(@id1,@id2)", conn))
{
sqlCommand.Parameters.AddWithValue("@id2", palestra.idSimposio);
sqlCommand.Parameters.AddWithValue("@id1", palestra.idPalestra);
sqlCommand.ExecuteNonQuery();
}
conn.Close();
}
return(true);
}
catch (Exception e)
{
return(false);
}
}
