public ActionResult Create([Bind(Include = "VacancyID,Title,Description,Responsibilities,Qualifications")] Vacancy vacancy) { if (ModelState.IsValid) { db.Vacancies.Add(vacancy); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(vacancy)); }
public void DeleteCompanyById(int companyId) // DELETE { using var db = new VacancyDbContext(); var companyToDelete = db.companies.First(x => x.CompanyId == companyId); db.Remove(companyToDelete); db.SaveChanges(); }
public void DeleteVacancyById(int vacancyId) // DELETE { using var db = new VacancyDbContext(); var vacancyToDelete = db.vacancies.First(x => x.VacancyId == vacancyId); db.vacancies.Remove(vacancyToDelete); db.SaveChanges(); }
public IEnumerable <Vacancy> Get() { List <Vacancy> vacancies; try { vacancies = GetVacancies(); } catch { vacancies = null; } if (vacancies != null) { // Использование транзакции, иначе при удалении и вставке данных создаются разные транзакции using (var transaction = _vacancyDbContext.Database.BeginTransaction()) { try { _vacancyDbContext.Vacancy.RemoveRange(_vacancyDbContext.Vacancy); _vacancyDbContext.SaveChanges(); _vacancyDbContext.Vacancy.AddRange(vacancies); _vacancyDbContext.SaveChanges(); transaction.Commit(); } catch { transaction.Rollback(); throw; } } } else { vacancies = _vacancyDbContext.Vacancy.Take(50).ToList(); } return(vacancies); /*} * catch * { * Response.StatusCode = (int)HttpStatusCode.BadRequest; * return null; * }*/ }
public void UpdateVacancyById(int vacancyId, Vacancy vacancyEditValues) // UPDATE { using var db = new VacancyDbContext(); var vacancyToUpdate = db.vacancies.Include(x => x.Company).First(x => x.VacancyId == vacancyId); // bij null geeft dit een InvalidOperationException (opvangen in controller) vacancyToUpdate.Description = vacancyEditValues.Description; vacancyToUpdate.DateOfCreation = vacancyEditValues.DateOfCreation; vacancyToUpdate.CompanyId = vacancyEditValues.CompanyId; db.vacancies.Update(vacancyToUpdate); db.SaveChanges(); }
public void UpdateCompanyById(int companyId, Company companyEditValues) // UPDATE { using var db = new VacancyDbContext(); var companyToUpdate = db.companies.First(x => x.CompanyId == companyId); // InvalidOperatorException if null companyToUpdate.Name = companyEditValues.Name; companyToUpdate.Street = companyEditValues.Street; companyToUpdate.HouseNumber = companyEditValues.HouseNumber; companyToUpdate.Postal = companyEditValues.Postal; companyToUpdate.City = companyEditValues.City; db.companies.Update(companyToUpdate); db.SaveChanges(); }
public void CreateCompany(Company newCompany) // CREATE { using var db = new VacancyDbContext(); db.companies.Add(newCompany); db.SaveChanges(); }
public void CreateVacancy(Vacancy newVacancy) // CREATE { using var db = new VacancyDbContext(); db.vacancies.Add(newVacancy); db.SaveChanges(); }