public List <MonTienQuyetDTO> SearchListMonTienQuyet(string valueToSearch) { List <MonTienQuyetDTO> List = new List <MonTienQuyetDTO>(); string query = string.Format("SELECT MTQuyet.ID_MonHoc, MTQuyet.ID_MonHoc_TienQuyet, MHoc1.MaMonHoc, MHoc1.TenMonHoc, MHoc2.MaMonHoc AS MaMonHocTienQuyet, MHoc2.TenMonHoc AS TenMonHocTienQuyet, MTQuyet.GhiChu " + "FROM dbo.MonTienQuyet MTQuyet, dbo.MonHoc MHoc1, dbo.MonHoc MHoc2 " + "WHERE MTQuyet.ID_MonHoc = MHoc1.ID_MonHoc AND MTQuyet.ID_MonHoc_TienQuyet = MHoc2.ID_MonHoc AND CONCAT(MHoc1.MaMonHoc, MHoc1.TenMonHoc, MHoc2.MaMonHoc AS MaMonHocTienQuyet, MHoc2.TenMonHoc AS TenMonHocTienQuyet, MTQuyet.GhiChu) LIKE N'%" + valueToSearch + "%'"); DataTable dataTable = DataBaseConnection.Instance.ExecuteQuery(query); foreach (DataRow dataRow in dataTable.Rows) { MonTienQuyetDTO monTienQuyet = new MonTienQuyetDTO(dataRow); List.Add(monTienQuyet); } return(List); }
public List <MonTienQuyetDTO> GetListMonTienQuyet() { List <MonTienQuyetDTO> List = new List <MonTienQuyetDTO>(); string query = "SELECT MTQuyet.ID_MonHoc, MTQuyet.ID_MonHoc_TienQuyet, MHoc1.MaMonHoc, MHoc1.TenMonHoc, MHoc2.MaMonHoc AS MaMonHocTienQuyet, MHoc2.TenMonHoc AS TenMonHocTienQuyet, MTQuyet.GhiChu " + "FROM dbo.MonTienQuyet MTQuyet, dbo.MonHoc MHoc1, dbo.MonHoc MHoc2 " + "WHERE MTQuyet.ID_MonHoc = MHoc1.ID_MonHoc AND MTQuyet.ID_MonHoc_TienQuyet = MHoc2.ID_MonHoc"; DataTable dataTable = DataBaseConnection.Instance.ExecuteQuery(query); foreach (DataRow dataRow in dataTable.Rows) { MonTienQuyetDTO monTienQuyet = new MonTienQuyetDTO(dataRow); List.Add(monTienQuyet); } return(List); }