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);
}
