public void DeleteCompanyById(int idCompanyToDelete)
{
using var db = new JobOffersDbContext();
var company = db.Companies.FirstOrDefault(x => x.Id == idCompanyToDelete);
if (company != null)
{
db.Companies.Remove(company);
db.SaveChanges();
}
else
{
throw new KeyNotFoundException("Company doesn't exist");
}
}
public void DeleteJobOfferById(int idJobOfferToDelete)
{
using var db = new JobOffersDbContext();
var jobOffer = db.JobOffers.FirstOrDefault(x => x.Id == idJobOfferToDelete);
if (jobOffer != null)
{
db.JobOffers.Remove(jobOffer);
db.SaveChanges();
}
else
{
throw new KeyNotFoundException("JobOffers don't exist");
}
}
public void UpdateJobOfferById(int idJobOfferToChange, JobOffer newJobOfferValues)
{
using var db = new JobOffersDbContext();
var jobOffer = db.JobOffers.FirstOrDefault(x => x.Id == idJobOfferToChange);
if (jobOffer != null)
{
jobOffer.Name = newJobOfferValues.Name;
jobOffer.CompanyId = newJobOfferValues.CompanyId;
jobOffer.CreatedAt = newJobOfferValues.CreatedAt;
db.JobOffers.Update(jobOffer);
db.SaveChanges();
}
else
{
throw new KeyNotFoundException("JobOffers don't exist");
}
}
public void UpdateCompanyById(int idCompanyToChange, Company newCompanyValues)
{
using var db = new JobOffersDbContext();
var company = db.Companies.FirstOrDefault(x => x.Id == idCompanyToChange);
if (company != null)
{
company.Name = newCompanyValues.Name;
company.Street = newCompanyValues.Street;
company.Postal = newCompanyValues.Postal;
company.Town = newCompanyValues.Town;
db.Companies.Update(company);
db.SaveChanges();
}
else
{
throw new KeyNotFoundException("Company doesn't exist");
}
}
public void Insert(T item)
{
dbSet.Add(item);
dbContext.SaveChanges();
}
public void CreateCompany(Company newCompany)
{
using var db = new JobOffersDbContext();
db.Companies.Add(newCompany);
db.SaveChanges();
}
public void CreateJobOffer(JobOffer newJobOffer)
{
using var db = new JobOffersDbContext();
db.JobOffers.Add(newJobOffer);
db.SaveChanges();
}
