protected void modositasClick(object sender, RoutedEventArgs e)
{
Session.isUpdate = true;
ModelProjectList itemSource = (sender as MenuItem).DataContext as ModelProjectList;
Session.ProjektID = itemSource.id;
Utilities.NavigateTo(grid, new NewProjectPanel(grid));
}
protected void projectOpenClick(object sender, RoutedEventArgs e)
{
ModelProjectList items = (sender as Button).DataContext as ModelProjectList;
Session.ProjektID = items.id;
Utilities.SetReturnPage(Utilities.Views.ProjectList);
Session.ProjectSearchValue = GetSearchValues();
Utilities.NavigateTo(grid, new ProjectDataSheet(grid, new Project(items.id)));
}
protected void projectArchivateClick(object sender, RoutedEventArgs e)
{
MessageBoxResult result = MessageBox.Show("Biztosan módosítani szeretnéd?", "HR Cloud", MessageBoxButton.YesNoCancel);
switch (result)
{
case MessageBoxResult.Yes:
ModelProjectList items = (sender as MenuItem).DataContext as ModelProjectList;
new Project(items.id).projectArchiver(items.id, items.statusz);
ProjectListLoad();
break;
case MessageBoxResult.No:
break;
case MessageBoxResult.Cancel:
break;
}
}
protected void projectDeleteClick(object sender, RoutedEventArgs e)
{
MessageBoxResult result = MessageBox.Show("Biztosan törölni szeretnéd? \n", "HR Cloud", MessageBoxButton.YesNoCancel);
switch (result)
{
case MessageBoxResult.Yes:
ModelProjectList items = (sender as MenuItem).DataContext as ModelProjectList;
Project.Delete(items.id);
ProjectListLoad();
break;
case MessageBoxResult.No:
break;
case MessageBoxResult.Cancel:
break;
}
}
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));
}
