public string Insert() { string id = null; MySql mySql = new MySql(); if (!mySql.bind("SELECT count(id) FROM jeloltek WHERE email='" + email + "'")) { DateTime localDate = DateTime.Now; ModelFullApplicant applicant = new ModelFullApplicant { nev = this.name, email = this.email, telefon = this.telephone, project = this.project, reg_date = localDate.ToString("yyyy.MM.dd"), megjegyzes = this.megjegyzes }; applicant.Insert(); ProjectConnection projectConn = new ProjectConnection(project) { project_name = this.project, email = this.email, date = localDate.ToString("yyyy.MM.dd") }; id = mySql.SqlSingleQuery("SELECT id FROM jeloltek WHERE email='" + email + "'", "id"); projectConn.Insert(Convert.ToInt32(id)); mySql.dbClose(); } else { id = mySql.SqlSingleQuery("SELECT id FROM jeloltek WHERE email = '" + email + "'", "id"); mySql.dbClose(); } return(id); //command = "SELECT jeloltek.id FROM jeloltek WHERE jeloltek.email = '" + items[0].email + "' AND jeloltek.nev = '" + items[0].nev + "'"; }
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 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 List <ModelFullApplicant> GetFullApplicant(int id = 0) { string command = "SELECT jeloltek.id,nev,email,telefon,lakhely,pmk_ismerte,szuldatum,neme,tapasztalat_ev, reg_date,felvett,jeloltek.megjegyzes,jeloltek.statusz,folderUrl,hirlevel,kategoria," + "coalesce((SELECT nem FROM nemek WHERE nemek.id = jeloltek.neme),'') AS neme," + "(SELECT nemek.id FROM nemek WHERE nemek.id = jeloltek.neme) AS id_neme," + "coalesce((SELECT megnevezes_munka FROM munkakor WHERE munkakor.id = jeloltek.munkakor),'') AS munkakor," + "coalesce((SELECT megnevezes_munka FROM munkakor WHERE munkakor.id = jeloltek.munkakor2),'') AS munkakor2," + "coalesce((SELECT megnevezes_munka FROM munkakor WHERE munkakor.id = jeloltek.munkakor3),'') AS munkakor3," + "coalesce((SELECT munkakor.id FROM munkakor WHERE munkakor.id = jeloltek.munkakor),0) AS id_munkakor," + "coalesce((SELECT munkakor.id FROM munkakor WHERE munkakor.id = jeloltek.munkakor2),0) AS id_munkakor2," + "coalesce((SELECT munkakor.id FROM munkakor WHERE munkakor.id = jeloltek.munkakor3),0) AS id_munkakor3," + "coalesce((SELECT megnevezes_nyelv FROM nyelv WHERE nyelv.id = jeloltek.nyelvtudas),'') AS nyelvtudas," + "coalesce((SELECT megnevezes_nyelv FROM nyelv WHERE nyelv.id = jeloltek.nyelvtudas2),'') AS nyelvtudas2," + "coalesce((SELECT nyelv.id FROM nyelv WHERE nyelv.id = jeloltek.nyelvtudas),0) AS id_nyelvtudas," + "coalesce((SELECT nyelv.id FROM nyelv WHERE nyelv.id = jeloltek.nyelvtudas2),0) AS id_nyelvtudas2," + "coalesce((SELECT ertesules_megnevezes FROM ertesulesek WHERE ertesulesek.id = jeloltek.ertesult),'') AS ertesules_megnevezes, " + "coalesce((SELECT ertesulesek.id FROM ertesulesek WHERE ertesulesek.id = jeloltek.ertesult),0) AS id_ertesult, " + "coalesce((SELECT megnevezes_vegzettseg FROM vegzettsegek WHERE vegzettsegek.id = jeloltek.vegz_terulet),'') AS vegz_terulet, " + "coalesce((SELECT vegzettsegek.id FROM vegzettsegek WHERE vegzettsegek.id = jeloltek.vegz_terulet),0) AS id_vegz_terulet " + "FROM jeloltek WHERE jeloltek.id = " + (id.Equals(0) ? Session.ApplicantID : id) + ""; List <ModelFullApplicant> list = ModelFullApplicant.GetModelFullApplicant(command); return(list); }
public static ModelFullApplicant GetFullApplicantByEmail(string email) { string command = "SELECT jeloltek.id,nev,email,telefon,lakhely,pmk_ismerte,szuldatum,neme,tapasztalat_ev, reg_date,felvett,jeloltek.megjegyzes,jeloltek.statusz,folderUrl,hirlevel,jeloltek.megjegyzes,kategoria," + "coalesce((SELECT nem FROM nemek WHERE nemek.id = jeloltek.neme),'') AS neme," + "(SELECT nemek.id FROM nemek WHERE nemek.id = jeloltek.neme) AS id_neme," + "coalesce((SELECT megnevezes_munka FROM munkakor WHERE munkakor.id = jeloltek.munkakor),'') AS munkakor," + "coalesce((SELECT megnevezes_munka FROM munkakor WHERE munkakor.id = jeloltek.munkakor2),'') AS munkakor2," + "coalesce((SELECT megnevezes_munka FROM munkakor WHERE munkakor.id = jeloltek.munkakor3),'') AS munkakor3," + "coalesce((SELECT munkakor.id FROM munkakor WHERE munkakor.id = jeloltek.munkakor),0) AS id_munkakor," + "coalesce((SELECT munkakor.id FROM munkakor WHERE munkakor.id = jeloltek.munkakor2),0) AS id_munkakor2," + "coalesce((SELECT munkakor.id FROM munkakor WHERE munkakor.id = jeloltek.munkakor3),0) AS id_munkakor3," + "coalesce((SELECT megnevezes_nyelv FROM nyelv WHERE nyelv.id = jeloltek.nyelvtudas),'') AS nyelvtudas," + "coalesce((SELECT megnevezes_nyelv FROM nyelv WHERE nyelv.id = jeloltek.nyelvtudas2),'') AS nyelvtudas2," + "coalesce((SELECT nyelv.id FROM nyelv WHERE nyelv.id = jeloltek.nyelvtudas),0) AS id_nyelvtudas," + "coalesce((SELECT nyelv.id FROM nyelv WHERE nyelv.id = jeloltek.nyelvtudas2),0) AS id_nyelvtudas2," + "coalesce((SELECT ertesules_megnevezes FROM ertesulesek WHERE ertesulesek.id = jeloltek.ertesult),'') AS ertesules_megnevezes, " + "coalesce((SELECT ertesulesek.id FROM ertesulesek WHERE ertesulesek.id = jeloltek.ertesult),0) AS id_ertesult, " + "coalesce((SELECT megnevezes_vegzettseg FROM vegzettsegek WHERE vegzettsegek.id = jeloltek.vegz_terulet),'') AS vegz_terulet, " + "coalesce((SELECT vegzettsegek.id FROM vegzettsegek WHERE vegzettsegek.id = jeloltek.vegz_terulet),0) AS id_vegz_terulet " + "FROM jeloltek WHERE jeloltek.email = '" + email + "'"; ModelFullApplicant applicant = ModelFullApplicant.GetModelFullApplicant(command)[0]; return(applicant); }
protected void applicantArchivateClick(object sender, RoutedEventArgs e) { MessageBoxResult result = MessageBox.Show("Biztosan megváltoztatod? \n\n", "HR Cloud", MessageBoxButton.YesNoCancel); switch (result) { case MessageBoxResult.Yes: ModelApplicantList items = (sender as MenuItem).DataContext as ModelApplicantList; selectedApplicant = new Applicant(items.id).data; if (selectedApplicant.statusz == 1) { Cimke_Grid.Visibility = Visibility.Visible; cimke_related_list.ItemsSource = new ModelCimkek().GetRelated(selectedApplicant.id); cimke_title.Text = "Cimkék (" + selectedApplicant.nev + ")"; } else { Utility.applicantArchiver(selectedApplicant.id, selectedApplicant.statusz); applicantListLoader(); } break; case MessageBoxResult.No: break; case MessageBoxResult.Cancel: break; } }
public static void Insert(ModelFullApplicant data) //javított { MySqlDB mySql = new MySqlDB(); string command = "INSERT INTO jeloltek (`id`, `nev`, `email`, `telefon`, `lakhely`, `ertesult`, `szuldatum`, neme, `tapasztalat_ev`, `munkakor`, `munkakor2`, `munkakor3`, `vegz_terulet`, `nyelvtudas`,`nyelvtudas2`, `reg_date`) " + "VALUES(NULL, '" + data.nev + "', '" + data.email + "', '" + data.telefon + "', '" + data.lakhely + "', " + data.ertesult + ", " + data.szuldatum + ", " + data.neme + "," + data.tapasztalat_ev + "," + data.munkakor + "," + data.munkakor2 + "," + data.munkakor3 + "," + data.vegz_terulet + "," + data.nyelvtudas + "," + data.nyelvtudas2 + ",'" + data.reg_date + "');"; mySql.Execute(command); command = "SELECT jeloltek.id FROM jeloltek WHERE jeloltek.email = '" + data.email + "' AND jeloltek.nev = '" + data.nev + "'"; mySql.Close(); Session.ApplicantID = Convert.ToInt16(mySql.UniqueList(command, "jeloltek", 1)[0]); mySql.Close(); }
protected void applicantModifyClick(object sender, RoutedEventArgs e) { if (isFulfilled()) { ModelFullApplicant applicant = getFormData(); Applicant.Update(getFormData()); Utilities.NavigateTo(grid, new ApplicantDataSheet(grid, new Applicant(applicant.id))); } else { showInfo.Text = "Nem lehet kitöltetlen mező!"; } }
protected ModelFullApplicant getFormData() { DateTime localDate = DateTime.Now; ModelFullApplicant items; ModelNem nemeComboBoxItem = (neme_cbx as ComboBox).SelectedItem as ModelNem; ModelNyelv nyelvComboBoxItem = (nyelv_cbx as ComboBox).SelectedItem as ModelNyelv; ModelNyelv nyelv2ComboBoxItem = (nyelv2_cbx as ComboBox).SelectedItem as ModelNyelv; ModelErtesulesek ertesulesComboBoxItem = (ertesules_cbx as ComboBox).SelectedItem as ModelErtesulesek; ModelMunkakor munkakorComboBoxItem = (munkakor_cbx as ComboBox).SelectedItem as ModelMunkakor; ModelMunkakor munkakor2ComboBoxItem = (munkakor2_cbx as ComboBox).SelectedItem as ModelMunkakor; ModelMunkakor munkakor3ComboBoxItem = (munkakor3_cbx as ComboBox).SelectedItem as ModelMunkakor; ModelVegzettseg vegzettsegComboBoxItem = (vegzettseg_cbx as ComboBox).SelectedItem as ModelVegzettseg; items = new ModelFullApplicant { id = 0, nev = nev_tbx.Text, email = email_tbx.Text, telefon = telefon_tbx.Text, lakhely = lakhely_tbx.Text, tapasztalat_ev = Convert.ToInt32((tapasztalat_tbx.Text.Length > 0? tapasztalat_tbx.Text : "0")), szuldatum = Convert.ToInt32(eletkor_tbx.Text.Length > 0 ? eletkor_tbx.Text : "0"), reg_date = localDate.ToString("yyyy.MM.dd."), neme = (neme_cbx.SelectedIndex.Equals(-1) ? "0" : nemeComboBoxItem.id.ToString()), munkakor = (munkakor_cbx.SelectedIndex.Equals(-1) ? "1" : munkakorComboBoxItem.id.ToString()), munkakor2 = (munkakor2_cbx.SelectedIndex.Equals(-1) ? "1" : munkakor2ComboBoxItem.id.ToString()), munkakor3 = (munkakor3_cbx.SelectedIndex.Equals(-1) ? "1" : munkakor3ComboBoxItem.id.ToString()), vegz_terulet = (vegzettseg_cbx.SelectedIndex.Equals(-1) ? "1" : vegzettsegComboBoxItem.id.ToString()), nyelvtudas = (nyelv_cbx.SelectedIndex.Equals(-1) ? "0" : nyelvComboBoxItem.id.ToString()), nyelvtudas2 = (nyelv2_cbx.SelectedIndex.Equals(-1) ? "0" : nyelv2ComboBoxItem.id.ToString()), ertesult = (ertesules_cbx.SelectedIndex.Equals(-1) ? "0" : ertesulesComboBoxItem.id.ToString()) }; return(items); }
public Applicant(int applicantId = 0) { this.data = GetFullApplicant(applicantId)[0]; this.list = GetFullApplicant(applicantId); }