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