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