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