public List <DKyPhong> Search(string str)
{
List <DKyPhong> listRoom = new List <DKyPhong>();
DataTable data = DataProvider.Instance.ExecuteQuery($"EXEC TimKiemdkp N'{str}'");
foreach (DataRow item in data.Rows)
{
DKyPhong dkphong = new DKyPhong(item);
listRoom.Add(dkphong);
}
return(listRoom);
}
public List <DKyPhong> GetListRoom()
{
List <DKyPhong> listRoom = new List <DKyPhong>();
DataTable data = DataProvider.Instance.ExecuteQuery("SELECT * FROM dbo.DangKyPhong");
foreach (DataRow item in data.Rows)
{
DKyPhong dkphong = new DKyPhong(item);
listRoom.Add(dkphong);
}
return(listRoom);
}