public void projectInsert(List <ProjectInsertListItems> items) // javított newprojectpanel
{
string command = "INSERT INTO projektek (`id`, `hr_id`, `megnevezes_projekt`, `pc`, `vegzettseg`, `tapasztalat_ev`, `statusz`, `fel_datum`, `le_datum`, `nyelvtudas`, `munkakor`, `szuldatum`, `ber`, `kepesseg1`, `kepesseg2`, `kepesseg3`, `kepesseg4`, `kepesseg5`, `feladatok`, `elvarasok`, `kinalunk`)" +
" VALUES (NULL, " + items[0].hr_id + ", '" + items[0].megnevezes_projekt + "'," + items[0].pc + "," + items[0].vegzettseg + "," + items[0].tapasztalat_ev + "," + items[0].statusz + ",'" + items[0].fel_datum + "','" + items[0].le_datum + "'," + items[0].nyelvtudas + "," + items[0].munkakor + "," + items[0].szuldatum + "," + items[0].ber + "," + items[0].kepesseg1 + "," + items[0].kepesseg2 + "," + items[0].kepesseg3 + "," + items[0].kepesseg4 + "," + items[0].kepesseg5 + ",'" + items[0].feladatok + "','" + items[0].elvarasok + "','" + items[0].kinalunk + "');";
mySql.update(command);
int proID = Convert.ToInt16(mySql.listQuery("SELECT projektek.id FROM projektek WHERE projektek.megnevezes_projekt = '" + items[0].megnevezes_projekt + "' AND projektek.pc = " + items[0].pc + " AND projektek.munkakor = '" + items[0].munkakor + "'", "projektek", 1)[0]);
ProjektID = proID;
mySql.close();
}
public void applicantInsert(List <JeloltExtendedList> items) //javított
{
string command = "INSERT INTO jeloltek (`id`, `nev`, `email`, `telefon`, `lakhely`, `ertesult`, `szuldatum`, neme, `tapasztalat_ev`, `munkakor`, `munkakor2`, `munkakor3`, `vegz_terulet`, `nyelvtudas`,`nyelvtudas2`, `reg_date`) " +
"VALUES(NULL, '" + items[0].nev + "', '" + items[0].email + "', '" + items[0].telefon + "', '" + items[0].lakhely + "', " + items[0].ertesult + ", " + items[0].szuldatum + ", " + items[0].neme + "," + items[0].tapasztalat_ev + "," + items[0].munkakor + "," + items[0].munkakor2 + "," + items[0].munkakor3 + "," + items[0].vegz_terulet + "," + items[0].nyelvtudas + "," + items[0].nyelvtudas2 + ",'" + items[0].reg_date + "');";
mySql.update(command);
command = "SELECT jeloltek.id FROM jeloltek WHERE jeloltek.email = '" + items[0].email + "' AND jeloltek.nev = '" + items[0].nev + "'";
mySql.close();
ApplicantID = Convert.ToInt16(mySql.listQuery(command, "jeloltek", 1)[0]);
mySql.close();
}