public List<Room> GetRoom()
{
sqlStr="select *from Room";
myTable = DBHelper.GetTable(sqlStr, tableName);
if (myTable!=null)
{
roomList = new List<Room>();
foreach (DataRow dr in myTable.Rows)
{
room = new Room();
room.Number =Convert.ToInt32(dr["Number"]);
room.TypeId = Convert.ToInt32(dr["TypeID"]);
room.BedNumber = Convert.ToInt32(dr["BedNumber"]);
room.Desciption = (string)dr["Description"];
room.State = (string)dr["State"];
room.GuestNumber = Convert.ToInt32(dr["GuestNumber"]);
room.RoomType = new RoomTypeServer().GetRoomType(room.TypeId);
room.Guest = new GuestServer().GetGuestById(room.GuestNumber);
roomList.Add(room);
}
}
return roomList;
}