public static List <Empresario> GetAll() { using (MySqlConnection conn = new MySqlConnection(Properties.Settings.Default.DB)) { conn.Open(); using (MySqlCommand cmd = new MySqlCommand("Select * from empresario_view", conn)) { MySqlDataReader reader = cmd.ExecuteReader(); List <Empresario> empresarios = new List <Empresario>(); while (reader.Read()) { empresarios.Add(Empresario.FromDB(reader)); } return(empresarios); } } }
public static Empresario GetDados(int id) { using (MySqlConnection conn = new MySqlConnection(Properties.Settings.Default.DB)) { conn.Open(); using (MySqlCommand cmd = new MySqlCommand("Select * from empresario_view WHERE idPessoa = @id", conn)) { cmd.Parameters.AddWithValue("@id", id); MySqlDataReader reader = cmd.ExecuteReader(); if (!reader.Read()) { return(null); } return(Empresario.FromDB(reader)); } } }