private void synchronizeResources()
{
List <ModelProjektek> projektList = ModelProjektek.getProjektek("SELECT id, megnevezes_projekt, statusz, fel_datum FROM projektek WHERE statusz=1");
Utility.deleteWebTable("projektek");
foreach (var item in projektList)
{
item.insertWeb(mySqlWeb);
}
List <ModelErtesulesek> ertesulesekList = ModelErtesulesek.getErtesulesek("SELECT id, ertesules_megnevezes FROM ertesulesek");
Utility.deleteWebTable("ertesulesek");
foreach (var item in ertesulesekList)
{
item.insertWeb(mySqlWeb);
}
List <ModelNyelv> nyelvList = ModelNyelv.getNyelv("SELECT id, megnevezes_nyelv FROM nyelv");
Utility.deleteWebTable("nyelv");
foreach (var item in nyelvList)
{
item.insertWeb(mySqlWeb);
}
List <ModelVegzettseg> vegzettsegList = ModelVegzettseg.getVegzettsegek("SELECT id, megnevezes_vegzettseg FROM vegzettsegek");
Utility.deleteWebTable("vegzettsegek");
foreach (var item in vegzettsegList)
{
item.insertWeb(mySqlWeb);
}
List <ModelFreelancerList> freelancerList = ModelFreelancerList.getFreelancerList("SELECT * FROM freelancer_list");
Utility.deleteWebTable("freelancer_list");
foreach (var item in freelancerList)
{
item.insertWeb(mySqlWeb);
}
List <ModelJelentkezesek> jelentkezesekList = ModelJelentkezesek.getJelentkezesekWeb("SELECT * FROM jelentkezesek");
Utility.deleteTable("jelentkezesek");
foreach (var item in jelentkezesekList)
{
item.Insert(mySql);
}
if (mySql != null)
{
mySql.dbClose();
}
if (mySqlWeb != null)
{
mySqlWeb.dbClose();
}
}
protected ModelInsertProject getData()
{
ModelVegzettseg vegzettsegComboBox = (vegzettseg_cbx as ComboBox).SelectedItem as ModelVegzettseg;
ModelMunkakor munkakorComboBox = (munkakor_cbx as ComboBox).SelectedItem as ModelMunkakor;
ModelNyelv nyelvComboBox = (nyelv_cbx as ComboBox).SelectedItem as ModelNyelv;
ModelKompetenciak kepzettseg1ComboBox = (k1_cbx as ComboBox).SelectedItem as ModelKompetenciak;
ModelKompetenciak kepzettseg2ComboBox = (k2_cbx as ComboBox).SelectedItem as ModelKompetenciak;
ModelKompetenciak kepzettseg3ComboBox = (k3_cbx as ComboBox).SelectedItem as ModelKompetenciak;
ModelKompetenciak kepzettseg4ComboBox = (k4_cbx as ComboBox).SelectedItem as ModelKompetenciak;
ModelKompetenciak kepzettseg5ComboBox = (k5_cbx as ComboBox).SelectedItem as ModelKompetenciak;
ModelPc pcComboBox = (pc_cbx as ComboBox).SelectedItem as ModelPc;
DateTime localDate = DateTime.Now;
ModelInsertProject data;
data = new ModelInsertProject
{
id = 0,
fel_datum = localDate.ToString("yyyy.MM.dd"),
le_datum = "-",
statusz = 1,
szuldatum = 0,
megnevezes_projekt = nev_tbx.Text,
hr_id = Session.UserData.id,
tapasztalat_ev = Convert.ToInt32((tapasztalat_tbx.Text.Length > 0 ? tapasztalat_tbx.Text : "0")),
ber = Convert.ToInt32((ber_tbx.Text.Length > 0 ? ber_tbx.Text : "0")),
pc = pcComboBox.id,
nyelvtudas = Convert.ToInt32(nyelv_cbx.SelectedIndex.Equals(-1) ? "0" : nyelvComboBox.id.ToString()),
munkakor = Convert.ToInt32(munkakor_cbx.SelectedIndex.Equals(-1) ? "0" : munkakorComboBox.id.ToString()),
vegzettseg = Convert.ToInt32(vegzettseg_cbx.SelectedIndex.Equals(-1) ? "0" : vegzettsegComboBox.id.ToString()),
kepesseg1 = Convert.ToInt32(k1_cbx.SelectedIndex.Equals(-1) ? "0" : kepzettseg1ComboBox.id.ToString()),
kepesseg2 = Convert.ToInt32(k2_cbx.SelectedIndex.Equals(-1) ? "0" : kepzettseg2ComboBox.id.ToString()),
kepesseg3 = Convert.ToInt32(k3_cbx.SelectedIndex.Equals(-1) ? "0" : kepzettseg3ComboBox.id.ToString()),
kepesseg4 = Convert.ToInt32(k4_cbx.SelectedIndex.Equals(-1) ? "0" : kepzettseg4ComboBox.id.ToString()),
kepesseg5 = Convert.ToInt32(k5_cbx.SelectedIndex.Equals(-1) ? "0" : kepzettseg5ComboBox.id.ToString()),
};
return(data);
}
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);
}
protected void DeleteListItem(object sender, RoutedEventArgs e)
{
MessageBoxResult result = MessageBox.Show("Biztosan törölni szeretnéd? \n", "HR Cloud", MessageBoxButton.YesNoCancel);
switch (result)
{
case MessageBoxResult.Yes:
MenuItem menuItem = sender as MenuItem;
ModelVegzettseg items = menuItem.DataContext as ModelVegzettseg;
int id = 9999;
switch (menuItem.Tag.ToString())
{
case "munkakor":
id = (menuItem.DataContext as ModelMunkakor).id;
break;
case "pc":
id = (menuItem.DataContext as ModelPc).id;
break;
case "ertesulesek":
id = (menuItem.DataContext as ModelErtesulesek).id;
break;
case "vegzettsegek":
id = (menuItem.DataContext as ModelVegzettseg).id;
break;
case "nyelv":
id = (menuItem.DataContext as ModelNyelv).id;
break;
case "kompetenciak":
id = (menuItem.DataContext as ModelKompetenciak).id;
break;
case "jelolt_cimkek":
id = (menuItem.DataContext as ModelCimkek).id;
break;
case "freelancer_list":
id = (menuItem.DataContext as ModelFreelancerList).id;
break;
default:
break;
}
if (id != 9999)
{
util.Delete(id, menuItem.Tag.ToString());
}
listLoader();
break;
case MessageBoxResult.No:
break;
case MessageBoxResult.Cancel:
break;
}
}
public List <ModelVegzettseg> Data_Vegzettseg() //javított
{
return(ModelVegzettseg.GetModelVegzettseg("SELECT * FROM vegzettsegek"));
}
protected ModelProjectSearchBar GetSearchValues()
{
ModelProjectSearchBar value = new ModelProjectSearchBar();
ModelNyelv nyelvItem = null;
ModelVegzettseg vegzettsegItem = null;
string nyelvkStr = "";
string vegzettsegStr = "";
try
{
nyelvItem = (nyelv_srccbx as ComboBox).SelectedItem as ModelNyelv;
vegzettsegItem = (vegzettseg_srccbx as ComboBox).SelectedItem as ModelVegzettseg;
}
catch (Exception) {
}
try { if (vegzettsegItem.id != -1)
{
vegzettsegStr = vegzettsegItem.id.ToString();
}
} catch (Exception) { }
try { if (nyelvItem.id != -1)
{
nyelvkStr = nyelvItem.id.ToString();
}
} catch (Exception) {}
string jeloltszam = jeloltszam_srcinp.Text;
if (jeloltszam_srcinp.Text == "")
{
jeloltszam = "0";
}
string interjuk = interju_srcinp.Text;
if (interju_srcinp.Text == "")
{
interjuk = "0";
}
string publikalt = "";
if (publikalt_check.IsChecked == true)
{
publikalt = "1";
}
string sorrend = " ASC";
if (sorrend_check.IsChecked == true)
{
sorrend = " DESC";
}
value = new ModelProjectSearchBar
{
projektnev = projektnev_srcinp.Text,
jeloltszam = jeloltszam,
publikalva = publikalva_srcinp.Text,
interjuk = interjuk,
pc = pc_srcinp.Text,
nyelvkStr = nyelvkStr,
nyelvIndex = nyelv_srccbx.SelectedIndex,
vegzettsegStr = vegzettsegStr,
vegzettsegIndex = vegzettseg_srccbx.SelectedIndex,
cimke = cimke_srcinp.Text,
jeloltnev = jeloltnev_srcinp.Text,
publikalt = publikalt,
publikaltBool = publikalt_check.IsChecked.Value,
HeaderSelected = HeaderSelected,
sorrend = sorrend
};
return(value);
}
protected ModelApplicantSearchBar GetSearchValues()
{
ModelApplicantSearchBar list = new ModelApplicantSearchBar();
ModelNem nemek_item = (nemek_srccbx as ComboBox).SelectedItem as ModelNem;
ModelMunkakor munkakor_item = (munkakor_srccbx as ComboBox).SelectedItem as ModelMunkakor;
ModelVegzettseg vegzettseg_item = (vegzettseg_srccbx as ComboBox).SelectedItem as ModelVegzettseg;
ModelCimkek cimke_item = (cimke_srccbx as ComboBox).SelectedItem as ModelCimkek;
double listSize = Math.Round(applicant_listBox.RenderSize.Height / 55);
string munkakorStr = "";
string vegzettsegStr = "";
string nemekStr = "";
string cimkeStr = "";
if (munkakor_srccbx.SelectedIndex != -1)
{
munkakorStr = munkakor_item.id.ToString();
}
if (vegzettseg_srccbx.SelectedIndex != -1)
{
vegzettsegStr = vegzettseg_item.id.ToString();
}
if (nemek_srccbx.SelectedIndex != -1)
{
nemekStr = nemek_item.id.ToString();
}
if (cimke_srccbx.SelectedIndex != -1)
{
cimkeStr = cimke_item.cimke_megnevezes;
}
else
{
cimkeStr = cimke_srcinp.Text;
}
//string tapasztalat = tapsztalat_srcinp.Text;
//if (tapsztalat_srcinp.Text == "")
// tapasztalat = "";
string interjuk = interju_srcinp.Text;
if (interju_srcinp.Text == "")
{
interjuk = "";
}
string szabad = "";
if (szabad_check.IsChecked == true)
{
szabad = "1";
}
string sorrend = " ASC";
list = new ModelApplicantSearchBar
{
nev = nev_srcinp.Text,
lakhely = lakhely_srcinp.Text,
email = email_srcinp.Text,
eletkor = eletkor_srcinp.Text,
//tapasztalat = tapasztalat,
regdate = regdate_srcinp.Text,
interjuk = interjuk,
nemekStr = nemekStr,
nemekIndex = nemek_srccbx.SelectedIndex,
munkakorStr = munkakorStr,
munkakorIndex = munkakor_srccbx.SelectedIndex,
vegzettsegStr = vegzettsegStr,
vegzettsegIndex = nemek_srccbx.SelectedIndex,
cimke = cimkeStr,
szabad = szabad,
allasbanBool = allasban_check.IsChecked.Value,
szabadBool = szabad_check.IsChecked.Value,
HeaderSelected = HeaderSelected,
sorrend = sorrend,
numberLimit = listSize
};
return(list);
}