public static void DeleteApplicant(int id, bool recruited = false) //javított használja: applicantlist { MySqlDB mySql = new MySqlDB(); string command = "DELETE FROM jeloltek WHERE jeloltek.id = " + id + ";"; mySql.Execute(command); command = "DELETE FROM kepessegek WHERE kepessegek.jelolt_id = " + id + ";"; mySql.Execute(command); if (recruited) { command = "DELETE FROM projekt_jelolt_kapcs_kulsos WHERE projekt_jelolt_kapcs_kulsos.jelolt_id = " + id + ";"; mySql.Execute(command); } else { command = "DELETE FROM projekt_jelolt_kapcs WHERE projekt_jelolt_kapcs.jelolt_id = " + id + ";"; mySql.Execute(command); } command = "DELETE FROM megjegyzesek WHERE megjegyzesek.jelolt_id = " + id + ";"; mySql.Execute(command); mySql.Close(); try{ Files.DeleteFolder(id); } catch { } }
public void interviewDelete(int id) // javítva { MySqlDB mySql = new MySqlDB(); mySql.Execute("DELETE FROM interview WHERE interview.id=" + id + " AND hr_id=" + Session.UserData.id + ""); mySql.Execute("DELETE FROM interju_resztvevo_kapcs WHERE interju_id=" + id + " "); mySql.Close(); }
public void jeloltKapcsDelete(int id) { MySqlDB mySql = new MySqlDB(); string command; command = "DELETE FROM projekt_jelolt_kapcs WHERE jelolt_id = " + id + " AND projekt_id = " + Session.ProjektID + ";"; mySql.Execute(command); command = "DELETE FROM interview WHERE jelolt_id = " + id + " AND projekt_id = " + Session.ProjektID + ";"; mySql.Execute(command); mySql.Close(); }
public static void telephoneFilterInsert(int ismerte, int muszakok, string utazas) //javított { MySqlDB mySql = new MySqlDB(); string command = "UPDATE projekt_jelolt_kapcs SET allapota = 1 WHERE projekt_id = " + Session.ProjektID + " AND jelolt_id = " + Session.ApplicantID + ""; mySql.Execute(command); command = "UPDATE jeloltek SET pmk_ismerte = " + ismerte + " WHERE id = " + Session.ApplicantID + ""; mySql.Execute(command); command = "INSERT INTO jelolt_statisztika (id, jelolt_id, utazas, muszakok) VALUES(null, " + Session.ApplicantID + ", '" + utazas + "', " + muszakok + ")"; mySql.Execute(command); mySql.Close(); }
public static void Insert(ModelInsertProject data) // javított newprojectpanel { MySqlDB mySql = new MySqlDB(); 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, " + data.hr_id + ", '" + data.megnevezes_projekt + "'," + data.pc + "," + data.vegzettseg + "," + data.tapasztalat_ev + "," + data.statusz + ",'" + data.fel_datum + "','" + data.le_datum + "'," + data.nyelvtudas + "," + data.munkakor + "," + data.szuldatum + "," + data.ber + "," + data.kepesseg1 + "," + data.kepesseg2 + "," + data.kepesseg3 + "," + data.kepesseg4 + "," + data.kepesseg5 + ",'" + data.feladatok + "','" + data.elvarasok + "','" + data.kinalunk + "');"; mySql.Execute(command); int proID = Convert.ToInt16(mySql.UniqueList("SELECT projektek.id FROM projektek WHERE projektek.megnevezes_projekt = '" + data.megnevezes_projekt + "' AND projektek.pc = " + data.pc + " AND projektek.munkakor = '" + data.munkakor + "'", "projektek", 1)[0]); Session.ProjektID = proID; command = "INSERT INTO`projekt_ertesitendok_kapcs` (projekt_id,ertesitendok_id) VALUES(" + proID + "," + Session.UserData.id + ")"; mySql.Execute(command); mySql.Close(); }
public static void AcceptRecruited(ModelFreelancerApplicant applicant) //javított használja: applicantlist { List <ModelProjektJeloltKapcs> kapcsolatok = ModelProjektJeloltKapcs.Get("SELECT * FROM projekt_jelolt_kapcs_kulsos WHERE jelolt_id = " + applicant.id + ""); MySqlDB mySql = new MySqlDB(); string command = "UPDATE jeloltek SET ervenyes = 1, friss = false WHERE id = " + applicant.id + ";"; mySql.Execute(command); foreach (var item in kapcsolatok) { command = "INSERT INTO projekt_jelolt_kapcs (id, projekt_id, jelolt_id, hr_id,allapota, datum) VALUES (NULL, " + item.projekt_id + ", " + item.jelolt_id + ", " + Session.UserData.id + ",4, '" + DateTime.Now.ToString("yyyy.MM.dd") + "' );"; mySql.Execute(command); } command = "DELETE FROM projekt_jelolt_kapcs_kulsos WHERE projekt_jelolt_kapcs_kulsos.jelolt_id = " + applicant.id + ";"; mySql.Execute(command); }
public static void Update(ModelInsertProject data) // javított newprojectpanel { MySqlDB mySql = new MySqlDB(); string command = "UPDATE projektek SET " + " `hr_id` = " + data.hr_id + ", " + "`megnevezes_projekt` = '" + data.megnevezes_projekt + "', " + " `pc` = " + data.pc + ", " + "`vegzettseg` = " + data.vegzettseg + ", " + "`tapasztalat_ev` = " + data.tapasztalat_ev + ", " + "`statusz` = " + data.statusz + ", " + "`nyelvtudas` = " + data.nyelvtudas + ", " + "`munkakor` = " + data.munkakor + ", " + "`szuldatum` = " + data.szuldatum + ", " + "`ber` = " + data.ber + ", " + "`kepesseg1` = " + data.kepesseg1 + ", " + "`kepesseg2` = " + data.kepesseg2 + ", " + "`kepesseg3` = " + data.kepesseg3 + ", " + "`kepesseg4` = " + data.kepesseg4 + ", " + "`kepesseg5` = " + data.kepesseg5 + " WHERE id = " + Session.ProjektID + ""; mySql.Execute(command); int proID = Convert.ToInt16(mySql.UniqueList("SELECT projektek.id FROM projektek WHERE projektek.megnevezes_projekt = '" + data.megnevezes_projekt + "' AND projektek.pc = " + data.pc + " AND projektek.munkakor = '" + data.munkakor + "'", "projektek", 1)[0]); Session.ProjektID = proID; mySql.Close(); }
public void insertWeb(MySqlDB mySql) { string command = "INSERT INTO `freelancer_list`(`id`, `name`, `email`) VALUES (" + id + ",'" + name + "','" + email + "')"; mySql.Execute(command); mySql.Close(); }
public void projectDescriptionUpdate(string type, string content) // javított { MySqlDB mySql = new MySqlDB(); string command = ""; switch (type) { case "feladatok": command = "UPDATE projektek SET feladatok='" + content + "' WHERE projektek.id = " + Session.ProjektID + ""; break; case "elvarasok": command = "UPDATE projektek SET elvarasok='" + content + "' WHERE projektek.id = " + Session.ProjektID + ""; break; case "kinalunk": command = "UPDATE projektek SET kinalunk='" + content + "' WHERE projektek.id = " + Session.ProjektID + ""; break; case "elonyok": command = "UPDATE projektek SET elonyok='" + content + "' WHERE projektek.id = " + Session.ProjektID + ""; break; default: break; } mySql.Execute(command); mySql.Close(); }
public void SetSent() { state = 1; MySqlDB mySql = new MySqlDB(); mySql.Execute("UPDATE `email_storage` SET `state` = 1 WHERE `id` = " + id + ";"); }
public int Fullify(ModelProfession prof) { MySqlDB mySql = new MySqlDB(); string command = "INSERT INTO jeloltek (nev,email,telefon,reg_date" + (!prof.szuldatum.Equals("") ? ",szuldatum" : "") + (!prof.lakhely.Equals("") ? ",lakhely" : "") + (!prof.neme.Equals(9999) ? ",neme": "") + (!prof.vegzettseg.Equals(9999) ? ",vegz_terulet" : "") + (!prof.nyelvtudas.Equals(9999) ? ",nyelvtudas" : "") + (!prof.ertesult.Equals(9999) ? ",ertesult" : "") + ") VALUES ('" + prof.name + "','" + prof.email + "','" + prof.telephone + "','" + prof.reg_date + "'" + (!prof.szuldatum.Equals("") ? ",'" + prof.szuldatum.ToString() + "'" : "") + (!prof.lakhely.Equals("") ? ",'" + prof.lakhely.ToString() + "'" : "") + (!prof.neme.Equals(9999) ? "," + prof.neme.ToString() : "") + (!prof.vegzettseg.Equals(9999) ? "," + prof.vegzettseg.ToString() : "") + (!prof.nyelvtudas.Equals(9999) ? "," + prof.nyelvtudas.ToString() : "") + (!prof.ertesult.Equals(9999) ? "," + prof.ertesult.ToString() : "") + ")"; mySql.Execute(command); mySql.Close(); ModelFullApplicant udata = Applicant.GetFullApplicantByEmail(prof.email); DirectoryInfo profession = new DirectoryInfo(Files.GetStatisticsUrl() + prof.id); DirectoryInfo newID = new DirectoryInfo(Files.GetApplicantUrl() + udata.id); Files.CopyAll(profession, newID); Delete(prof.id); return(udata != null ? udata.id : 0); }
public static void Update(ModelFullApplicant data) //javított { MySqlDB mySql = new MySqlDB(); string query = "UPDATE jeloltek SET " + " `nev` = '" + data.nev + "'" + ", `email` = '" + data.email + "'" + ", `telefon` = '" + data.telefon + "'" + ", `lakhely` = '" + data.lakhely + "'" + ", `ertesult` = " + data.ertesult + "" + ", `szuldatum` = '" + data.szuldatum + "'" + ", `neme` = " + data.neme + "" + ", `tapasztalat_ev` = " + data.tapasztalat_ev + "" + ", `munkakor` = " + data.munkakor + "" + ", `munkakor2` = " + data.munkakor2 + "" + ", `munkakor3` = " + data.munkakor3 + "" + ", `vegz_terulet` = " + data.vegz_terulet + "" + ", `nyelvtudas` = " + data.nyelvtudas + "" + ",`nyelvtudas2` = " + data.nyelvtudas2 + "" + ", `reg_date` = '" + data.reg_date + "'" + "WHERE jeloltek.id = " + Session.ApplicantID + ""; mySql.Execute(query); int appID = Convert.ToInt16(mySql.UniqueList("SELECT jeloltek.id FROM jeloltek WHERE jeloltek.email = '" + data.email + "' AND jeloltek.nev = '" + data.nev + "' AND jeloltek.lakhely = '" + data.lakhely + "'", "jeloltek", 1)[0]); Session.ApplicantID = appID; mySql.Close(); }
public void DeleteProjectConncetion(int id) { MySqlDB mySql = new MySqlDB(); string command = "DELETE FROM projekt_jelolt_kapcs WHERE projekt_id = " + id + " AND jelolt_id = " + Session.ApplicantID + ";"; mySql.Execute(command); mySql.Close(); }
public static void UpdateTest(List <int> list) // javítva használja: interviewpanel { MySqlDB mySql = new MySqlDB(); string command = "INSERT INTO `kompetencia_jelolt_kapcs` (`interju_id`, `projekt_id`, `jelolt_id`, `hr_id`, `k1_id`, `k1_val`, `k2_id`, `k2_val`, `k3_id`, `k3_val`, `k4_id`, `k4_val`, `k5_id`, `k5_val`, tamogatom) VALUES (" + Session.InterViewID + ", " + Session.ProjektID + ", " + Session.ApplicantID + ", " + Session.UserData.id + ", " + list[0] + ", " + list[1] + ", " + list[2] + ", " + list[3] + ", " + list[4] + ", " + list[5] + ", " + list[6] + ", " + list[7] + ", " + list[8] + ", " + list[9] + ", " + list[10] + ");"; mySql.Execute(command); mySql.Close(); }
public static void DeleteInvited(int id) // javítva { MySqlDB mySql = new MySqlDB(); string command = "DELETE FROM `interju_resztvevo_kapcs` WHERE user_id = " + id + ""; mySql.Execute(command); mySql.Close(); }
public void Delete(int id) { MySqlDB mySql = new MySqlDB(); string command = "DELETE FROM pmkcvtest.errorlog WHERE id =" + id; mySql.Execute(command); mySql.Close(); }
public void Update(ModelErrorLog data) { MySqlDB mySql = new MySqlDB(); string command = "UPDATE pmkcvtest.errorlog SET placeofbug='" + data.placeofbug + "', description='" + data.description + "', solution='" + data.solution + "', date='" + data.date + "', result='" + data.result + "', resultdate='" + data.resultdate + "'"; mySql.Execute(command); mySql.Close(); }
public void madeSent(int id) // javítva { MySqlDB mySql = new MySqlDB(); string command = "UPDATE `interview` SET sent = 1 WHERE id = " + id + ""; mySql.Execute(command); mySql.Close(); }
//public static void SaveUser(string username) //javítva használja: login //{ // SqLite.Update("DELETE FROM 'app';"); // SqLite.Update("INSERT INTO 'app' (username) VALUES ('" + username + "');"); // MySql.Close(); //} //public static void DeleteSavedUser() //javítva használja: login //{ // SqLite.Update("DELETE FROM 'app';"); // MySql.Close(); //} public static void Registration(string username, string name, string email, int kategoria) { MySqlDB mySql = new MySqlDB(); DateTime dateTime = DateTime.Now; mySql.Execute("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 static void Delete(int megjegyzes_id) { MySqlDB mySql = new MySqlDB(); string command = "DELETE FROM megjegyzesek WHERE megjegyzesek.id = " + megjegyzes_id; mySql.Execute(command); mySql.Close(); }
public void projectCostDelete(int id) // javított { MySqlDB mySql = new MySqlDB(); string command = "DELETE FROM projekt_koltsegek WHERE projekt_koltsegek.id = " + id + ""; mySql.Execute(command); mySql.Close(); }
public static void DeleteFromFavorite(int id) //javított { MySqlDB mySql = new MySqlDB(); string command = "DELETE FROM jelolt_megfigyelt WHERE jelolt_megfigyelt.jelolt_id = " + id + ";"; mySql.Execute(command); mySql.Close(); }
public void Delete(int id) //javított { MySqlDB mySql = new MySqlDB(); string command = "DELETE FROM jelolt_allapot_szakmai WHERE id = " + id + ";"; mySql.Execute(command); mySql.Close(); }
public void projectCostInsert(string megnevezes, string osszeg) // javított { MySqlDB mySql = new MySqlDB(); string command = "INSERT INTO `projekt_koltsegek` (id, projekt_id, koltseg_megnevezes, osszeg) VALUES (null, " + Session.ProjektID + ", '" + megnevezes + "', " + osszeg + ");"; mySql.Execute(command); mySql.Close(); }
public void DeleteRecruitedProjectConnection(int projectId, int applicantId) { MySqlDB mySql = new MySqlDB(); string command = "DELETE FROM projekt_jelolt_kapcs_kulsos WHERE projekt_id = " + projectId + " AND jelolt_id = " + applicantId + ";"; mySql.Execute(command); mySql.Close(); }
public void publishProject(int stat) { MySqlDB mySql = new MySqlDB(); string command = "UPDATE projektek SET publikalt= " + stat + " WHERE projektek.id = " + Session.ProjektID + ";"; mySql.Execute(command); mySql.Close(); }
public void Insert(ModelErrorLog data) { MySqlDB mySql = new MySqlDB(); string command = "INSERT INTO errorlog (`placeofbug`, `description`, `solution`, `date`) VALUES ('" + data.placeofbug + "','" + data.description + "','" + data.solution + "','" + data.date + "')"; mySql.Execute(command); mySql.Close(); }
public void jeloltKapcsUpdate(int id, int allapota) { MySqlDB mySql = new MySqlDB(); string command = "UPDATE projekt_jelolt_kapcs SET allapota = " + allapota + " WHERE jelolt_id = " + id + " AND projekt_id = " + Session.ProjektID + ";"; mySql.Execute(command); mySql.Close(); }
public void ertesitendokKapcsDelete(int id) { MySqlDB mySql = new MySqlDB(); string command = "DELETE FROM projekt_ertesitendok_kapcs WHERE ertesitendok_id = " + id + " AND projekt_id = " + Session.ProjektID + ";"; mySql.Execute(command); mySql.Close(); }
public void Delete(int ApplicantID) { MySqlDB mySql = new MySqlDB(); string command = "DELETE FROM profession_jeloltek WHERE id=" + ApplicantID; mySql.Execute(command); mySql.Close(); Files.DeleteProfessionFolder(ApplicantID); }