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