public List <NguonMinhChungDTO> SearchListNguonMinhChung(string valueToSearch)
{
List <NguonMinhChungDTO> List = new List <NguonMinhChungDTO>();
string query = string.Format("SELECT * FROM dbo.NguonMinhChung WHERE CONCAT(MaNguonMinhChung, TenNguonMinhChung, NoiDungNguonMinhChung, GhiChu) LIKE N'%" + valueToSearch + "%'");
DataTable dataTable = DataBaseConnection.Instance.ExecuteQuery(query);
foreach (DataRow dataRow in dataTable.Rows)
{
NguonMinhChungDTO nguonMinhChung = new NguonMinhChungDTO(dataRow);
List.Add(nguonMinhChung);
}
return(List);
}
public List <NguonMinhChungDTO> GetListNguonMinhChung()
{
List <NguonMinhChungDTO> List = new List <NguonMinhChungDTO>();
string query = "SELECT * FROM dbo.NguonMinhChung";
DataTable dataTable = DataBaseConnection.Instance.ExecuteQuery(query);
foreach (DataRow dataRow in dataTable.Rows)
{
NguonMinhChungDTO nguonMinhChung = new NguonMinhChungDTO(dataRow);
List.Add(nguonMinhChung);
}
return(List);
}