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;
}
}
