/// <summary>
/// Load the LinkedList of Room for a Building
/// </summary>
/// <param name="building">The Building the Rooms are in</param>
/// <returns>Linked List of rooms</returns>
public LinkedList loadRoomList(Building building)
{
LinkedList roomList = new LinkedList();
Room tempRoom;
string sqlStatment = "SELECT * FROM Room WHERE BuildingID LIKE " + building.getID();
try
{
OpenConection();
cmd = new OleDbCommand(sqlStatment, conn);
reader = cmd.ExecuteReader();
while (reader.Read())
{
if (reader["Deleted"].ToString().Equals("False"))
{
tempRoom = new Room();
tempRoom.setID(reader["ID"].ToString());
tempRoom.setRoomNumber(reader["Number"].ToString());
tempRoom.setCapacity(Convert.ToInt32(reader["Capacity"]));
tempRoom.setRoomType(reader["RoomType"].ToString());
tempRoom.setSlotsOff(reader["SlotsOff"].ToString());
roomList.addAtTail(tempRoom);
}
}
CloseConnection();
}
catch
{
// MessageBox.Show("Failed to get data from source");
}
return roomList;
}
