public void addJeloltInsert(int jelolt_index, int projekt_index) { string command = "SELECT * FROM projekt_jelolt_kapcs"; DateTime dateTime = DateTime.Now; List <projekt_jelolt_kapcs> list = mySql.getPojectApplicantRelation(command); bool notexist = true; foreach (var i in list) { if (i.projekt_id == projekt_index && i.jelolt_id == jelolt_index) { notexist = false; } } if (notexist) { command = "INSERT INTO projekt_jelolt_kapcs (id, projekt_id, jelolt_id, hr_id, datum) VALUES (NULL, " + projekt_index + ", " + jelolt_index + ", " + session.UserData[0].id + ", '" + dateTime.ToString("yyyy.MM.dd.") + "' );"; mySql.update(command); } mySql.close(); }