public List <StayLength> GetStayLengths()
{
List <StayLength> stayLengths = new List <StayLength>();
MySqlCommand cmd = new MySqlCommand();
cmd.Connection = connect;
cmd.CommandText = "SELECT sl.id, sl.name" +
" FROM stay_length sl" +
" ORDER BY sl.id";
using (DbDataReader reader = cmd.ExecuteReader()) {
if (reader.HasRows)
{
while (reader.Read())
{
StayLength stayLength = new StayLength()
{
Id = reader.GetInt32(0),
Name = reader.GetValue(1).ToString(),
};
stayLengths.Add(stayLength);
}
}
}
return(stayLengths);
}
public StayLength GetStayLength(string name)
{
StayLength stayLength = null;
MySqlCommand cmd = new MySqlCommand();
cmd.Connection = connect;
cmd.CommandText = "SELECT sl.id, sl.name" +
" FROM stay_length sl" +
$@" WHERE sl.name = '{name}'" +
" ORDER BY sl.id";
using (DbDataReader reader = cmd.ExecuteReader()) {
if (reader.HasRows)
{
reader.Read();
stayLength = new StayLength()
{
Id = reader.GetInt32(0),
Name = reader.GetValue(1).ToString(),
};
}
}
return(stayLength);
}