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