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