private void g_level_filtered_comms(string glevel) { AdvanceSearching LNEngine_AdvanceSearch = new AdvanceSearching(); switch (type) { case 1: LNEngine_AdvanceSearch.perform_search("ID", adsearch_txtbox.Text, glevel); results_lv.Items.Clear(); if (LNEngine_AdvanceSearch.dt.Rows.Count > 0) { for (int i = 0; i < LNEngine_AdvanceSearch.dt.Rows.Count; i++) { DataRow dr = LNEngine_AdvanceSearch.dt.Rows[i]; ListViewItem fetched_data = new ListViewItem(dr["ID"].ToString()); fetched_data.SubItems.Add(dr["ResourceN"].ToString()); fetched_data.SubItems.Add(dr["Author"].ToString()); // fetched_data.SubItems.Add(dr["GradeLevel"].ToString()); fetched_data.SubItems.Add(dr["w_tags"].ToString()); results_lv.Items.Add(fetched_data); } } break; case 2: LNEngine_AdvanceSearch.perform_search("Author", adsearch_txtbox.Text, glevel); results_lv.Items.Clear(); if (LNEngine_AdvanceSearch.dt.Rows.Count > 0) { for (int i = 0; i < LNEngine_AdvanceSearch.dt.Rows.Count; i++) { DataRow dr = LNEngine_AdvanceSearch.dt.Rows[i]; ListViewItem fetched_data = new ListViewItem(dr["ID"].ToString()); fetched_data.SubItems.Add(dr["ResourceN"].ToString()); fetched_data.SubItems.Add(dr["Author"].ToString()); // fetched_data.SubItems.Add(dr["GradeLevel"].ToString()); fetched_data.SubItems.Add(dr["w_tags"].ToString()); results_lv.Items.Add(fetched_data); } } break; case 3: LNEngine_AdvanceSearch.perform_search("Tags", adsearch_txtbox.Text, glevel); results_lv.Items.Clear(); if (LNEngine_AdvanceSearch.dt.Rows.Count > 0) { for (int i = 0; i < LNEngine_AdvanceSearch.dt.Rows.Count; i++) { DataRow dr = LNEngine_AdvanceSearch.dt.Rows[i]; ListViewItem fetched_data = new ListViewItem(dr["ID"].ToString()); fetched_data.SubItems.Add(dr["ResourceN"].ToString()); fetched_data.SubItems.Add(dr["Author"].ToString()); // fetched_data.SubItems.Add(dr["GradeLevel"].ToString()); fetched_data.SubItems.Add(dr["w_tags"].ToString()); results_lv.Items.Add(fetched_data); } } break; } }
private void search_type() { AdvanceSearching LNEngine_AdvanceSearch = new AdvanceSearching(); if (g_level_filt.SelectedItem.ToString() == "" | g_level_filt.SelectedItem.ToString() == "All" | String.IsNullOrWhiteSpace(g_level_filt.SelectedItem.ToString())) { switch (type) { case 1: LNEngine_AdvanceSearch.perform_search("ID", adsearch_txtbox.Text, ""); results_lv.Items.Clear(); if (LNEngine_AdvanceSearch.dt.Rows.Count > 0) { for (int i = 0; i < LNEngine_AdvanceSearch.dt.Rows.Count; i++) { DataRow dr = LNEngine_AdvanceSearch.dt.Rows[i]; ListViewItem fetched_data = new ListViewItem(dr["ID"].ToString()); fetched_data.SubItems.Add(dr["ResourceN"].ToString()); fetched_data.SubItems.Add(dr["Author"].ToString()); // fetched_data.SubItems.Add(dr["GradeLevel"].ToString()); fetched_data.SubItems.Add(dr["w_tags"].ToString()); results_lv.Items.Add(fetched_data); } } break; case 2: LNEngine_AdvanceSearch.perform_search("Author", adsearch_txtbox.Text, ""); results_lv.Items.Clear(); if (LNEngine_AdvanceSearch.dt.Rows.Count > 0) { for (int i = 0; i < LNEngine_AdvanceSearch.dt.Rows.Count; i++) { DataRow dr = LNEngine_AdvanceSearch.dt.Rows[i]; ListViewItem fetched_data = new ListViewItem(dr["ID"].ToString()); fetched_data.SubItems.Add(dr["ResourceN"].ToString()); fetched_data.SubItems.Add(dr["Author"].ToString()); // fetched_data.SubItems.Add(dr["GradeLevel"].ToString()); fetched_data.SubItems.Add(dr["w_tags"].ToString()); results_lv.Items.Add(fetched_data); } } break; case 3: LNEngine_AdvanceSearch.perform_search("Tags", adsearch_txtbox.Text, ""); results_lv.Items.Clear(); if (LNEngine_AdvanceSearch.dt.Rows.Count > 0) { for (int i = 0; i < LNEngine_AdvanceSearch.dt.Rows.Count; i++) { DataRow dr = LNEngine_AdvanceSearch.dt.Rows[i]; ListViewItem fetched_data = new ListViewItem(dr["ID"].ToString()); fetched_data.SubItems.Add(dr["ResourceN"].ToString()); fetched_data.SubItems.Add(dr["Author"].ToString()); // fetched_data.SubItems.Add(dr["GradeLevel"].ToString()); fetched_data.SubItems.Add(dr["w_tags"].ToString()); results_lv.Items.Add(fetched_data); } } break; } } else { switch (glevel_int) { case 11: g_level_filtered_comms("G7"); break; case 12: g_level_filtered_comms("G8"); break; case 13: g_level_filtered_comms("G9"); break; case 14: g_level_filtered_comms("G10"); break; //ADD CODES HERE } } }