public void settingDelete(int id, string table)
{
string command = "DELETE FROM " + table + " WHERE id=" + id + "";
mySql.update(command);
mySql.close();
}
public void add(string comment, int project_id, int applicant_id, int teljesites)
{
DateTime dateTime = DateTime.Now;
if (teljesites >= 10)
{
teljesites = 10;
}
string command = "INSERT INTO megjegyzesek (jelolt_id,projekt_id,hr_id,hr_nev,megjegyzes,datum,ertekeles) VALUES (" + applicant_id + "," + project_id + "," + sess.UserData[0].id + ",'" + sess.UserData[0].name + "','" + comment + "','" + dateTime.ToString("yyyy. MM. dd.") + "'," + teljesites + ")";
mySql.update(command);
mySql.close();
}
public void telephoneFilterInsert(int ismerte, int muszakok, string utazas) //javított
{
string command = "UPDATE projekt_jelolt_kapcs SET allapota = 1 WHERE projekt_id = " + pControl.ProjektID + " AND jelolt_id = " + aControl.ApplicantID + "";
mySql.update(command);
command = "UPDATE jeloltek SET pmk_ismerte = " + ismerte + " WHERE id = " + aControl.ApplicantID + "";
mySql.update(command);
command = "INSERT INTO jelolt_statisztika (id, jelolt_id, utazas, muszakok) VALUES(null, " + aControl.ApplicantID + ", '" + utazas + "', " + muszakok + ")";
mySql.update(command);
mySql.close();
}
public void userRegistration(string username, string name, string email, int kategoria)
{
DateTime dateTime = DateTime.Now;
mySql.update("INSERT INTO `users` (`id`, `username`, `name`, `email`, `kategoria`, `jogosultsag`, `validitas`, `belepve`, `reg_datum`) VALUES (NULL, '" + username + "', '" + name + "', '" + email + "', '" + kategoria + "', '1', '1', '" + dateTime.ToString("yyyy. MM. dd.") + "', '" + dateTime.ToString("yyyy. MM. dd.") + "');");
mySql.close();
}
public void applicalntProjectListDelete(int id) //javított
{
string command = "DELETE FROM projekt_jelolt_kapcs WHERE projekt_id = " + id + " AND jelolt_id = " + ApplicantID + ";";
mySql.update(command);
mySql.close();
}
public void Activity_write()
{
//List<activity_struct> list)
Model.MySql mySql = new Model.MySql();
DateTime dateTime = DateTime.Now;
string command = "INSERT INTO `activity_log` (`id`, `hr_id`, `nev`, `tipus`, `leiras`, `datum`) VALUES(NULL, 1, 'nev', 'tipus', 'leiras', '" + dateTime.ToString() + "')";
//string query = "INSERT INTO `activity_log` (`id`, `hr_id`, `nev`, `tipus`, `leiras`, `datum`) VALUES(NULL, "+list[1]+ ", '" + list[2] + "', '" + list[3] + "', '" + list[4] + "', '"+ dateTime.ToString("hu-HU") + "')";
mySql.update(command);
mySql.close();
}
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();
}