protected ModelProjectSearchBar GetSearchValues() { ModelProjectSearchBar value = new ModelProjectSearchBar(); ModelNyelv nyelvItem = null; ModelVegzettseg vegzettsegItem = null; string nyelvkStr = ""; string vegzettsegStr = ""; try { nyelvItem = (nyelv_srccbx as ComboBox).SelectedItem as ModelNyelv; vegzettsegItem = (vegzettseg_srccbx as ComboBox).SelectedItem as ModelVegzettseg; } catch (Exception) { } try { if (vegzettsegItem.id != -1) { vegzettsegStr = vegzettsegItem.id.ToString(); } } catch (Exception) { } try { if (nyelvItem.id != -1) { nyelvkStr = nyelvItem.id.ToString(); } } catch (Exception) {} string jeloltszam = jeloltszam_srcinp.Text; if (jeloltszam_srcinp.Text == "") { jeloltszam = "0"; } string interjuk = interju_srcinp.Text; if (interju_srcinp.Text == "") { interjuk = "0"; } string publikalt = ""; if (publikalt_check.IsChecked == true) { publikalt = "1"; } string sorrend = " ASC"; if (sorrend_check.IsChecked == true) { sorrend = " DESC"; } value = new ModelProjectSearchBar { projektnev = projektnev_srcinp.Text, jeloltszam = jeloltszam, publikalva = publikalva_srcinp.Text, interjuk = interjuk, pc = pc_srcinp.Text, nyelvkStr = nyelvkStr, nyelvIndex = nyelv_srccbx.SelectedIndex, vegzettsegStr = vegzettsegStr, vegzettsegIndex = vegzettseg_srccbx.SelectedIndex, cimke = cimke_srcinp.Text, jeloltnev = jeloltnev_srcinp.Text, publikalt = publikalt, publikaltBool = publikalt_check.IsChecked.Value, HeaderSelected = HeaderSelected, sorrend = sorrend }; return(value); }
public static List <ModelProjectList> GetProjectList(ModelProjectSearchBar value) { List <ModelProjectList> list = new List <ModelProjectList>(); string command = "SELECT coalesce((SELECT count(jelolt_id) FROM projekt_jelolt_kapcs WHERE projekt_id = projektek.id GROUP BY jeloltek.id LIMIT 1),0) as jeloltek_db, coalesce((SELECT count(jelolt_id) FROM interview WHERE projekt_id = projektek.id LIMIT 1),0) as interjuk_db, projektek.id, projektek.publikalt, megnevezes_projekt, megnevezes_munka, fel_datum, projektek.statusz FROM projektek LEFT JOIN projekt_jelolt_kapcs ON projektek.id = projekt_jelolt_kapcs.projekt_id LEFT JOIN jeloltek ON jeloltek.id = projekt_jelolt_kapcs.jelolt_id LEFT JOIN munkakor ON munkakor.id = projektek.munkakor LEFT JOIN pc ON pc.id = projektek.pc LEFT JOIN megjegyzesek ON projektek.id = megjegyzesek.projekt_id " + " WHERE projektek.statusz=" + Session.ProjectStatusz; if (value.projektnev != "") { command += " AND projektek.megnevezes_projekt LIKE '%" + value.projektnev + "%' "; } if (value.jeloltszam != "0") { command += " AND coalesce((SELECT count(projekt_id) FROM projekt_jelolt_kapcs WHERE projekt_id = projektek.id Group by projekt_id LIMIT 1),0) >=" + value.jeloltszam + " "; } if (value.publikalva != "") { command += " AND projektek.fel_datum LIKE '%" + value + "%' "; } if (value.interjuk != "0") { command += " AND coalesce((SELECT count(jelolt_id) FROM interview WHERE projekt_id = projektek.id Group by jelolt_id LIMIT 1),0) >=" + value.interjuk + " "; } if (value.pc != "") { command += " AND pc.megnevezes_pc LIKE '%" + value.pc + "%' "; } if (value.nyelvkStr != "" && value.nyelvkStr != "1") { command += " AND projektek.nyelvtudas LIKE '%" + value.nyelvkStr + "%' "; } if (value.vegzettsegStr != "" && value.vegzettsegStr != "1") { command += " AND projektek.vegzettseg LIKE '%" + value.vegzettsegStr + "%' "; } if (value.cimke != "") { command += " AND megjegyzesek.megjegyzes LIKE '%" + value.cimke + "%' "; } if (value.jeloltnev != "") { command += " AND jeloltek.nev LIKE '%" + value.jeloltnev + "%' "; } if (value.publikalt != "") { command += " AND projektek.publikalt LIKE '%" + value.publikalt + "%' "; } command += " GROUP BY projektek.id "; switch (value.HeaderSelected) { case "1": command += " ORDER BY projektek.id" + value.sorrend; break; case "2": command += " ORDER BY projektek.megnevezes_projekt" + value.sorrend; break; case "3": command += " ORDER BY projektek.munkakor" + value.sorrend; break; case "4": command += " ORDER BY jeloltek_db" + value.sorrend; break; case "5": command += " ORDER BY projektek.fel_datum" + value.sorrend; break; default: command += " ORDER BY projektek.fel_datum DESC"; break; } return(ModelProjectList.GetModelProjectList(command)); }
protected void SetSearchValues() { if (Session.ProjectSearchValue == null) { return; } ModelProjectSearchBar value = Session.ProjectSearchValue; projektnev_srcinp.Text = value.projektnev; jeloltnev_srcinp.Text = value.jeloltnev; pc_srcinp.Text = value.pc; publikalva_srcinp.Text = value.publikalva; cimke_srcinp.Text = value.cimke; publikalt_check.IsChecked = value.publikaltBool; nyelv_srccbx.SelectedIndex = value.nyelvIndex; vegzettseg_srccbx.SelectedIndex = value.vegzettsegIndex; if (value.jeloltszam == "0") { value.jeloltszam = ""; jeloltszam_label.Visibility = Visibility.Visible; } else { jeloltszam_srcinp.Text = value.jeloltszam; } if (value.interjuk == "0") { value.interjuk = ""; interju_label.Visibility = Visibility.Visible; } else { interju_srcinp.Text = value.interjuk; } if (value.projektnev.Length > 0) { projektnev_label.Visibility = Visibility.Hidden; } if (value.jeloltnev.Length > 0) { jeloltnev_label.Visibility = Visibility.Hidden; } if (value.jeloltszam.Length > 0) { jeloltszam_label.Visibility = Visibility.Hidden; } if (value.pc.Length > 0) { pc_label.Visibility = Visibility.Hidden; } if (value.interjuk.Length > 0) { interju_label.Visibility = Visibility.Hidden; } if (value.publikalva.Length > 0) { publikalva_label.Visibility = Visibility.Hidden; } if (value.cimke.Length > 0) { cimke_label.Visibility = Visibility.Hidden; } }