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