public List <NguonMinhChung_MinhChungDTO> SearchListNguonMinhChung_MinhChung(string valueToSearch)
{
List <NguonMinhChung_MinhChungDTO> List = new List <NguonMinhChung_MinhChungDTO>();
string query = string.Format("SELECT NMChungMChung.ID_NguonMinhChung, NMChungMChung.ID_TaiLieu, NMChung.MaNguonMinhChung, NMChung.TenNguonMinhChung, MChung.MaTaiLieu, MChung.TenTaiLieu, NMChungMChung.GhiChu " +
"FROM dbo.NguonMinhChung_MinhChung NMChungMChung, dbo.NguonMinhChung NMChung, dbo.MinhChung MChung " +
"WHERE NMChungMChung.ID_NguonMinhChung = NMChung.ID_NguonMinhChung AND NMChungMChung.ID_TaiLieu = MChung.ID_TaiLieu AND CONCAT(NMChung.MaNguonMinhChung, NMChung.TenNguonMinhChung, MChung.MaTaiLieu, MChung.TenTaiLieu, NMChungMChung.GhiChu) LIKE N'%" + valueToSearch + "%'");
DataTable dataTable = DataBaseConnection.Instance.ExecuteQuery(query);
foreach (DataRow dataRow in dataTable.Rows)
{
NguonMinhChung_MinhChungDTO nguonMinhChung_MinhChung = new NguonMinhChung_MinhChungDTO(dataRow);
List.Add(nguonMinhChung_MinhChung);
}
return(List);
}
public List <NguonMinhChung_MinhChungDTO> GetListNguonMinhChung_MinhChung()
{
List <NguonMinhChung_MinhChungDTO> List = new List <NguonMinhChung_MinhChungDTO>();
string query = "SELECT NMChungMChung.ID_NguonMinhChung, NMChungMChung.ID_TaiLieu, NMChung.TenNguonMinhChung, NMChung.NoiDungNguonMinhChung, MChung.MaTaiLieu, MChung.TenTaiLieu, NMChungMChung.GhiChu " +
"FROM dbo.NguonMinhChung_MinhChung NMChungMChung, dbo.NguonMinhChung NMChung, dbo.MinhChung MChung " +
"WHERE NMChungMChung.ID_NguonMinhChung = NMChung.ID_NguonMinhChung AND NMChungMChung.ID_TaiLieu = MChung.ID_TaiLieu";
DataTable dataTable = DataBaseConnection.Instance.ExecuteQuery(query);
foreach (DataRow dataRow in dataTable.Rows)
{
NguonMinhChung_MinhChungDTO nguonMinhChung_MinhChung = new NguonMinhChung_MinhChungDTO(dataRow);
List.Add(nguonMinhChung_MinhChung);
}
return(List);
}
