public List <ModelApplicantSzakmaiList> Data_JeloltKapcsSzakmai(int projekt_id)
{
string command = " SELECT jeloltek.id, jeloltek.nev, coalesce((jelolt_allapot_szakmai.state),0) as state FROM jeloltek LEFT JOIN projekt_jelolt_kapcs ON projekt_jelolt_kapcs.jelolt_id = jeloltek.id LEFT JOIN jelolt_allapot_szakmai ON jeloltek.id = jelolt_allapot_szakmai.jelolt_id WHERE projekt_jelolt_kapcs.projekt_id = " + projekt_id;
List <ModelApplicantSzakmaiList> list = new ModelApplicantSzakmaiList().Get(command);
return(list);
}
protected void openApplicant(object sender, RoutedEventArgs e)
{
Button button = sender as Button;
ModelApplicantSzakmaiList items = button.DataContext as ModelApplicantSzakmaiList;
Session.ApplicantID = items.id;
grid.Children.Clear();
grid.Children.Add(szakmaiApplicantDataView = new SzakmaiApplicantDataView(grid));
}
private void Interju_igenyles_Click(object sender, RoutedEventArgs e)
{
Button button = sender as Button;
ModelApplicantSzakmaiList items = button.DataContext as ModelApplicantSzakmaiList;
inter_date_year.Text = DateTime.Now.Year.ToString();
inter_date_month.Text = DateTime.Now.Month.ToString();
inter_date_day.Text = "";
var grid = (Grid)this.FindName("Interview_request_panel");
grid.Visibility = Visibility.Visible;
inter_jelolt.Text = items.nev;
inter_jelolt_id.Text = items.id.ToString();
}