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