public static List <ModelErtesitendok> Data_InterjuErtesitendokKapcsolt() // javítva használja: interviewpanel
{
string command = "SELECT users.id, name, email, kategoria, jogosultsag, validitas FROM interju_resztvevo_kapcs left JOIN users ON user_id = users.id WHERE interju_id = " + Session.InterViewID + " GROUP BY users.id";
List <ModelErtesitendok> list = ModelErtesitendok.GetModelErtesitendok(command);
return(list);
}
public static List <ModelErtesitendok> Data_ProjektErtesitendokKapcsolt() // javítva használja: interviewpanel
{
string command = "SELECT users.id, name, email, kategoria, jogosultsag, validitas FROM users INNER JOIN projekt_ertesitendok_kapcs ON ertesitendok_id = users.id WHERE projekt_id = " + Session.ProjektID + " GROUP BY users.id";
List <ModelErtesitendok> list = ModelErtesitendok.GetModelErtesitendok(command);
return(list);
}
protected void ertesitendoDeleteClick(object sender, RoutedEventArgs e)
{
Button delete = sender as Button;
ModelErtesitendok items = delete.DataContext as ModelErtesitendok;
project.ertesitendokKapcsDelete(items.id);
kapcs_ertesitendo_listBox.ItemsSource = util.Data_ErtesitendokKapcs();
}
protected void addColleagueToInterview(object sender, RoutedEventArgs e)
{
Button btn = sender as Button;
ModelErtesitendok items = btn.DataContext as ModelErtesitendok;
Interview.Insert(items.id);
choose_editlist.ItemsSource = Interview.Data_ProjektErtesitendokKapcsolt();
ertesitendok_editlist.ItemsSource = Interview.Data_InterjuErtesitendokKapcsolt();
}
protected void removeColleague(object sender, RoutedEventArgs e)
{
if (Session.UserData.kategoria >= 1)
{
MenuItem menu = sender as MenuItem;
ModelErtesitendok items = menu.DataContext as ModelErtesitendok;
Interview.DeleteInvited(items.id);
choose_editlist.ItemsSource = Interview.Data_ProjektErtesitendokKapcsolt();
ertesitendok_editlist.ItemsSource = Interview.Data_InterjuErtesitendokKapcsolt();
}
}
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();
}
}
public List <ModelErtesitendok> Data_Ertesitendok()
{
return(ModelErtesitendok.GetModelErtesitendok("SELECT * FROM users WHERE kategoria = 0 AND validitas = 1"));
}
public List <ModelErtesitendok> Data_ErtesitendokKapcs() // javítva
{
string command = "SELECT users.id, name, email, kategoria, jogosultsag, validitas FROM users INNER JOIN projekt_ertesitendok_kapcs ON users.id = projekt_ertesitendok_kapcs.ertesitendok_id WHERE projekt_ertesitendok_kapcs.projekt_id =" + Session.ProjektID + " AND users.validitas = 1 GROUP BY users.id";
return(ModelErtesitendok.GetModelErtesitendok(command));
}
public List <ModelErtesitendok> Data_ErtesitendokCheckbox(string ertesitendok_src = "")
{
string command = "SELECT id, name ,email, kategoria, jogosultsag, validitas FROM users WHERE name LIKE '%" + ertesitendok_src + "%'";
return(ModelErtesitendok.GetModelErtesitendok(command));
}
