private void navigate(int i)
{
if (!browserJobVite.IsBusy)
{
if (i > 0)
{
string CategoryDecoded = "";
string CityDecoded = "";
string StatusDecoded = "";
string TitleHeadingDecoded = "";
string BriefDescriptionDecoded = "";
string DescriptionFieldDecoded = "";
string RecruiterDecoded = "";
string JobtypeDecoded = "";
string RequisitionLink = "";
source.LoadHtml(browserJobVite.DocumentText);
try
{
foreach (HtmlNode Category in source.DocumentNode.SelectNodes("//table[@class=\"tableContent\"]/tr/td"))
{
if (Category.InnerText == "Categoria:")
{
CategoryDecoded = System.Net.WebUtility.HtmlDecode(Category.NextSibling.InnerText);
//txtLog.Text = txtLog.Text + "Categoria: " + CategoryDecoded + Environment.NewLine;
break;
}
}
}
catch(Exception e)
{}
try
{
foreach (HtmlNode City in source.DocumentNode.SelectNodes("//table[@class=\"tableContent\"]/tr/td"))
{
if (City.InnerText == "Cidade:")
{
CityDecoded = System.Net.WebUtility.HtmlDecode(City.NextSibling.InnerText);
//txtLog.Text = txtLog.Text + "Cidade: " + CityDecoded + Environment.NewLine;
}
}
}
catch(Exception e)
{}
try
{
foreach (HtmlNode Status in source.DocumentNode.SelectNodes("//span[@id=\"Status\"]"))
{
StatusDecoded = System.Net.WebUtility.HtmlDecode(Status.InnerHtml);
//txtLog.Text = txtLog.Text + StatusDecoded + Environment.NewLine;
}
}
catch(Exception e)
{}
try
{
//Nome da Requisition
foreach (HtmlNode TitleHeading in source.DocumentNode.SelectNodes("//span[@id=\"TitleHeading\"]"))
{
TitleHeadingDecoded = System.Net.WebUtility.HtmlDecode(TitleHeading.InnerText);
//txtLog.Text = txtLog.Text + TitleHeadingDecoded + Environment.NewLine;
}
}
catch(Exception e)
{}
try
{
foreach (HtmlNode BriefDescription in source.DocumentNode.SelectNodes("//span[@id=\"BriefDescription\"]"))
{
BriefDescriptionDecoded = System.Net.WebUtility.HtmlDecode(BriefDescription.InnerText);
//txtLog.Text = txtLog.Text + BriefDescriptionDecoded + Environment.NewLine;
}
}
catch(Exception e)
{}
try
{
//Big Description
foreach (HtmlNode DescriptionField in source.DocumentNode.SelectNodes("//span[@id=\"DescriptionField\"]"))
{
DescriptionFieldDecoded = System.Net.WebUtility.HtmlDecode(DescriptionField.InnerText);
//txtLog.Text = txtLog.Text + DescriptionFieldDecoded + Environment.NewLine;
}
}
catch(Exception e)
{}
try
{
foreach (HtmlNode Recruiter in source.DocumentNode.SelectNodes("//table[@class=\"tableContent\"]/tr/td"))
{
if (Recruiter.InnerText == "Recrutador:")
{
RecruiterDecoded = System.Net.WebUtility.HtmlDecode(Recruiter.NextSibling.InnerText);
//txtLog.Text = txtLog.Text + "Recruiter: " + RecruiterDecoded + Environment.NewLine + Environment.NewLine + Environment.NewLine;
}
}
}
catch(Exception e)
{}
try
{
foreach (HtmlNode Jobtype in source.DocumentNode.SelectNodes("//table[@class=\"tableContent\"]/tr/td"))
{
if (Jobtype.InnerText == "Tipo da Vaga:")
{
JobtypeDecoded = System.Net.WebUtility.HtmlDecode(Jobtype.NextSibling.InnerText);
//txtLog.Text = txtLog.Text + JobtypeDecoded + Environment.NewLine;
}
}
}
catch (Exception ex)
{ }
try
{
foreach (HtmlNode RequisitionLinks in source.DocumentNode.SelectNodes("//table[@class=\"tableContent\"]/tr/td"))
{
if (RequisitionLinks.InnerText == "Candidates:")
{
RequisitionLink = RequisitionLinks.NextSibling.FirstChild.Attributes["href"].Value;
txtLog.Text = RequisitionLink;
}
}
}
catch (Exception ex)
{
}
try
{
//ADICIONAR AO BANCO
int CategoryId = 25;
int RecruiterId = 466;
int CityId = 5508;
int JobtypeId = 5;
using (grouponjobsdevEntities context = new grouponjobsdevEntities())
{
Requisition_Log log = new Requisition_Log();
try
{
CategoryId = context.Categories.Where(c => c.Name == CategoryDecoded).Select(c => c.CategoryId).First();
}
catch (Exception ex)
{
log.Adicionar(i.ToString(),TitleHeadingDecoded, "Category", CategoryDecoded, ex.Message);
}
try
{
RecruiterId = context.Recruiters.Where(r => r.Name == RecruiterDecoded).Select(r => r.RecruiterId).First();
}
catch (Exception ex)
{
log.Adicionar(i.ToString(),TitleHeadingDecoded, "Recruiter", RecruiterDecoded, ex.Message);
}
try
{
CityId = context.Cities.Where(c => c.Name == CityDecoded).Select(c => c.CityId).First();
}
catch (Exception ex)
{
log.Adicionar(i.ToString(),TitleHeadingDecoded, "City", CityDecoded, ex.Message);
}
try
{
JobtypeId = context.Jobtypes.Where(j => j.Name == JobtypeDecoded).Select(j => j.JobtypeId).First();
}
catch (Exception ex)
{
//log.Adicionar(i.ToString(),TitleHeadingDecoded, "Jobtype", JobtypeDecoded, ex.Message);
}
//txtLog.Text = CategoryId.ToString() + " " + RecruiterId.ToString() + " " + CityId.ToString() + " " + JobtypeId.ToString();
Requisition req = new Requisition();
req.Adicionar(TitleHeadingDecoded, RecruiterId, StatusDecoded, BriefDescriptionDecoded, DescriptionFieldDecoded, CityId, CategoryId, JobtypeId, RequisitionLink);
}
}
catch (Exception ex)
{
txtLog.Text = ex.ToString();
}
}
browserJobVite.Navigate(new Uri("https://hire.jobvite.com/Hiring/ViewJob.aspx?v=4&js=1023&vr=1&id=" + i));
}
}
private void FixupRequisition(Requisition previousValue)
{
if (previousValue != null && previousValue.Candidates.Contains(this))
{
previousValue.Candidates.Remove(this);
}
if (Requisition != null)
{
if (!Requisition.Candidates.Contains(this))
{
Requisition.Candidates.Add(this);
}
if (RequisitionId != Requisition.RequisitionId)
{
RequisitionId = Requisition.RequisitionId;
}
}
else if (!_settingFK)
{
RequisitionId = null;
}
}
public void Adicionar(string Name, int RecruiterId, string Status, string SmallDescription, string BigDescription, int CityId, int CategoryId, int JobtypeId, string RequisitionLink)
{
using (grouponjobsdevEntities context = new grouponjobsdevEntities())
{
Requisition req = new Requisition();
req.Name = Name;
req.RecruiterId = RecruiterId;
req.Status = Status;
req.SmallDescription = SmallDescription;
req.BigDescription = BigDescription;
req.CityId = CityId;
req.CategoryId = CategoryId;
req.JobtypeId = JobtypeId;
req.RequisitionLink = RequisitionLink;
context.Requisitions.AddObject(req);
context.SaveChanges();
}
}