예제 #1
0
 public static List <Category> GetCategories()
 {
     using (Vacancy_ModelContainer db = new Vacancy_ModelContainer())
     {
         return(db.CategorySet.ToList());
     }
 }
예제 #2
0
        public static void setVacancies(string url, string name)
        {
            Category category = GetCategory(url);

            category.Category_Name = name;

            using (Vacancy_ModelContainer db = new Vacancy_ModelContainer())
            {
                if (!db.CategorySet.Any(a => a.Category_Name == category.Category_Name))
                {
                    db.CategorySet.Add(category);

                    db.SaveChanges();
                }
                category.Id = db.CategorySet.Where(w => w.Category_Name == category.Category_Name).Select(s => s.Id).Single();

                if (!Equal(category.Vacancy.ToList(), db.CategorySet.Where(w => w.Category_Name == category.Category_Name).Single().Vacancy.ToList()))
                {
                    db.Database.ExecuteSqlCommand("delete from VacancySet where CategoryId =" + db.CategorySet.Where(g => g.Category_Name == category.Category_Name).Select(s => s.Id).Single().ToString());
                    db.VacancySet.AddRange(category.Vacancy.ToList());
                    db.SaveChanges();
                }
            }
        }