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