public List <ertesitendok_struct> Data_ProjektErtesitendokKapcsolt() // javítva használja: interviewpanel { string command = "SELECT users.id, name, email FROM users INNER JOIN projekt_ertesitendok_kapcs ON ertesitendok_id = users.id WHERE projekt_id = " + pControl.ProjektID + ""; List <ertesitendok_struct> list = mySql.getErtesitendok(command); mySql.close(); return(list); }
public List <ertesitendok_struct> Data_ErtesitendokCheckbox(string ertesitendok_src) { string command = "SELECT id, name ,email FROM users WHERE name LIKE '%" + ertesitendok_src + "%' AND kategoria = 0"; List <ertesitendok_struct> list = mySql.getErtesitendok(command); mySql.close(); return(list); }
public List <ertesitendok_struct> Data_Ertesitendok() { string command = "SELECT * FROM users WHERE kategoria = 0"; List <ertesitendok_struct> list = mySql.getErtesitendok(command); mySql.close(); return(list); }