public List <ModelApplicantListbox> Data_JeloltForCheckbox()
{
string command = "SELECT jeloltek.id, nev FROM jeloltek LEFT JOIN projekt_jelolt_kapcs ON projekt_jelolt_kapcs.jelolt_id = jeloltek.id WHERE projekt_jelolt_kapcs.projekt_id != " + Session.ProjektID + " OR projekt_jelolt_kapcs.projekt_id IS NULL GROUP BY jeloltek.id";
List <ModelApplicantListbox> list = ModelApplicantListbox.GetModelApplicantListboxShort(command);
return(list);
}
public static List <ModelApplicantListbox> GetAllActive(string name = "") //javított
{
string command = "SELECT id, nev FROM jeloltek WHERE jeloltek.statusz = 1 AND jeloltek.ervenyes = 1 AND nev LIKE '%" + name + "%'";
List <ModelApplicantListbox> list = ModelApplicantListbox.GetModelApplicantListboxShort(command);
return(list);
}
protected void addPerson(object sender, RoutedEventArgs e)
{
Button btn = sender as Button;
if (selectedTabCode == 1)
{
ModelApplicantListbox items = btn.DataContext as ModelApplicantListbox;
new Applicant(items.id).AddToProject(project.data.id);
projekt_kapcsolodo_list.ItemsSource = Applicant.GetAllActive(AddApplicantSearchTbx.Text);
kapcs_jeloltek_listBox.ItemsSource = util.Data_JeloltKapcs();
}
if (selectedTabCode == 2)
{
ModelErtesitendok items = btn.DataContext as ModelErtesitendok;
project.addErtesitendokInsert(items.id);
projekt_kapcsolodo_list.ItemsSource = util.Data_ErtesitendokCheckbox(AddApplicantSearchTbx.Text);
kapcs_ertesitendo_listBox.ItemsSource = util.Data_ErtesitendokKapcs();
}
}