public List <Phong> GetListRoomNoEmpty() { List <Phong> listRoom = new List <Phong>(); DataTable data = DataProvider.Instance.ExecuteQuery("SELECT * FROM dbo.Phong WHERE tinhtrang=N'Có người'"); foreach (DataRow item in data.Rows) { Phong p = new Phong(item); listRoom.Add(p); } return(listRoom); }
public List <Phong> GetListRoom() { List <Phong> listRoom = new List <Phong>(); DataTable data = DataProvider.Instance.ExecuteQuery("SELECT * FROM Phong"); foreach (DataRow item in data.Rows) { Phong food = new Phong(item); listRoom.Add(food); } return(listRoom); }