public List <MocThamChieuDTO> SearchListMocThamChieu(string valueToSearch)
{
List <MocThamChieuDTO> List = new List <MocThamChieuDTO>();
string query = string.Format("SELECT * FROM dbo.MocThamChieu WHERE CONCAT(MaMocThamChieu, TenMocThamChieu, NoiDungMocThamChieu, GhiChu) LIKE N'%" + valueToSearch + "%'");
DataTable dataTable = DataBaseConnection.Instance.ExecuteQuery(query);
foreach (DataRow dataRow in dataTable.Rows)
{
MocThamChieuDTO mocThamChieu = new MocThamChieuDTO(dataRow);
List.Add(mocThamChieu);
}
return(List);
}
public List <MocThamChieuDTO> GetListMocThamChieu()
{
List <MocThamChieuDTO> List = new List <MocThamChieuDTO>();
string query = "SELECT * FROM dbo.MocThamChieu";
DataTable dataTable = DataBaseConnection.Instance.ExecuteQuery(query);
foreach (DataRow dataRow in dataTable.Rows)
{
MocThamChieuDTO mocThamChieu = new MocThamChieuDTO(dataRow);
List.Add(mocThamChieu);
}
return(List);
}
