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();
}
