public static List <ModelSzakmaiBevont> Data_SzakmaiProject()
{
string command = "SELECT coalesce((SELECT count(jelolt_id) FROM projekt_jelolt_kapcs WHERE projekt_id = projektek.id),0) as jeloltek_db, projektek.id, megnevezes_projekt, megnevezes_munka FROM projektek LEFT JOIN munkakor ON munkakor.id = projektek.munkakor INNER JOIN projekt_ertesitendok_kapcs ON projektek.id = projekt_ertesitendok_kapcs.projekt_id WHERE projektek.statusz = 1 AND ertesitendok_id = " + Session.UserData.id + " GROUP BY id";
List <ModelSzakmaiBevont> list = ModelSzakmaiBevont.GetModelSzakmaiBevont(command);
return(list);
}
protected void openProject(object sender, RoutedEventArgs e)
{
Button button = sender as Button;
ModelSzakmaiBevont items = button.DataContext as ModelSzakmaiBevont;
Session.ProjektID = items.id;
grid.Children.Clear();
grid.Children.Add(szakmaiProjektDataSheet = new SzakmaiProjektDataSheet(grid));
}
