public List <TuitionFee> GetById() { try { //prepare connection string using (MySqlConnection con = new MySqlConnection(GOCSystem2018.Config.GetConnectionString())) { //try to open connection con.Open(); //prepare sql query string sql = "SELECT * FROM tuition_fee WHERE id =@id;"; MySqlCommand cmd = new MySqlCommand(sql, con); cmd.Parameters.AddWithValue("id", id); MySqlDataReader reader = cmd.ExecuteReader(); //loop while have record while (reader.Read()) { //instantiate model TuitionFee tuitionFee = new TuitionFee(); //prepare properties tuitionFee.id = Convert.ToInt32(reader["id"].ToString()); tuitionFee.tuitionFeeName = reader["tuition_fee_name"].ToString(); tuitionFee.tuitionFeeAmount = reader["tuition_amount"].ToString(); tuitionFee.tuitionFeeDescription = reader["tuition_desc"].ToString(); tuitionFee.status = reader["status"].ToString(); tuitionFee.reservationFee = reader["Reservation_Fee"].ToString(); tuitionFee.dept = reader["Department"].ToString(); tuitionFees.Add(tuitionFee); } } } catch (MySqlException ex) { MessageBox.Show("ERROR : " + ex.ToString(), "System Message", MessageBoxButtons.OK, MessageBoxIcon.Error); } return(tuitionFees); }