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();
}
}
private void Grid_MouseDown(object sender, MouseButtonEventArgs e)
{
Grid grid = sender as Grid;
ModelFreelancerList data = grid.DataContext as ModelFreelancerList;
freel_name.Text = data.name;
freel_link.Text = "https://web.phoenix-mecano.hu/recruitment?rid=" + data.rid;
}
protected ModelApplicantSearchBar GetSearchValues()
{
ModelApplicantSearchBar data = new ModelApplicantSearchBar();
ModelFreelancerList cimke_item = (toborzo_srccbx as ComboBox).SelectedItem as ModelFreelancerList;
double listSize = Math.Round(applicant_listBox.RenderSize.Height / 55);
string sorrend = " ASC";
data = new ModelApplicantSearchBar
{
nev = nev_srcinp.Text,
lakhely = lakhely_srcinp.Text,
//tapasztalat = tapasztalat,
bekuldo = (cimke_item != null ? cimke_item.id : 0),
regdate = regdate_srcinp.Text,
sorrend = sorrend,
numberLimit = listSize
};
return(data);
}
protected void ResourceLoader()
{
toborzo_srccbx.ItemsSource = ModelFreelancerList.getFreelancerList("SELECT * FROM freelancer_list");
}
public List <ModelFreelancerList> Data_Freelancer()
{
return(ModelFreelancerList.getFreelancerList("SELECT * FROM freelancer_list"));
}