private Room GetRoomExecQuery(string query)
{
if (connection.State == System.Data.ConnectionState.Closed)
{
connection.Open();
}
MySqlCommand command = new MySqlCommand(query, connection);
Room room = null;
using (reader = command.ExecuteReader())
{
while (reader.Read())
{
room = roomDAL.GetRoom(reader);
}
}
connection.Close();
return(room);
}