public List <UpgradeData> GetUpgradeInfo() { List <UpgradeData> list = new List <UpgradeData>(); using (MySqlConnection conn = db.GetConnection()) { //conn.Open(); string query = String.Format( "SELECT upgrade_type, upgrade_level, upgrade_amount, upgrade_cost FROM tb_upgrade_info"); Console.WriteLine(query); using (MySqlCommand cmd = (MySqlCommand)conn.CreateCommand()) { cmd.CommandText = query; using (MySqlDataReader reader = (MySqlDataReader)cmd.ExecuteReader()) { while (reader.Read()) { UpgradeData data = new UpgradeData(); data.UpgradeType = reader.GetString(0); data.UpgradeLevel = reader.GetInt32(1); data.UpgradeAmount = reader.GetInt32(2); data.UpgradeCost = reader.GetInt32(3); list.Add(data); } } } } return(list); }
public UpgradeData GetUpgradeInfo(string UpgradeType, int UpgradeLevel) { UpgradeData data = new UpgradeData(); using (MySqlConnection conn = db.GetConnection()) { if (conn.State == System.Data.ConnectionState.Open) { conn.Close(); } conn.Open(); string query = String.Format( @" SELECT upgrade_type, upgrade_level, upgrade_amount, upgrade_cost FROM tb_upgrade_info WHERE upgrade_type = '{0}' AND upgrade_level = {1} ", UpgradeType, UpgradeLevel); Console.WriteLine(query); using (MySqlCommand cmd = (MySqlCommand)conn.CreateCommand()) { cmd.CommandText = query; try { using (MySqlDataReader reader = (MySqlDataReader)cmd.ExecuteReader()) { if (reader.Read()) { data.UpgradeType = reader.GetString(0); data.UpgradeLevel = reader.GetInt32(1); data.UpgradeAmount = reader.GetInt32(2); data.UpgradeCost = reader.GetInt32(3); return(data); } } } catch { return(null); } } } return(null); }