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