public List <MonHoc_NhomTuChonDTO> SearchListMonHoc_NhomTuChon(string valueToSearch) { List <MonHoc_NhomTuChonDTO> List = new List <MonHoc_NhomTuChonDTO>(); string query = string.Format("SELECT MHocMTChon.ID_MonHoc, MHocMTChon.ID_NhomTuChon, MHoc.MaMonHoc, MHoc.TenMonHoc, NTChon.MaNhomTuChon, NTChon.TenNhomTuChon, MHocMTChon.GhiChu " + "FROM dbo.MonHoc_NhomTuChon MHocMTChon, dbo.MonHoc MHoc, dbo.NhomTuChon NTChon " + "WHERE MHocMTChon.ID_MonHoc = MHoc.ID_MonHoc AND MHocMTChon.ID_NhomTuChon = NTChon.ID_NhomTuChon AND CONCAT(MHoc.MaMonHoc, MHoc.TenMonHoc, NTChon.MaNhomTuChon, NTChon.TenNhomTuChon, MHocMTChon.GhiChu) LIKE N'%" + valueToSearch + "%'"); DataTable dataTable = DataBaseConnection.Instance.ExecuteQuery(query); foreach (DataRow dataRow in dataTable.Rows) { MonHoc_NhomTuChonDTO monHoc_NhomTuChon = new MonHoc_NhomTuChonDTO(dataRow); List.Add(monHoc_NhomTuChon); } return(List); }
public List <MonHoc_NhomTuChonDTO> GetListMonHoc_NhomTuChon() { List <MonHoc_NhomTuChonDTO> List = new List <MonHoc_NhomTuChonDTO>(); string query = "SELECT MHocMTChon.ID_MonHoc, MHocMTChon.ID_NhomTuChon, MHoc.MaMonHoc, MHoc.TenMonHoc, NTChon.MaNhomTuChon, NTChon.TenNhomTuChon, MHocMTChon.GhiChu " + "FROM dbo.MonHoc_NhomTuChon MHocMTChon, dbo.MonHoc MHoc, dbo.NhomTuChon NTChon " + "WHERE MHocMTChon.ID_MonHoc = MHoc.ID_MonHoc AND MHocMTChon.ID_NhomTuChon = NTChon.ID_NhomTuChon"; DataTable dataTable = DataBaseConnection.Instance.ExecuteQuery(query); foreach (DataRow dataRow in dataTable.Rows) { MonHoc_NhomTuChonDTO monHoc_NhomTuChon = new MonHoc_NhomTuChonDTO(dataRow); List.Add(monHoc_NhomTuChon); } return(List); }