public List <StayWhere> GetStayWheres() { List <StayWhere> stayWheres = new List <StayWhere>(); MySqlCommand cmd = new MySqlCommand(); cmd.Connection = connect; cmd.CommandText = "SELECT sw.id, sw.name" + " FROM stay_where sw" + " ORDER BY sw.id"; using (DbDataReader reader = cmd.ExecuteReader()) { if (reader.HasRows) { while (reader.Read()) { StayWhere stayWhere = new StayWhere() { Id = reader.GetInt32(0), Name = reader.GetValue(1).ToString(), }; stayWheres.Add(stayWhere); } } } return(stayWheres); }
public StayWhere GetStayWhere(string name) { StayWhere stayWhere = null; MySqlCommand cmd = new MySqlCommand(); cmd.Connection = connect; cmd.CommandText = "SELECT sw.id, sw.name" + " FROM stay_where sw" + $@" WHERE sw.name = '{name}'" + " ORDER BY sw.id"; using (DbDataReader reader = cmd.ExecuteReader()) { if (reader.HasRows) { reader.Read(); stayWhere = new StayWhere() { Id = reader.GetInt32(0), Name = reader.GetValue(1).ToString(), }; } } return(stayWhere); }