/// <summary> /// Get the selected id from the database. /// </summary> /// <returns>List</returns> public List <Adobo> GetById() { try { using (MySqlConnection con = new MySqlConnection(AwesomeAdobo.Config.GetConnectionString())) { //open connection con.Open(); //set query string string sql = "SELECT * FROM adobo WHERE id = @id"; //prepare command MySqlCommand cmd = new MySqlCommand(sql, con); //set parameters cmd.Parameters.AddWithValue("id", id); //execute query MySqlDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { Adobo adobo = new Adobo(); adobo.id = int.Parse(reader["id"].ToString()); adobo.color = reader["adobo_color"].ToString(); adobo.taste = reader["adobo_taste"].ToString(); adobo.lapotness = reader["adobo_lapotness"].ToString(); adobo.typeOfMeat = reader["adobo_type_of_meat"].ToString(); adobos.Add(adobo); } } } catch (MySqlException ex) { MessageBox.Show(ex.ToString()); } return(adobos); }
public List<Adobo> Read() { try { using (MySqlConnection con = new MySqlConnection(AwesomeAdobo.Config.GetConnectionString())) { //open connection con.Open(); //set query string string sql = "SELECT * FROM adobo WHERE active = 1"; //prepare command MySqlCommand cmd = new MySqlCommand(sql, con); //execute query MySqlDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { Adobo adobo = new Adobo(); adobo.id = int.Parse(reader["id"].ToString()); adobo.color = reader["adobo_color"].ToString(); adobo.taste = reader["adobo_taste"].ToString(); adobo.lapotness = reader["adobo_lapotness"].ToString(); adobo.typeOfMeat = reader["adobo_type_of_meat"].ToString(); adobos.Add(adobo); } } } catch (MySqlException ex) { MessageBox.Show(ex.ToString()); } return adobos; }