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