private void SaveCategoty_Click(object sender, RoutedEventArgs e)
{
VacancyTable vc = new VacancyTable();
try
{
vc.CategoryName = _nameCategory.Text;
vc.linkCategory = _linkCategory.Text;
db.VacancyTableSet.Add(vc);
db.SaveChanges();
MessageBox.Show("Категория добавлена");
}
catch (Exception ex)
{
MessageBox.Show("Error!");
MessageBox.Show(ex.Message);
}
path = vc.linkCategory;
XDocument doc = new XDocument();
doc = XDocument.Load(path);
VacancyList = doc.Element("rss")
.Element("channel")
//.Element("link")
.Elements()
.Where(w => w.Name == "item")
.Select(s =>
new Vacancies
{
VacancyName = s.Element("title").Value,
Description = s.Element("description").Value,
pubDate = DateTime.Parse(s.Element("pubDate").Value),
CategodyId = int.Parse(vc.CategoryId.ToString())
}
).OrderByDescending(o => o.pubDate).ToList();
foreach (var item in VacancyList)
{
db.VacanciesSet.SkipWhile(s => s.pubDate > DateTime.Parse("2018-01-01"));
db.VacanciesSet.Add(item);
}
db.SaveChanges();
MainWindow.fr.Source = new Uri(@"Pages\CategoryList.xaml", UriKind.RelativeOrAbsolute);
}
private void findVacancy_Click(object sender, RoutedEventArgs e)
{
VacancyTable vc = db.VacancyTableSet.FirstOrDefault(f => f.CategoryName == categoryName.Text);
ListVacancy.ItemsSource = db.VacanciesSet.Where(w => w.pubDate >= (DateTime)pubdate.SelectedDate && w.CategodyId == vc.CategoryId).OrderByDescending(o => o.pubDate).ToList();
}
private void _count_Click(object sender, RoutedEventArgs e)
{
VacancyTable vc = db.VacancyTableSet.FirstOrDefault(f => f.CategoryId.ToString() == _catFind.Text);
_chVac.Text = db.VacanciesSet.Where(w => w.CategodyId == vc.CategoryId).Count().ToString();
}
